diff options
Diffstat (limited to 'ext/mysql/tests/mysql_create_db.phpt')
-rw-r--r-- | ext/mysql/tests/mysql_create_db.phpt | 56 |
1 files changed, 56 insertions, 0 deletions
diff --git a/ext/mysql/tests/mysql_create_db.phpt b/ext/mysql/tests/mysql_create_db.phpt new file mode 100644 index 0000000..bc91964 --- /dev/null +++ b/ext/mysql/tests/mysql_create_db.phpt @@ -0,0 +1,56 @@ +--TEST-- +mysql_create_db() +--SKIPIF-- +<?php +require_once('skipif.inc'); +if (!function_exists('mysql_create_db')) + die("Skip mysql_create_db() exists only in old versions of the libmysql."); +?> +--FILE-- +<?php +include "connect.inc"; + +$link = NULL; +$tmp = null; + +if (false !== ($tmp = mysql_create_db())) + printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); + +if (false !== ($tmp = mysql_create_db($link, $link, $link))) + printf("[002] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); + +if ($link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) + printf("[003] Can connect to the server using host=%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n", + $host, $user . 'unknown_really', $db, $port, $socket); + +if (!mysql_query("CREATE DATABASE mysqlcreatedb", $link)) + die(sprintf("[004] Cannot create database, aborting test, [%d] %s\n", mysql_errno($link), mysql_error($link))); + +if (!mysql_query("DROP DATABASE mysqlcreatedb", $link)) + printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link)); + +if (true !== ($tmp = mysql_create_db("mysqlcreatedb", $link))) + printf("[006] Expecting boolean/true, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); + +if (false !== ($tmp = mysql_create_db("mysqlcreatedb", $link))) + printf("[007] Expecting boolean/false, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); + +if (!mysql_query("DROP DATABASE mysqlcreatedb", $link)) + printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link)); + +print "done!"; +?> +--CLEAN-- +<?php +require_once('connect.inc'); +if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) + printf("[c001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", + $host, $user, $db, $port, $socket); + +if (!mysql_query("DROP DATABASE IF EXISTS mysqlcreatedb", $link)) + printf("[c002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); + +mysql_close($link); +?> +--EXPECTF-- +done! |