safe-global / safe-locking-service / 9445500257

92%

push

github

Add leaderboard materialized view (#128)

- Add a new Django command to update a materialized view that contains the leaderboards for all campaigns.
- Refreshing the leaderboards happen with the following actions:
  * A CSV with new activities is uploaded
  * The command `python manage.py update_leaderboard_view` is executed.
- The materialized view is stored under `campaign_leaderboards` with an index on the `address` and `campaign_uuid`.
- Updates the view query to get the leaderboard position so that it uses the new materialized view instead.

---------

Co-authored-by: Uxío <Uxio0@users.noreply.github.com>

21 of 21 new or added lines in 3 files covered. (100.0%)

1958 of 2155 relevant lines covered (90.86%)

0.91 hits per line