/** * Method to test buildIndexDeclare(). * * @return void * * @covers Windwalker\Query\Postgresql\PostgresqlQueryBuilder::buildIndexDeclare */ public function testBuildIndexDeclare() { $expected = "{$this->qn}idx_alias{$this->qn} ({$this->qn}alias{$this->qn})"; $actual = PostgresqlQueryBuilder::buildIndexDeclare('idx_alias', 'alias'); $this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual)); $expected = "{$this->qn}idx_alias{$this->qn} ({$this->qn}alias{$this->qn}, {$this->qn}name{$this->qn})"; $actual = PostgresqlQueryBuilder::buildIndexDeclare('idx_alias', array('alias', 'name')); $this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual)); }
/** * Method to test buildIndexDeclare(). * * @return void * * @covers Windwalker\Query\Postgresql\PostgresqlQueryBuilder::buildIndexDeclare */ public function testBuildIndexDeclare() { $expected = "{$this->qn('idx_alias')} ({$this->qn('alias')})"; $actual = PostgresqlQueryBuilder::buildIndexDeclare('idx_alias', 'alias', null); $this->assertEquals($this->format($expected), $this->format($actual)); $expected = "{$this->qn('idx_alias')} ON {$this->qn('foo')} ({$this->qn('alias')}, {$this->qn('name')})"; $actual = PostgresqlQueryBuilder::buildIndexDeclare('idx_alias', array('alias', 'name'), 'foo'); $this->assertEquals($this->format($expected), $this->format($actual)); }