protected function setUp() { if (!$this->db) { $this->db = \Fobia\DataBase\DbFactory::create('mysql://root@localhost/mysql'); } $this->q = $this->db->createSelectQuery(); }
/** * @covers Fobia\DataBase\Query\QueryReplace::getQuery * @todo Implement testGetQuery(). */ public function testGetQuery() { $q = $this->db->createReplaceQuery(); $str = "REPLACE INTO user ( Host, User, Password ) VALUES ( 'localhost', 'test', '' )"; $q->insertInto('user')->set('Host', $this->db->quote('localhost'))->set('User', $this->db->quote('test'))->set('Password', $this->db->quote('')); $this->assertEquals($str, $q->getQuery()); }
/** * @covers Fobia\DataBase\Query\QueryInsert::getQuery * @todo Implement testGetQuery(). */ public function testGetQuery() { $q = $this->db->createInsertQuery(); $str = "INSERT INTO user ( Host, User, Password ) VALUES ( 'localhost', 'test', '' )"; $q->set('Host', $this->db->quote('localhost'))->set('User', $this->db->quote('test'))->set('Password', $this->db->quote('')); $qi = clone $q; $q->insertInto('user'); $qi->insertIntoIgnore('user'); $this->assertEquals($str, $q->getQuery()); $this->assertRegExp('/^INSERT IGNORE /', $qi->getQuery()); }
/** * @covers Fobia\DataBase\DbStatement::__destruct * @todo Implement test__destruct(). */ public function test__destruct() { $stmt = $this->db->query("SELECT VERSION()"); unset($stmt); }
public function testRollback() { $this->db->beginTransaction(); $this->assertTrue($this->db->rollback()); }
/** * @covers Fobia\DataBase\Query\QueryUpdate::getQuery * @todo Implement testGetQuery(). */ public function testGetQuery() { $q = $this->q; $q->update('test')->orderBy('test')->limit(1)->set('id', $this->db->quote(2))->where($q->expr->eq('id', $this->db->quote(1))); $this->assertEquals("UPDATE test SET id = '2' WHERE id = '1' ORDER BY test LIMIT 1", $q->getQuery()); }