xref: /PHP-5.4/ext/pdo/tests/pdo_018.phpt (revision 0f53b4e5)
1--TEST--
2PDO Common: serializing
3--SKIPIF--
4<?php # vim:ft=php
5if (!extension_loaded('pdo')) die('skip');
6if (!interface_exists('Serializable')) die('skip no Serializable interface');
7$dir = getenv('REDIR_TEST_DIR');
8if (false == $dir) die('skip no driver');
9require_once $dir . 'pdo_test.inc';
10PDOTest::skip();
11?>
12--FILE--
13<?php
14if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.dirname(__FILE__) . '/../../pdo/tests/');
15require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
16$db = PDOTest::factory();
17
18class TestBase implements Serializable
19{
20	public    $BasePub = 'Public';
21	protected $BasePro = 'Protected';
22	private   $BasePri = 'Private';
23
24	function serialize()
25	{
26		$serialized = array();
27		foreach($this as $prop => $val) {
28			$serialized[$prop] = $val;
29		}
30		$serialized = serialize($serialized);
31		echo __METHOD__ . "() = '$serialized'\n";
32		return $serialized;
33	}
34
35	function unserialize($serialized)
36	{
37		echo __METHOD__ . "($serialized)\n";
38		foreach(unserialize($serialized) as $prop => $val) {
39			$this->$prop = '#'.$val;
40		}
41		return true;
42	}
43}
44
45class TestDerived extends TestBase
46{
47	public    $BasePub    = 'DerivedPublic';
48	protected $BasePro    = 'DerivdeProtected';
49	public    $DerivedPub = 'Public';
50	protected $DerivedPro = 'Protected';
51	private   $DerivedPri = 'Private';
52
53	function serialize()
54	{
55		echo __METHOD__ . "()\n";
56		return TestBase::serialize();
57	}
58
59	function unserialize($serialized)
60	{
61		echo __METHOD__ . "()\n";
62		return TestBase::unserialize($serialized);
63	}
64}
65
66class TestLeaf extends TestDerived
67{
68}
69
70$db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(20) NOT NULL UNIQUE)');
71$db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')');
72$db->exec('INSERT INTO classtypes VALUES(1, \'TestBase\')');
73$db->exec('INSERT INTO classtypes VALUES(2, \'TestDerived\')');
74$db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(255))');
75
76$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
77
78var_dump($db->query('SELECT COUNT(*) FROM classtypes')->fetchColumn());
79var_dump($db->query('SELECT id, name FROM classtypes ORDER by id')->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE));
80
81$objs = array();
82$objs[0] = new stdClass;
83$objs[1] = new TestBase;
84$objs[2] = new TestDerived;
85$objs[3] = new TestLeaf;
86
87$stmt = $db->prepare('SELECT id FROM classtypes WHERE name=:cname');
88$stmt->bindParam(':cname', $cname);
89
90$ctypes = array();
91
92foreach($objs as $obj)
93{
94	$cname = get_class($obj);
95	$ctype = NULL; /* set default for non stored class name */
96	$stmt->execute();
97	$stmt->bindColumn('id', $ctype);
98	$stmt->fetch(PDO::FETCH_BOUND);
99	$ctypes[$cname] = $ctype;
100}
101
102echo "===TYPES===\n";
103var_dump($ctypes);
104
105unset($stmt);
106
107echo "===INSERT===\n";
108$stmt = $db->prepare('INSERT INTO test VALUES(:id, :classtype, :val)');
109$stmt->bindParam(':id', $idx);
110$stmt->bindParam(':classtype', $ctype);
111$stmt->bindParam(':val', $val);
112
113foreach($objs as $idx => $obj)
114{
115	$ctype = $ctypes[get_class($obj)];
116	if (method_exists($obj, 'serialize'))
117	{
118		$val = $obj->serialize();
119	}
120	else
121	{
122		$val = '';
123	}
124	$stmt->execute();
125}
126
127unset($stmt);
128
129echo "===DATA===\n";
130$res = $db->query('SELECT test.val FROM test')->fetchAll(PDO::FETCH_COLUMN);
131
132// For Oracle map NULL to empty string so the test doesn't diff
133if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'oci' && $res[0] === null) {
134    $res[0] = "";
135}
136var_dump($res);
137
138echo "===FAILURE===\n";
139try
140{
141	$db->query('SELECT classtypes.name AS name, test.val AS val FROM test LEFT JOIN classtypes ON test.classtype=classtypes.id')->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_CLASSTYPE|PDO::FETCH_SERIALIZE, 'TestLeaf', array());
142}
143catch (PDOException $e)
144{
145	echo 'Exception:';
146	echo $e->getMessage()."\n";
147}
148
149echo "===COUNT===\n";
150var_dump($db->query('SELECT COUNT(*) FROM test LEFT JOIN classtypes ON test.classtype=classtypes.id WHERE (classtypes.id IS NULL OR classtypes.id > 0)')->fetchColumn());
151
152echo "===DATABASE===\n";
153$stmt = $db->prepare('SELECT classtypes.name AS name, test.val AS val FROM test LEFT JOIN classtypes ON test.classtype=classtypes.id WHERE (classtypes.id IS NULL OR classtypes.id > 0)');
154
155$stmt->execute();
156var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));
157
158echo "===FETCHCLASS===\n";
159$stmt->execute();
160var_dump($stmt->fetchAll(PDO::FETCH_CLASS|PDO::FETCH_CLASSTYPE|PDO::FETCH_SERIALIZE, 'TestLeaf'));
161
162
163?>
164--EXPECTF--
165string(1) "3"
166array(3) {
167  [0]=>
168  string(8) "stdClass"
169  [1]=>
170  string(8) "TestBase"
171  [2]=>
172  string(11) "TestDerived"
173}
174===TYPES===
175array(4) {
176  ["stdClass"]=>
177  string(1) "0"
178  ["TestBase"]=>
179  string(1) "1"
180  ["TestDerived"]=>
181  string(1) "2"
182  ["TestLeaf"]=>
183  NULL
184}
185===INSERT===
186TestBase::serialize() = 'a:3:{s:7:"BasePub";s:6:"Public";s:7:"BasePro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}'
187TestDerived::serialize()
188TestBase::serialize() = 'a:5:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}'
189TestDerived::serialize()
190TestBase::serialize() = 'a:5:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}'
191===DATA===
192array(4) {
193  [0]=>
194  string(0) ""
195  [1]=>
196  string(91) "a:3:{s:7:"BasePub";s:6:"Public";s:7:"BasePro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}"
197  [2]=>
198  string(172) "a:5:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}"
199  [3]=>
200  string(172) "a:5:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}"
201}
202===FAILURE===
203Exception:SQLSTATE[HY000]: General error: cannot unserialize class
204===COUNT===
205string(1) "3"
206===DATABASE===
207array(3) {
208  [0]=>
209  array(2) {
210    ["name"]=>
211    string(8) "TestBase"
212    ["val"]=>
213    string(91) "a:3:{s:7:"BasePub";s:6:"Public";s:7:"BasePro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}"
214  }
215  [1]=>
216  array(2) {
217    ["name"]=>
218    string(11) "TestDerived"
219    ["val"]=>
220    string(172) "a:5:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}"
221  }
222  [2]=>
223  array(2) {
224    ["name"]=>
225    NULL
226    ["val"]=>
227    string(172) "a:5:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";s:7:"BasePri";s:7:"Private";}"
228  }
229}
230===FETCHCLASS===
231TestBase::unserialize(a:3:{s:7:"BasePub";s:6:"Public";s:7:"BasePro";s:9:"Protected";s:7:"BasePri";s:7:"Private";})
232TestDerived::unserialize()
233TestBase::unserialize(a:5:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";s:7:"BasePri";s:7:"Private";})
234TestDerived::unserialize()
235TestBase::unserialize(a:5:{s:7:"BasePub";s:13:"DerivedPublic";s:7:"BasePro";s:16:"DerivdeProtected";s:10:"DerivedPub";s:6:"Public";s:10:"DerivedPro";s:9:"Protected";s:7:"BasePri";s:7:"Private";})
236array(3) {
237  [0]=>
238  object(TestBase)#%d (3) {
239    ["BasePub"]=>
240    string(7) "#Public"
241    ["BasePro":protected]=>
242    string(10) "#Protected"
243    ["BasePri":"TestBase":private]=>
244    string(8) "#Private"
245  }
246  [1]=>
247  object(TestDerived)#%d (6) {
248    ["BasePub"]=>
249    string(14) "#DerivedPublic"
250    ["BasePro":protected]=>
251    string(17) "#DerivdeProtected"
252    ["DerivedPub"]=>
253    string(7) "#Public"
254    ["DerivedPro":protected]=>
255    string(10) "#Protected"
256    ["DerivedPri":"TestDerived":private]=>
257    string(7) "Private"
258    ["BasePri":"TestBase":private]=>
259    string(8) "#Private"
260  }
261  [2]=>
262  object(TestLeaf)#%d (6) {
263    ["BasePub"]=>
264    string(14) "#DerivedPublic"
265    ["BasePro":protected]=>
266    string(17) "#DerivdeProtected"
267    ["DerivedPub"]=>
268    string(7) "#Public"
269    ["DerivedPro":protected]=>
270    string(10) "#Protected"
271    ["DerivedPri":"TestDerived":private]=>
272    string(7) "Private"
273    ["BasePri":"TestBase":private]=>
274    string(8) "#Private"
275  }
276}
277