public function testQuery()
{
$d = Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite'));
$d->adapter()->query('SELECT * FROM users WHERE id = 1');
$r = null;
while (($row = $d->adapter()->fetch()) != false) {
$r = $row;
}
$this->assertEquals(1, $r['id']);
$this->assertEquals('test1', $r['username']);
$this->assertEquals('password1', $r['password']);
$this->assertEquals('[email protected]', $r['email']);
$this->assertEquals('reader', $r['access']);
$this->assertEquals(1, $d->adapter()->numRows());
$this->assertEquals(5, $d->adapter()->numFields());
}