/**
* dropIndex
*
* @param string $name
* @param bool $constraint
*
* @return mixed
*/
public function dropIndex($name, $constraint = false)
{
if ($constraint) {
$query = PostgresqlQueryBuilder::dropConstraint($this->table, $name, true, 'RESTRICT');
} else {
$query = PostgresqlQueryBuilder::dropIndex($name, true);
}
$this->db->setQuery($query)->execute();
return $this;
}
/**
* Method to test dropIndex().
*
* @return void
*
* @covers Windwalker\Query\Postgresql\PostgresqlQueryBuilder::dropIndex
*/
public function testDropIndex()
{
$expected = "ALTER TABLE {$this->qn}foo{$this->qn} DROP INDEX {$this->qn}bar{$this->qn}";
$actual = PostgresqlQueryBuilder::dropIndex('foo', 'INDEX', 'bar');
$this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual));
}
/**
* Method to test dropIndex().
*
* @return void
*
* @covers Windwalker\Query\Postgresql\PostgresqlQueryBuilder::dropIndex
*/
public function testDropIndex()
{
$expected = "DROP INDEX {$this->qn('bar')}";
$actual = PostgresqlQueryBuilder::dropIndex('bar');
$this->assertEquals($this->format($expected), $this->format($actual));
$expected = "DROP INDEX CONCURRENTLY IF EXISTS {$this->qn('bar')}";
$actual = PostgresqlQueryBuilder::dropIndex('bar', true, true);
$this->assertEquals($this->format($expected), $this->format($actual));
}
