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

    public function testMultiHasManyRelationsWithLimit()
    {
        $this->_db->log = true;
        $this->_db->return['_execute'] = new MockResult(array('records' => array(array(0 => 5))));
        MockDatabasePost::find('first', array('conditions' => array('id' => 5, 'is_published' => true, 'MockDatabaseComment.is_spam' => false, 'MockDatabasePostRevision.title' => 'foo'), 'with' => array('MockDatabaseComment', 'MockDatabasePostRevision')));
        $this->_db->log = false;
        $result = $this->_db->logs;
        $expected[0] = <<<SQL
SELECT DISTINCT({MockDatabasePost}.{id}) AS _ID_
\tFROM {mock_database_posts} AS {MockDatabasePost}
\tLEFT JOIN {mock_database_comments} AS {MockDatabaseComment}
\t\tON {MockDatabasePost}.{id} = {MockDatabaseComment}.{mock_database_post_id}
\tLEFT JOIN {mock_database_post_revisions} AS {MockDatabasePostRevision}
\t\tON {MockDatabasePostRevision}.{deleted} IS NULL
\t\t\tAND {MockDatabasePost}.{id} = {MockDatabasePostRevision}.{mock_database_post_id}
\tWHERE
\t\t{MockDatabasePost}.{id} = 5
\t\tAND {MockDatabasePost}.{is_published} = 1
\t\tAND {MockDatabaseComment}.{is_spam} = 0
\t\tAND {MockDatabasePostRevision}.{title} = 'foo'
\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}
\tLEFT JOIN {mock_database_post_revisions} AS {MockDatabasePostRevision}
\t\tON {MockDatabasePostRevision}.{deleted} IS NULL
\t\t\tAND {MockDatabasePost}.{id} = {MockDatabasePostRevision}.{mock_database_post_id}
\tWHERE
\t\t{MockDatabasePost}.{id} IN (5)
\t\tAND {MockDatabaseComment}.{is_spam} = 0
\t\tAND {MockDatabasePostRevision}.{title} = 'foo';
SQL;
        $expected = array_map(function ($v) {
            return preg_replace('/[\\t\\n]+/', ' ', $v);
        }, $expected);
        $this->assertEqual($expected, $result);
    }