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

    public function testOrderOnRelated()
    {
        $query = new Query(array('model' => $this->_model, 'with' => array('MockDatabaseComment')));
        $result = $this->_db->order('MockDatabaseComment.created DESC', $query);
        $expected = 'ORDER BY {MockDatabaseComment}.{created} DESC';
        $this->assertEqual($expected, $result);
        $result = $this->_db->order(array('MockDatabaseComment.created' => 'DESC'), $query);
        $expected = 'ORDER BY {MockDatabaseComment}.{created} DESC';
        $this->assertEqual($expected, $result);
        $result = $this->_db->order(array('MockDatabasePost.title' => 'ASC', 'MockDatabaseComment.created' => 'DESC'), $query);
        $expected = 'ORDER BY {MockDatabasePost}.{title} ASC, {MockDatabaseComment}.{created} DESC';
        $this->assertEqual($expected, $result);
        $result = $this->_db->order(array('title' => 'ASC', 'MockDatabaseComment.created' => 'DESC'), $query);
        $expected = 'ORDER BY {MockDatabasePost}.{title} ASC, {MockDatabaseComment}.{created} DESC';
        $this->assertEqual($expected, $result);
    }