Db::getTables PHP Method

    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!
 }