getDailyLogs method

Future<List<UserSymptomsLogData>> getDailyLogs(
  1. String userId
)

get daily logs based on userID

Implementation

Future<List<UserSymptomsLogData>> getDailyLogs(String userId) async {
  Database? db = await instance.database;

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

  return usersLogDataList;
}