public function testInsertIdType()
{
$db = new DatabaseSqliteStandalone(':memory:');
$this->assertInstanceOf('ResultWrapper', $db->query('CREATE TABLE a ( a_1 )', __METHOD__), "Database creationg");
$this->assertTrue($db->insert('a', array('a_1' => 10), __METHOD__), "Insertion worked");
$this->assertEquals("integer", gettype($db->insertId()), "Actual typecheck");
$this->assertTrue($db->close(), "closing database");
}
/**
* Returns version of currently supported SQLite fulltext search module or false if none present.
* @return String
*/
static function getFulltextSearchModule()
{
static $cachedResult = null;
if ($cachedResult !== null) {
return $cachedResult;
}
$cachedResult = false;
$table = 'dummy_search_test';
$db = new DatabaseSqliteStandalone(':memory:');
if ($db->query("CREATE VIRTUAL TABLE {$table} USING FTS3(dummy_field)", __METHOD__, true)) {
$cachedResult = 'FTS3';
}
$db->close();
return $cachedResult;
}
/**
* @covers DatabaseSqlite::numFields
*/
public function testNumFields()
{
$db = new DatabaseSqliteStandalone(':memory:');
$databaseCreation = $db->query('CREATE TABLE a ( a_1 )', __METHOD__);
$this->assertInstanceOf('ResultWrapper', $databaseCreation, "Failed to create table a");
$res = $db->select('a', '*');
$this->assertEquals(0, $db->numFields($res), "expects to get 0 fields for an empty table");
$insertion = $db->insert('a', array('a_1' => 10), __METHOD__);
$this->assertTrue($insertion, "Insertion failed");
$res = $db->select('a', '*');
$this->assertEquals(1, $db->numFields($res), "wrong number of fields");
$this->assertTrue($db->close(), "closing database");
}
