diff options
Diffstat (limited to 'ext/oci8/tests/default_prefetch1.phpt')
| -rw-r--r-- | ext/oci8/tests/default_prefetch1.phpt | 50 |
1 files changed, 36 insertions, 14 deletions
diff --git a/ext/oci8/tests/default_prefetch1.phpt b/ext/oci8/tests/default_prefetch1.phpt index aa130e9f9..bcd66fa38 100644 --- a/ext/oci8/tests/default_prefetch1.phpt +++ b/ext/oci8/tests/default_prefetch1.phpt @@ -7,26 +7,39 @@ oci8.default_prefetch=100 --FILE-- <?php -require dirname(__FILE__)."/connect.inc"; -require dirname(__FILE__).'/create_table.inc'; +require(dirname(__FILE__)."/connect.inc"); -$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)"; +// Initialize -if (!($s = oci_parse($c, $insert_sql))) { - die("oci_parse(insert) failed!\n"); -} +$stmtarray = array( + "drop table default_prefetch1_tab", + "create table default_prefetch1_tab (id number, value number)", + "insert into default_prefetch1_tab (id, value) values (1,1)", + "insert into default_prefetch1_tab (id, value) values (1,1)", + "insert into default_prefetch1_tab (id, value) values (1,1)", +); -for ($i = 0; $i<3; $i++) { - if (!oci_execute($s)) { - die("oci_execute(insert) failed!\n"); +foreach ($stmtarray as $stmt) { + $s = oci_parse($c, $stmt); + $r = @oci_execute($s); + if (!$r) { + $m = oci_error($s); + if (!in_array($m['code'], array( // ignore expected errors + 942 // table or view does not exist + ))) { + echo $stmt . PHP_EOL . $m['message'] . PHP_EOL; + } } } -if (!oci_commit($c)) { - die("oci_commit() failed!\n"); +foreach ($stmtarray as $stmt) { + $s = oci_parse($c, $stmt); + oci_execute($s); } -$select_sql = "SELECT * FROM ".$schema.$table_name.""; +// Run Test + +$select_sql = "select * from default_prefetch1_tab"; if (!($s = oci_parse($c, $select_sql))) { die("oci_parse(select) failed!\n"); @@ -37,10 +50,19 @@ if (!oci_execute($s)) { } var_dump(oci_fetch($s)); - var_dump(oci_num_rows($s)); -require dirname(__FILE__).'/drop_table.inc'; + +// Cleanup + +$stmtarray = array( + "drop table default_prefetch1_tab" +); + +foreach ($stmtarray as $stmt) { + $s = oci_parse($c, $stmt); + oci_execute($s); +} echo "Done\n"; ?> |