queries.dart

newUser(User user) async {
    final db = await database;
    var res = await db.insert('user', user.toJson());

    return res;
}

getUser(int id) async {
    final db = await database;
    var res = await db.query('user', where: 'id = ?', whereArgs: [id]);

    return res.isNotEmpty ? User.fromJson(res.first) : Null;
}