diff options
Diffstat (limited to 'ext/pdo/tests/pdo_031.phpt')
-rwxr-xr-x | ext/pdo/tests/pdo_031.phpt | 63 |
1 files changed, 0 insertions, 63 deletions
diff --git a/ext/pdo/tests/pdo_031.phpt b/ext/pdo/tests/pdo_031.phpt deleted file mode 100755 index 30a75d79b4..0000000000 --- a/ext/pdo/tests/pdo_031.phpt +++ /dev/null @@ -1,63 +0,0 @@ ---TEST-- -PDO Common: PDOStatement SPL iterator ---SKIPIF-- -<?php # vim:ft=php -if (!extension_loaded('pdo')) die('skip'); -if (!extension_loaded('SPL')) print 'skip SPL not available'; -$dir = getenv('REDIR_TEST_DIR'); -if (false == $dir) die('skip no driver'); -require_once $dir . 'pdo_test.inc'; -if (!class_exists('RecursiveArrayIterator', false)) die('skip Class RecursiveArrayIterator missing'); -if (!class_exists('RecursiveTreeIterator', false) && !file_exists(getenv('REDIR_TEST_DIR').'../../spl/examples/recursivetreeiterator.inc')) die('skip Class RecursiveTreeIterator missing'); -PDOTest::skip(); -?> ---FILE-- -<?php -if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.dirname(__FILE__) . '/../../pdo/tests/'); -require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc'; -if (!class_exists('RecursiveTreeIterator', false)) require_once(getenv('REDIR_TEST_DIR').'../../spl/examples/recursivetreeiterator.inc'); - -$data = array( - array('10', 'Abc', 'zxy'), - array('20', 'Def', 'wvu'), - array('30', 'Ghi', 'tsr'), -); - -$db = PDOTest::factory(); - -$db->exec('CREATE TABLE test(id INT NOT NULL PRIMARY KEY, val VARCHAR(10), val2 VARCHAR(16))'); - -$stmt = $db->prepare("INSERT INTO test VALUES(?, ?, ?)"); -foreach ($data as $row) { - $stmt->execute($row); -} - -unset($stmt); - -echo "===QUERY===\n"; - -$stmt = $db->query('SELECT * FROM test'); - -foreach(new RecursiveTreeIterator(new RecursiveArrayIterator($stmt->fetchAll(PDO::FETCH_ASSOC)), RecursiveTreeIterator::BYPASS_KEY) as $c=>$v) -{ - echo "$v [$c]\n"; -} - -echo "===DONE===\n"; -exit(0); -?> ---EXPECT-- -===QUERY=== -|-Array [0] -| |-10 [id] -| |-Abc [val] -| \-zxy [val2] -|-Array [1] -| |-20 [id] -| |-Def [val] -| \-wvu [val2] -\-Array [2] - |-30 [id] - |-Ghi [val] - \-tsr [val2] -===DONE=== |