/** * 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.'); }