connect method

@override Future<void> connect()

Establishes a connection to the database.

Implementation

@override
Future<void> connect() async {
  try {
    await _ensureDatabaseFileExists(_path);
    _db = sqlite3.open(_path);
  } catch (e) {
    throw DatabaseException('Failed to open SQLite database at $_path: $e');
  }
}