How can get SQLite date in flutter?

Question

In my project, I had used the sqlite and I had written the code, but I don't know how can get data when I need to read it.

class DatabaseHelper {
  DatabaseHelper._privateConstructor();
  static final DatabaseHelper instance = DatabaseHelper._privateConstructor();
  static Database? _database;
  Future<Database> get database async => _database ??= await _initDatabase();

  Future<Database> _initDatabase() async {
    Directory documentsDirectory = await getApplicationDocumentsDirectory();
    String path = join(documentsDirectory.path, 'user.db');
    return await openDatabase(path, version: 1, onCreate: _onCreate);
  }

  Future _onCreate(Database db, int version) async {
    await db
        .execute('''CREATE TABLE USER (id INTEGER PRIMARY KEY, badge TEXT)''');
  }

  Future<List<Grocery>> getGroceries() async {
    Database db = await instance.database;
    var groceries = await db.query('USER', orderBy: 'badge');
    List<Grocery> groceryList = groceries.isNotEmpty
        ? groceries.map((e) => Grocery.fromMap(e)).toList()
        : [];

    return groceryList;
  }
}

I had written this code and I need to got the badge data. How could I can got it?

The bage data only has one date, it was just recode the notification badge. so anytime was update it.

medium.com/@nabin.dhakal/crud-with-sqlite-df9254d917d0 This may help you — Nabin Dhakal
– Nabin Dhakal, Commented Jun 30, 2022 at 12:38

Adil Shinwari · Accepted Answer · 2022-06-30 16:37:40Z

0

You can get the data calling the getGroceries() method in initState or using the FutureBuilder widget in flutter.

answered Jun 30, 2022 at 16:37

Adil Shinwari

8167 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can get SQLite date in flutter?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related