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
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>