public function testSqliteAdapter()
{
$pdo = new PDO('sqlite::memory:');
$adapter = new SqliteAdapter($pdo);
$this->assertInstanceOf('\\Phoenix\\Database\\QueryBuilder\\QueryBuilderInterface', $adapter->getQueryBuilder());
$pdo->query('CREATE TABLE "test" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL,"title" varchar(255) NOT NULL);');
$tableInfo = $adapter->tableInfo('test');
$this->assertCount(2, $tableInfo);
$this->assertArrayHasKey('id', $tableInfo);
$this->assertArrayHasKey('title', $tableInfo);
foreach ($tableInfo as $column) {
$this->assertInstanceOf('\\Phoenix\\Database\\Element\\Column', $column);
}
}
