/**
* @test
*/
public function shouldSkipEmptyWheres()
{
// given
$query = new Query();
$query->table = 'products';
$query->where();
$query->where('id = ?', 1);
// when
$sql = $this->_dialect->buildQuery($query);
// then
$this->assertEquals('SELECT * FROM products WHERE id = ?', $sql);
}
/**
* @param string $where
* @param array $values
* @return ModelQueryBuilder
*/
public function where($where = '', $values = array())
{
$this->_query->where($where, $values);
return $this;
}
/**
* @test
*/
public function shouldBuildUpdateQuery()
{
//given
$query = new Query();
$query->table = 'products';
$query->type = QueryType::$UPDATE;
$query->updateAttributes = array('col1' => 'val1', 'col2' => 'val2');
$query->where(array('col1' => 'prev1', 'col2' => 'prev2'));
//when
$sql = $this->dialect->buildQuery($query);
//then
$this->assertEquals("UPDATE products SET col1 = ?, col2 = ? WHERE col1 = ? AND col2 = ?", $sql);
}
