summaryrefslogtreecommitdiff
path: root/ext/pdo/tests/pdo_010.phpt
diff options
context:
space:
mode:
Diffstat (limited to 'ext/pdo/tests/pdo_010.phpt')
-rw-r--r--ext/pdo/tests/pdo_010.phpt118
1 files changed, 0 insertions, 118 deletions
diff --git a/ext/pdo/tests/pdo_010.phpt b/ext/pdo/tests/pdo_010.phpt
deleted file mode 100644
index 6de31d1ea1..0000000000
--- a/ext/pdo/tests/pdo_010.phpt
+++ /dev/null
@@ -1,118 +0,0 @@
---TEST--
-PDO Common: PDO_FETCH_CLASSTYPE and GROUP/UNIQUE
---SKIPIF--
-<?php # vim:ft=php
-if (!extension_loaded('pdo')) die('skip');
-$dir = getenv('REDIR_TEST_DIR');
-if (false == $dir) die('skip no driver');
-require_once $dir . 'pdo_test.inc';
-PDOTest::skip();
-?>
---FILE--
-<?php
-require getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
-$db = PDOTest::factory();
-
-$db->exec('CREATE TABLE classtypes(id int NOT NULL PRIMARY KEY, name VARCHAR(10) NOT NULL UNIQUE)');
-$db->exec('INSERT INTO classtypes VALUES(0, \'stdClass\')');
-$db->exec('INSERT INTO classtypes VALUES(1, \'Test1\')');
-$db->exec('INSERT INTO classtypes VALUES(2, \'Test2\')');
-$db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, classtype int, val VARCHAR(10), grp VARCHAR(10))');
-$db->exec('INSERT INTO test VALUES(1, 0, \'A\', \'Group1\')');
-$db->exec('INSERT INTO test VALUES(2, 1, \'B\', \'Group1\')');
-$db->exec('INSERT INTO test VALUES(3, 2, \'C\', \'Group2\')');
-$db->exec('INSERT INTO test VALUES(4, 3, \'D\', \'Group2\')');
-
-$stmt = $db->prepare('SELECT classtypes.name, test.grp AS grp, test.id AS id, test.val AS val FROM test LEFT JOIN classtypes ON test.classtype=classtypes.id');
-
-class Test1
-{
- public function __construct()
- {
- echo __METHOD__ . "()\n";
- }
-}
-
-class Test2
-{
- public function __construct()
- {
- echo __METHOD__ . "()\n";
- }
-}
-
-class Test3
-{
- public function __construct()
- {
- echo __METHOD__ . "()\n";
- }
-}
-
-
-$stmt->execute();
-var_dump($stmt->fetchAll(PDO_FETCH_CLASS|PDO_FETCH_CLASSTYPE|PDO_FETCH_GROUP, 'Test3'));
-
-$stmt->execute();
-var_dump($stmt->fetchAll(PDO_FETCH_CLASS|PDO_FETCH_CLASSTYPE|PDO_FETCH_UNIQUE, 'Test3'));
-
-?>
---EXPECTF--
-Test1::__construct()
-Test2::__construct()
-Test3::__construct()
-array(2) {
- ["Group1"]=>
- array(2) {
- [0]=>
- object(stdClass)#%d (2) {
- ["id"]=>
- string(1) "1"
- ["val"]=>
- string(1) "A"
- }
- [1]=>
- object(Test1)#%d (2) {
- ["id"]=>
- string(1) "2"
- ["val"]=>
- string(1) "B"
- }
- }
- ["Group2"]=>
- array(2) {
- [0]=>
- object(Test2)#%d (2) {
- ["id"]=>
- string(1) "3"
- ["val"]=>
- string(1) "C"
- }
- [1]=>
- object(Test3)#%d (2) {
- ["id"]=>
- string(1) "4"
- ["val"]=>
- string(1) "D"
- }
- }
-}
-Test1::__construct()
-Test2::__construct()
-Test3::__construct()
-array(2) {
- ["Group1"]=>
- object(Test1)#%d (2) {
- ["id"]=>
- string(1) "2"
- ["val"]=>
- string(1) "B"
- }
- ["Group2"]=>
- object(Test3)#%d (2) {
- ["id"]=>
- string(1) "4"
- ["val"]=>
- string(1) "D"
- }
-}