cvs: php-src /ext/oci8/tests bind_empty.phpt

From: 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

« previous php.cvs (#42912) next »