public function estDbSqlite()
{
require 'unit-tests/config.db.php';
if (empty($configSqlite)) {
$this->markTestSkipped("Skipped");
return;
}
$connection = new Phalcon\Db\Adapter\Pdo\Sqlite($configSqlite);
//List tables
$expectedTables = array(0 => 'customers', 1 => 'm2m_parts', 2 => 'm2m_robots', 3 => 'm2m_robots_parts', 4 => 'parts', 5 => 'personas', 6 => 'personnes', 7 => 'prueba', 8 => 'robots', 9 => 'robots_parts', 10 => 'sqlite_sequence', 11 => 'subscriptores', 12 => 'tipo_documento');
$tables = $connection->listTables();
$this->assertEquals($tables, $expectedTables);
$tables = $connection->listTables('public');
$this->assertEquals($tables, $expectedTables);
//Table exist
$this->assertEquals($connection->tableExists('personas'), 1);
$this->assertEquals($connection->tableExists('noexist'), 0);
$this->assertEquals($connection->tableExists('personas', 'public'), 1);
$this->assertEquals($connection->tableExists('personas', 'test'), 1);
//Columns
$expectedDescribe = $this->getExpectedColumnsSqlite();
$describe = $connection->describeColumns('personas');
$this->assertEquals($describe, $expectedDescribe);
$describe = $connection->describeColumns('personas', 'main');
$this->assertEquals($describe, $expectedDescribe);
//Indexes ps. sqlite's integer primary key autoincrement is not listed in indexes
$expectedIndexes = array('robots_parts_parts_id' => Phalcon\Db\Index::__set_state(array('_indexName' => 'robots_parts_parts_id', '_columns' => array('parts_id'))), 'robots_parts_robots_id' => Phalcon\Db\Index::__set_state(array('_indexName' => 'robots_parts_robots_id', '_columns' => array('robots_id'))));
$describeIndexes = $connection->describeIndexes('robots_parts');
$this->assertEquals($describeIndexes, $expectedIndexes);
$describeIndexes = $connection->describeIndexes('robots_parts', 'main');
$this->assertEquals($describeIndexes, $expectedIndexes);
//References
$expectedReferences = array('foreign_key_0' => Phalcon\Db\Reference::__set_state(array('_referenceName' => 'foreign_key_0', '_referencedTable' => 'parts', '_columns' => array('parts_id'), '_referencedColumns' => array('id'), '_referencedSchema' => null)), 'foreign_key_1' => Phalcon\Db\Reference::__set_state(array('_referenceName' => 'foreign_key_1', '_referencedTable' => 'robots', '_columns' => array('robots_id'), '_referencedColumns' => array('id'), '_referencedSchema' => null)));
$describeReferences = $connection->describeReferences('robots_parts');
$this->assertEquals($describeReferences, $expectedReferences);
}
