From 90ad13cca1557ee4dc807a9832c6b244b31906b7 Mon Sep 17 00:00:00 2001
From: Ulf Wendel <uw@php.net>
Date: Wed, 11 Jul 2007 15:17:47 +0000
Subject: [PATCH] Whitespace and new checks for default connection.

---
 ext/mysql/tests/mysql_insert_id.phpt | 97 +++++++++++++++-------------
 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!
-- 
2.50.1