/**
* Method to test showDbTables().
*
* @return void
*
* @covers Windwalker\Query\Postgresql\PostgresqlQueryBuilder::showDbTables
*/
public function testShowDbTables()
{
$expected = <<<SQL
SELECT table_name AS "Name"
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
AND table_schema NOT IN ('pg_catalog', 'information_schema')
ORDER BY
table_name ASC
SQL;
$actual = PostgresqlQueryBuilder::showDbTables('foo');
$this->assertEquals($this->format($expected), $this->format($actual));
}
/**
* Method to test showDbTables().
*
* @return void
*
* @covers Windwalker\Query\Postgresql\PostgresqlQueryBuilder::showDbTables
*/
public function testShowDbTables()
{
$expected = "SHOW TABLE STATUS FROM {$this->qn}foo{$this->qn}";
$actual = PostgresqlQueryBuilder::showDbTables('foo');
$this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual));
$expected = "SHOW TABLE STATUS FROM {$this->qn}foo{$this->qn} WHERE a = b";
$actual = PostgresqlQueryBuilder::showDbTables('foo', 'a = b');
$this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual));
}
/**
* getTableDetail
*
* @param bool $table
*
* @return mixed
*/
public function getTableDetail($table)
{
$table = $this->db->replacePrefix($table);
$query = PostgresqlQueryBuilder::showDbTables($this->database, 'table_name = ' . $this->db->quote($table));
$table = $this->db->setQuery($query)->loadOne();
if (!$table) {
return false;
}
return $table;
}