public function testCreateAndListViews() { $this->createTestTable('view_test_table'); $name = "doctrine_test_view"; $sql = "SELECT * FROM view_test_table"; $view = new \Doctrine\DBAL\Schema\View($name, $sql); $this->_sm->dropAndCreateView($view); $views = $this->_sm->listViews(); }
public function testCreateAndListViews() { if (!$this->_sm->getDatabasePlatform()->supportsViews()) { $this->markTestSkipped('Views is not supported by this platform.'); } $this->createTestTable('view_test_table'); $name = "doctrine_test_view"; $sql = "SELECT * FROM view_test_table"; $view = new \Doctrine\DBAL\Schema\View($name, $sql); $this->_sm->dropAndCreateView($view); $views = $this->_sm->listViews(); }