在Flutter中有没有使用预填充数据库的例子？

flutter:
  assets:
    - assets/

import 'package:flutter/services.dart';
import 'package:path/path.dart';
import 'package:sqflite/sqflite.dart';

Future<void> copyDatabase() async {
  var databasesPath = await getDatabasesPath();
  var path = join(databasesPath, 'example.db');

  // 检查数据库文件是否已经复制到设备上
  if (FileSystemEntity.typeSync(path) == FileSystemEntityType.notFound) {
    // 复制预填充的数据库文件到设备上
    ByteData data = await rootBundle.load('assets/example.db');
    List<int> bytes = data.buffer.asUint8List(data.offsetInBytes, data.lengthInBytes);
    await File(path).writeAsBytes(bytes);
  }
}

// 在应用程序启动时调用copyDatabase函数
void main() async {
  WidgetsFlutterBinding.ensureInitialized();
  await copyDatabase();
  runApp(MyApp());
}

import 'package:sqflite/sqflite.dart';

Future<void> openDatabaseAndQuery() async {
  var databasesPath = await getDatabasesPath();
  var path = join(databasesPath, 'example.db');

  // 打开数据库
  Database database = await openDatabase(path);

  // 查询数据
  List<Map<String, dynamic>> result = await database.rawQuery('SELECT * FROM table_name');

  // 处理查询结果
  // ...

  // 关闭数据库连接
  await database.close();
}