In Encrypted database, How to check whether the db connection is succesful or not ?

[rajagopalx]

Hi,

I am using the encrypted database. If I input the wrong passphrase how to catch the exception

Currently, I am getting exception if I am inserting records into the db.
[ERROR:flutter/lib/ui/ui_dart_state.cc(209)] Unhandled Exception: SqliteException(26): file is not a database, file is not a database (code 26)

But, Is there any other way to check whether the database connection is success or not.

P.S: I am new to flutter development.

My Code

LazyDatabase _openConnection() {
  return LazyDatabase(() async {
    final dbFolder = await getApplicationDocumentsDirectory();
    final file = File(p.join(dbFolder.path, 'db.sqlite'));
    setupSqlCipher();
    return NativeDatabase(file, setup: (rawDb) {
      rawDb.execute("PRAGMA key = 'mypassword';");
    });
  });
}

@DriftDatabase(tables: [
  mytables,
], daos: [
])
class MyDatabase extends _$MyDatabase {
  MyDatabase() : super(_openConnection());
  @override
  int get schemaVersion => 1;
}

https://drift.simonbinder.eu/docs/other-engines/encryption/

[simolus3]

You could add a simple statement accessing the database in the setup callback, like this:

setup: (rawDb) {
  rawDb.execute("PRAGMA key = 'wrongpassword';");
  
  try {
    rawDb.execute('PRAGMA user_version;');
  } on SqliteException catch (e) {
    if (e.resultCode == 26) {
      // not a database, the password is probably wrong
    }
  }
},

[rajagopalx]

Thank You so much