/**
* Uses a table alias
* @group update
* @covers Query::getQuery
*/
function testUpdateQueryWithAlias()
{
$column_values = array('a.my_column1' => 'value1', 'a.my_column2' => 'value2');
$q = new Query('my_table', 'a');
$q->setAction(Query::ACTION_UPDATE);
$q->setUpdateColumnValues($column_values);
$query = $q->getQuery();
$actual = "{$query}";
$expected = "UPDATE `my_table` AS a SET `a`.`my_column1` = 'value1', `a`.`my_column2` = 'value2'";
$this->assertEquals(preg_replace('/\\s/', '', $expected), preg_replace('/\\s/', '', $actual));
}
