MySQL_Test_After.php

<?php
/**
 * This is a simple unit test for our functions
 * to insure that they return the data as intended
 *
 * This test should be run with a MySQL functions removed
 * 
 * @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');
require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'MySQL_Functions.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,
    );

    /**
     * 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');
        }

        // 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_pconnect(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(preg_replace('/_Test([_0-9]+)?/', '', $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 all connections
        mysql_close_all();
    }

    /**
     * Test mysql_connect
     *
     * @return boolean
     */
    public function MySQL_Connect_Test()
    {
        // Simple connection test
        $ourDb = $this->_getConnection();

        return is_int($ourDb);
    }
    
    /**
     * Test pconnect
     *
     * @return boolean
     */
    public function MySQL_Pconnect_Test()
    {
        // We need to make sure that the connection ids are the same
        $lastMySQLId = false;

        for ($x = 0; $x <= 5; $x++) {
            // Connect
            $mysql = mysql_pconnect(TEST_HOST, TEST_USER, TEST_PASS);

            // Keep track of resource
            $this->_cached[] = $mysql;

            // Get thread ids
            $thisMySQLId = mysql_thread_id();

            // Get original ids if not set
            if ($lastMySQLId == false) {
                $lastMySQLId = $thisMySQLId;
            }

            // Keep checking that the ids are the same
            if ($thisMySQLId !== $lastMySQLId) {
                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
        $query = mysql_query("SELECT DATABASE() as Databasename");
        $dbName = mysql_fetch_assoc($query);

        // Must be identical
        return ($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
        $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);
        $query = 'INSERT INTO ' . TEST_TABLE . " (field_name) VALUES ('$val1')";

        // Add it & Get added ID (confirm add)
        mysql_query($query);
        $id1 = mysql_insert_id();

        return $id1 == 1;
    }
    
    /**
     * Test mysql_escape_string
     *
     * @return boolean
     */
    public function MySQL_Escape_String_Test()
    {
        // Connect
        $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);
        $query = 'INSERT INTO ' . TEST_TABLE . " (field_name) VALUES ('$val1')";

        // Add it & Get added ID (confirm add)
        mysql_query($query);
        $id1 = mysql_insert_id();

        return $id1 == 2;
    }
    
    /**
     * 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 1';
        
        // Results
        $res1 = array();

        // For each fetch type
        foreach (array(MYSQL_ASSOC, MYSQL_NUM, MYSQL_BOTH) as $fetchType) {

            // Query
            $query = mysql_query($sql);

            // Must match
            while ($r = mysql_fetch_array($query, $fetchType)) {
                $res1[] = $r;
            }
        }

        $count = count($res1);
        for ($x = 0; $x < $count; $x++) {
            $keys = array_keys($res1[$x]);
            $thisCount = count($res1[$x]);
            if ($x == 0) {
                if ($thisCount != 3 || !is_string($keys[0]) || !is_string($keys[1])) {
                    return false;
                }
            } else if ($x == 1) {
                if ($thisCount != 3 || !is_int($keys[0]) || !is_int($keys[1])) {
                    return false;
                }
            } else {
                if ($thisCount != 6 || !is_string($keys[0]) || !is_int($keys[1])) {
                    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();

        // Query
        $query = mysql_query($sql);

        // Must match
        while ($r = mysql_fetch_object($query)) {
            $res1[] = $r;
        }

        // Can't be identical because of stdclass object resource # difference
        return (is_object($res1[0]) && count((array) $res1[0]) == 3);
    }
    
    /**
     * Test mysql_ping
     *
     * @return boolean
     */
    public function MySQL_Ping_Test()
    {
        return (mysql_ping() === true);
    }
    
    /**
     * Test mysql_errno
     *
     * @return boolean
     */
    public function MySQL_Errno_Test()
    {
        $badSql = 'SELCT * FROM TABL.*';
        
        mysql_query($badSql);
        return mysql_errno() == 1064;
    }
    
    /**
     * Test mysql_error
     *
     * @return boolean
     */
    public function MySQL_Error_Test()
    {
        $badSql = 'SELCT * FROM TABLE.*';
        
        mysql_query($badSql);
        return (stripos(mysql_error(), 'You have an error in your SQL syntax') !== false);
    }
    
    /**
     * Test mysql_affected_rows
     *
     * @return boolean
     */
    public function MySQL_Affected_Rows_Test()
    {
        // Connect
        $this->_getConnection();
        
        // Select Db
        $this->_selectDb();
        
        // Set different SQL
        $sql = 'UPDATE ' . TEST_TABLE . " SET field_name = 'test string' WHERE field_id <= 100";
        
        // Query
        mysql_query($sql);

        return mysql_affected_rows() === 2;
    }
    
    /**
     * Test mysql_client_encoding
     *
     * @return boolean
     */
    public function MySQL_Client_Encoding_Test()
    {
        // Connect
        $this->_getConnection();

        // Select Db
        $this->_selectDb();

        // Get encoding
        $code1 = mysql_client_encoding();

        return strlen($code1) >= 4;
    }    

    /**
     * Test mysql_close
     *
     * @return boolean
     */
    public function MySQL_Close_Test()
    {
        // Connect
        $mysql = $this->_getConnection();

        // Select Db
        $this->_selectDb();

        return mysql_close($mysql) === true;
    }
    
    /**
     * Test mysql_create_db
     *
     * @return boolean
     */
    public function MySQL_Create_Db_Test()
    {
        // Drop db
        return mysql_create_db('unit_sql_v_2') === true;
    }
    
    /**
     * 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
        $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();

        // Query
        $query = mysql_query($sql);
        
        mysql_data_seek($query, 1);

        return mysql_fetch_assoc($query) == true;
    }
    
    /**
     * Test mysql_list_dbs
     *
     * @return boolean
     */
    public function MySQL_List_Dbs_Test()
    {
        // Connect
        $this->_getConnection();
        
        $dbs1 = mysql_list_dbs();
        
        $list1 = array();

        while ($a = mysql_fetch_row($dbs1)) {
            $list1[] = $a[0];        
        }

        // Must have the two dbs we created
        return (in_array('unit_sql_v_1', $list1) && in_array('unit_sql_v_2', $list1));
    }
    
    /**
     * 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
        $this->_getConnection();
        
        $dbs1 = mysql_list_dbs();        

        $list1 = array();

        $i = 0;
        $cnt = mysql_num_rows($dbs1);
        while ($i < $cnt) {
            $list1[] = mysql_db_name($dbs1, $i);
            $i++;
        }

        return (in_array('unit_sql_v_1', $list1) && in_array('unit_sql_v_2', $list1));  
    }
    
    /**
     * 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);
        
        // Get first rows
        $row1 = mysql_fetch_assoc($query1);

        // Match them
        return (count($row1) === 3);
    }

    /**
     * Test mysql_drop_db
     *
     * @return boolean
     */
    public function MySQL_Drop_Db_Test()
    {
        return mysql_drop_db('unit_sql_v_2') === true;
    }
    
    /**
     * 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();

        // For each fetch type
        foreach (array(MYSQL_ASSOC, MYSQL_NUM, MYSQL_BOTH) as $fetchType) {

            // Query
            $query = mysql_unbuffered_query($sql);

            // Must match
            while ($r = mysql_fetch_array($query, $fetchType)) {
                $res1[] = $r;
            }
        }
        
        $count = count($res1);
        for ($x = 0; $x < $count; $x++) {
            $keys = array_keys($res1[$x]);
            $thisCount = count($res1[$x]);
            if ($x == 0) {
                if ($thisCount != 3 || !is_string($keys[0]) || !is_string($keys[1])) {
                    return false;
                }
            } else if ($x == 1) {
                if ($thisCount != 3 || !is_int($keys[0]) || !is_int($keys[1])) {
                    return false;
                }
            } else {
                if ($thisCount != 6 || !is_string($keys[0]) || !is_int($keys[1])) {
                    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
        $this->_getConnection();

        // Results
        $res1 = array();

        // Query
        $query = mysql_list_tables(TEST_DB);

        // Must match
        while ($r = mysql_fetch_assoc($query)) {
            $res1[] = $r;
        }

        return in_array('unit_sql_table_1', $res1[0]);
    }
    
    /**
     * 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
        $this->_getConnection();
        
        $dbs1 = mysql_list_tables(TEST_DB);
        
        $list1 = array();

        $i = 0;
        $cnt = mysql_num_rows($dbs1);
        while ($i < $cnt) {
            $list1[] = mysql_tablename($dbs1, $i);
            $i++;
        }

        return $list1[0] === 'unit_sql_table_1';
    }
    
    /**
     * Test mysql_stat
     *
     * @return boolean
     */
    public function MySQL_Stat_Test()
    {
        // Get stats
        $stat1 = mysql_stat();

        $finds = array('Uptime:', 'Threads:', 'Questions:', 'Open tables:', 'Queries per second');

        foreach ($finds as $find) {
            if (stripos($stat1, $find) === false) {
                return false;
            }
        }
        // Compare
        return true;
    }
    
    /**
     * Test mysql_set_charset
     *
     * @return boolean
     */
    public function MySQL_Set_Charset_Test()
    {
        // Set charset
        $charset = 'latin1';
        mysql_set_charset($charset);

        // Get charset
        $enc1 = mysql_client_encoding();

        return $enc1 === "latin1";
    }
    
    /**
     * 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);

        $string1 = mysql_result($query, 1);

        return is_numeric($string1);
    }
    
    /**
     * Test mysql_list_processes
     *
     * @return boolean
     */
    public function MySQL_List_Processes_Test()
    {
        $dbs1 = mysql_list_processes();
        
        while ($row = mysql_fetch_assoc($dbs1)) {
            if (!is_numeric($row['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();

        return preg_match('/[0-9\.]+(\-.*)?/', $str1);
    }
    
    /**
     * Test mysql_get_proto_info
     *
     * @return boolean
     */
    public function MySQL_Get_Proto_Info_Test()
    {
        $str1 = mysql_get_proto_info();
        return is_int($str1);
    }
    
    /**
     * Test mysql_get_host_info
     *
     * @return boolean
     */
    public function MySQL_Get_Host_Info_Test()
    {
        $str1 = mysql_get_host_info();
        return stripos($str1, 'via');
    }
    
    /**
     * Test mysql_get_client_info
     *
     * @return boolean
     */
    public function MySQL_Get_Client_Info_Test()
    {
        $str1 = mysql_get_client_info();
        return is_string($str1);
    }
    
    /**
     * Test mysql_free_result
     *
     * @return boolean
     */
    public function MySQL_Free_Result_Test()
    {
        $sql = 'SELECT * FROM ' . TEST_TABLE;
        
        $query1 = mysql_query($sql);
        
        $count1 = 0;
        // Validate query to avoid throwing errors
        while (is_resource_custom($query1) && get_resource_type_custom($query1) == 'mysql result' && $row = mysql_fetch_assoc($query1)) {
            $count1++;            
            mysql_free_result($query1);
        }

        return $count1 === 1;
    }
    
    /**
     * 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);

        while ($row = mysql_fetch_row($query1)) {
            $row2 = 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);

        $list1 = array();
        $cnt = count($query1);

        $i = 0;
        while ($i < $cnt) {
            $list1[] = mysql_field_name($query1, $i);
            $i++;
        }

        return count($list1) === 3;
    }
    
    /**
     * 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);

        // Get items
        $length1 = mysql_field_len($query1, 0);

        return $length1 === 20;
    }
    
    /**
     * 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);

        // Get items
        $flags1 = mysql_field_flags($query1, 0);
        $finds = array('not_null', 'primary_key', 'unsigned', 'zerofill', 'auto_increment');

        foreach ($finds as $find) {
            if (stripos($flags1, $find) === false) {
                return false;
            }
        }

        return true;
    }
    
    /**
     * 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);

        // Get items
        $name1 = mysql_field_name($query1, 0);
        return $name1 === 'field_id';
    }
    
    /**
     * 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);

        // Get items
        $type1 = mysql_field_type($query1, 0);
        return $type1 === 'int';
    }
    
    /**
     * 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);

        // Get items
        $table1 = mysql_field_table($query1, 0);
        return $table1 === 'unit_sql_table_1';
    }
    
    /**
     * 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);

        // Seek
        mysql_field_seek($query1, 1);

        // Get items
        $info1 = mysql_fetch_field($query1);
        return $info1->name == 'field_name';
    }
    
    /**
     * 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);

        // Get items
        $info1 = mysql_fetch_field($query1, 1);

        return $info1 == true;
    }
    
    /**
     * 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);

        // Get items
        $num1 = mysql_num_fields($query1);

        return $num1 == true;
    }
    
    /**
     * 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()
    {
        // Select Db
        $this->_selectDb();

        $query = "DELETE FROM " . TEST_TABLE;
        mysql_query($query);

        for ($x = 0; $x <= 2; $x++) {
            mysql_query('INSERT INTO ' . TEST_TABLE . " (field_name) VALUES ('ID: {$x}')");
        }

        // Get row
        $sql = 'SELECT * FROM ' . TEST_TABLE;

        // Select db + query
        $query1 = mysql_query($sql);

        return mysql_num_rows($query1) == 3;
    }

    /**
     * Test mysql_num_rows on unbuffered queries
     *
     * @return boolean
     */
    public function MySQL_Num_Rows_Test_2()
    {
        // Select Db
        $this->_selectDb();

        $query = "DELETE FROM " . TEST_TABLE;
        mysql_query($query);

        for ($x = 0; $x <= 2; $x++) {
            mysql_query('INSERT INTO ' . TEST_TABLE . " (field_name) VALUES ('ID: {$x}')");
        }

        // Get row
        $sql = 'SELECT * FROM ' . TEST_TABLE;

        // Select db + query
        $query1 = mysql_unbuffered_query($sql);

        while ($row = mysql_fetch_row($query1)) {}

        return mysql_num_rows($query1) == 3;
    }
    
    /**
     * 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";

        mysql_query($sql1);

        $info1 = mysql_info();

        $finds = array('Rows matched:', 'Changed:', 'Warnings:');

        foreach ($finds as $find) {
            if (stripos($info1, $find) === false) {
                return false;
            }
        }

        return true;
    }

    /**
     * Test Adding existing connection
     *
     * @return boolean
     */
    public function MySQL_Add_Existing_Connection_Test()
    {
        $dbh = new PDO("mysql:host" . TEST_HOST, TEST_USER, TEST_PASS);

        $ourInstance = mysql_add_existing_connection($dbh);

        $this->_selectDb($ourInstance);

        // Get db name
        $query = mysql_query("SELECT DATABASE() as Databasename");
        $dbName = mysql_fetch_assoc($query, $ourInstance);

        // Must be identical
        return ($dbName['Databasename'] === TEST_DB);
    }

    /**
     * Test Exception Handling
     *
     * @return boolean
     */
    public function MySQL_Query_Test_2()
    {
        try {
            mysql_query("SELECT DATABASE() as Databasename", 99999999);
        } catch (MySQL2PDOException $e) {
            return true;
        }

        return false;
    }

    /**
     * Get connection to DB
     *
     * @return our resource (#)
     */
    protected function _getConnection()
    {
        $mysql = mysql_connect(TEST_HOST, TEST_USER, TEST_PASS, true);

        // Keep track of resource
        $this->_cached[] = $mysql;

        return $mysql;
    }
    
    /**
     * Select Db
     *
     * @param boolean $mysql
     * 
     * @return void
     */
    protected function _selectDb($mysql = false)
    {
        if ($mysql === false) {
            mysql_select_db(TEST_DB);
        } else {
            mysql_select_db(TEST_DB, $mysql);
        }
    }
}

// Start tests
new MySQL_Test;