import 'package:sqflite/sqflite.dart';

// Init database
Future<String?> init() async {
  var databasesPath = await getDatabasesPath();
  String path = p.join(databasesPath, _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: ^2.4.1
  sqflite_aurora:
    git:
      url: https://hub.mos.ru/auroraos/flutter/flutter-community-plugins/sqflite_aurora.git

flutter pub get

flutter-aurora pub get