database property

Implementation

Future<Database> get database async {
  final path = join(await getDatabasesPath(), 'sqlite_handler_database.db');
  return openDatabase(
    path,
    onCreate: (db, version) async {
      // Create tables based on the model's tableName
      // This will be handled by individual model classes
    },
    onConfigure: (db) async => await db.execute('PRAGMA foreign_keys = ON'),
    version: 1,
  );
}