public function getTables($dbName = '') { if (!empty($dbName)) { $sql = 'SHOW TABLES FROM ' . $dbName; } else { $sql = 'SHOW TABLES '; } $result = $this->query($sql); $info = array(); foreach ($result as $key => $val) { $info[$key] = current($val); } return $info; }
public function testGetTables() { $va_tables = $this->db->getTables(); $this->assertContains('foo', $va_tables); $this->assertContains('bar', $va_tables); $this->assertEquals(212, sizeof($va_tables)); // 210 CA tables plus 2 we created! }