How to work with nested Models in Sqlflite Flutter

Question

I am going to be working with sqlflite package in Flutter, and I have been reading a lot about it. However, everywhere I find the example being shown for the single model, that is

SingleModel{
  String data1, data2;

  ....
}

I have followed

these as well, but that did not quite resolve it. My main requirements is to work with the data like this:

user: {
  'id': unique_key,
  'name': 'abc',
  'courses': [
    { 'coursename': 'some_coursename'},
    { 'coursename': 'some_other_coursename'}
  ]
}

I have designed my model correctly,

UserModel Class

class UserModel{
  int id;
  String name;
  List<Course> _courses;

  UserModel.set(Map data){
    this.id = data['id'];
    this.name = data['name'];
    if(data['courses'] != null)
         this.courses = [data['courses']];
  }

  // append more courses
  void setMorCourses(Map course){
     // checking for duplicate errors
     if(!this.courses.contains(course['course']))
         this.courses.add(course['course'])
  }
}

Now, I am confused on how to use the Nested Model with sqlflite. I believe I need to work in the DatabaseHelper class.

Course Class

class CourseModel{
  String coursename;

  CourseModel.set(Map data){
    this.coursename = data['coursename'];
  }
}

you can refer this https://stackoverflow.com/questions/55353469/store-complex-type-in-flutter-sqflite — Ravi Patel, Aug 19 '20 at 09:35
But @RaviPatel none of them gave me a reference of storing the item like `JSON`. It says to create two tables, that is vague. — Alok, Aug 19 '20 at 09:38
This is a better way to do this so i prefer you to do store object with this — Ravi Patel, Aug 19 '20 at 09:47
for JSON here is a reference link :- https://stackoverflow.com/questions/62815607/how-to-store-a-complex-json-response-from-api-in-local-database-in-flutter — Ravi Patel, Aug 19 '20 at 09:49

How to work with nested Models in Sqlflite Flutter

0 Answers0