summaryrefslogtreecommitdiff
path: root/ext/pdo_pgsql/tests
diff options
context:
space:
mode:
Diffstat (limited to 'ext/pdo_pgsql/tests')
-rw-r--r--ext/pdo_pgsql/tests/bug36727.phpt23
-rw-r--r--ext/pdo_pgsql/tests/bug_33876.phpt151
-rw-r--r--ext/pdo_pgsql/tests/common.phpt24
-rw-r--r--ext/pdo_pgsql/tests/config.inc14
-rw-r--r--ext/pdo_pgsql/tests/large_objects.phpt61
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!
View Lorry Controller Status