Return to long_columns.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / pdo_odbc / tests

Annotation of embedaddon/php/ext/pdo_odbc/tests/long_columns.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: PDO ODBC "long" columns
                      3: --SKIPIF--
                      4: <?php # vim:ft=php
                      5: if (!extension_loaded('pdo_odbc')) print 'skip not loaded';
                      6: ?>
                      7: --FILE--
                      8: <?php
                      9: require 'ext/pdo/tests/pdo_test.inc';
                     10: $db = PDOTest::test_factory('ext/pdo_odbc/tests/common.phpt');
                     11: $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
                     12: 
                     13: if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data CLOB)')) {
                     14:        if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data longtext)')) {
                     15:                if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data varchar(4000))')) {
                     16:                        die("BORK: don't know how to create a long column here:\n" . implode(", ", $db->errorInfo()));
                     17:                }
                     18:        }
                     19: }
                     20: 
                     21: $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
                     22: 
                     23: $sizes = array(32, 64, 128, 253, 254, 255, 256, 257, 258, 512, 1024, 2048, 3998, 3999, 4000);
                     24: 
                     25: $db->beginTransaction();
                     26: $insert = $db->prepare('INSERT INTO TEST VALUES (?, ?)');
                     27: foreach ($sizes as $num) {
                     28:        $insert->execute(array($num, str_repeat('i', $num)));
                     29: }
                     30: $insert = null;
                     31: $db->commit();
                     32: 
                     33: foreach ($db->query('SELECT id, data from TEST') as $row) {
                     34:        $expect = str_repeat('i', $row[0]);
                     35:        if (strcmp($expect, $row[1])) {
                     36:                echo "Failed on size $row[id]:\n";
                     37:                printf("Expected %d bytes, got %d\n", strlen($expect), strlen($row['data']));
                     38:                echo bin2hex($expect) . "\n";
                     39:                echo bin2hex($row['data']) . "\n";
                     40:        }
                     41: }
                     42: 
                     43: echo "Finished\n";
                     44: 
                     45: --EXPECT--
                     46: Finished