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')); }