PHP mysqlnd svn commit: r1168 - trunk/tests/ext/pdo

[uwendel]

Author: uwendel
Date: 2007-12-12 18:42:29 +0100 (Wed, 12 Dec 2007)
New Revision: 1168

Added:
   trunk/tests/ext/pdo/pdo_query_tmp_invalid_fetch_class.phpt
   trunk/tests/ext/pdo/pdo_query_tmp_params.phpt
Log:
Isolated issues from pdo_query.phpt. Remove after fixing.


Added: trunk/tests/ext/pdo/pdo_query_tmp_invalid_fetch_class.phpt
===================================================================
--- trunk/tests/ext/pdo/pdo_query_tmp_invalid_fetch_class.phpt	                       
(rev 0)
+++ trunk/tests/ext/pdo/pdo_query_tmp_invalid_fetch_class.phpt	2007-12-12 17:42:29 UTC
(rev 1168)
@@ -0,0 +1,39 @@
+--TEST--
+PDO Common: PDO->query() - temporary for bug fixing, remove, part of pdo_query.phpt
+--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 {
+
+	$stmt = $db->query('SELECT id, val FROM test', PDO::FETCH_CLASS,
'invalid_fetch_class');
+	var_dump($db->errorInfo());
+	if (is_object($stmt)) {
+		$res = $stmt->fetchAll();
+		var_dump($res);
+	}
+
+} catch (PDOException $e) {
+	// we should never get here, we use warnings, but never trust a system...s
+	printf("[001] %s, [%s} %s\n",
+		$e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
+}
+print "done!";
+?>
+--EXPECTF--
+done!
\ No newline at end of file

Added: trunk/tests/ext/pdo/pdo_query_tmp_params.phpt
===================================================================
--- trunk/tests/ext/pdo/pdo_query_tmp_params.phpt	                        (rev 0)
+++ trunk/tests/ext/pdo/pdo_query_tmp_params.phpt	2007-12-12 17:42:29 UTC (rev 1168)
@@ -0,0 +1,53 @@
+--TEST--
+PDO Common: PDO->query() - temporary for bug fixing, remove, part of pdo_query.phpt
+--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 {
+
+	/*
+	Valid:
+	PDOStatement query  ( string $statement  )
+	PDOStatement query  ( string $statement  , int $PDO::FETCH_COLUMN  , int $colno  )
+	PDOStatement query  ( string $statement  , int $PDO::FETCH_CLASS  , string $classname  ,
array $ctorargs  )
+	PDOStatement query  ( string $statement  , int $PDO::FETCH_INTO  , object $object  )
+
+	Invalid:
+	query(string, object)
+	query(string, int, int, int)
+	*/
+	$mode = new stdClass();
+	if (false !== ($ret = @$db->query('SELECT id, val FROM test', $mode)))
+		printf("[002] Expecting false/boolean got %s/%s\n",
+			var_export($ret, true), gettype($ret));
+
+	if (false !== ($ret = @$db->query('SELECT id, val FROM test', 1, 1, 1)))
+		printf("[003] Expecting false/boolean got %s/%s\n",
+			var_export($ret, true), gettype($ret));
+
+
+} catch (PDOException $e) {
+	// we should never get here, we use warnings, but never trust a system...s
+	printf("[001] %s, [%s} %s\n",
+		$e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));
+}
+print "done!";
+?>
+--EXPECTF--
+done!
\ No newline at end of file