/** * Method to test dropTable(). * * @return void * * @covers Windwalker\Query\Postgresql\PostgresqlQueryBuilder::dropTable */ public function testDropTable() { $expected = "DROP TABLE {$this->qn}foo{$this->qn}"; $actual = PostgresqlQueryBuilder::dropTable('foo'); $this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual)); $expected = "DROP TABLE IF EXISTS {$this->qn}foo{$this->qn}"; $actual = PostgresqlQueryBuilder::dropTable('foo', true); $this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual)); }
/** * tearDownAfterClass * * @return void */ public static function tearDownAfterClass() { if (!static::$dbo) { return; } if (!static::$debug) { try { static::$dbo->setQuery(PostgresqlQueryBuilder::dropTable('#__cloud', true))->execute(); } catch (\Exception $e) { // Do nothing } try { static::$dbo->setQuery(PostgresqlQueryBuilder::dropTable('#__wind', true))->execute(); } catch (\Exception $e) { // Do nothing } } parent::tearDownAfterClass(); }
/** * Method to test dropTable(). * * @return void * * @covers Windwalker\Query\Postgresql\PostgresqlQueryBuilder::dropTable */ public function testDropTable() { $expected = "DROP TABLE {$this->qn('foo')}"; $actual = PostgresqlQueryBuilder::dropTable('foo'); $this->assertEquals($this->format($expected), $this->format($actual)); $expected = "DROP TABLE IF EXISTS {$this->qn('foo')}"; $actual = PostgresqlQueryBuilder::dropTable('foo', true); $this->assertEquals($this->format($expected), $this->format($actual)); }