getTodaySymptomsLog function

Future<List<UserSymptomsLogData>> getTodaySymptomsLog({
  1. required String? userId,
})

get Today's symptoms logs based on userId

Implementation

Future<List<UserSymptomsLogData>> getTodaySymptomsLog(
    {required String? userId}) async {
  List<UserSymptomsLogData> usersLogDataList = [];
  final dbHelper = MenstrualCycleDbHelper.instance;

  Database? db = await dbHelper.database;

  final List<Map<String, dynamic>> queryResponse = await db!.rawQuery(
      "Select * from ${MenstrualCycleDbHelper.tableDailyUserSymptomsLogsData} WHERE ${MenstrualCycleDbHelper.columnUserId}='$userId'");
  List.generate(queryResponse.length, (i) {
    UserSymptomsLogData userLogsData = UserSymptomsLogData();
    userLogsData.id = queryResponse[i][MenstrualCycleDbHelper.columnID];
    userLogsData.userid = queryResponse[i][MenstrualCycleDbHelper.columnUserId];
    userLogsData.symptomData = Encryption.instance.decrypt(
        queryResponse[i][MenstrualCycleDbHelper.columnUserEncryptDate]);
    userLogsData.logDate =
        queryResponse[i][MenstrualCycleDbHelper.columnLogDate];
    userLogsData.createdAt =
        queryResponse[i][MenstrualCycleDbHelper.columnCreatedDateTime];
    usersLogDataList.add(userLogsData);
  });
  return usersLogDataList;
}