Пример #1
0
 /**
  * @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());
 }
Пример #2
0
 /**
  * @covers Fobia\DataBase\Handler\MySQL::createInsertQuery
  * @todo   Implement testCreateInsertQuery().
  */
 public function testCreateInsertQuery()
 {
     $q = $this->db->createInsertQuery();
     $this->assertInstanceOf('\\Fobia\\DataBase\\Query\\QueryInsert', $q);
 }