/**
* testUpdateAllSyntax method
*
* @return void
*/
public function testUpdateAllSyntax()
{
$fields = array('SqlserverTestModel.client_id' => '[SqlserverTestModel].[client_id] + 1');
$conditions = array('SqlserverTestModel.updated <' => date('2009-01-01 00:00:00'));
$this->db->update($this->model, $fields, null, $conditions);
$result = $this->db->getLastQuery();
$this->assertNotRegExp('/SqlserverTestModel/', $result);
$this->assertRegExp('/^UPDATE \\[sqlserver_test_models\\]/', $result);
$this->assertRegExp('/SET \\[client_id\\] = \\[client_id\\] \\+ 1/', $result);
}
/**
* testUpdateAllSyntax method
*
* @return void
* @access public
*/
function testUpdateAllSyntax()
{
$fields = array('MssqlTestModel.client_id' => '[MssqlTestModel].[client_id] + 1');
$conditions = array('MssqlTestModel.updated <' => date('2009-01-01 00:00:00'));
$this->db->update($this->model, $fields, null, $conditions);
$result = $this->db->getLastQuery();
$this->assertNoPattern('/MssqlTestModel/', $result);
$this->assertPattern('/^UPDATE \\[mssql_test_models\\]/', $result);
$this->assertPattern('/SET \\[client_id\\] = \\[client_id\\] \\+ 1/', $result);
}
