diff options
Diffstat (limited to 'ext/pdo_odbc/tests')
-rw-r--r-- | ext/pdo_odbc/tests/common.phpt | 48 | ||||
-rw-r--r-- | ext/pdo_odbc/tests/long_columns.phpt | 46 |
2 files changed, 0 insertions, 94 deletions
diff --git a/ext/pdo_odbc/tests/common.phpt b/ext/pdo_odbc/tests/common.phpt deleted file mode 100644 index f64da1a438..0000000000 --- a/ext/pdo_odbc/tests/common.phpt +++ /dev/null @@ -1,48 +0,0 @@ ---TEST-- -ODBC ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded('pdo_odbc')) print 'skip'; ?> ---REDIRECTTEST-- -# magic auto-configuration - -$config = array( - 'TESTS' => 'ext/pdo/tests' -); - - -if (false !== getenv('PDO_ODBC_TEST_DSN')) { - # user set them from their shell - $config['ENV']['PDOTEST_DSN'] = getenv('PDO_ODBC_TEST_DSN'); - $config['ENV']['PDOTEST_USER'] = getenv('PDO_ODBC_TEST_USER'); - $config['ENV']['PDOTEST_PASS'] = getenv('PDO_ODBC_TEST_PASS'); - if (false !== getenv('PDO_ODBC_TEST_ATTR')) { - $config['ENV']['PDOTEST_ATTR'] = getenv('PDO_ODBC_TEST_ATTR'); - } -} elseif (preg_match('/^WIN/i', PHP_OS)) { - # on windows, try to create a temporary MS access database - $path = realpath(dirname(__FILE__)) . '\pdo_odbc.mdb'; - if (!file_exists($path)) { - try { - $adox = new COM('ADOX.Catalog'); - $adox->Create('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' . $path); - $adox = null; - - } catch (Exception $e) { - } - } - if (file_exists($path)) { - $config['ENV']['PDOTEST_DSN'] = "odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=$path;Uid=Admin"; - } -} -# other magic autodetection here, eg: for DB2 by inspecting env -/* -$USER = 'db2inst1'; -$PASSWD = 'ibmdb2'; -$DBNAME = 'SAMPLE'; - -$CONNECTION = "odbc:DSN=$DBNAME;UID=$USER;PWD=$PASSWD;"; -*/ - - -return $config; diff --git a/ext/pdo_odbc/tests/long_columns.phpt b/ext/pdo_odbc/tests/long_columns.phpt deleted file mode 100644 index 65ec2f96e9..0000000000 --- a/ext/pdo_odbc/tests/long_columns.phpt +++ /dev/null @@ -1,46 +0,0 @@ ---TEST-- -PDO ODBC "long" columns ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded('pdo_odbc')) print 'skip not loaded'; -?> ---FILE-- -<?php -require 'ext/pdo/tests/pdo_test.inc'; -$db = PDOTest::test_factory('ext/pdo_odbc/tests/common.phpt'); -$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); - -if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data CLOB)')) { - if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data longtext)')) { - if (false === $db->exec('CREATE TABLE TEST (id INT NOT NULL PRIMARY KEY, data varchar(4000))')) { - die("BORK: don't know how to create a long column here:\n" . implode(", ", $db->errorInfo())); - } - } -} - -$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); - -$sizes = array(32, 64, 128, 253, 254, 255, 256, 257, 258, 512, 1024, 2048, 3998, 3999, 4000); - -$db->beginTransaction(); -$insert = $db->prepare('INSERT INTO TEST VALUES (?, ?)'); -foreach ($sizes as $num) { - $insert->execute(array($num, str_repeat('i', $num))); -} -$insert = null; -$db->commit(); - -foreach ($db->query('SELECT id, data from TEST') as $row) { - $expect = str_repeat('i', $row[0]); - if (strcmp($expect, $row[1])) { - echo "Failed on size $row[id]:\n"; - printf("Expected %d bytes, got %d\n", strlen($expect), strlen($row['data'])); - echo bin2hex($expect) . "\n"; - echo bin2hex($row['data']) . "\n"; - } -} - -echo "Finished\n"; - ---EXPECT-- -Finished |