/**
* getTableDetail
*
* @param bool $table
*
* @return mixed
*/
public function getTableDetail($table)
{
$table = $this->db->replacePrefix($table);
$query = MysqlQueryBuilder::showDbTables($this->database, 'Name = ' . $this->db->quote($table));
$table = $this->db->setQuery($query)->loadOne();
if (!$table) {
return false;
}
return $table;
}
/**
* Method to test showDbTables().
*
* @return void
*
* @covers Windwalker\Query\Mysql\MysqlQueryBuilder::showDbTables
*/
public function testShowDbTables()
{
$expected = "SHOW TABLE STATUS FROM {$this->qn('foo')}";
$actual = MysqlQueryBuilder::showDbTables('foo');
$this->assertEquals($this->format($expected), $this->format($actual));
$expected = "SHOW TABLE STATUS FROM {$this->qn('foo')} WHERE a = b";
$actual = MysqlQueryBuilder::showDbTables('foo', 'a = b');
$this->assertEquals($this->format($expected), $this->format($actual));
}
/**
* Method to test showDbTables().
*
* @return void
*
* @covers Windwalker\Query\Mysql\MysqlQueryBuilder::showDbTables
*/
public function testShowDbTables()
{
$expected = "SHOW TABLE STATUS FROM {$this->qn}foo{$this->qn}";
$actual = MysqlQueryBuilder::showDbTables('foo');
$this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual));
$expected = "SHOW TABLE STATUS FROM {$this->qn}foo{$this->qn} WHERE a = b";
$actual = MysqlQueryBuilder::showDbTables('foo', 'a = b');
$this->assertEquals(\SqlFormatter::compress($expected), \SqlFormatter::compress($actual));
}
