Annotation of embedaddon/php/ext/pdo_oci/tests/bug57702.phpt, revision 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
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>