Handling Database Exception

[anivkuttan]

is there any document available for Handling an exception?

TextColumn get branchName => text().unique();

how to handle unique failed exception

// import 'package:drift/native.dart'; 
  try {
    
      await db.branchCollection.insertBranch(branch);
       
    } catch (e) {
        if (e is SqliteException) {  }
    }

if i use this,

import 'package:drift/native.dart';

this is causes the build error because it depending on Native Drift
Is there any way to handle exceptions?

[simolus3]

I'm considering adding a set of common drift exception classes that could be caught.

How are you opening the database? The SqliteException class is also exported by package:sqlite3/common.dart, which is cross-platform. But if you're using driftFlutter to open your database, you'll probably receive a DriftRemoteException. You can extract the underlying cause, but that will probably not be available on the web.

[anivkuttan]

For Web platform

import 'package:drift/drift.dart';
import 'package:drift/wasm.dart';

  static QueryExecutor createDatabase(String databaseName) {
    return DatabaseConnection.delayed(Future(() async {
      final database = await WasmDatabase.open(
        databaseName: databaseName,
        sqlite3Uri: Uri.parse('/sqlite3.wasm'),
        driftWorkerUri: Uri.parse('/drift_worker.dart.js'),
      );
      return database.resolvedExecutor;
    }));
  }

For Android & iOS

import 'dart:io';

import 'package:drift/drift.dart';
import 'package:drift/native.dart';
import 'package:path/path.dart';
import 'package:path_provider/path_provider.dart';

static QueryExecutor createDatabase(String databaseName) {
    return LazyDatabase(() async {
      final dbFolder = await getApplicationDocumentsDirectory();
      final file = File(join(dbFolder.path, '$databaseName.sqlite'));
      return NativeDatabase(file, logStatements: true);
    });
  }

how to handle the exception on the web and Android iOS platforms?