import 'package:sqlite3/sqlite3.dart' hide Database;
import 'package:sqflite_common_ffi/sqflite_ffi.dart';

// Init database
Future<String?> init() async {
  // Set up databaseFactory by databaseFactoryFfi for sqflite_common_ffi
  databaseFactory = databaseFactoryFfi;
  var databasesPath = await getApplicationSupportDirectory();
  String path = p.join(databasesPath.path, _name);
  _db = await openDatabase(
    path,
    version: 1,
    onCreate: (Database db, int version) async {
      await db.execute('CREATE TABLE $_table (val_str TEXT)');
    },
  );
  return await select();
}

// Get value from Database
Future<String?> select() async {
  final rows = await _db?.rawQuery('SELECT rowid as id, * FROM $_table');
  if (rows != null && rows.isNotEmpty && rows[0].containsKey('id')) {
    return rows[0]['val_str'].toString();
  }
  return null;
}

// Set value to Database
Future<void> insert(String value) async {
  await _db?.transaction((txn) async {
    await txn.rawInsert('INSERT INTO $_table(val_str) VALUES(?)', [value]);
  });
}

// Close database
Future<void> close() async {
  await _db?.close();
}

dependencies:
  sqflite_common_ffi: ^2.0.0
  sqlite3: ^2.5.0
  sqlite3_flutter_libs_aurora:
    git:
      url: https://hub.mos.ru/auroraos/flutter/flutter-community-plugins/sqlite3_flutter_libs_aurora.git

flutter pub get

flutter-aurora pub get