import 'dart:async';
import 'dart:io';
import 'package:sqflite/sqflite.dart';
import 'package:path_provider/path_provider.dart';
import 'package:path/path.dart';
import '../model/Ogrenci.dart';

class databaseHelper {
  static late databaseHelper _ANADATA;
  static late Database _DATABASE;
  String ogrenciTablosu = "ogrenci";
  String columID = "id";
  String columName = "ad_soyad";
  String columnActv = "aktif";

  factory databaseHelper() {
    if (_ANADATA == null) {
      _ANADATA = databaseHelper.init();
      return _ANADATA;
    } else {
      return _ANADATA;
    }
  }

  databaseHelper.init();

  Future<Database> getDatabase() async {
    if (_DATABASE == null) {
      _DATABASE = await _initializeDatabase();
      return _DATABASE;
    } else {
      return _DATABASE;
    }
  }

  _initializeDatabase() async {
    Directory dir = await getApplicationDocumentsDirectory();
    String dbPath = join(dir.path, "db.sql");
    var ogrenciDb =
        await openDatabase(dbPath, version: 1, onCreate: _createDatabase);
    return ogrenciDb;
  }

  Future<void> _createDatabase(Database db, int version) async {
    await db.execute(
        "CREATE TABLE $ogrenciTablosu ($columID INTEGER PRIMARY KEY AUTOINCREMENT,$columName TEXT,$columnActv INTEGER) ");
  }

  Future<int> ogrenciEkle(ogrenci ogrenci) async {
    var db = await getDatabase();
    var sonuc = await db.insert(ogrenciTablosu, ogrenci.toMap());

    return sonuc;
  }
}