List:Commits« Previous MessageNext Message »
From:uwendel Date:September 13 2007 1:58pm
Subject:PHP mysqlnd svn commit: r1034 - trunk/tests/ext/mysql
View as plain text  
Author: uwendel
Date: 2007-09-13 15:58:23 +0200 (Thu, 13 Sep 2007)
New Revision: 1034

Added:
   trunk/tests/ext/mysql/mysql_pconn_disable.phpt
   trunk/tests/ext/mysql/mysql_pconn_reuse.phpt
Log:
Same as for ext/mysqli. Playing with disabling and reusing.


Added: trunk/tests/ext/mysql/mysql_pconn_disable.phpt
===================================================================
--- trunk/tests/ext/mysql/mysql_pconn_disable.phpt	2007-09-13 13:36:25 UTC (rev 1033)
+++ trunk/tests/ext/mysql/mysql_pconn_disable.phpt	2007-09-13 13:58:23 UTC (rev 1034)
@@ -0,0 +1,58 @@
+--TEST--
+mysql_pconnect() - disabling feature
+--SKIPIF--
+<?php
+require_once('skipif.inc');
+require_once('skipifconnectfailure.inc');
+?>
+--INI--
+mysql.allow_persistent=0
+mysql.max_persistent=1
+mysql.max_links=2
+--FILE--
+<?php
+	require_once("connect.inc");
+	require_once("table.inc");
+	// assert(ini_get('mysql.allow_persistent') == false);
+
+	if ($socket)
+		$myhost = sprintf("%s:%s", $host, $socket);
+	else if ($port)
+		$myhost = sprintf("%s:%s", $host, $port);
+	else
+	$myhost = $host;
+
+	if (($plink = mysql_pconnect($myhost, $user, $passwd)))
+		printf("[001] Can connect to the server.\n");
+
+	if (($res = @mysql_query('SELECT id FROM test ORDER BY id ASC', $plink)) &&
+			($row = mysql_fetch_assoc($res)) &&
+			(mysql_free_result($res))) {
+		printf("[002] Can fetch data using persistent connection! Data = '%s'\n",
+			$row['id']);
+	}
+
+	$thread_id = mysql_thread_id($plink);
+	mysql_close($plink);
+
+	if (!($plink = mysql_pconnect($myhost, $user, $passwd)))
+		printf("[003] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error());
+
+	if (mysql_thread_id($plink) != $thread_id)
+		printf("[004] Looks like the second call to pconnect() did not give us the same
connection.\n");
+
+	$thread_id = mysql_thread_id($plink);
+	mysql_close($plink);
+
+	if (!($plink = mysql_connect($myhost, $user, $passwd, true)))
+		printf("[005] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error());
+
+	if (mysql_thread_id($plink) == $thread_id)
+		printf("[006] Looks like connect() did not return a new connection.\n");
+
+	print "done!";
+?>
+--EXPECTF--
+[001] Can connect to the server.
+[002] Can fetch data using persistent connection! Data = '1'
+done!
\ No newline at end of file

Added: trunk/tests/ext/mysql/mysql_pconn_reuse.phpt
===================================================================
--- trunk/tests/ext/mysql/mysql_pconn_reuse.phpt	2007-09-13 13:36:25 UTC (rev 1033)
+++ trunk/tests/ext/mysql/mysql_pconn_reuse.phpt	2007-09-13 13:58:23 UTC (rev 1034)
@@ -0,0 +1,61 @@
+--TEST--
+mysql_pconnect() - disabling feature
+--SKIPIF--
+<?php
+require_once('skipif.inc');
+require_once('skipifconnectfailure.inc');
+?>
+--INI--
+mysql.allow_persistent=1
+mysql.max_persistent=1
+mysql.max_links=2
+--FILE--
+<?php
+	require_once("connect.inc");
+	require_once("table.inc");
+	mysql_close($link);
+
+	if ($socket)
+		$myhost = sprintf("%s:%s", $host, $socket);
+	else if ($port)
+		$myhost = sprintf("%s:%s", $host, $port);
+	else
+	$myhost = $host;
+
+	if (($plink = mysql_pconnect($myhost, $user, $passwd)))
+		printf("[001] Can connect to the server.\n");
+
+	if ((mysql_select_db($db, $plink)) &&
+			($res = mysql_query('SELECT id FROM test', $plink)) &&
+			($row = mysql_fetch_assoc($res)) &&
+			(mysql_free_result($res))) {
+		printf("[002] Can fetch data using persistent connection! Data = '%s'\n",
+			$row['id']);
+	} else {
+		printf("[002] [%d] %s\n", mysql_errno($plink), mysql_error($plink));
+	}
+
+	$thread_id = mysql_thread_id($plink);
+	mysql_close($plink);
+
+	if (!($plink = mysql_pconnect($myhost, $user, $passwd)))
+		printf("[003] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error());
+
+	if (mysql_thread_id($plink) != $thread_id)
+		printf("[004] Looks like the second call to pconnect() did not give us the same
connection.\n");
+
+	$thread_id = mysql_thread_id($plink);
+	mysql_close($plink);
+
+	if (!($plink = mysql_connect($myhost, $user, $passwd, true)))
+		printf("[005] Cannot connect, [%d] %s\n", mysql_errno(), mysql_error());
+
+	if (mysql_thread_id($plink) == $thread_id)
+		printf("[006] Looks like connect() did not return a new connection.\n");
+
+	print "done!";
+?>
+--EXPECTF--
+[001] Can connect to the server.
+[002] Can fetch data using persistent connection! Data = '1'
+done!
\ No newline at end of file

Thread
PHP mysqlnd svn commit: r1034 - trunk/tests/ext/mysqluwendel13 Sep