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);
$result = $this->_db->order(array(), $query);
$expected = '';
$this->assertEqual($expected, $result);
}