Return to bug57702.phpt CVS log

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

Annotation of embedaddon/php/ext/pdo_oci/tests/bug57702.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: PDO OCI Bug #57702 (Multi-row BLOB fetches)
                      3: --SKIPIF--
                      4: <?php
                      5: if (!extension_loaded('pdo') || !extension_loaded('pdo_oci')) die('skip not loaded');
                      6: require(dirname(__FILE__).'/../../pdo/tests/pdo_test.inc');
                      7: PDOTest::skip();
                      8: ?>
                      9: --FILE--
                     10: <?php
                     11: 
                     12: require('ext/pdo/tests/pdo_test.inc');
                     13: $db = PDOTest::test_factory('ext/pdo_oci/tests/common.phpt');
                     14: 
                     15: // Note the PDO test setup sets PDO::ATTR_STRINGIFY_FETCHES to true
                     16: // (and sets PDO::ATTR_CASE to PDO::CASE_LOWER)
                     17: 
                     18: $query = "begin execute immediate 'drop table mytable'; exception when others then if sqlcode <> -942 then raise; end if; end;";
                     19: $stmt = $db->prepare($query);
                     20: $stmt->execute();
                     21: 
                     22: $query = "create table bug57702 (id number, data1 blob, data2 blob)";
                     23: $stmt = $db->prepare($query);
                     24: $stmt->execute();
                     25: 
                     26: function do_insert($db, $id, $data1, $data2)
                     27: {
                     28:        $db->beginTransaction(); 
                     29:        $stmt = $db->prepare("insert into bug57702 (id, data1, data2) values (:id, empty_blob(), empty_blob()) returning data1, data2 into :blob1, :blob2");
                     30:        $stmt->bindParam(':id', $id);
                     31:        $stmt->bindParam(':blob1', $blob1, PDO::PARAM_LOB);
                     32:        $stmt->bindParam(':blob2', $blob2, PDO::PARAM_LOB);
                     33:        $blob1 = null;
                     34:        $blob2 = null;
                     35:        $stmt->execute();
                     36: 
                     37:        fwrite($blob1, $data1);  
                     38:        fclose($blob1);
                     39:        fwrite($blob2, $data2);  
                     40:        fclose($blob2); 
                     41:        $db->commit();
                     42: }
                     43: 
                     44: do_insert($db, 1, "row 1 col 1", "row 1 col 2");
                     45: do_insert($db, 2, "row 2 col 1", "row 2 col 2");
                     46: 
                     47: ////////////////////
                     48: 
                     49: echo "First Query\n";
                     50: 
                     51: // Fetch it back
                     52: $stmt = $db->prepare('select data1, data2 from bug57702 order by id');
                     53: $stmt->execute();
                     54: $row = $stmt->fetch(PDO::FETCH_ASSOC);
                     55: var_dump($row['data1']);
                     56: var_dump($row['data2']);
                     57: $row = $stmt->fetch(PDO::FETCH_ASSOC);
                     58: var_dump($row['data1']);
                     59: var_dump($row['data2']);
                     60: 
                     61: ////////////////////
                     62: 
                     63: echo "\nSecond Query\n";
                     64: 
                     65: foreach($db->query("select data1 as d1, data2 as d2 from bug57702 order by id") as $row) {
                     66:        var_dump($row['d1']);
                     67:        var_dump($row['d2']);
                     68: }
                     69: 
                     70: ////////////////////
                     71: 
                     72: echo "\nThird Query\n";
                     73: 
                     74: $stmt = $db->prepare('select data1 as d3_1, data2 as d3_2 from bug57702 order by id');
                     75: 
                     76: $rs = $stmt->execute();
                     77: $stmt->bindColumn('d3_1' , $clob1, PDO::PARAM_LOB);
                     78: $stmt->bindColumn('d3_2' , $clob2, PDO::PARAM_LOB);
                     79: 
                     80: while ($stmt->fetch(PDO::FETCH_BOUND)) {
                     81:     var_dump($clob1);
                     82:     var_dump($clob2);
                     83: }
                     84: print "done\n";
                     85: 
                     86: ////////////////////
                     87: 
                     88: echo "\nFourth Query\n"; 
                     89: 
                     90: $a = array();
                     91: $i = 0;
                     92: foreach($db->query("select data1 as d4_1, data2 as d4_2 from bug57702 order by id") as $row) {
                     93:        $a[$i][0] = $row['d4_1'];
                     94:        $a[$i][1] = $row['d4_2'];
                     95:     $i++;
                     96: }
                     97: 
                     98: for ($i = 0; $i < count($a); $i++) {
                     99:     var_dump($a[$i][0]);
                    100:     var_dump($a[$i][1]);
                    101: }
                    102: 
                    103: ////////////////////
                    104: 
                    105: echo "\nFifth Query\n"; 
                    106: 
                    107: $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);  // Let's use streams
                    108: 
                    109: // Since each column only has one lob descriptor, the last row is
                    110: // shown twice because the lob descriptor for each column is reused in
                    111: // the stream
                    112: 
                    113: $a = array();
                    114: $i = 0;
                    115: foreach($db->query("select data1 as d4_1, data2 as d4_2 from bug57702 order by id") as $row) {
                    116:        $a[$i][0] = $row['d4_1'];
                    117:        $a[$i][1] = $row['d4_2'];
                    118:     $i++;
                    119: }
                    120: 
                    121: for ($i = 0; $i < count($a); $i++) {
                    122:     var_dump(stream_get_contents($a[$i][0]));
                    123:     var_dump(stream_get_contents($a[$i][1]));
                    124: }
                    125: 
                    126: // Cleanup
                    127: $query = "drop table bug57702";
                    128: $stmt = $db->prepare($query);
                    129: $stmt->execute();
                    130: 
                    131: print "done\n";
                    132: 
                    133: ?>
                    134: --EXPECTF--
                    135: First Query
                    136: string(11) "row 1 col 1"
                    137: string(11) "row 1 col 2"
                    138: string(11) "row 2 col 1"
                    139: string(11) "row 2 col 2"
                    140: 
                    141: Second Query
                    142: string(11) "row 1 col 1"
                    143: string(11) "row 1 col 2"
                    144: string(11) "row 2 col 1"
                    145: string(11) "row 2 col 2"
                    146: 
                    147: Third Query
                    148: string(11) "row 1 col 1"
                    149: string(11) "row 1 col 2"
                    150: string(11) "row 2 col 1"
                    151: string(11) "row 2 col 2"
                    152: done
                    153: 
                    154: Fourth Query
                    155: string(11) "row 1 col 1"
                    156: string(11) "row 1 col 2"
                    157: string(11) "row 2 col 1"
                    158: string(11) "row 2 col 2"
                    159: 
                    160: Fifth Query
                    161: string(11) "row 2 col 1"
                    162: string(11) "row 2 col 2"
                    163: string(11) "row 2 col 1"
                    164: string(11) "row 2 col 2"
                    165: done