existsDatabase function
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;
}