Return to refcur_prefetch_3.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / oci8 / tests

Annotation of embedaddon/php/ext/oci8/tests/refcur_prefetch_3.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: Prefetch with Nested cursors with INI setting.
                      3: --INI--
                      4: oci8.default_prefetch=5
                      5: --SKIPIF--
                      6: <?php if (!extension_loaded('oci8')) die("skip no oci8 extension");
                      7: if (!extension_loaded('oci8')) die("skip no oci8 extension");
                      8: require(dirname(__FILE__)."/connect.inc");
                      9: if (preg_match('/Release (11\.2|12)\./', oci_server_version($c), $matches) !== 1) {
                     10:        die("skip expected output only valid when using Oracle 11gR2 or greater databases");
                     11: } else if (preg_match('/^(11\.2|12)\./', oci_client_version()) != 1) {
                     12:     die("skip test expected to work only with Oracle 11gR2 or greater version of client");
                     13: }
                     14: 
                     15: ?>
                     16: --FILE--
                     17: <?php
                     18: require dirname(__FILE__)."/connect.inc";
                     19: 
                     20: //Create tables here
                     21: $stmtarray = array(
                     22:     "drop table nescurtest",
                     23:     "create table nescurtest(c1 varchar2(10))"
                     24: );
                     25: 
                     26: oci8_test_sql_execute($c, $stmtarray);
                     27: 
                     28: // Insert 500 rows into the table.
                     29: $insert_sql = "INSERT INTO nescurtest (c1) VALUES (:c1)";
                     30: if (!($s = oci_parse($c, $insert_sql))) {
                     31:     die("oci_parse(insert) failed!\n");
                     32: }
                     33: 
                     34: for ($i = 0; $i<=500; $i++) {
                     35:     $val2 = 'test'.$i;
                     36:     oci_bind_by_name($s,':c1',$val2);
                     37:     if (!oci_execute($s)) {
                     38:         die("oci_execute(insert) failed!\n");
                     39:     }
                     40: }
                     41: 
                     42: echo"-----------------------------------------------\n";
                     43: echo "Test with Nested Cursors\n";
                     44: echo"-----------------------------------------------\n";
                     45: $cur1 = oci_new_cursor($c);
                     46: $sqlstmt = "select cursor(select * from nescurtest) curs1 from dual";
                     47: $s = oci_parse($c,$sqlstmt);
                     48: oci_execute($s);
                     49: $data = oci_fetch_array($s);
                     50: oci_execute($data['CURS1']);
                     51: 
                     52: // Calculate round-trips 
                     53: $initial_rt = print_roundtrips($c);
                     54: for ($i = 0;$i<10;$i++) {
                     55:     echo "Fetch Row using Nested cursor Query\n";
                     56:     var_dump(oci_fetch_row($data['CURS1']));
                     57: }
                     58: 
                     59: $cnt = (print_roundtrips($c) - $initial_rt);
                     60: echo "Number of roundtrips made with prefetch count 5 for 10 rows is  $cnt\n";
                     61: 
                     62: function  print_roundtrips($c) {
                     63:     $sql_stmt = "select value from v\$mystat a,v\$statname c where
                     64:          a.statistic#=c.statistic# and c.name='SQL*Net roundtrips to/from client'";
                     65:     $s = oci_parse($c,$sql_stmt);
                     66:     oci_define_by_name($s,"VALUE",$value);
                     67:     oci_execute($s);
                     68:     oci_fetch($s);
                     69:     return $value;
                     70: }
                     71: 
                     72: // Clean up  here
                     73: 
                     74: $stmtarray = array(
                     75:     "drop table nescurtest"
                     76: );
                     77: 
                     78: oci8_test_sql_execute($c, $stmtarray);
                     79: 
                     80: echo "Done\n";
                     81: ?>
                     82: --EXPECTF--
                     83: -----------------------------------------------
                     84: Test with Nested Cursors
                     85: -----------------------------------------------
                     86: Fetch Row using Nested cursor Query
                     87: array(1) {
                     88:   [0]=>
                     89:   %unicode|string%(%d) "test0"
                     90: }
                     91: Fetch Row using Nested cursor Query
                     92: array(1) {
                     93:   [0]=>
                     94:   %unicode|string%(%d) "test1"
                     95: }
                     96: Fetch Row using Nested cursor Query
                     97: array(1) {
                     98:   [0]=>
                     99:   %unicode|string%(%d) "test2"
                    100: }
                    101: Fetch Row using Nested cursor Query
                    102: array(1) {
                    103:   [0]=>
                    104:   %unicode|string%(%d) "test3"
                    105: }
                    106: Fetch Row using Nested cursor Query
                    107: array(1) {
                    108:   [0]=>
                    109:   %unicode|string%(%d) "test4"
                    110: }
                    111: Fetch Row using Nested cursor Query
                    112: array(1) {
                    113:   [0]=>
                    114:   %unicode|string%(%d) "test5"
                    115: }
                    116: Fetch Row using Nested cursor Query
                    117: array(1) {
                    118:   [0]=>
                    119:   %unicode|string%(%d) "test6"
                    120: }
                    121: Fetch Row using Nested cursor Query
                    122: array(1) {
                    123:   [0]=>
                    124:   %unicode|string%(%d) "test7"
                    125: }
                    126: Fetch Row using Nested cursor Query
                    127: array(1) {
                    128:   [0]=>
                    129:   %unicode|string%(%d) "test8"
                    130: }
                    131: Fetch Row using Nested cursor Query
                    132: array(1) {
                    133:   [0]=>
                    134:   %unicode|string%(%d) "test9"
                    135: }
                    136: Number of roundtrips made with prefetch count 5 for 10 rows is  3
                    137: Done