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

    public function test_mysql_field()
    {
        $this->getConnection("shim_test");
        $result = mysql_query("SELECT * FROM testing LIMIT 1");
        $this->assertEquals("testing", mysql_field_table($result, 0));
        $this->assertEquals("id", mysql_field_name($result, 0));
        $this->assertEquals("int", mysql_field_type($result, 0));
        $this->assertEquals(11, mysql_field_len($result, 0));
        $this->assertEquals("not_null primary_key auto_increment", mysql_field_flags($result, 0));
        $this->assertEquals("testing", mysql_field_table($result, 1));
        $this->assertEquals("one", mysql_field_name($result, 1));
        $this->assertEquals("string", mysql_field_type($result, 1));
        $this->assertEquals(255, mysql_field_len($result, 1));
        $this->assertEquals("multiple_key", mysql_field_flags($result, 1));
        $this->assertEquals("testing", mysql_field_table($result, 2));
        $this->assertEquals("two", mysql_field_name($result, 2));
        $this->assertEquals("string", mysql_field_type($result, 2));
        $this->assertEquals(255, mysql_field_len($result, 2));
        $this->assertEquals("unique_key", mysql_field_flags($result, 2));
        $this->assertEquals("testing", mysql_field_table($result, 3));
        $this->assertEquals("three", mysql_field_name($result, 3));
        $this->assertEquals("string", mysql_field_type($result, 3));
        $this->assertEquals(255, mysql_field_len($result, 3));
        $this->assertEquals("multiple_key", mysql_field_flags($result, 3));
        $this->assertEquals("testing", mysql_field_table($result, 4));
        $this->assertEquals("four", mysql_field_name($result, 4));
        $this->assertEquals("string", mysql_field_type($result, 4));
        $this->assertEquals(255, mysql_field_len($result, 4));
        $this->assertEquals("multiple_key", mysql_field_flags($result, 4));
        $this->assertEquals("testing", mysql_field_table($result, 5));
        $this->assertEquals("five", mysql_field_name($result, 5));
        $this->assertEquals("string", mysql_field_type($result, 5));
        $this->assertEquals(255, mysql_field_len($result, 5));
        $this->assertEmpty(mysql_field_flags($result, 5));
        $this->assertEquals("testing", mysql_field_table($result, 6));
        $this->assertEquals("six", mysql_field_name($result, 6));
        $this->assertEquals("string", mysql_field_type($result, 6));
        $this->assertEquals(255, mysql_field_len($result, 6));
        $this->assertEmpty(mysql_field_flags($result, 6));
        $this->assertEquals("testing", mysql_field_table($result, 7));
        $this->assertEquals("seven", mysql_field_name($result, 7));
        $this->assertEquals("string", mysql_field_type($result, 7));
        $this->assertEquals(255, mysql_field_len($result, 7));
        $this->assertEquals("multiple_key", mysql_field_flags($result, 7));
        $this->assertEquals("testing", mysql_field_table($result, 8));
        $this->assertEquals("eight", mysql_field_name($result, 8));
        $this->assertEquals("string", mysql_field_type($result, 8));
        $this->assertEquals(255, mysql_field_len($result, 8));
        $this->assertEmpty(mysql_field_flags($result, 8));
        $this->assertEquals("testing", mysql_field_table($result, 9));
        $this->assertEquals("nine", mysql_field_name($result, 9));
        $this->assertEquals("string", mysql_field_type($result, 9));
        $this->assertEquals(6, mysql_field_len($result, 9));
        $this->assertEquals("enum", mysql_field_flags($result, 9));
        $this->assertEquals("testing", mysql_field_table($result, 10));
        $this->assertEquals("ten", mysql_field_name($result, 10));
        $this->assertEquals("string", mysql_field_type($result, 10));
        $this->assertEquals(15, mysql_field_len($result, 10));
        $this->assertEquals("set", mysql_field_flags($result, 10));
        $this->assertEquals("testing", mysql_field_table($result, 11));
        $this->assertEquals("eleven", mysql_field_name($result, 11));
        $this->assertEquals("blob", mysql_field_type($result, 11));
        $this->assertEquals(16777215, mysql_field_len($result, 11));
        $this->assertEquals("blob", mysql_field_flags($result, 11));
    }