Annotation of embedaddon/php/ext/oci8/tests/default_prefetch2.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: oci8.default_prefetch ini option
! 3: --SKIPIF--
! 4: <?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
! 5: --INI--
! 6: oci8.default_prefetch=100
! 7: --FILE--
! 8: <?php
! 9:
! 10: require(dirname(__FILE__)."/connect.inc");
! 11:
! 12: // Initialize
! 13:
! 14: $stmtarray = array(
! 15: "drop table default_prefetch2_tab",
! 16: "create table default_prefetch2_tab (id number, value number)",
! 17: "insert into default_prefetch2_tab (id, value) values (1,1)",
! 18: "insert into default_prefetch2_tab (id, value) values (1,1)",
! 19: "insert into default_prefetch2_tab (id, value) values (1,1)",
! 20: );
! 21:
! 22: oci8_test_sql_execute($c, $stmtarray);
! 23:
! 24: // Run Test
! 25:
! 26: $select_sql = "select * from default_prefetch2_tab";
! 27:
! 28: if (!($s = oci_parse($c, $select_sql))) {
! 29: die("oci_parse(select) failed!\n");
! 30: }
! 31:
! 32: var_dump(oci_set_prefetch($s, 10));
! 33:
! 34: if (!oci_execute($s)) {
! 35: die("oci_execute(select) failed!\n");
! 36: }
! 37:
! 38: var_dump(oci_fetch($s));
! 39: var_dump(oci_num_rows($s));
! 40:
! 41: // Cleanup
! 42:
! 43: $stmtarray = array(
! 44: "drop table default_prefetch2_tab"
! 45: );
! 46:
! 47: oci8_test_sql_execute($c, $stmtarray);
! 48:
! 49: echo "Done\n";
! 50: ?>
! 51: --EXPECT--
! 52: bool(true)
! 53: bool(true)
! 54: int(1)
! 55: Done
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>