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

    public function testWithOptionWithNullConstraint()
    {
        $options = array('type' => 'read', 'model' => $this->_model, 'with' => array('MockDatabasePostRevision'));
        $result = $this->_db->read(new Query($options));
        $expected = 'SELECT * FROM {mock_database_posts} AS {MockDatabasePost} LEFT JOIN ';
        $expected .= '{mock_database_post_revisions} AS {MockDatabasePostRevision} ON ';
        $expected .= '{MockDatabasePostRevision}.{deleted} IS NULL AND ';
        $expected .= '{MockDatabasePost}.{id} = {MockDatabasePostRevision}.';
        $expected .= '{mock_database_post_id};';
        $this->assertEqual($expected, $this->_db->sql);
    }