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

[uwendel]

Author: uwendel
Date: 2008-03-03 18:33:51 +0100 (Mon, 03 Mar 2008)
New Revision: 1316

Added:
   trunk/tests/ext/pdo/pdo_class_pdo_row_interface.phpt
Log:
FETCH_LAZY has an interesting OO model as it seems...



Added: trunk/tests/ext/pdo/pdo_class_pdo_row_interface.phpt
===================================================================
--- trunk/tests/ext/pdo/pdo_class_pdo_row_interface.phpt	                        (rev 0)
+++ trunk/tests/ext/pdo/pdo_class_pdo_row_interface.phpt	2008-03-03 17:33:51 UTC (rev
1316)
@@ -0,0 +1,97 @@
+--TEST--
+PDO Common: PDORow class interface
+--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('PDO', false);
+
+$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\')');
+$stmt = $db->prepare('SELECT id FROM test WHERE id = 1');
+$stmt->execute();
+$row = $stmt->fetch(PDO::FETCH_LAZY);
+
+printf("Accessing values...\n");
+var_dump($row->id);
+var_dump($row->{0});
+var_dump($row->queryString);
+
+printf("Type\n");
+var_dump(get_class($row));
+
+printf("Parent class\n");
+var_dump(get_parent_class($row));
+
+printf("\nMethods:\n");
+var_dump(get_class_methods(get_class($row)));
+
+printf("\nClass variables:\n");
+var_dump(get_class_vars(get_class($row)));
+
+printf("\nObject variables:\n");
+var_dump(get_object_vars($row));
+print "done!";
+?>
+--BUGFREE_EXPECTF--
+Accessing values...
+string(1) "1"
+string(1) "1"
+string(32) "SELECT id FROM test WHERE id = 1"
+Type
+string(6) "PDORow"
+Parent class
+bool(false)
+
+Methods:
+array(0) {
+}
+
+Class variables:
+array(0) {
+}
+
+Object variables:
+array(2) {
+  ["queryString"]=>
+  string(32) "SELECT id FROM test WHERE id = 1"
+  ["id"]=>
+  string(1) "1"
+  [0]=>
+  string(1) "1"
+}
+done!
+--EXPECTF--
+Accessing values...
+string(1) "1"
+string(1) "1"
+UNKNOWN:0
+Type
+string(6) "PDORow"
+Parent class
+string(6) "PDORow"
+
+Methods:
+array(0) {
+}
+
+Class variables:
+array(0) {
+}
+
+Object variables:
+array(2) {
+  ["queryString"]=>
+  string(32) "SELECT id FROM test WHERE id = 1"
+  ["id"]=>
+  string(1) "1"
+}
+done!
\ No newline at end of file