Add existing databases not work

[rrifafauzikomara]

import 'package:flutter/services.dart' show rootBundle;
import 'package:moor/ffi.dart';
import 'package:moor/moor.dart';
import 'package:path/path.dart' as path;
import 'package:path_provider/path_provider.dart';

LazyDatabase _openConnection() {
  return LazyDatabase(() async {
    /// put the database file, called db_orion here, into the documents folder for your app.
    final dbFolder = await getApplicationDocumentsDirectory();
    final file = File(path.join(dbFolder.path, 'db_orion'));

    if (!await file.exists()) {
      /// Extract the pre-populated database file from assets
      final blob = await rootBundle.load('assets/database/db_orion');
      final buffer = blob.buffer;
      await file.writeAsBytes(
          buffer.asUint8List(blob.offsetInBytes, blob.lengthInBytes));
    }

    return VmDatabase(file, logStatements: true);
  });
}

@UseMoor(tables: [
  ....
])
class AppDatabase extends _$AppDatabase {
  AppDatabase() : super(_openConnection());

  @override
  int get schemaVersion => 1;
}

Library: moor_flutter: ^3.1.0

Assets:

flutter:
  uses-material-design: true
  assets:
    - assets/database/db_orion

When I run for the first time, I don't see on the log that the DB or event table is created. And when I check on my device, the DB is not created.

[davidmartos96]

It looks Ok at first glance.
Maybe a silly question but, have you run a single query in the database? It will not be created if you don't interact with it.

This is what I do at the start of the app, but you can also let it open itself automatically when running any SQL (SELECT, UPDATE, INSERT...)

final AppDatabase appDb = AppDatabase();
await appDb.executor.ensureOpen(appDb);

[rrifafauzikomara]

Still not work, Because I already call the AppDatabase class (injected) when the app is started. And it's should be created the database and table (if I do not load DB from assets). But when the DB from assets, it's not created the DB and table and when I execute CRUD. It's not working.

class CoreModule extends ChildModule {
  final String baseUrl;
  final SharedPreferences preferences;

  CoreModule({@required this.baseUrl, @required this.preferences});

  @override
  List<Bind> get binds => [
        Bind((_) => Modular.get<DioClient>().dio),
        Bind((_) => DioClient(
            apiBaseUrl: baseUrl,
            appInfo: Modular.get<AppInfo>(),
            dateTimeHelper: Modular.get<DateTimeHelper>())),
        Bind((_) => preferences),
        Bind((_) => AppDatabase()), //This is
      ];

  @override
  List<ModularRouter> get routers => [];
}

And this is the root of my code:

void main() async {
  Config.appFlavor = Flavor.DEVELOPMENT;
  WidgetsFlutterBinding.ensureInitialized();

  /// Init core and shared module
  final preferences = await SharedPreferences.getInstance();
  final packageInfo = await PackageInfo.fromPlatform();
  final deviceInfo = await DeviceInfoPlugin();

  Modular.init(SharedModule(packageInfo: packageInfo, deviceInfo: deviceInfo));
  Modular.init(
      CoreModule(baseUrl: ApiConstant.baseUrlDebug, preferences: preferences));

  /// Change device orientation and force to portrait
  await SystemChrome.setPreferredOrientations([DeviceOrientation.portraitUp])
      .then((value) => runApp(ModularApp(module: AppModule())));
}

[rrifafauzikomara]

I fix with this code (this code didn't available on the moor docs or different within the moor docs)

/// This function for load db from the assets
LazyDatabase _openConnection() {
  return LazyDatabase(() async {
    /// put the database file, called db_orion.db here, into the documents folder for your app.
    final dbFolder = await getDatabasesPath();
    final file = File(join(dbFolder, 'db_orion'));

    if (!await file.exists()) {
      /// Extract the pre-populated database file from assets
      final blob = await rootBundle.load('assets/database/db_orion');
      await file.writeAsBytes(blob.buffer.asUint8List());
    }

    return FlutterQueryExecutor.inDatabaseFolder(
      path: file.path,
      logStatements: true,
    );
  });
}