/**
* Test for `MySqlQuery::update()`.
*
* @since 1.0.0
* @access public
*
* @requires function Freyja\Database\Query\MySqlQuery::table
* @requires function Freyja\Database\Query\MySqlQuery::update
* @requires function Freyja\Database\Query\MySqlQuery::orderBy
* @requires function Freyja\Database\Query\MySqlQuery::limit
* @requires function Freyja\Database\Query\MySqlQuery::build
*/
public function testUpdate()
{
$query = new MySqlQuery();
$query_str = $query->update(array('field' => 56, 'other_field' => 'ciaone', 'another_field' => null))->table('table')->orderBy('field', 'desc')->limit(15)->build();
$expected_str = 'UPDATE table SET field = 56, other_field = \'{esc}ciaone{esc}\', another_field = NULL ORDER BY field DESC LIMIT 15';
$this->assertEquals($query_str, $expected_str, 'Failed asserting that MySqlQuery correctly build an update query.');
}
