getRoles method

Implementation

Future<List<Role>> getRoles() async {
  final db = await database;
  final List<Map<String, dynamic>> maps = await db.query(
      'roles',
      where: 'isDeleted = ?',
      whereArgs: [0],
      orderBy: 'id DESC');

  return List.generate(maps.length, (i) {
    return Role(
      id: maps[i]['id'],
      title: maps[i]['title'],
      isEnable: maps[i]['isEnable'],
    );
  });
}