| List: | Commits | « Previous MessageNext Message » | |
| From: | uwendel | Date: | March 7 2008 2:23pm |
| Subject: | PHP mysqlnd svn commit: r1323 - trunk/tests/ext/pdo | ||
| View as plain text | |||
Author: uwendel Date: 2008-03-07 14:23:41 +0100 (Fri, 07 Mar 2008) New Revision: 1323 Added: trunk/tests/ext/pdo/pdo_stmt_fetchall.phpt trunk/tests/ext/pdo/pdo_stmt_fetchall_group.phpt Log: Test for PDOStatement::fetchAll(). Don't check how it works in detail. The assorted flags are neither well documented nor have I been able to figure out the logic behind some of them. Added: trunk/tests/ext/pdo/pdo_stmt_fetchall.phpt =================================================================== --- trunk/tests/ext/pdo/pdo_stmt_fetchall.phpt (rev 0) +++ trunk/tests/ext/pdo/pdo_stmt_fetchall.phpt 2008-03-07 13:23:41 UTC (rev 1323) @@ -0,0 +1,135 @@ +--TEST-- +PDO Common: PDOStatement->fetchAll() +--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 +if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.dirname(__FILE__) . '/../../pdo/tests/'); +require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc'; +$db = PDOTest::factory(); + +$db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY, val VARCHAR(10), grp VARCHAR(10))'); +$db->exec('INSERT INTO test VALUES(1, \'A\', \'Group1\')'); +$db->exec('INSERT INTO test VALUES(2, \'B\', \'Group2\')'); + +try { + + // default settings + $query = 'SELECT id FROM test ORDER by ID'; + $stmt = $db->prepare($query); + $stmt->execute(); + $expected = $stmt->fetchAll(); + var_dump($expected); + + if (!is_array($tmp = $stmt->fetchAll()) || (count($tmp) > 0)) + printf("[002] Expecting empty array, got %s\n", var_export($tmp, true)); + + $stmt->execute(); + $row = $stmt->fetch(); + $rows = $stmt->fetchAll(); + if ($expected[1] !== $rows[0]) + printf("[003] Expecting %s got %s\n", var_export($expected[1], true), var_export($rows[0], true)); + + // default shall equal FETCH_BOTH + $stmt->execute(); + $tmp = $stmt->fetchAll(PDO::FETCH_BOTH); + if ($tmp != $expected) + printf("[004] PDO::FETCH_BOTH and default fetch setting differ, default: %s, FETCH_BOTH: %s\n", + var_export($expected, true), var_export($tmp, true)); + + // FETCH_ASSOC + $tmp = array(); + $stmt->execute(); + $tmp = $stmt->fetchAll(PDO::FETCH_ASSOC); + if (count($tmp) == count($expected)) { + foreach ($tmp as $k => $v) + if (($v['id'] !== $expected[$k]['id']) || (count($v) > 1)) + printf("[006] Expecting %s got %s\n", var_export($expected[$k]['id'], true), var_export($v['id'], true)); + } else { + printf("[005] Got %d rows expecting %d rows\n", + count($tmp), count($expected)); + } + + // FETCH_NUM + $tmp = array(); + $stmt->execute(); + $tmp = $stmt->fetchAll(PDO::FETCH_NUM); + if (count($tmp) == count($expected)) { + foreach ($tmp as $k => $v) + if (($v[0] !== $expected[$k][0]) || (count($v) > 1)) + printf("[007] Expecting %s got %s\n", var_export($expected[$k][0], true), var_export($v[0], true)); + } else { + printf("[008] Got %d rows expecting %d rows\n", + count($tmp), count($expected)); + } + + // FETCH_OBJ + $tmp = array(); + $offset = 0; + $stmt->execute(); + $tmp = $stmt->fetchAll(PDO::FETCH_OBJ); + if (count($tmp) == count($expected)) { + foreach ($tmp as $k => $row) { + if (get_class($row) !== 'stdClass') + printf("[010] Expecting object of type stdClass got %s\n", get_class($row)); + + if (property_exists(get_class($row), 'id')) + printf("[011] That's a BC change to 5.3 in Feb 2008\n"); + + if ($row->id !== $expected[$offset]['id']) + printf("[012] Expecting id = %s got %s\n", + var_export($expected[$offset]['id'], true), + var_export($row->id, true)); + + $offset++; + } + } else { + printf("[009] Got %d rows expecting %d rows\n", + count($tmp), count($expected)); + } + + + $stmt->execute(); + $row = $stmt->fetch(PDO::FETCH_OBJ); + $row->id = 'myvalue'; + $tmp = $stmt->fetchAll(PDO::FETCH_OBJ); + $tmp[0]->id = 'myvalue'; + + + // PDO::FETCH_LAZY: combines PDO::FETCH_BOTH and PDO::FETCH_OBJ, creating the object variable names as they are accessed + $stmt->execute(); + $tmp = $stmt->fetchAll(PDO::FETCH_LAZY); + +} catch (PDOException $e) { + // we should never get here, we use warnings, but never trust a system... + printf("[001] %s, [%s} %s\n", + $e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo())); +} +print "done!"; +?> +--EXPECTF-- +array(2) { + [0]=> + array(2) { + ["id"]=> + string(1) "1" + [0]=> + string(1) "1" + } + [1]=> + array(2) { + ["id"]=> + string(1) "2" + [0]=> + string(1) "2" + } +} + +Warning: PDOStatement::fetchAll(): SQLSTATE[HY000]: General error: PDO::FETCH_LAZY can't be used with PDOStatement::fetchAll() in %s on line %d +done! \ No newline at end of file Added: trunk/tests/ext/pdo/pdo_stmt_fetchall_group.phpt =================================================================== --- trunk/tests/ext/pdo/pdo_stmt_fetchall_group.phpt (rev 0) +++ trunk/tests/ext/pdo/pdo_stmt_fetchall_group.phpt 2008-03-07 13:23:41 UTC (rev 1323) @@ -0,0 +1,274 @@ +--TEST-- +PDO Common: PDOStatement->fetchAll() / PDO::FETCH_GROUP +--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 +if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.dirname(__FILE__) . '/../../pdo/tests/'); +require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc'; +$db = PDOTest::factory(); + +$db->exec('CREATE TABLE test(id int NOT NULL PRIMARY KEY,grp VARCHAR(10), val VARCHAR(10))'); +$db->exec('INSERT INTO test(id, grp, val) VALUES(5, "A", "5-A")'); +$db->exec('INSERT INTO test(id, grp, val) VALUES(6, "A", "6-A")'); +$db->exec('INSERT INTO test(id, grp, val) VALUES(7, "B", "7-B")'); + +try { + + // default settings + $query = 'SELECT id, grp, val FROM test ORDER by ID'; + $stmt = $db->prepare($query); + $stmt->execute(); + $expected = $stmt->fetchAll(PDO::FETCH_ASSOC); + var_dump($expected); + + $stmt->execute(); + printf("fetchAll(PDO::FETCH_GROUP)\n"); + var_dump($tmp = $stmt->fetchAll(PDO::FETCH_GROUP)); + + $stmt->execute(); + // TODO: the rule seems to be: if no column index is given, + // use column index = 1 for the values and column_index = 0 for FETCH_GROUP + // However, this is not documented! + printf("fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP)\n"); + var_dump($tmp = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP)); + + $stmt->execute(); + printf("fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP, 0)\n"); + var_dump($tmp = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP, 0)); + + $stmt->execute(); + printf("fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP, 1)\n"); + var_dump($tmp = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP, 1)); + + // TODO: there seems to be an int overflow somewhere + $stmt->execute(); + printf("fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP, -1)\n"); + var_dump($tmp = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP, -1)); + + // TODO: see about about the column index default used + $stmt->execute(); + printf("fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE)\n"); + var_dump($tmp = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE)); + + $stmt->execute(); + printf("fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE, 0)\n"); + var_dump($tmp = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE, 0)); + + $stmt->execute(); + printf("fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE, 1)\n"); + var_dump($tmp = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP, 1)); + + $stmt->execute(); + printf("fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE, PHP_INT_MAX + 1)\n"); + var_dump($tmp = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP, PHP_INT_MAX + 1)); + +} catch (PDOException $e) { + // we should never get here, we use warnings, but never trust a system... + printf("[001] %s, [%s} %s\n", + $e->getMessage(), $db->errorInfo(), implode(' ', $db->errorInfo())); +} +print "done!"; +?> +--EXPECTF-- +array(3) { + [0]=> + array(3) { + ["id"]=> + string(1) "5" + ["grp"]=> + string(1) "A" + ["val"]=> + string(3) "5-A" + } + [1]=> + array(3) { + ["id"]=> + string(1) "6" + ["grp"]=> + string(1) "A" + ["val"]=> + string(3) "6-A" + } + [2]=> + array(3) { + ["id"]=> + string(1) "7" + ["grp"]=> + string(1) "B" + ["val"]=> + string(3) "7-B" + } +} +fetchAll(PDO::FETCH_GROUP) +array(3) { + [5]=> + array(1) { + [0]=> + array(4) { + ["grp"]=> + string(1) "A" + [0]=> + string(1) "A" + ["val"]=> + string(3) "5-A" + [1]=> + string(3) "5-A" + } + } + [6]=> + array(1) { + [0]=> + array(4) { + ["grp"]=> + string(1) "A" + [0]=> + string(1) "A" + ["val"]=> + string(3) "6-A" + [1]=> + string(3) "6-A" + } + } + [7]=> + array(1) { + [0]=> + array(4) { + ["grp"]=> + string(1) "B" + [0]=> + string(1) "B" + ["val"]=> + string(3) "7-B" + [1]=> + string(3) "7-B" + } + } +} +fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP) +array(3) { + [5]=> + array(1) { + [0]=> + string(1) "A" + } + [6]=> + array(1) { + [0]=> + string(1) "A" + } + [7]=> + array(1) { + [0]=> + string(1) "B" + } +} +fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP, 0) +array(3) { + [5]=> + array(1) { + [0]=> + string(1) "5" + } + [6]=> + array(1) { + [0]=> + string(1) "6" + } + [7]=> + array(1) { + [0]=> + string(1) "7" + } +} +fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP, 1) +array(2) { + ["A"]=> + array(2) { + [0]=> + string(1) "5" + [1]=> + string(1) "6" + } + ["B"]=> + array(1) { + [0]=> + string(1) "7" + } +} +fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP, -1) +array(3) { + [5]=> + array(1) { + [0]=> + string(1) "A" + } + [6]=> + array(1) { + [0]=> + string(1) "A" + } + [7]=> + array(1) { + [0]=> + string(1) "B" + } +} +fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE) +array(3) { + [5]=> + string(1) "A" + [6]=> + string(1) "A" + [7]=> + string(1) "B" +} +fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE, 0) +array(3) { + [5]=> + string(1) "5" + [6]=> + string(1) "6" + [7]=> + string(1) "7" +} +fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE, 1) +array(2) { + ["A"]=> + array(2) { + [0]=> + string(1) "5" + [1]=> + string(1) "6" + } + ["B"]=> + array(1) { + [0]=> + string(1) "7" + } +} +fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_UNIQUE, PHP_INT_MAX + 1) +array(3) { + [5]=> + array(1) { + [0]=> + string(1) "A" + } + [6]=> + array(1) { + [0]=> + string(1) "A" + } + [7]=> + array(1) { + [0]=> + string(1) "B" + } +} +done! \ No newline at end of file
| Thread | ||
|---|---|---|
| • PHP mysqlnd svn commit: r1323 - trunk/tests/ext/pdo | uwendel | 7 Mar |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.479 sec. using MySQL 5.1.14-beta-log