public function testOrder() {
$query = new Query(array('model' => $this->_model));
$result = $this->db->order("foo_bar", $query);
$expected = 'ORDER BY foo_bar ASC';
$this->assertEqual($expected, $result);
$result = $this->db->order("title", $query);
$expected = 'ORDER BY {MockDatabasePost}.{title} ASC';
$this->assertEqual($expected, $result);
$result = $this->db->order("title", $query);
$expected = 'ORDER BY {MockDatabasePost}.{title} ASC';
$this->assertEqual($expected, $result);
$result = $this->db->order(array("title"), $query);
$expected = 'ORDER BY {MockDatabasePost}.{title} ASC';
$this->assertEqual($expected, $result);
$result = $this->db->order(array("title" => "desc"), $query);
$expected = 'ORDER BY {MockDatabasePost}.{title} desc';
$this->assertEqual($expected, $result);
$result = $this->db->order(array("title" => "dasc"), $query);
$expected = 'ORDER BY {MockDatabasePost}.{title} ASC';
$this->assertEqual($expected, $result);
$result = $this->db->order(array("title" => array()), $query);
$expected = 'ORDER BY {MockDatabasePost}.{title} ASC';
$this->assertEqual($expected, $result);
$result = $this->db->order(array('author_id', "title" => "DESC"), $query);
$expected = 'ORDER BY {MockDatabasePost}.{author_id} ASC, {MockDatabasePost}.{title} DESC';
$this->assertEqual($expected, $result);
}