/** * Test for `MySqlQuery::distinct()`. * * @since 1.2.0 * @access public * * @requires function Freyja\Database\Query\MySqlQuery::table * @requires function Freyja\Database\Query\MySqlQuery::select * @requires function Freyja\Database\Query\MySqlQuery::distinct * @requires function Freyja\Database\Query\MySqlQuery::build */ public function testDistinct() { $query = new MySqlQuery(); $query->table('table')->select(array('field1', 'field2'))->distinct(); $query_str = $query->build(); $expected_str = 'SELECT DISTINCT field1, field2 FROM table'; $this->assertEquals($expected_str, $query_str, 'Failed asserting that MySqlQuery correctly build a `SELECT DISTINCT` query.'); }