Dshafik\MySQL\Tests\MySqlShimTest::getConnection PHP Method

    protected function getConnection($db = 'shim_test')
    {
        $mysql = mysql_connect(static::$host, 'root');
        $this->assertConnection($mysql);
        mysql_query("SET NAMES latin1");
        $result = mysql_query("CREATE DATABASE IF NOT EXISTS `{$db}` CHARACTER SET latin1;");
        $this->assertTrue($result);
        $result = mysql_select_db($db);
        $this->assertTrue($result);
        $result = mysql_query("CREATE TABLE IF NOT EXISTS testing (\n                id int AUTO_INCREMENT,\n                one varchar(255),\n                two varchar(255),\n                three varchar(255),\n                four varchar(255),\n                five varchar(255),\n                six varchar(255),\n                seven varchar(255),\n                eight varchar(255),\n                nine ENUM('one', 'two', '\\'three'),\n                ten SET('one', 'two', '\\'\\'three'),\n                eleven MEDIUMTEXT,\n                INDEX one_idx (one),\n                UNIQUE INDEX two_unq (two),\n                INDEX three_four_idx (three, four),\n                UNIQUE INDEX four_five_unq (four, five),\n                INDEX seven_eight_idx (seven, eight),\n                UNIQUE INDEX seven_eight_unq (seven, eight),\n                PRIMARY KEY (id)\n            ) CHARACTER SET latin1;");
        $result = mysql_query("CREATE TABLE IF NOT EXISTS testing2 (\n                id int AUTO_INCREMENT,\n                one varchar(255),\n                two varchar(255),\n                three varchar(255),\n                four varchar(255),\n                five varchar(255),\n                six varchar(255),\n                seven varchar(255),\n                eight varchar(255),\n                nine ENUM('one', 'two', '\\'three'),\n                ten SET('one', 'two', '\\'\\'three'),\n                eleven MEDIUMTEXT,\n                INDEX one_idx (one),\n                UNIQUE INDEX two_unq (two),\n                INDEX three_four_idx (three, four),\n                UNIQUE INDEX four_five_unq (four, five),\n                INDEX seven_eight_idx (seven, eight),\n                UNIQUE INDEX seven_eight_unq (seven, eight),\n                PRIMARY KEY (id)\n            ) CHARACTER SET latin1;");
        if ($db !== null) {
            $this->assertTrue(mysql_select_db($db));
        }
        return $mysql;
    }