public function get_tables_list()
{
$tables = array();
$engine = $this->get_sql_engine();
if ($engine != 'sqlite') {
$result = DB::select('SHOW TABLES');
if (!empty($result)) {
foreach ($result as $item) {
$item = (array) $item;
if (count($item) > 0) {
$item_vals = array_values($item);
$tables[] = $item_vals[0];
}
}
}
} else {
$sql = DB::select("SELECT * FROM sqlite_master WHERE type='table';");
if (is_array($sql) and !empty($sql)) {
foreach ($sql as $item) {
$item = (array) $item;
if (isset($item['tbl_name'])) {
$tables[] = $item['tbl_name'];
} elseif (isset($item['name'])) {
$tables[] = $item['name'];
}
}
}
}
return $tables;
}