Pheasant\Tests\ResultSetTestCase::testGettingARow PHP Method

testGettingARow() public method

public testGettingARow ( )
    public function testGettingARow()
    {
        $rs = $this->connection()->execute('SELECT name,value,active FROM user');
        $this->assertEquals($rs->count(), 2);
        $this->assertSame($rs->row(), array('name' => 'Llama', 'value' => '24', 'active' => '0'));
        $this->assertSame($rs->row(), array('name' => 'Drama', 'value' => NULL, 'active' => '1'));
        $this->assertSame($rs->row(), NULL);
        // this should rewind and seek
        $this->assertEquals($rs->seek(1)->row(), array('name' => 'Drama', 'value' => NULL, 'active' => true));
    }