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));
}