cvs: php-src /ext/oci8/tests bind_empty.phpt
| From: | Antony Dovgal | Date: | Tue, 30 Jan 2007 11:43:07 +0000 |
| Subject: | cvs: php-src /ext/oci8/tests bind_empty.phpt | ||
| Groups: | php.cvs | ||
| Request: | Send a blank email to php-cvs+get-42912@lists.php.net to get a copy of this message | ||
tony2001 Tue Jan 30 11:43:07 2007 UTC
Modified files:
/php-src/ext/oci8/tests bind_empty.phpt
Log:
improve test
patch by Chris Jones
http://cvs.php.net/viewvc.cgi/php-src/ext/oci8/tests/bind_empty.phpt?r1=1.4&r2=1.5&diff_format=u
Index: php-src/ext/oci8/tests/bind_empty.phpt
diff -u php-src/ext/oci8/tests/bind_empty.phpt:1.4 php-src/ext/oci8/tests/bind_empty.phpt:1.5
--- php-src/ext/oci8/tests/bind_empty.phpt:1.4 Tue Feb 7 14:11:01 2006
+++ php-src/ext/oci8/tests/bind_empty.phpt Tue Jan 30 11:43:07 2007
@@ -4,7 +4,7 @@
<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
--FILE--
<?php
-
+
require dirname(__FILE__).'/connect.inc';
$drop = "DROP table bind_test";
@@ -16,18 +16,57 @@
oci_execute($statement);
+echo "Test 1\n";
+
$name = null;
$stmt = oci_parse($c, "UPDATE bind_test SET name=:name");
oci_bind_by_name($stmt, ":name", $name);
-$res = oci_execute($stmt);
+var_dump(oci_execute($stmt));
+
+echo "Test 2\n";
$name = "";
$stmt = oci_parse($c, "UPDATE bind_test SET name=:name");
oci_bind_by_name($stmt, ":name", $name);
+var_dump(oci_execute($stmt));
+
+echo "Test 3\n";
+
+$stmt = oci_parse($c, "INSERT INTO bind_test (NAME) VALUES ('abc')");
$res = oci_execute($stmt);
+$stmt = oci_parse($c, "INSERT INTO bind_test (NAME) VALUES ('def')");
+$res = oci_execute($stmt);
+
+$name = null;
+$stmt = oci_parse($c, "UPDATE bind_test SET name=:name WHERE NAME = 'abc'");
+oci_bind_by_name($stmt, ":name", $name);
+
+var_dump(oci_execute($stmt));
+
+$stid = oci_parse($c, "select * from bind_test order by 1");
+oci_execute($stid);
+oci_fetch_all($stid, $res);
+var_dump($res);
+
+echo "Test 4\n";
+
+$name = "";
+$stmt = oci_parse($c, "UPDATE bind_test SET name=:name WHERE NAME = 'def'");
+oci_bind_by_name($stmt, ":name", $name);
+
+var_dump(oci_execute($stmt));
+
+$stid = oci_parse($c, "select * from bind_test order by 1");
+oci_execute($stid);
+oci_fetch_all($stid, $res);
+var_dump($res);
+
+
+// Clean up
+
$drop = "DROP table bind_test";
$statement = oci_parse($c, $drop);
@oci_execute($statement);
@@ -36,4 +75,58 @@
?>
--EXPECTF--
+Test 1
+bool(true)
+Test 2
+bool(true)
+Test 3
+bool(true)
+array(1) {
+ ["NAME"]=>
+ array(2) {
+ [0]=>
+ string(3) "def"
+ [1]=>
+ NULL
+ }
+}
+Test 4
+bool(true)
+array(1) {
+ ["NAME"]=>
+ array(2) {
+ [0]=>
+ NULL
+ [1]=>
+ NULL
+ }
+}
+Done
+--UEXPECTF--
+Test 1
+bool(true)
+Test 2
+bool(true)
+Test 3
+bool(true)
+array(1) {
+ [u"NAME"]=>
+ array(2) {
+ [0]=>
+ unicode(3) "def"
+ [1]=>
+ NULL
+ }
+}
+Test 4
+bool(true)
+array(1) {
+ [u"NAME"]=>
+ array(2) {
+ [0]=>
+ NULL
+ [1]=>
+ NULL
+ }
+}
Done