uw Mon Jul 23 12:28:12 2007 UTC Added files: /php-src/ext/mysqli/tests mysqli_fetch_object_no_constructor.phpt mysqli_fetch_object_no_object.phpt mysqli_fetch_object_oo.phpt mysqli_fetch_object.phpt Log: Tests for mysqli_fetch_object()
http://cvs.php.net/viewvc.cgi/php-src/ext/mysqli/tests/mysqli_fetch_object_no_constructor.phpt?view=markup&rev=1.1 Index: php-src/ext/mysqli/tests/mysqli_fetch_object_no_constructor.phpt +++ php-src/ext/mysqli/tests/mysqli_fetch_object_no_constructor.phpt --TEST-- mysqli_fetch_object() - calling constructor on class wo constructor --SKIPIF-- <?php require_once('skipif.inc'); ?> <?php require_once('skipifemb.inc'); ?> --FILE-- <?php include "connect.inc";
$tmp = NULL; $link = NULL; require('table.inc'); if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5")) { printf("[001] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); } class mysqli_fetch_object_test { public $a = null; public $b = null; public function toString() { var_dump($this); } } printf("No exception with PHP:\n"); var_dump($obj = new mysqli_fetch_object_test(1, 2)); printf("\nException with mysqli. Note that at all other places we throws errors but no exceptions unless the error mode has been changed:\n"); try { var_dump($obj = mysqli_fetch_object($res, 'mysqli_fetch_object_test', array(1, 2))); } catch (Exception $e) { printf("Exception: %s\n", $e->getMessage()); } printf("\nFatal error with PHP (but no exception!):\n"); var_dump($obj->mysqli_fetch_object_test(1, 2)); mysqli_close($link); print "done!"; ?> --EXPECTF-- No exception with PHP: object(mysqli_fetch_object_test)#%d (%d) { ["a"]=> NULL ["b"]=> NULL } Exception with mysqli. Note that at all other places we throws errors but no exceptions unless the error mode has been changed: Exception: Class mysqli_fetch_object_test does not have a constructor hence you cannot use ctor_params Fatal error with PHP (but no exception!): Fatal error: Call to undefined method mysqli_fetch_object_test::mysqli_fetch_object_test() in %s on line %d --UEXPECTF-- No exception with PHP: object(mysqli_fetch_object_test)#%d (%d) { [%s"a"]=> NULL [%s"b"]=> NULL } Exception with mysqli. Note that at all other places we throws errors but no exceptions unless the error mode has been changed: Exception: Class mysqli_fetch_object_test does not have a constructor hence you cannot use ctor_params Fatal error with PHP (but no exception!): Fatal error: Call to undefined method mysqli_fetch_object_test::mysqli_fetch_object_test() in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/mysqli/tests/mysqli_fetch_object_no_object.phpt?view=markup&rev=1.1 Index: php-src/ext/mysqli/tests/mysqli_fetch_object_no_object.phpt +++ php-src/ext/mysqli/tests/mysqli_fetch_object_no_object.phpt --TEST-- mysqli_fetch_object() --SKIPIF-- <?php require_once('skipif.inc'); ?> <?php require_once('skipifemb.inc'); ?> --FILE-- <?php include "connect.inc"; require('table.inc'); if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5")) { printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); } $obj = mysqli_fetch_object($res); var_dump(gettype($obj)); mysqli_close($link); print "done!"; ?> --EXPECTF-- %s(6) "object" done! http://cvs.php.net/viewvc.cgi/php-src/ext/mysqli/tests/mysqli_fetch_object_oo.phpt?view=markup&rev=1.1 Index: php-src/ext/mysqli/tests/mysqli_fetch_object_oo.phpt +++ php-src/ext/mysqli/tests/mysqli_fetch_object_oo.phpt --TEST-- mysqli_fetch_object() --SKIPIF-- <?php require_once('skipif.inc'); ?> <?php require_once('skipifemb.inc'); ?> --FILE-- <?php include "connect.inc"; $tmp = NULL; $link = NULL; $mysqli = new mysqli(); $res = @new mysqli_result($mysqli); if (!is_null($tmp = @$res->fetch_object())) printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); require('table.inc'); if (!$mysqli = new mysqli($host, $user, $passwd, $db, $port, $socket)) printf("[002] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $user, $db, $port, $socket); if (!$res = $mysqli->query("SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5")) { printf("[003] [%d] %s\n", $mysqli->errno, $mysqli->error); } if (!is_null($tmp = @$res->fetch_object($link))) printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); if (!is_null($tmp = @$res->fetch_object($link, $link))) printf("[005] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); if (!is_null($tmp = @$res->fetch_object($link, $link, $link))) printf("[006] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); $obj = mysqli_fetch_object($res); if (($obj->ID !== "1") || ($obj->label !== "a") || (get_class($obj) != 'stdClass')) { printf("[007] Object seems wrong. [%d] %s\n", $mysqli->errno, $mysqli->error); var_dump($obj); } class mysqli_fetch_object_test { public $a = null; public $b = null; public function toString() { var_dump($this); } } $obj = $res->fetch_object('mysqli_fetch_object_test'); if (($obj->ID !== "2") || ($obj->label !== "b") || ($obj->a !== NULL) || ($obj->b !== NULL) || (get_class($obj) != 'mysqli_fetch_object_test')) { printf("[008] Object seems wrong. [%d] %s\n", $mysqli->errno, $mysqli->error); var_dump($obj); } class mysqli_fetch_object_construct extends mysqli_fetch_object_test { public function __construct($a, $b) { $this->a = $a; $this->b = $b; } } $obj = $res->fetch_object('mysqli_fetch_object_construct', null); if (($obj->ID !== "3") || ($obj->label !== "c") || ($obj->a !== NULL) || ($obj->b !== NULL) || (get_class($obj) != 'mysqli_fetch_object_construct')) { printf("[009] Object seems wrong. [%d] %s\n", $mysqli->errno, $mysqli->error); var_dump($obj); } $obj = $res->fetch_object('mysqli_fetch_object_construct', array('a')); if (($obj->ID !== "4") || ($obj->label !== "d") || ($obj->a !== 'a') || ($obj->b !== NULL) || (get_class($obj) != 'mysqli_fetch_object_construct')) { printf("[010] Object seems wrong. [%d] %s\n", $mysqli->errno, $mysqli->error); var_dump($obj); } $obj = $res->fetch_object('mysqli_fetch_object_construct', array('a', 'b')); if (($obj->ID !== "5") || ($obj->label !== "e") || ($obj->a !== 'a') || ($obj->b !== 'b') || (get_class($obj) != 'mysqli_fetch_object_construct')) { printf("[011] Object seems wrong. [%d] %s\n", $mysqli->errno, $mysqli->error); var_dump($obj); } var_dump($res->fetch_object('mysqli_fetch_object_construct', array('a', 'b', 'c'))); var_dump(mysqli_fetch_object($res)); mysqli_free_result($res); if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST")) { printf("[012] [%d] %s\n", $mysqli->errno, $mysqli->error); } mysqli_free_result($res); var_dump(mysqli_fetch_object($res)); // Fatal error, script execution will end var_dump($res->fetch_object('this_class_does_not_exist')); $mysqli->close(); print "done!"; ?> --EXPECTF-- Warning: Missing argument 1 for mysqli_fetch_object_construct::__construct() in %s on line %d Warning: Missing argument 2 for mysqli_fetch_object_construct::__construct() in %s on line %d Notice: Undefined variable: a in %s on line %d Notice: Undefined variable: b in %s on line %d Warning: Missing argument 2 for mysqli_fetch_object_construct::__construct() in %s on line %d Notice: Undefined variable: b in %s on line %d NULL NULL Warning: mysqli_fetch_object(): Couldn't fetch mysqli_result in %s on line %d NULL Fatal error: Class 'this_class_does_not_exist' not found in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/mysqli/tests/mysqli_fetch_object.phpt?view=markup&rev=1.1 Index: php-src/ext/mysqli/tests/mysqli_fetch_object.phpt +++ php-src/ext/mysqli/tests/mysqli_fetch_object.phpt --TEST-- mysqli_fetch_object() --SKIPIF-- <?php require_once('skipif.inc'); ?> <?php require_once('skipifemb.inc'); ?> --FILE-- <?php include_once("connect.inc"); $tmp = NULL; $link = NULL; if (!is_null($tmp = @mysqli_fetch_object())) printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); if (!is_null($tmp = @mysqli_fetch_object($link))) printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); require('table.inc'); if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5")) { printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); } $obj = mysqli_fetch_object($res); if (($obj->ID !== "1") || ($obj->label !== "a") || (get_class($obj) != 'stdClass')) { printf("[004] Object seems wrong. [%d] %s\n", mysqli_errno($link), mysqli_error($link)); var_dump($obj); } class mysqli_fetch_object_test { public $a = null; public $b = null; public function toString() { var_dump($this); } } $obj = mysqli_fetch_object($res, 'mysqli_fetch_object_test'); if (($obj->ID !== "2") || ($obj->label !== "b") || ($obj->a !== NULL) || ($obj->b !== NULL) || (get_class($obj) != 'mysqli_fetch_object_test')) { printf("[005] Object seems wrong. [%d] %s\n", mysqli_errno($link), mysqli_error($link)); var_dump($obj); } class mysqli_fetch_object_construct extends mysqli_fetch_object_test { public function __construct($a, $b) { $this->a = $a; $this->b = $b; } } $obj = mysqli_fetch_object($res, 'mysqli_fetch_object_construct', null); if (($obj->ID !== "3") || ($obj->label !== "c") || ($obj->a !== NULL) || ($obj->b !== NULL) || (get_class($obj) != 'mysqli_fetch_object_construct')) { printf("[006] Object seems wrong. [%d] %s\n", mysqli_errno($link), mysqli_error($link)); var_dump($obj); } $obj = mysqli_fetch_object($res, 'mysqli_fetch_object_construct', array('a')); if (($obj->ID !== "4") || ($obj->label !== "d") || ($obj->a !== 'a') || ($obj->b !== NULL) || (get_class($obj) != 'mysqli_fetch_object_construct')) { printf("[007] Object seems wrong. [%d] %s\n", mysqli_errno($link), mysqli_error($link)); var_dump($obj); } $obj = mysqli_fetch_object($res, 'mysqli_fetch_object_construct', array('a', 'b')); if (($obj->ID !== "5") || ($obj->label !== "e") || ($obj->a !== 'a') || ($obj->b !== 'b') || (get_class($obj) != 'mysqli_fetch_object_construct')) { printf("[008] Object seems wrong. [%d] %s\n", mysqli_errno($link), mysqli_error($link)); var_dump($obj); } var_dump(mysqli_fetch_object($res, 'mysqli_fetch_object_construct', array('a', 'b', 'c'))); var_dump(mysqli_fetch_object($res)); mysqli_free_result($res); if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST")) { printf("[009] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); } mysqli_free_result($res); var_dump(mysqli_fetch_object($res)); if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5")) printf("[010] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); /* TODO I'm using the procedural interface, this should not throw an exception. Also, I did not ask to get exceptions using the mysqli_options() */ if ($TEST_EXPERIMENTAL) if (false !== ($obj = mysqli_fetch_object($res, 'mysqli_fetch_object_construct', 'a'))) printf("[011] Should have failed\n"); mysqli_free_result($res); if (!$res = mysqli_query($link, "SELECT id AS ID, label FROM test AS TEST ORDER BY id LIMIT 5")) printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); class mysqli_fetch_object_private_constructor extends mysqli_fetch_object_test { private function __construct($a, $b) { $this->a = $a; $this->b = $b; } } /* TODO I think we should bail out here. The following line will give a Fatal error: Call to private ... from invalid context var_dump($obj = new mysqli_fetch_object_private_constructor(1, 2)); This does not fail. */ $obj = mysqli_fetch_object($res, 'mysqli_fetch_object_private_constructor', array('a', 'b')); mysqli_free_result($res); // Fatal error, script execution will end var_dump(mysqli_fetch_object($res, 'this_class_does_not_exist')); mysqli_close($link); print "done!"; ?> --EXPECTF-- Warning: Missing argument 1 for mysqli_fetch_object_construct::__construct() in %s on line %d Warning: Missing argument 2 for mysqli_fetch_object_construct::__construct() in %s on line %d Notice: Undefined variable: a in %s on line %d Notice: Undefined variable: b in %s on line %d Warning: Missing argument 2 for mysqli_fetch_object_construct::__construct() in %s on line %d Notice: Undefined variable: b in %s on line %d NULL NULL Warning: mysqli_fetch_object(): Couldn't fetch mysqli_result in %s on line %d NULL Fatal error: Class 'this_class_does_not_exist' not found in %s on line %d
-- PHP CVS Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php