[Flutter] Flutter SQLite connection trouble (for Android)

Doing app for Android.(new on flutter) Trying to connect to already existing SQLite file to project. I have issue with connection, it doesnt connecting to file but init empty new one with same name in drirectory of android (Android/data/com.exemple.android_studio_project). In enternet i have seen only lazy initialization variant. There was some methods to locate file, but for some reason they dont working.

I tried to ask AI but answer wasnt satisfy me.

**True db location is: D:\android_studio_project\lib\souece.db **

part of the code sqLite_connect.dart:

import 'dart:typed_data';

import 'package:flutter/services.dart';
import 'packageath_provider/path_provider.dart';
import 'package:sqflite/sqflite.dart';
import 'packageath/path.dart';
import 'dart:io';

class SqliteConnect {
static final SqliteConnect instance = SqliteConnect._init();

SqliteConnect._init();

Database? _database;

Future<Database> get database async {
if (_database != null) return _database!;


_database = await _initDB('source.db');
return _database!;
}

Future<Database> _initDB(String filePath) async {

Directory documentsDirectory = await getApplicationDocumentsDirectory();


String path = join(documentsDirectory.path, filePath);


bool dbExists = await _checkDbExists(path);


if (!dbExists) {
await _copyDbFromAssets(path);
}


return await openDatabase(path);
}


Future<bool> _checkDbExists(String path) async {
try {
return await File(path).exists();
} catch (e) {
return false;
}
}


Future<void> _copyDbFromAssets(String path) async {

ByteData data = await rootBundle.load('android_studio_project/assets/source.db');


List<int> bytes = data.buffer.asUint8List(data.offsetInBytes, data.lengthInBytes);


await File(path).writeAsBytes(bytes, flush: true);
}






}


I expexting to take data from the file that be in the app

If theer is technology of storing data in sqlite on Flutter app that i dont know, i will be glad to take advise.

Continue reading...