diff options
author | SVN Migration <svn@php.net> | 2006-10-15 21:09:28 +0000 |
---|---|---|
committer | SVN Migration <svn@php.net> | 2006-10-15 21:09:28 +0000 |
commit | 88ec761548b66f58acc1a86cdd0fc164ca925476 (patch) | |
tree | d0af978fa00d83bb1d82c613f66477fbd6bb18aa /ext/pdo_pgsql/tests | |
parent | 268984b4787e797db6054313fc9ba3b9e845306e (diff) | |
download | php-git-PECL_OPENSSL.tar.gz |
This commit was manufactured by cvs2svn to create branch 'PECL_OPENSSL'.PECL_OPENSSL
Diffstat (limited to 'ext/pdo_pgsql/tests')
-rw-r--r-- | ext/pdo_pgsql/tests/bug36727.phpt | 23 | ||||
-rw-r--r-- | ext/pdo_pgsql/tests/bug_33876.phpt | 151 | ||||
-rw-r--r-- | ext/pdo_pgsql/tests/common.phpt | 24 | ||||
-rw-r--r-- | ext/pdo_pgsql/tests/config.inc | 14 | ||||
-rw-r--r-- | ext/pdo_pgsql/tests/large_objects.phpt | 61 |
5 files changed, 0 insertions, 273 deletions
diff --git a/ext/pdo_pgsql/tests/bug36727.phpt b/ext/pdo_pgsql/tests/bug36727.phpt deleted file mode 100644 index c6f7c8a80f..0000000000 --- a/ext/pdo_pgsql/tests/bug36727.phpt +++ /dev/null @@ -1,23 +0,0 @@ ---TEST-- -Bug #36727 (segfault in bindValue() when no parameters are defined) ---SKIPIF-- -<?php -if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded'); -require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc'; -require dirname(__FILE__) . '/config.inc'; -PDOTest::skip(); -?> ---FILE-- -<?php -require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc'; -require dirname(__FILE__) . '/config.inc'; -$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); - -$stmt = $db->prepare('SELECT * FROM child'); -var_dump($stmt->bindValue(':test', 1, PDO::PARAM_INT)); - -echo "Done\n"; -?> ---EXPECT-- -bool(false) -Done diff --git a/ext/pdo_pgsql/tests/bug_33876.phpt b/ext/pdo_pgsql/tests/bug_33876.phpt deleted file mode 100644 index fc9d20f696..0000000000 --- a/ext/pdo_pgsql/tests/bug_33876.phpt +++ /dev/null @@ -1,151 +0,0 @@ ---TEST-- -PDO PgSQL Bug #33876 ---SKIPIF-- -<?php -if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded'); -require dirname(__FILE__) . '/config.inc'; -require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc'; -PDOTest::skip(); -?> ---FILE-- -<?php -require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc'; -$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); -$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT); - -$db->exec("SET LC_MESSAGES='C'"); -$db->exec('CREATE TABLE test (foo varchar(5) NOT NULL, bar bool NOT NULL)'); -$db->exec("INSERT INTO test VALUES('false','f')"); -$db->exec("INSERT INTO test VALUES('true', 't')"); - -$res = $db->prepare('SELECT foo from test where bar = ?'); - -# this is the portable approach to binding a bool -$res->bindValue(1, false, PDO::PARAM_BOOL); -if (!$res->execute()) - print_r($res->errorInfo()); -else - print_r($res->fetchAll(PDO::FETCH_ASSOC)); - -# this is the portable approach to binding a bool -$res->bindValue(1, true, PDO::PARAM_BOOL); -if (!$res->execute()) - print_r($res->errorInfo()); -else - print_r($res->fetchAll(PDO::FETCH_ASSOC)); - - -# true gets cast to string (because the implied default is string) -# true-as-string is 1, so this "works" -if (!$res->execute(array(true))) - print_r($res->errorInfo()); -else - print_r($res->fetchAll(PDO::FETCH_ASSOC)); - -# Expected to fail; unless told otherwise, PDO assumes string inputs -# false -> "" as string, which pgsql doesn't like -if (!$res->execute(array(false))) - print_r($res->errorInfo()); -else - print_r($res->fetchAll(PDO::FETCH_ASSOC)); - -# And now using emulator prepares -echo "EMUL\n"; - - -$res = $db->prepare('SELECT foo from test where bar = ?', array( - PDO::PGSQL_ATTR_DISABLE_NATIVE_PREPARED_STATEMENT => true)); - -# this is the portable approach to binding a bool -$res->bindValue(1, false, PDO::PARAM_BOOL); -if (!$res->execute()) - print_r($res->errorInfo()); -else - print_r($res->fetchAll(PDO::FETCH_ASSOC)); - -# this is the portable approach to binding a bool -$res->bindValue(1, true, PDO::PARAM_BOOL); -if (!$res->execute()) - print_r($res->errorInfo()); -else - print_r($res->fetchAll(PDO::FETCH_ASSOC)); - - -# true gets cast to string (because the implied default is string) -# true-as-string is 1, so this "works" -if (!$res->execute(array(true))) - print_r($res->errorInfo()); -else - print_r($res->fetchAll(PDO::FETCH_ASSOC)); - -# Expected to fail; unless told otherwise, PDO assumes string inputs -# false -> "" as string, which pgsql doesn't like -if (!$res->execute(array(false))) - print_r($res->errorInfo()); -else - print_r($res->fetchAll(PDO::FETCH_ASSOC)); - - - ---EXPECT-- -Array -( - [0] => Array - ( - [foo] => false - ) - -) -Array -( - [0] => Array - ( - [foo] => true - ) - -) -Array -( - [0] => Array - ( - [foo] => true - ) - -) -Array -( - [0] => 22P02 - [1] => 7 - [2] => ERROR: invalid input syntax for type boolean: "" -) -EMUL -Array -( - [0] => Array - ( - [foo] => false - ) - -) -Array -( - [0] => Array - ( - [foo] => true - ) - -) -Array -( - [0] => Array - ( - [foo] => true - ) - -) -Array -( - [0] => 22P02 - [1] => 7 - [2] => ERROR: invalid input syntax for type boolean: "" -) diff --git a/ext/pdo_pgsql/tests/common.phpt b/ext/pdo_pgsql/tests/common.phpt deleted file mode 100644 index 2ecc2025f0..0000000000 --- a/ext/pdo_pgsql/tests/common.phpt +++ /dev/null @@ -1,24 +0,0 @@ ---TEST-- -Postgres ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded('pdo_pgsql')) print 'skip'; ?> ---REDIRECTTEST-- -# magic auto-configuration -# Also update config.inc if you make changes here... - -$config = array( - 'TESTS' => 'ext/pdo/tests' -); - -if (false !== getenv('PDO_PGSQL_TEST_DSN')) { - # user set them from their shell - $config['ENV']['PDOTEST_DSN'] = getenv('PDO_PGSQL_TEST_DSN'); - if (false !== getenv('PDO_PGSQL_TEST_ATTR')) { - $config['ENV']['PDOTEST_ATTR'] = getenv('PDO_PGSQL_TEST_ATTR'); - } -} else { - $config['ENV']['PDOTEST_DSN'] = 'pgsql:host=localhost port=5432 dbname=test user=root password='; -} - -return $config; diff --git a/ext/pdo_pgsql/tests/config.inc b/ext/pdo_pgsql/tests/config.inc deleted file mode 100644 index 6d616cddb5..0000000000 --- a/ext/pdo_pgsql/tests/config.inc +++ /dev/null @@ -1,14 +0,0 @@ -<?php # vim:se ft=php: -if (false !== getenv('PDO_PGSQL_TEST_DSN')) { - # user set them from their shell - $config['ENV']['PDOTEST_DSN'] = getenv('PDO_PGSQL_TEST_DSN'); - if (false !== getenv('PDO_PGSQL_TEST_ATTR')) { - $config['ENV']['PDOTEST_ATTR'] = getenv('PDO_PGSQL_TEST_ATTR'); - } -} else { - $config['ENV']['PDOTEST_DSN'] = 'pgsql:host=localhost port=5432 dbname=test user=root password='; -} - -foreach ($config['ENV'] as $k => $v) { - putenv("$k=$v"); -} diff --git a/ext/pdo_pgsql/tests/large_objects.phpt b/ext/pdo_pgsql/tests/large_objects.phpt deleted file mode 100644 index f6ee9e29c0..0000000000 --- a/ext/pdo_pgsql/tests/large_objects.phpt +++ /dev/null @@ -1,61 +0,0 @@ ---TEST-- -PDO PgSQL Large Objects ---SKIPIF-- -<?php # vim:se ft=php: -if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded'); -require dirname(__FILE__) . '/config.inc'; -require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc'; -PDOTest::skip(); -?> ---FILE-- -<?php -require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc'; -$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt'); -$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); -$db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); - -$db->exec('CREATE TABLE test (blobid integer not null primary key, bloboid OID)'); - -$db->beginTransaction(); -$oid = $db->pgsqlLOBCreate(); -try { -$stm = $db->pgsqlLOBOpen($oid); -fwrite($stm, "Hello dude\n"); - -$stmt = $db->prepare("INSERT INTO test (blobid, bloboid) values (?, ?)"); -$stmt->bindValue(1, 1); -/* bind as LOB; the oid from the pgsql stream will be inserted instead - * of the stream contents. Binding other streams will attempt to bind - * as bytea, and will most likely lead to an error. - * You can also just bind the $oid in as a string. */ -$stmt->bindParam(2, $stm, PDO::PARAM_LOB); -$stmt->execute(); -$stm = null; - -/* Pull it out */ -$stmt = $db->prepare("SELECT * from test"); -$stmt->execute(); -$stmt->bindColumn('bloboid', $lob, PDO::PARAM_LOB); -echo "Fetching:\n"; -while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) { - var_dump($row['blobid']); - var_dump(stream_get_contents($lob)); -} -echo "Fetched!\n"; -} catch (Exception $e) { - /* catch exceptions so that we can guarantee to clean - * up the LOB */ - echo "Exception! at line ", $e->getLine(), "\n"; - var_dump($e->getMessage()); -} - -/* Now to remove the large object from the database, so it doesn't - * linger and clutter up the storage */ -$db->pgsqlLOBUnlink($oid); - ---EXPECT-- -Fetching: -int(1) -string(11) "Hello dude -" -Fetched! |