CODEWITHSUNDEEP
fluttersqflite
Sermed mayi
Sermed mayi

Reputation: 757

Flutter : insert data to tables in sqflite at initialaztion database

I have created helper class for sqlite database and tried to insert data to tables in intialzing database as this :

class DbHelper {
  static final DbHelper _instance = DbHelper.internal();
  factory DbHelper() => _instance;
  DbHelper.internal();
  static Database _db;
  //---------------- Create database method-------------------
  Future<Database> createDatabase() async {
    var teamsTable = SqliteData().teams;
    var clubsTable = SqliteData().clubs;
    if (_db != null) {
      return _db;
    }
    String path = join(await getDatabasesPath(), 'clubsFantasy.db');
    _db = await openDatabase(path, version: 1,
        onCreate: (Database db, int v) async {
      await db.execute('''
          create table teams (club varchar(50) ,
          price integer ,
          surename varchar(3),
          id integer,
          league varchar(20))
          ''');
      await db.execute(
         'create table clubs (id integer ,club varchar(50) ,league_id integer,price integer ,surename varchar(3),  league_name varchar(20),counter integer , selected varchar(5))');
      teamsTable.map((e) => {db.insert('teams', e.toMap())}).toList();
      clubsTable.map((e) => {db.insert('clubs', e.toMap())}).toList();
    });

    return _db;
  }
//---------------- load data method---------------------
  Future getTeamsData() async {
    Database db = await createDatabase();
    return db.query('teams');
  }

  Future getClubsData() async {
    Database db = await createDatabase();
    return db.query('clubs');
  }
}

I call database at splash screen to create database and insert data to tables:

DbHelper helper;
  @override
  void initState() {
    helper = DbHelper();
    checkLogin();
    helper.createDatabase();
    super.initState();
  }

now I want to display data and used it in provider ,I did this :

class TeamsProvider with ChangeNotifier {
  DbHelper helper;
  get clubs => helper.getClubsData();
  get teams => helper.getTeamsData();
}

I called teams in future builder in screen :

Widget build(BuildContext context) {
    return Consumer<TeamsProvider>(
      builder: (context, teamsProv, child) {
        return FutureBuilder(
            future: teamsProv.teams,
            builder: (context, snapshot) {
              if (snapshot.hasData) {.....etc

I get error : The method 'getTeamsData' was called on null. Receiver: null Tried calling: getTeamsData()

Upvotes: 0

Views: 1187

Answers (1)

Peter Koltai
Peter Koltai

Reputation: 9734

I am not sure but try declaring your DbHelper like this:

class DbHelper {
    factory DbHelper() => DbHelper._internal()
    DbHelper._internal();

DbHelper methods like:

   static Future<Database> createDatabase() async {...
   static Future getTeamsData() async {...
   static Future getClubsData() async {...

And then:

class TeamsProvider with ChangeNotifier {
    get clubs => DbHelper.getClubsData();
    get teams => DbHelper.getTeamsData();
}

Upvotes: 1

Related Questions