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"); }
public function testDeleteJoin() { $db = new DatabaseSqliteStandalone(':memory:'); $db->query('CREATE TABLE a (a_1)', __METHOD__); $db->query('CREATE TABLE b (b_1, b_2)', __METHOD__); $db->insert('a', array(array('a_1' => 1), array('a_1' => 2), array('a_1' => 3)), __METHOD__); $db->insert('b', array(array('b_1' => 2, 'b_2' => 'a'), array('b_1' => 3, 'b_2' => 'b')), __METHOD__); $db->deleteJoin('a', 'b', 'a_1', 'b_1', array('b_2' => 'a'), __METHOD__); $res = $db->query("SELECT * FROM a", __METHOD__); $this->assertResultIs(array(array('a_1' => 1), array('a_1' => 3)), $res); }
/** * @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"); }