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