lithium\tests\cases\data\source\DatabaseTest::testModelFindFirstPassesConditionsIntoSubsequent PHP Метод

    public function testModelFindFirstPassesConditionsIntoSubsequent()
    {
        $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), 'with' => 'MockDatabaseComment'));
        $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}
\tWHERE
\t\t{MockDatabasePost}.{id} = 5
\t\tAND {MockDatabasePost}.{is_published} = 1
\t\tAND {MockDatabaseComment}.{is_spam} = 0
\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
\t\t{MockDatabasePost}.{id} IN (5)
\t\tAND {MockDatabaseComment}.{is_spam} = 0;
SQL;
        $expected = array_map(function ($v) {
            return preg_replace('/[\\t\\n]+/', ' ', $v);
        }, $expected);
        $this->assertEqual($expected, $result);
    }