diff options
Diffstat (limited to 'ext/pdo_mysql/tests/pdo_mysql_stmt_fetchobject.phpt')
| -rw-r--r-- | ext/pdo_mysql/tests/pdo_mysql_stmt_fetchobject.phpt | 109 |
1 files changed, 109 insertions, 0 deletions
diff --git a/ext/pdo_mysql/tests/pdo_mysql_stmt_fetchobject.phpt b/ext/pdo_mysql/tests/pdo_mysql_stmt_fetchobject.phpt new file mode 100644 index 0000000..2e278b1 --- /dev/null +++ b/ext/pdo_mysql/tests/pdo_mysql_stmt_fetchobject.phpt @@ -0,0 +1,109 @@ +--TEST-- +MySQL PDO: PDOStatement->fetchObject() +--SKIPIF-- +<?php +require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'skipif.inc'); +require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc'); +MySQLPDOTest::skip(); +$db = MySQLPDOTest::factory(); + +try { + $query = "SELECT '', NULL, \"\" FROM DUAL"; + $stmt = $db->prepare($query); + $ok = @$stmt->execute(); +} catch (PDOException $e) { + die("skip: Test cannot be run with SQL mode ANSI"); +} +if (!$ok) + die("skip: Test cannot be run with SQL mode ANSI"); +?> +--FILE-- +<?php +require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc'); +$db = MySQLPDOTest::factory(); +MySQLPDOTest::createTestTable($db); + +try { + + $query = "SELECT id, '', NULL, \"\" FROM test ORDER BY id ASC LIMIT 3"; + $stmt = $db->prepare($query); + + class myclass { + + private $set_calls = 0; + protected static $static_set_calls = 0; + + // NOTE: PDO does not care about protected + protected $grp; + + // NOTE: PDO does not care about private and calls __construct() after __set() + private function __construct($param1, $param2) { + printf("myclass::__construct(%s, %s): %d / %d\n", + $param1, $param2, + self::$static_set_calls, $this->set_calls); + } + + // NOTE: PDO will call __set() prior to calling __construct() + public function __set($prop, $value) { + $this->not_a_magic_one(); + printf("myclass::__set(%s, -%s-) %d\n", + $prop, var_export($value, true), $this->set_calls, self::$static_set_calls); + if ("" != $prop) + $this->{$prop} = $value; + } + + // NOTE: PDO can call regular methods prior to calling __construct() + public function not_a_magic_one() { + $this->set_calls++; + self::$static_set_calls++; + } + + } + $stmt->execute(); + $rowno = 0; + $rows[] = array(); + while (is_object($rows[] = $stmt->fetchObject('myclass', array($rowno++, $rowno)))) + ; + + var_dump($rows[$rowno - 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!"; +?> +--CLEAN-- +<?php +require dirname(__FILE__) . '/mysql_pdo_test.inc'; +MySQLPDOTest::dropTestTable(); +?> +--EXPECTF-- +myclass::__set(id, -'1'-) 1 +myclass::__set(, -''-) 2 +myclass::__set(null, -NULL-) 3 +myclass::__set(, -''-) 4 +myclass::__construct(0, 1): 4 / 4 +myclass::__set(id, -'2'-) 1 +myclass::__set(, -''-) 2 +myclass::__set(null, -NULL-) 3 +myclass::__set(, -''-) 4 +myclass::__construct(1, 2): 8 / 4 +myclass::__set(id, -'3'-) 1 +myclass::__set(, -''-) 2 +myclass::__set(null, -NULL-) 3 +myclass::__set(, -''-) 4 +myclass::__construct(2, 3): 12 / 4 +object(myclass)#%d (4) { + [%u|b%"set_calls":"myclass":private]=> + int(4) + [%u|b%"grp":protected]=> + NULL + [%u|b%"id"]=> + %unicode|string%(1) "3" + [%u|b%"null"]=> + NULL +} +done! |