Implement a mechanism for Redis cache flushing

[sadatmalik]

User Story: As an admin, I sometimes need to update the database directly. This can lead to inconsistencies with Redis cached entries. Therefore, I need a way to manually flush the Redis cache to ensure data consistency.

Problem: Currently, there is no direct method to purge the Redis cache from the AWS console. Flushing the cache must be done via the Redis console or AWS Systems Manager (SSM).

Objective: Investigate available options and implement a repeatable, easy-to-use method for manually purging the Redis cache when necessary. Document the process.

Tasks:

• [x] Research methods to clear the Redis cache using AWS tools (e.g., Redis CLI, AWS SSM).
• [x] Implement a Python script or alternative solution to automate the cache purging process.
• [x] Test in local and staging
• [x] Document the solution, with step-by-step instructions for usage.
• [x] Deploy to master and confirm operation is as expected

[sadatmalik]

Opting to implement as a system admin API call for cleaner security access. Longer term it is better to introduce the Amazon service manager to manage cloud services.

From the TC admin api:

Before and after in Redis:

[sadatmalik]

Pre and post flush_user_cache:

[sadatmalik]

Applied as a hot fix to prod - and tested to be working:

Redis entries after flushing users cache:

[sadatmalik]

Documented step by step instructions for usage here: https://app.tettra.co/teams/talentbeyondboundaries/pages/recurring-tc-processes#header-76mk0-flushing-the-tc-redis-cache