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"); }