/** * 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)); }