Esempi in PHP per QueryUpdate::setCondition

Esempio n. 1

File: Test_QueryBuilder.php Progetto: atrakroo/carpool-1

 public function testQueryUpdateSqlStringWithCondition()
 {
     $query = new QueryUpdate('MyTable');
     $query->setColumns(array('col1', 'col2'));
     $query->setCondition('col3 > 0');
     $requiredSql = 'UPDATE MyTable SET col1=?,col2=? WHERE col3 > 0';
     $this->assertEquals($query->__toString(), $requiredSql);
 }