Agfdhyk

I'm using this tutorial for work with sqflite:

https://grokonez.com/flutter/flutter-sqlite-example-crud-sqflite-example

The database was preloaded in my app, but after I ran an update query and exited the app, my data was reset!

How do I make sure my changes to the database persist after I exit the app.

Database Helper:

class DatabaseHelper {

  static final DatabaseHelper _instance = new DatabaseHelper.internal();



  factory DatabaseHelper() => _instance;



  Database _db;



  DatabaseHelper.internal();



  Future<Database> get db async {

    if (_db != null) {

      print('---------------Open DB Exist-------------');

      return _db;

    }

    print('---------------Create Copy DB-------------');

    _db = await initDb();



    return _db;

  }



  initDb() async {

    String databasesPath = await getDatabasesPath();

    String path = join(databasesPath, 'mezajxdbs.db'); //On Device



    ByteData data =

        await rootBundle.load(join("assets", "dbs.db")); //In Assets folder

    List<int> bytes =

        data.buffer.asUint8List(data.offsetInBytes, data.lengthInBytes);

    await File(path).writeAsBytes(bytes);



    // await deleteDatabase(path); // just for testing



    _db = await openDatabase(path, version: 1);

    return _db;

  }

Future<List> getAllCategories() async {

    var dbClient = await db;

    // var result = await dbClient.query(tabelCategory, columns: [columnId, columnImage, columnName]);

    var result = await dbClient.rawQuery('SELECT * FROM category');

    return result.toList();

  }



  Future<int> getCount() async {

    var dbClient = await db;

    return Sqflite.firstIntValue(

        await dbClient.rawQuery('SELECT COUNT(*) FROM category'));

  }



  Future<Category> getCategory(int id) async {

    var dbClient = await db;

    var result = await dbClient

        .rawQuery('SELECT * FROM category WHERE ID_Category = $id');

    if (result.length == 0) return null;

    return new Category.fromMap(result.first);

  }



Future<int> updateFavorite(Food food) async {

      print('updated fav food');

    var dbClient = await db;

    return await dbClient.rawUpdate(

        'UPDATE food SET Favorite = '${food.favotite}' WHERE ID_Food = ${food.id}');

  }  







Future<int> saveFood(Food food) async {

    var dbClient = await db;

   var result = await dbClient.rawInsert(

       'INSERT INTO food (FK_Category, FK_Mezaj, Name, Value, Description, ImageName, Favorite) VALUES ('${food.cateory}', '${food.mezaj}', '${food.name}', '${food.value}', '${food.description}', '${food.image}', '${food.favotite}'  )');



    return result;

  }

Future close() async {

    var dbClient = await db;

    return dbClient.close();

  }

}

Food Model:

class Food {

  int _id, _mezaj, _favorite, _category;

  String _name, _value, _description, _image;



  Food(this._category, this._mezaj, this._name, this._image, this._value, this._description, this._favorite);



  Food.map(dynamic obj) {

    // obj[Database Column Name] --> sample obj["ID_Food"] \

    this._id = obj["ID_Food"];

    this._category = obj["FK_Category"];

    this._mezaj = obj["FK_Mezaj"];

    this._name = obj["Name"];

    this._value = obj["Value"];

    this._description = obj["Description"];

    this._image = obj["ImageName"];

    this._favorite = obj["Favorite"];

  }



  int get id => _id;

  int get cateory => _category;

  int get mezaj => _mezaj;

  String get name => _name;

  String get value => _value;

  String get description => _description;

  String get image => _image;

  int get favotite => _favorite;





  Map<String, dynamic> toMap() {

    var map = new Map<String, dynamic>();

    if (_id != null) {

      map['ID_Food'] = _id;

    }

    map["FK_Category"] = _category;

    map["FK_Mezaj"] = _mezaj;

    map["Name"] = _name;

    map["Value"] = _value;

    map["Description"] = _description;

    map["ImageName"] = _image;

    map["Favorite"] = _favorite;



    return map;

  }



  Food.fromMap(Map<String, dynamic> map){

    this._id = map["ID_Food"];

    this._category = map["FK_Category"];

    this._mezaj = map["FK_Mezaj"];

    this._name = map["Name"];

    this._value = map["Value"];

    this._description = map["Description"];

    this._image = map["ImageName"];

    this._favorite = map["Favorite"];

  }

}

Insert Code:

await db.saveFood(new Food(1, 2, 'Test2', 'ahoo', '2-2', "Create SQLite Tutorial", 1));

After Stop Debuging, and run again into debug, all inserted Data was reset!