lithium\tests\cases\data\source\database\adapter\PostgreSqlTest::testHasManyRelationWithLimitAndOrder PHP Метод

    public function testHasManyRelationWithLimitAndOrder()
    {
        $this->_db->log = true;
        $this->_db->return['_execute'] = new MockResult(array('records' => array(array(0 => 5))));
        MockDatabasePost::first(array('with' => array('MockDatabaseComment'), 'order' => array('title', 'id', 'MockDatabaseComment.body' => 'DESC')));
        $this->_db->log = false;
        $result = $this->_db->logs;
        $expected[0] = <<<SQL
SELECT _ID_ FROM (
\t\tSELECT DISTINCT ON({MockDatabasePost}.{id}) {MockDatabasePost}.{id} AS _ID_,
\t\t\t{MockDatabasePost}.{title} AS {_MockDatabasePost_title_},
\t\t\t{MockDatabasePost}.{id} AS {_MockDatabasePost_id_},
\t\t\t{MockDatabaseComment}.{body} AS {_MockDatabaseComment_body_}
\t\t\tFROM {mock_database_posts} AS {MockDatabasePost}
\t\t\tLEFT JOIN {mock_database_comments} AS {MockDatabaseComment}
\t\t\t\tON {MockDatabasePost}.{id} = {MockDatabaseComment}.{mock_database_post_id}
\t) AS _TEMP_
\tORDER BY {_MockDatabasePost_title_} ASC, {_MockDatabasePost_id_} ASC, {_MockDatabaseComment_body_} DESC
\tLIMIT 1;
SQL;
        $expected[1] = <<<SQL
SELECT * FROM {mock_database_posts} AS {MockDatabasePost}
\tLEFT JOIN {mock_database_comments} AS {MockDatabaseComment}
\t\tON {MockDatabasePost}.{id} = {MockDatabaseComment}.{mock_database_post_id}
\tWHERE {MockDatabasePost}.{id} IN (5)
\tORDER BY {MockDatabasePost}.{title} ASC, {MockDatabasePost}.{id} ASC, {MockDatabaseComment}.{body} DESC;
SQL;
        $expected = array_map(function ($v) {
            return preg_replace('/[\\t\\n]+/', ' ', $v);
        }, $expected);
        $this->assertEqual($expected, $result);
    }