Doctrine\DBAL\Platforms\DB2Platform::getCreateViewSQL PHP Метод

getCreateViewSQL() публичный Метод

{@inheritDoc}
public getCreateViewSQL ( $name, $sql )
    public function getCreateViewSQL($name, $sql)
    {
        return "CREATE VIEW " . $name . " AS " . $sql;
    }

Usage Example

Пример #1
0
 public function testGeneratesDDLSnippets()
 {
     $this->assertEquals("CREATE DATABASE foobar", $this->_platform->getCreateDatabaseSQL('foobar'));
     $this->assertEquals("DROP DATABASE foobar", $this->_platform->getDropDatabaseSQL('foobar'));
     $this->assertEquals('DECLARE GLOBAL TEMPORARY TABLE', $this->_platform->getCreateTemporaryTableSnippetSQL());
     $this->assertEquals('TRUNCATE foobar IMMEDIATE', $this->_platform->getTruncateTableSQL('foobar'));
     $this->assertEquals('TRUNCATE foobar IMMEDIATE', $this->_platform->getTruncateTableSQL('foobar'), true);
     $viewSql = 'SELECT * FROM footable';
     $this->assertEquals('CREATE VIEW fooview AS ' . $viewSql, $this->_platform->getCreateViewSQL('fooview', $viewSql));
     $this->assertEquals('DROP VIEW fooview', $this->_platform->getDropViewSQL('fooview'));
 }