extensions-website/reviewers/tests
Oleg Komarov 13ac2436ad ApprovalQueue: use a materialized table (#240)
see #238

This change improves the listing performance: old code had to process all
ApprovalActivity to compute an extension's moderation status and position in
the queue.

Now we maintain a sortkey, a reference to the latest "meaningful" activity
object, and a total comment count. These fields are updated in a post_save
signal.

"Meaningful" activity means moderation status changes:
approved, awaiting changes, awaiting review.

"Non-meaningful" activity shouldn't affect queue position anymore and
extensions without "meaningful" activity should not appear in the queue, but
their respective detail pages should still be reachable via a direct link.
This UX may still need improvement, and #210 may be relevant here.

Reviewed-on: #240
Reviewed-by: Anna Sirota <annasirota@noreply.localhost>
2024-08-23 15:11:45 +02:00
..
__init__.py Initial review process 2024-02-18 19:05:12 +01:00
test_notifications.py Notifications: unsubscribe from extension approval activity (#177) (#207) 2024-07-30 12:11:03 +02:00
test_views.py ApprovalQueue: use a materialized table (#240) 2024-08-23 15:11:45 +02:00