<?php
/**
* This is a simple unit test for all the MySQL_*
* functions so that they match our functions
*
* This test should be run with a MySQL functions enabled
*
* @author Aziz S. Hussain <azizsaleh@gmail.com>
* @copyright GPL license
* @license http://www.gnu.org/copyleft/gpl.html
* @link http://www.AzizSaleh.com
*/
/*
* Test Db Params - user needs db/table create, drop,
* insert, delete, update permissions)
*/
define('TEST_HOST', 'localhost');
define('TEST_USER', 'root');
define('TEST_PASS', '');
define('TEST_DB', 'unit_sql_v_1');
define('TEST_TABLE', 'unit_sql_table_1');
require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'MySQL.php');
require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'MySQL_Definitions.php');
/**
* MySQL_Test
*
* Test object
*
* @author Aziz S. Hussain <azizsaleh@gmail.com>
* @copyright GPL license
* @license http://www.gnu.org/copyleft/gpl.html
* @link http://www.AzizSaleh.com
*/
class MySQL_Test
{
/**
* Test Results
*
* @var array
*/
public $results = array(
'valid' => 0,
'invalid' => 0,
'naf' => 0,
'tests' => 0,
);
/**
* MySQL Object
*
* @var MySQL
*/
protected $_object;
/**
* Connection holder
*
* @var array
*/
protected $_cached = array();
/**
* Start testing
*
* @return void
*/
public function __construct()
{
// Set text on browser
if (php_sapi_name() != 'cli') {
header('Content-type: text/plain');
}
// Set object
$this->_object = MySQL::getInstance();
// Get tests
$tests = get_class_methods($this);
// Set print mask
$masker = "| %-30.30s | %7s |" . PHP_EOL;
// Print header
printf($masker, '------------------------------', '-------');
printf($masker, 'Test', 'Result');
printf($masker, '------------------------------', '-------');
// Load db first
$link = mysql_connect(TEST_HOST, TEST_USER, TEST_PASS);
$statements = explode(';',
file_get_contents(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'MySQL_Test_Schema.sql')
);
foreach ($statements as $statement) {
mysql_query(trim($statement)) or die(mysql_error());
}
mysql_close($link);
// Go through each test
foreach ($tests as $test) {
// Skip private/protected methods
if (substr($test, 0, 1) == '_') {
continue;
}
// Get mysql_* method
$name = strtolower(str_replace('_Test', '', $test));
// Increment # of tests
$this->results['tests']++;
// If it doesn't exist, naf it (not a function)
if (!function_exists($name)) {
$this->results['naf']++;
printf($masker, $test, 'NAF');
continue;
}
// Run tests
if ($this->$test()) {
$this->results['valid']++;
printf($masker, $test, 'Success');
} else {
$this->results['invalid']++;
printf($masker, $test, 'Failure');
}
}
// Print footer
printf($masker, '------------------------------', '-------');
}
/**
* After finishing, print out the results
*
* @return void
*/
public function __destruct()
{
// Echo results
echo PHP_EOL . "Completed \t{$this->results['tests']} Tests" . PHP_EOL;
echo "Passed \t\t{$this->results['valid']} Tests" . PHP_EOL;
echo "Failed \t\t{$this->results['invalid']} Tests" . PHP_EOL;
echo "NAF \t\t{$this->results['naf']} Tests" . PHP_EOL;
// Close our connections
$this->_object->mysql_close_all();
// Close mysql connections
foreach ($this->_cached as $resource) {
// Not a resource
if (!is_resource($resource)) {
continue;
}
// Check resource type
$type = get_resource_type($resource);
if (substr($type, 0, 10) != 'mysql link') {
continue;
}
// Close it
mysql_close($resource);
}
}
/**
* Test mysql_connect
*
* @return boolean
*/
public function MySQL_Connect_Test()
{
// Simple connection test
list($mysql, $ourDb) = $this->_getConnection();
return ($ourDb !== false && is_resource($mysql));
}
/**
* Test pconnect
*
* @return boolean
*/
public function MySQL_Pconnect_Test()
{
// We need to make sure that the connection ids are the same
$lastMySQLId = false;
$lastOurId = false;
for ($x = 0; $x <= 5; $x++) {
// Connect
$mysql = mysql_pconnect(TEST_HOST, TEST_USER, TEST_PASS);
$ourDb = $this->_object->mysql_pconnect(TEST_HOST, TEST_USER, TEST_PASS);
// Keep track of resource
$this->_cached[] = $mysql;
// Get thread ids
$thisMySQLId = mysql_thread_id();
$thisOurId = $this->_object->mysql_thread_id();
// Get original ids if not set
if ($lastMySQLId == false) {
$lastMySQLId = $thisMySQLId;
$lastOurId = $thisOurId;
}
// Keep checking that the ids are the same
if ($thisMySQLId !== $lastMySQLId || $thisOurId !== $lastOurId) {
return false;
}
}
return true;
}
/**
* Test mysql_select_db
*
* @return boolean
*/
public function MySQL_Select_Db_Test()
{
// Connect
$this->_getConnection();
// Select Db
$this->_selectDb();
// Get db name
$dbName = mysql_fetch_assoc(mysql_query("SELECT DATABASE() as Databasename"));
$dbNameOur = $this->_object->mysql_fetch_assoc($this->_object->mysql_query("SELECT DATABASE() as Databasename"));
// Must be identical
return ($dbName['Databasename'] === $dbNameOur['Databasename'] && $dbName['Databasename'] === TEST_DB);
}
/**
* Test mysql_selectdb
*
* @return boolean
*/
public function MySQL_SelectDb_Test()
{
// Alias of Mysql_Select_Db_Test
return true;
}
/**
* Test mysql_query
*
* @return boolean
*/
public function MySQL_Query_Test()
{
// Done in Mysql_Select_Db_Test
return true;
}
/**
* Test mysql_real_escape_string
*
* @return boolean
*/
public function MySQL_Real_Escape_String_Test()
{
// Connect
list($mysql, $ourDb) = $this->_getConnection();
// Compose string
$string = "mysql_real_escape_string() calls MySQL's library function mysql_real_escape_string, which prepends backslashes to the following characters: \x00, \n, \r, \, ', \" and \x1a. ";
// Select Db
$this->_selectDb();
// Escape it
$val1 = mysql_real_escape_string($string);
$val2 = $this->_object->mysql_real_escape_string($string);
$query = 'INSERT INTO ' . TEST_TABLE . " (field_name) VALUES ('$val2')";
$query2 = 'INSERT INTO ' . TEST_TABLE . " (field_name) VALUES ('$val2')";
// Add it
mysql_query($query);
$this->_object->mysql_query($query2);
// Get added ID (confirm add)
$id1 = mysql_insert_id();
$id2 = $this->_object->mysql_insert_id();
return $id1 == 1 && $id2 == 2;
}
/**
* Test mysql_escape_string
*
* @return boolean
*/
public function MySQL_Escape_String_Test()
{
// Connect
list($mysql, $ourDb) = $this->_getConnection();
// Compose string
$string = "mysql_real_escape_string() calls MySQL's library function mysql_real_escape_string, which prepends backslashes to the following characters: \x00, \n, \r, \, ', \" and \x1a. ";
// Select Db
$this->_selectDb();
// Escape it
$val1 = mysql_escape_string($string);
$val2 = $this->_object->mysql_escape_string($string);
$query = 'INSERT INTO ' . TEST_TABLE . " (field_name) VALUES ('$val2')";
$query2 = 'INSERT INTO ' . TEST_TABLE . " (field_name) VALUES ('$val2')";
// Add it
mysql_query($query);
$this->_object->mysql_query($query2);
// Get added ID (confirm add)
$id1 = mysql_insert_id();
$id2 = $this->_object->mysql_insert_id();
return $id1 == 3 && $id2 == 4;
}
/**
* Test mysql_fetch_array
*
* @return boolean
*/
public function MySQL_Fetch_Array_Test()
{
// Select Db
$this->_selectDb();
// Get rows (we should have 2 by now)
$sql = 'SELECT * FROM ' . TEST_TABLE . ' ORDER BY field_id ASC LIMIT 2';
// Results
$res1 = array();
$res2 = array();
// For each fetch type
foreach (array(MYSQL_ASSOC) as $fetchType) {
// Query
$query = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
// Must match
while ($r = mysql_fetch_array($query, $fetchType)) {
$res1[] = $r;
}
while($r2 = $this->_object->mysql_fetch_array($query2, $fetchType)) {
$res2[] = $r2;
}
}
$count = count($res1);
for ($x = 0; $x < $count; $x++) {
// Standardize order of keys, data must match
$row1 = $res1[$x];
$row2 = $res2[$x];
sort($row1, SORT_STRING);
sort($row2, SORT_STRING);
if ($row1 !== $row2) {
return false;
}
}
return true;
}
/**
* Test mysql_fetch_assoc
*
* @return boolean
*/
public function MySQL_Fetch_Assoc_Test()
{
// Done in Mysql_Select_Db_Test
return true;
}
/**
* Test mysql_fetch_row
*
* @return boolean
*/
public function MySQL_Fetch_Row_Test()
{
// Done in Mysql_Fetch_Array_Test
return true;
}
/**
* Test mysql_fetch_object
*
* @return boolean
*/
public function MySQL_Fetch_Object_Test()
{
// Select Db
$this->_selectDb();
// Get rows (we should have 2 by now)
$sql = 'SELECT * FROM ' . TEST_TABLE . ' ORDER BY field_id ASC LIMIT 1';
// Results
$res1 = array();
$res2 = array();
// Query
$query = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
// Must match
while ($r = mysql_fetch_object($query)) {
$res1[] = $r;
}
while($r2 = $this->_object->mysql_fetch_object($query2)) {
$res2[] = $r2;
}
// Can't be identical because of stdclass object resource # difference
return $res1 == $res2;
}
/**
* Test mysql_ping
*
* @return boolean
*/
public function MySQL_Ping_Test()
{
return (mysql_ping() === true && $this->_object->mysql_ping() === true);
}
/**
* Test mysql_errno
*
* @return boolean
*/
public function MySQL_Errno_Test()
{
$badSql = 'SELECT * FROM TABLE.*';
mysql_query($badSql);
$this->_object->mysql_query($badSql);
return mysql_errno() === $this->_object->mysql_errno();
}
/**
* Test mysql_error
*
* @return boolean
*/
public function MySQL_Error_Test()
{
$badSql = 'SELECT * FROM TABLE.*';
mysql_query($badSql);
$this->_object->mysql_query($badSql);
return mysql_error() === $this->_object->mysql_error();
}
/**
* Test mysql_affected_rows
*
* @return boolean
*/
public function MySQL_Affected_Rows_Test()
{
// Connect
list($mysql, $ourDb) = $this->_getConnection();
// Select Db
$this->_selectDb();
// Set different SQL
$sql = 'UPDATE ' . TEST_TABLE . " SET field_name = 'test string' WHERE field_id <= 100";
$sql2 = 'UPDATE ' . TEST_TABLE . " SET field_name = 'test string 2' WHERE field_id <= 100";
// Query
mysql_query($sql);
$this->_object->mysql_query($sql2);
return mysql_affected_rows() === $this->_object->mysql_affected_rows();
}
/**
* Test mysql_client_encoding
*
* @return boolean
*/
public function MySQL_Client_Encoding_Test()
{
// Connect
list($mysql, $ourDb) = $this->_getConnection();
// Select Db
$this->_selectDb();
// Get encoding
$code1 = mysql_client_encoding();
$code2 = $this->_object->mysql_client_encoding();
return $code1 === $code2;
}
/**
* Test mysql_close
*
* @return boolean
*/
public function MySQL_Close_Test()
{
// Connect
list($mysql, $ourDb) = $this->_getConnection();
// Select Db
$this->_selectDb();
return mysql_close($mysql) === $this->_object->mysql_close($ourDb);
}
/**
* Test mysql_create_db
*
* @return boolean
*/
public function MySQL_Create_Db_Test()
{
// Connect
$newDb = 'unit_sql_v_2';
return mysql_create_db($newDb) === $this->_object->mysql_create_db($newDb);
}
/**
* Test mysql_createdb
*
* @return boolean
*/
public function MySQL_CreateDb_Test()
{
// Alias of Mysql_Create_Db_Test
return true;
}
/**
* Test mysql_data_seek
*
* @return boolean
*/
public function MySQL_Data_Seek_Test()
{
// Connect
list($mysql, $ourDb) = $this->_getConnection();
// Select Db
$this->_selectDb();
// Get rows (we should have 2 by now)
$sql = 'SELECT * FROM ' . TEST_TABLE . ' ORDER BY field_id ASC LIMIT 2';
// Results
$res1 = array();
$res2 = array();
// Query
$query = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
mysql_data_seek($query, 1);
$this->_object->mysql_data_seek($query2, 1);
return mysql_fetch_assoc($query) == $this->_object->mysql_fetch_assoc($query2);
}
/**
* Test mysql_list_dbs
*
* @return boolean
*/
public function MySQL_List_Dbs_Test()
{
// Connect
list($mysql, $ourDb) = $this->_getConnection();
$dbs1 = mysql_list_dbs();
$dbs2 = $this->_object->mysql_list_dbs();
$list1 = array();
$list2 = array();
while ($a = mysql_fetch_row($dbs1)) {
$list1[] = $a[0];
}
while ($a = $this->_object->mysql_fetch_row($dbs2)) {
$list2[] = $a[0];
}
return $list1 === $list2;
}
/**
* Test mysql_listdbs
*
* @return boolean
*/
public function MySQL_ListDbs_Test()
{
// Alias of Mysql_List_Dbs_Test
return true;
}
/**
* Test mysql_db_name
*
* @return boolean
*/
public function MySQL_Db_Name_Test()
{
// Connect
list($mysql, $ourDb) = $this->_getConnection();
$dbs1 = mysql_list_dbs();
$dbs2 = $this->_object->mysql_list_dbs();
$list1 = array();
$list2 = array();
$i = 0;
$cnt = mysql_num_rows($dbs1);
while ($i < $cnt) {
$list1[] = mysql_db_name($dbs1, $i);
$i++;
}
$i = 0;
$cnt = $this->_object->mysql_num_rows($dbs2);
while ($i < $cnt) {
$list2[] = $this->_object->mysql_db_name($dbs2, $i);
$i++;
}
return $list1 === $list2;
}
/**
* Test mysql_dbname
*
* @return boolean
*/
public function MySQL_Dbname_Test()
{
// Alias of Mysql_Db_Name_Test
return true;
}
/**
* Test mysql_db_query
*
* @return boolean
*/
public function MySQL_Db_Query_Test()
{
// Connect
list($mysql, $ourDb) = $this->_getConnection();
// Get row
$sql = 'SELECT * FROM ' . TEST_TABLE . ' ORDER BY field_id ASC LIMIT 1';
// Select db + query
$query1 = mysql_db_query(TEST_DB, $sql);
$query2 = $this->_object->mysql_db_query(TEST_DB, $sql);
// Get first rows
$row1 = mysql_fetch_assoc($query1);
$row2 = $this->_object->mysql_fetch_assoc($query2);
// Match them
return $row1 === $row2;
}
/**
* Test mysql_drop_db
*
* @return boolean
*/
public function MySQL_Drop_Db_Test()
{
// Connect
$newDb = 'unit_sql_v_2';
return mysql_drop_db($newDb) === $this->_object->mysql_drop_db($newDb);
}
/**
* Test mysql_dropdb
*
* @return boolean
*/
public function MySQL_DropDb_Test()
{
// Alias of Mysql_Drop_Db_Test
return true;
}
/**
* Test mysql_unbuffered_query
*
* @return boolean
*/
public function MySQL_Unbuffered_Query_Test()
{
// Select Db
$this->_selectDb();
// Get rows (we should have 2 by now)
$sql = 'SELECT * FROM ' . TEST_TABLE . ' ORDER BY field_id ASC LIMIT 1';
// Results
$res1 = array();
$res2 = array();
// For each fetch type
foreach (array(MYSQL_ASSOC, MYSQL_NUM, MYSQL_BOTH) as $fetchType) {
// Query
$query = mysql_unbuffered_query($sql);
$query2 = $this->_object->mysql_unbuffered_query($sql);
// Must match
while ($r = mysql_fetch_array($query, $fetchType)) {
$res1[] = $r;
}
while($r2 = $this->_object->mysql_fetch_array($query2, $fetchType)) {
$res2[] = $r2;
}
}
$count = count($res1);
for ($x = 0; $x < $count; $x++) {
// Standardize order of keys, data must match
$row1 = $res1[$x];
$row2 = $res2[$x];
sort($row1, SORT_STRING);
sort($row2, SORT_STRING);
if ($row1 !== $row2) {
return false;
}
}
return true;
}
/**
* Test mysql_thread_id
*
* @return boolean
*/
public function MySQL_Thread_Id_Test()
{
// Done in Mysql_Pconnect_Test
return true;
}
/**
* Test mysql_list_tables
*
* @return boolean
*/
public function MySQL_List_Tables_Test()
{
// Connect
list($mysql, $ourDb) = $this->_getConnection();
// Results
$res1 = array();
$res2 = array();
// Query
$query = mysql_list_tables(TEST_DB);
$query2 = $this->_object->mysql_list_tables(TEST_DB);
// Must match
while ($r = mysql_fetch_assoc($query)) {
$res1[] = $r;
}
while($r2 = $this->_object->mysql_fetch_assoc($query2)) {
$res2[] = $r2;
}
return $res1 === $res2;
}
/**
* Test mysql_listtables
*
* @return boolean
*/
public function MySQL_ListTables_Test()
{
// Alias of Mysql_List_Tables_Test
return true;
}
/**
* Test mysql_tablename
*
* @return boolean
*/
public function MySQL_Tablename_Test()
{
// Connect
list($mysql, $ourDb) = $this->_getConnection();
$dbs1 = mysql_list_tables(TEST_DB);
$dbs2 = $this->_object->mysql_list_tables(TEST_DB);
$list1 = array();
$list2 = array();
$i = 0;
$cnt = mysql_num_rows($dbs1);
while ($i < $cnt) {
$list1[] = mysql_tablename($dbs1, $i);
$i++;
}
$i = 0;
$cnt = $this->_object->mysql_num_rows($dbs2);
while ($i < $cnt) {
$list2[] = $this->_object->mysql_tablename($dbs2, $i);
$i++;
}
return $list1 === $list2;
}
/**
* Test mysql_stat
*
* @return boolean
*/
public function MySQL_Stat_Test()
{
// Get stats
$stat1 = mysql_stat();
$stat2 = $this->_object->mysql_stat();
// Extract all #'s out
preg_match_all('!\d+!', $stat1, $matches1);
preg_match_all('!\d+!', $stat2, $matches2);
unset($stat1, $stat2);
// Go through each number
$count = count($matches1[0]);
for ($x = 0; $x < $count; $x++) {
$diff = abs($matches1[0][$x] - $matches2[0][$x]);
// Make sure that the difference is <= 10 (margin of change while queries are running)
if ($diff > 10) {
return false;
}
}
return true;
}
/**
* Test mysql_set_charset
*
* @return boolean
*/
public function MySQL_Set_Charset_Test()
{
// Set charset
$charset = 'latin1';
mysql_set_charset($charset);
$this->_object->mysql_set_charset($charset);
// Get charset
$enc1 = mysql_client_encoding();
$enc2 = $this->_object->mysql_client_encoding();
return $enc1 === $enc2;
}
/**
* Test mysql_result
*
* @return boolean
*/
public function MySQL_Result_Test()
{
// Select Db
$this->_selectDb();
// Get rows
$sql = 'SELECT * FROM ' . TEST_TABLE . ' ORDER BY field_id ASC LIMIT 2';
// Query
$query = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
$string1 = mysql_result($query, 1);
$string2 = $this->_object->mysql_result($query2, 1);
return $string1 === $string2;
}
/**
* Test mysql_list_processes
*
* @return boolean
*/
public function MySQL_List_Processes_Test()
{
$dbs1 = mysql_list_processes();
$dbs2 = $this->_object->mysql_list_processes();
$list1 = array();
$list2 = array();
while ($row = mysql_fetch_assoc($dbs1)) {
$list1[] = $row;
}
while ($row = $this->_object->mysql_fetch_assoc($dbs2)) {
$list2[] = $row;
}
$count = count($list1);
for ($x = 0; $x < $count; $x++) {
if ($list1[$x]['Id'] != $list1[$x]['Id']) {
return false;
}
}
return true;
}
/**
* Test mysql_insert_id
*
* @return boolean
*/
public function MySQL_Insert_Id_Test()
{
// Done in Mysql_Real_Escape_String_Test
return true;
}
/**
* Test mysql_get_server_info
*
* @return boolean
*/
public function MySQL_Get_Server_Info_Test()
{
$str1 = mysql_get_server_info();
$str2 = $this->_object->mysql_get_server_info();
return $str1 === $str2;
}
/**
* Test mysql_get_proto_info
*
* @return boolean
*/
public function MySQL_Get_Proto_Info_Test()
{
$str1 = mysql_get_proto_info();
$str2 = $this->_object->mysql_get_proto_info();
return $str1 === $str2;
}
/**
* Test mysql_get_host_info
*
* @return boolean
*/
public function MySQL_Get_Host_Info_Test()
{
$str1 = mysql_get_host_info();
$str2 = $this->_object->mysql_get_host_info();
return $str1 === $str2;
}
/**
* Test mysql_get_client_info
*
* @return boolean
*/
public function MySQL_Get_Client_Info_Test()
{
$str1 = mysql_get_client_info();
$str2 = $this->_object->mysql_get_client_info();
return $str1 === $str2;
}
/**
* Test mysql_free_result
*
* @return boolean
*/
public function MySQL_Free_Result_Test()
{
$sql = 'SELECT * FROM ' . TEST_TABLE;
$query1 = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
$count1 = 0;
$count2 = 0;
// Validate query to avoid throwing errors
while (get_resource_type($query1) == 'mysql result' && $row = @mysql_fetch_assoc($query1)) {
$count1++;
mysql_free_result($query1);
}
while ($query2 && $row = $this->_object->mysql_fetch_assoc($query2)) {
$count2++;
$this->_object->mysql_free_result($query2);
}
return $count1 === $count2;
}
/**
* Test mysql_freeresult
*
* @return boolean
*/
public function MySQL_FreeResult_Test()
{
// Alias of Mysql_Free_Result_Test
return true;
}
/**
* Test mysql_fetch_lengths
*
* @return boolean
*/
public function MySQL_Fetch_Lengths_Test()
{
$sql = 'SELECT * FROM ' . TEST_TABLE;
$query1 = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
while ($row = mysql_fetch_row($query1)) {
$row2 = mysql_fetch_lengths($query1);
foreach ($row as $sub => $string) {
if (strlen($string) != $row2[$sub]) {
return false;
}
}
}
while ($row = $this->_object->mysql_fetch_row($query2)) {
$row2 = $this->_object->mysql_fetch_lengths($query1);
foreach ($row as $sub => $string) {
if (strlen($string) != $row2[$sub]) {
return false;
}
}
}
return true;
}
/**
* Test mysql_list_fields
*
* @return boolean
*/
public function MySQL_List_Fields_Test()
{
// Select Db
$this->_selectDb();
$query1 = mysql_list_fields(TEST_DB, TEST_TABLE);
$query2 = $this->_object->mysql_list_fields(TEST_DB, TEST_TABLE);
$list1 = array();
$list2 = array();
// Our object gives us num_rows, something that we can't do in mysql_*
$cnt = $this->_object->mysql_num_rows($query2);
$i = 0;
while ($i < $cnt) {
$list1[] = mysql_field_name($query1, $i);
$i++;
}
$i = 0;
while ($i < $cnt) {
$list2[] = $this->_object->mysql_field_name($query2, $i);
$i++;
}
return $list1 === $list2;
}
/**
* Test mysql_listfields
*
* @return boolean
*/
public function MySQL_ListFields_Test()
{
// Alias of Mysql_List_Fields_Test
return true;
}
/**
* Test mysql_field_len
*
* @return boolean
*/
public function MySQL_Field_Len_Test()
{
// Select Db
$this->_selectDb();
// Query
$sql = 'SELECT * FROM ' . TEST_TABLE . ' LIMIT 1';
// Query
$query1 = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
// Get items
$length1 = mysql_field_len($query1, 0);
$length2 = $this->_object->mysql_field_len($query2, 0);
return $length1 === $length2;
}
/**
* Test mysql_fieldlen
*
* @return boolean
*/
public function MySQL_FieldLen_Test()
{
// Alias of Mysql_Field_Len_Test
return true;
}
/**
* Test mysql_field_flags
*
* @return boolean
*/
public function MySQL_Field_Flags_Test()
{
// Select Db
$this->_selectDb();
// Query
$sql = 'SELECT * FROM ' . TEST_TABLE . ' LIMIT 1';
// Query
$query1 = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
// Get items
$flags1 = mysql_field_flags($query1, 0);
$flags2 = $this->_object->mysql_field_flags($query2, 0);
return $flags1 === $flags2;
}
/**
* Test mysql_fieldflags
*
* @return boolean
*/
public function MySQL_FieldFlags_Test()
{
// Alias of Mysql_Field_Flags_Test
return true;
}
/**
* Test mysql_field_name
*
* @return boolean
*/
public function MySQL_Field_Name_Test()
{
// Select Db
$this->_selectDb();
// Query
$sql = 'SELECT * FROM ' . TEST_TABLE . ' LIMIT 1';
// Query
$query1 = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
// Get items
$name1 = mysql_field_name($query1, 0);
$name2 = $this->_object->mysql_field_name($query2, 0);
return $name1 === $name2;
}
/**
* Test mysql_fieldname
*
* @return boolean
*/
public function MySQL_FieldName_Test()
{
// Alias of Mysql_Field_Name_Test
return true;
}
/**
* Test mysql_field_type
*
* @return boolean
*/
public function MySQL_Field_Type_Test()
{
// Select Db
$this->_selectDb();
// Query
$sql = 'SELECT * FROM ' . TEST_TABLE . ' LIMIT 1';
// Query
$query1 = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
// Get items
$type1 = mysql_field_type($query1, 0);
$type2 = $this->_object->mysql_field_type($query2, 0);
return $type1 === $type2;
}
/**
* Test mysql_fieldtype
*
* @return boolean
*/
public function MySQL_FieldType_Test()
{
// Alias of Mysql_Field_Type_Test
return true;
}
/**
* Test mysql_field_table
*
* @return boolean
*/
public function MySQL_Field_Table_Test()
{
// Select Db
$this->_selectDb();
// Query
$sql = 'SELECT * FROM ' . TEST_TABLE . ' LIMIT 1';
// Query
$query1 = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
// Get items
$table1 = mysql_field_table($query1, 0);
$table2 = $this->_object->mysql_field_table($query2, 0);
return $table1 === $table2;
}
/**
* Test mysql_fieldtable
*
* @return boolean
*/
public function MySQL_FieldTable_Test()
{
// Alias of Mysql_Field_Table_Test
return true;
}
/**
* Test mysql_field_seek
*
* @return boolean
*/
public function MySQL_Field_Seek_Test()
{
// Select Db
$this->_selectDb();
// Query
$sql = 'SELECT * FROM ' . TEST_TABLE . ' LIMIT 1';
// Query
$query1 = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
// Seek
mysql_field_seek($query1, 1);
$this->_object->mysql_field_seek($query1, 1);
// Get items
$info1 = mysql_fetch_field($query1);
$info2 = $this->_object->mysql_fetch_field($query2);
return $info1 == $info2;
}
/**
* Test mysql_fetch_field
*
* @return boolean
*/
public function MySQL_Fetch_Field_Test()
{
// Select Db
$this->_selectDb();
// Query
$sql = 'SELECT * FROM ' . TEST_TABLE . ' LIMIT 1';
// Query
$query1 = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
// Get items
$info1 = mysql_fetch_field($query1, 1);
$info2 = $this->_object->mysql_fetch_field($query2, 1);
return $info1 == $info2;
}
/**
* Test mysql_num_fields
*
* @return boolean
*/
public function MySQL_Num_Fields_Test()
{
// Select Db
$this->_selectDb();
// Query
$sql = 'SELECT * FROM ' . TEST_TABLE . ' LIMIT 1';
// Query
$query1 = mysql_query($sql);
$query2 = $this->_object->mysql_query($sql);
// Get items
$num1 = mysql_num_fields($query1);
$num2 = $this->_object->mysql_num_fields($query2);
return $num1 == $num2;
}
/**
* Test mysql_numfields
*
* @return boolean
*/
public function MySQL_Numfields_Test()
{
// Alias of Mysql_Num_Fields_Test
return true;
}
/**
* Test mysql_num_rows
*
* @return boolean
*/
public function MySQL_Num_Rows_Test()
{
// Done in Mysql_Db_Name_Test
return true;
}
/**
* Test mysql_numrows
*
* @return boolean
*/
public function MySQL_NumRows_Test()
{
// Alias of Mysql_Num_Rows_Test
return true;
}
/**
* Test mysql_info
*
* @return boolean
*/
public function MySQL_Info_Test()
{
// Select Db
$this->_selectDb();
$sql1 = 'UPDATE ' . TEST_TABLE . " SET field_name = 'test 2' WHERE field_id <= 1";
$sql2 = 'UPDATE ' . TEST_TABLE . " SET field_name = 'test 2' WHERE field_id <= 2 AND field_id > 1";
mysql_query($sql1);
$this->_object->mysql_query($sql2);
$info1 = mysql_info();
$info2 = $this->_object->mysql_info();
return $info1 == $info2;
}
/**
* Get connection to DB
*
* @return array 0 -> mysql resource, 1 -> our resource (#)
*/
protected function _getConnection()
{
$mysql = mysql_connect(TEST_HOST, TEST_USER, TEST_PASS, true);
$ourDb = $this->_object->mysql_connect(TEST_HOST, TEST_USER, TEST_PASS, true);
// Keep track of resource
$this->_cached[] = $mysql;
return array($mysql, $ourDb);
}
/**
* Select Db
*
* @param boolean $mysql
* @param boolean $ourDb
*
* @return void
*/
protected function _selectDb($mysql = false, $ourDb = false)
{
if ($mysql === false) {
mysql_select_db(TEST_DB);
} else {
mysql_select_db(TEST_DB, $mysql);
}
if ($ourDb === false) {
$this->_object->mysql_select_db(TEST_DB);
} else {
$this->_object->mysql_select_db(TEST_DB, $ourDb);
}
}
}
// Start tests
new MySQL_Test;
|
Download
