existsDatabase function

Future<bool> existsDatabase(
  1. String databaseName
)

Returns try if the schema databaseName exists.

Implementation

Future<bool> existsDatabase(String databaseName) async {
  final sql = '''
  SELECT SCHEMA_NAME
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME = '$databaseName'
''';

  final result = await Transaction.current.db.query(sql);
  return result.rows.isNotEmpty;
}