Extends
lithium\test\Unit
Tests that various syntaxes for the `'order'` key of the query object produce the correct
SQL.
Source
public function testQueryOrderSyntaxes() {
$query = new Query(array(
'type' => 'read', 'model' => $this->_model, 'order' => array('created' => 'ASC')
));
$sql = 'SELECT * FROM {mock_database_posts} AS {MockDatabasePost} ';
$sql .= 'ORDER BY {MockDatabasePost}.{created} ASC;';
$this->assertEqual($sql, $this->db->renderCommand($query));
}