/**
*
* @return Status:
*/
public function checkPrerequisites()
{
$result = Status::newGood();
// Bail out if SQLite is too old
$db = new DatabaseSqliteStandalone(':memory:');
if (version_compare($db->getServerVersion(), self::MINIMUM_VERSION, '<')) {
$result->fatal('config-outdated-sqlite', $db->getServerVersion(), self::MINIMUM_VERSION);
}
// Check for FTS3 full-text search module
if (DatabaseSqlite::getFulltextSearchModule() != 'FTS3') {
$result->warning('config-no-fts3');
}
return $result;
}
private function prepareDB($version)
{
static $maint = null;
if ($maint === null) {
$maint = new FakeMaintenance();
$maint->loadParamsAndArgs(null, array('quiet' => 1));
}
global $IP;
$db = new DatabaseSqliteStandalone(':memory:');
$db->sourceFile("{$IP}/tests/phpunit/data/db/sqlite/tables-{$version}.sql");
$updater = DatabaseUpdater::newForDB($db, false, $maint);
$updater->doUpdates(array('core'));
return $db;
}
/**
* 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;
}
function replaceVars($s)
{
return parent::replaceVars($s);
}
/**
* @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");
}
public function testCaseInsensitiveLike()
{
// TODO: Test this for all databases
$db = new DatabaseSqliteStandalone(':memory:');
$res = $db->query('SELECT "a" LIKE "A" AS a');
$row = $res->fetchRow();
$this->assertFalse((bool) $row['a']);
}
