/**
* dropColumn
*
* @param string $name
*
* @return mixed
*/
public function dropColumn($name)
{
$query = PostgresqlQueryBuilder::dropColumn($this->table, $name);
$this->db->setQuery($query)->execute();
return $this;
}
/**
* Method to test dropColumn().
*
* @return void
*
* @covers Windwalker\Query\Postgresql\PostgresqlQueryBuilder::dropColumn
*/
public function testDropColumn()
{
$expected = "ALTER TABLE {$this->qn}foo{$this->qn} DROP {$this->qn}bar{$this->qn}";
$actual = PostgresqlQueryBuilder::dropColumn('foo', 'bar');
$this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual));
}
/**
* Method to test dropColumn().
*
* @return void
*
* @covers Windwalker\Query\Postgresql\PostgresqlQueryBuilder::dropColumn
*/
public function testDropColumn()
{
$expected = "ALTER TABLE {$this->qn('foo')} DROP {$this->qn('bar')}";
$actual = PostgresqlQueryBuilder::dropColumn('foo', 'bar');
$this->assertEquals($this->format($expected), $this->format($actual));
}