1. import datetime
  3. def verify_user_records(user_records):
  4. """
  5. Verifies the integrity of user records for scheduled runs.
  6. Performs basic sanity checks.
  8. Args:
  9. user_records (list): A list of dictionaries, where each dictionary
  10. represents a user record. Example:
  11. [{'user_id': 1, 'username': 'john_doe', 'email': 'john.doe@example.com', 'scheduled_run_time': '2024-01-01T10:00:00'}]
  12. Returns:
  13. list: A list of error messages. Empty if all records are valid.
  14. """
  15. errors = []
  16. for record in user_records:
  17. # Check for required fields
  18. required_fields = ['user_id', 'username', 'email', 'scheduled_run_time']
  19. for field in required_fields:
  20. if field not in record:
  21. errors.append(f"Missing required field: {field}")
  22. continue # Skip to next field if one is missing
  24. # Validate user_id (must be an integer)
  25. if not isinstance(record.get('user_id'), int):
  26. errors.append("user_id must be an integer.")
  28. # Validate username (must be a string)
  29. if not isinstance(record.get('username'), str):
  30. errors.append("username must be a string.")
  32. # Validate email (basic format check)
  33. email = record.get('email')
  34. if not isinstance(email, str) or "@" not in email or "." not in email:
  35. errors.append("Invalid email format.")
  37. # Validate scheduled_run_time (must be a valid datetime string)
  38. try:
  39. datetime.datetime.fromisoformat(record.get('scheduled_run_time'))
  40. except ValueError:
  41. errors.append("Invalid scheduled_run_time format. Must be ISO format (YYYY-MM-DDTHH:MM:SS).")
  43. return errors
  45. if __name__ == '__main__':
  46. user_records = [
  47. {'user_id': 1, 'username': 'john_doe', 'email': 'john.doe@example.com', 'scheduled_run_time': '2024-01-01T10:00:00'},
  48. {'user_id': 'two', 'username': 'jane_doe', 'email': 'jane.doe@example.com', 'scheduled_run_time': '2024-01-02T12:00:00'}, #invalid user_id
  49. {'username': 'peter_pan', 'email': 'peter.pan@example.com', 'scheduled_run_time': '2024-01-03T14:00:00'}, #missing user_id
  50. {'user_id': 4, 'username': 123, 'email': 'invalid_email', 'scheduled_run_time': '2024-01-04T16:00:00'}, #invalid username and email
  51. {'user_id': 5, 'username': 'alice', 'email': 'alice@example.com', 'scheduled_run_time': '2024/01/05 18:00:00'} #incorrect date format
  52. ]
  54. errors = verify_user_records(user_records)
  56. if errors:
  57. print("User record validation errors:")
  58. for error in errors:
  59. print(error)
  60. else:
  61. print("User records are valid.")

Add your comment