listTables method

Implementation

@override
Future<List<String>> listTables() async {
  var res = await container!.runSQL(r'\d');
  if (res == null || res.isEmpty) return <String>[];

  var body = res.split(RegExp(r'--+\+--+\+--+\+'))[1];
  var parts = body.split(RegExp(r'[\r\n]'));

  var names =
      parts
          .where((p) => p.contains(RegExp(r'\s+\|\s+\w+\s+\|')))
          .map((p) => p.split(RegExp(r'\s+\|\s+'))[1].trim())
          .toList();

  return names;
}