/**
* 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));
}
