lithium\tests\cases\data\source\DatabaseTest::testOrder PHP Method

    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);
    }