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

    public function testModelFindBy()
    {
        $this->_db->log = true;
        MockDatabasePost::findById(5, array('with' => 'MockDatabaseComment'));
        $this->_db->log = false;
        $result = $this->_db->logs[0];
        $expected = "SELECT DISTINCT({MockDatabasePost}.{id}) AS _ID_ FROM {mock_database_posts}";
        $expected .= " AS {MockDatabasePost} LEFT JOIN {mock_database_comments} AS ";
        $expected .= "{MockDatabaseComment} ON {MockDatabasePost}.{id} = ";
        $expected .= "{MockDatabaseComment}.{mock_database_post_id} WHERE ";
        $expected .= "{MockDatabasePost}.{id} = 5 LIMIT 1;";
        $this->assertEqual($expected, $result);
    }