/** * * @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']); }