Return to fetch_object_2.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: oci_fetch_object() with CLOB and NULL
                      3: --SKIPIF--
                      4: <?php
                      5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
                      6: require(dirname(__FILE__).'/skipif.inc');
                      7: ?>
                      8: --FILE--
                      9: <?php
                     10: 
                     11: require(dirname(__FILE__).'/connect.inc');
                     12: 
                     13: // Initialization
                     14: 
                     15: $stmtarray = array(
                     16:     "drop table fetch_object_2_tab",
                     17:     "create table fetch_object_2_tab (col1 number, col2 CLOB, col3 varchar2(15))",
                     18:     "insert into fetch_object_2_tab values (123, '1st row col2 string', '1 more text')",
                     19:     "insert into fetch_object_2_tab values (456, '2nd row col2 string', NULL)",
                     20:     "insert into fetch_object_2_tab values (789, '3rd row col2 string', '3 more text')",
                     21: );
                     22: 
                     23: oci8_test_sql_execute($c, $stmtarray);
                     24: 
                     25: // Run Test
                     26: 
                     27: echo "Test 1\n";
                     28: 
                     29: if (!($s = oci_parse($c, 'select * from fetch_object_2_tab order by 1'))) {
                     30:     die("oci_parse(select) failed!\n");
                     31: }
                     32: 
                     33: if (!oci_execute($s)) {
                     34:     die("oci_execute(select) failed!\n");
                     35: }
                     36: 
                     37: while ($row = oci_fetch_object($s)) {
                     38:     var_dump($row);
                     39: }
                     40: 
                     41: echo "Test 2\n";
                     42: 
                     43: if (!($s = oci_parse($c, 'select * from fetch_object_2_tab order by 1'))) {
                     44:     die("oci_parse(select) failed!\n");
                     45: }
                     46: 
                     47: if (!oci_execute($s)) {
                     48:     die("oci_execute(select) failed!\n");
                     49: }
                     50: 
                     51: while ($row = oci_fetch_object($s)) {
                     52:     echo $row->COL1 . "\n";
                     53:     echo $row->COL2->load(100) . "\n";
                     54:     echo $row->COL3 . "\n";
                     55: }
                     56: 
                     57: // Clean up
                     58: 
                     59: $stmtarray = array(
                     60:     "drop table fetch_object_2_tab"
                     61: );
                     62: 
                     63: oci8_test_sql_execute($c, $stmtarray);
                     64: 
                     65: ?>
                     66: ===DONE===
                     67: <?php exit(0); ?>
                     68: --EXPECTF--
                     69: Test 1
                     70: object(stdClass)#%d (3) {
                     71:   ["COL1"]=>
                     72:   string(3) "123"
                     73:   ["COL2"]=>
                     74:   object(OCI-Lob)#%d (1) {
                     75:     ["descriptor"]=>
                     76:     resource(%d) of type (oci8 descriptor)
                     77:   }
                     78:   ["COL3"]=>
                     79:   string(11) "1 more text"
                     80: }
                     81: object(stdClass)#%d (3) {
                     82:   ["COL1"]=>
                     83:   string(3) "456"
                     84:   ["COL2"]=>
                     85:   object(OCI-Lob)#%d (1) {
                     86:     ["descriptor"]=>
                     87:     resource(%d) of type (oci8 descriptor)
                     88:   }
                     89:   ["COL3"]=>
                     90:   NULL
                     91: }
                     92: object(stdClass)#%d (3) {
                     93:   ["COL1"]=>
                     94:   string(3) "789"
                     95:   ["COL2"]=>
                     96:   object(OCI-Lob)#%d (1) {
                     97:     ["descriptor"]=>
                     98:     resource(%d) of type (oci8 descriptor)
                     99:   }
                    100:   ["COL3"]=>
                    101:   string(11) "3 more text"
                    102: }
                    103: Test 2
                    104: 123
                    105: 1st row col2 string
                    106: 1 more text
                    107: 456
                    108: 2nd row col2 string
                    109: 
                    110: 789
                    111: 3rd row col2 string
                    112: 3 more text
                    113: ===DONE===