import 'dart:ffi';
import 'dart:io';

import 'package:jadb/models/create_empty_db.dart';
import 'package:jadb/search.dart';
import 'package:sqflite_common_ffi/sqflite_ffi.dart';
import 'package:sqlite3/open.dart';
import 'package:test/test.dart';

Future<DatabaseExecutor> setup_inmemory_database() async {
  final libsqlitePath = Platform.environment['LIBSQLITE_PATH'];

  if (libsqlitePath == null) {
    throw Exception('LIBSQLITE_PATH is not set');
  }

  final dbConnection = await createDatabaseFactoryFfi(
    ffiInit: () =>
        open.overrideForAll(() => DynamicLibrary.open(libsqlitePath)),
  ).openDatabase(':memory:');

  return dbConnection;
}

void main() {
  test('Create empty db', () async {
    final db = await setup_inmemory_database();

    await createEmptyDb(db);

    await db.jadbVerifyTables();
  });
}