diff options
author | Ulf Wendel <uw@php.net> | 2007-07-11 15:17:47 +0000 |
---|---|---|
committer | Ulf Wendel <uw@php.net> | 2007-07-11 15:17:47 +0000 |
commit | 90ad13cca1557ee4dc807a9832c6b244b31906b7 (patch) | |
tree | 365af65b4a376b1d8fa72613cc77610a19fa4a76 | |
parent | 9a1520df39b32bd266db1256bdffeb9452b83168 (diff) | |
download | php-git-90ad13cca1557ee4dc807a9832c6b244b31906b7.tar.gz |
Whitespace and new checks for default connection.
-rw-r--r-- | ext/mysql/tests/mysql_insert_id.phpt | 97 | ||||
-rw-r--r-- | ext/mysql/tests/mysql_list_dbs.phpt | 67 |
2 files changed, 90 insertions, 74 deletions
diff --git a/ext/mysql/tests/mysql_insert_id.phpt b/ext/mysql/tests/mysql_insert_id.phpt index ab648e8a01..850c9e8251 100644 --- a/ext/mysql/tests/mysql_insert_id.phpt +++ b/ext/mysql/tests/mysql_insert_id.phpt @@ -2,53 +2,60 @@ mysql_insert_id() --SKIPIF-- <?php require_once('skipif.inc'); ?> -<?php require_once('skipifemb.inc'); ?> --FILE-- <?php - include "connect.inc"; - - $tmp = NULL; - $link = NULL; - - if (false !== ($tmp = @mysql_insert_id())) - printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - - if (false !== ($tmp = @mysql_insert_id($link))) - printf("[002] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - - require('table.inc'); - - if (0 !== ($tmp = mysql_insert_id($link))) - printf("[003] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); - - if (!$res = mysql_query("SELECT id, label FROM test ORDER BY id LIMIT 1", $link)) { - printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link)); - } - if (0 !== ($tmp = mysql_insert_id($link))) - printf("[005] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); - mysql_free_result($res); - - // no auto_increment column - if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (100, 'a')", $link)) { - printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link)); - } - if (0 !== ($tmp = mysql_insert_id($link))) - printf("[007] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); - - if (!$res = mysql_query("ALTER TABLE test MODIFY id INT NOT NULL AUTO_INCREMENT", $link)) { - printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link)); - } - if (!$res = mysql_query("INSERT INTO test(label) VALUES ('a')", $link)) { - printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link)); - } - if (0 === ($tmp = mysql_insert_id($link))) - printf("[010] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); - - mysql_close($link); - - var_dump(mysql_insert_id($link)); - - print "done!"; +include "connect.inc"; + +$tmp = NULL; +$link = NULL; + +if (false !== ($tmp = @mysql_insert_id())) + printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); + +if (false !== ($tmp = @mysql_insert_id($link))) + printf("[002] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); + +if (!is_null($tmp = @mysql_insert_id($link, 'too many args'))) + printf("[002a] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); + +require('table.inc'); + +if (0 !== ($tmp = mysql_insert_id($link))) + printf("[003] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); + +if (!$res = mysql_query("SELECT id, label FROM test ORDER BY id LIMIT 1", $link)) { + printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link)); +} +if (0 !== ($tmp = mysql_insert_id($link))) + printf("[005] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); +mysql_free_result($res); + +// no auto_increment column +if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (100, 'a')", $link)) { + printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link)); +} +if (0 !== ($tmp = mysql_insert_id($link))) + printf("[007] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp); + +if (!$res = mysql_query("ALTER TABLE test MODIFY id INT NOT NULL AUTO_INCREMENT", $link)) { + printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link)); +} +if (!$res = mysql_query("INSERT INTO test(label) VALUES ('a')", $link)) { + printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link)); +} +if (0 === ($tmp = mysql_insert_id($link))) + printf("[010] Expecting int/not zero, got %s/%s\n", gettype($tmp), $tmp); + +if ($tmp !== ($tmp2 = mysql_insert_id())) + printf("[011] Expecting %s/%s, got %s/%s\n", + gettype($tmp), $tmp, + gettype($tmp2), $tmp2); + +mysql_close($link); + +var_dump(mysql_insert_id($link)); + +print "done!"; ?> --EXPECTF-- Warning: mysql_insert_id(): %d is not a valid MySQL-Link resource in %s on line %d diff --git a/ext/mysql/tests/mysql_list_dbs.phpt b/ext/mysql/tests/mysql_list_dbs.phpt index 6f8cacb1d4..5050f01901 100644 --- a/ext/mysql/tests/mysql_list_dbs.phpt +++ b/ext/mysql/tests/mysql_list_dbs.phpt @@ -4,35 +4,44 @@ mysql_list_dbs() <?php require_once('skipif.inc'); ?> --FILE-- <?php - include_once "connect.inc"; - - $tmp = NULL; - $link = NULL; - - if (false !== ($tmp = @mysql_list_dbs(NULL))) - printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); - - if (NULL !== ($tmp = @mysql_list_dbs($link, $link))) - printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); - - require('table.inc'); - - if (!$res = mysql_list_dbs($link)) - printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); - - if (!$num = mysql_num_rows($res)) - printf("[004] Empty database list? [%d] %s\n", mysql_errno($link), mysql_error($link)); - - $row = mysql_fetch_array($res, MYSQL_NUM); - if (ini_get('unicode.semantics') && !is_unicode($row[0])) { - printf("[005] Check for unicode support\n"); - var_inspect($row); - } - - mysql_free_result($res); - mysql_close($link); - - print "done!\n"; +include_once "connect.inc"; + +$tmp = NULL; +$link = NULL; + +if (false !== ($tmp = @mysql_list_dbs(NULL))) + printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); + +if (NULL !== ($tmp = @mysql_list_dbs($link, $link))) + printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); + +require('table.inc'); + +if (!$res = mysql_list_dbs($link)) + printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link)); + +if (!$num = mysql_num_rows($res)) + printf("[004] Empty database list? [%d] %s\n", mysql_errno($link), mysql_error($link)); + +$row = mysql_fetch_array($res, MYSQL_NUM); +if (ini_get('unicode.semantics') && !is_unicode($row[0])) { + printf("[005] Check for unicode support\n"); + var_inspect($row); +} + +mysql_free_result($res); + +if (!$res2 = mysql_list_dbs()) + printf("[006] [%d] %s\n", mysql_errno(), mysql_error()); + +$row2 = mysql_fetch_array($res2, MYSQL_NUM); +mysql_free_result($res2); + +assert($row === $row2); + +mysql_close($link); + +print "done!\n"; ?> --EXPECTF-- done! |