Page MenuHomePhabricator

Calculate and update the "edits on shared pages count" property for SuggestedInvestigations cases
Closed, ResolvedPublic

Description

The schema defined in T433853: Create a table to store calculated properties for SuggestedInvestigations has gotten tentative approval (or at least hasn't been rejected outright) as of writing and is probably stable enough to develop on while waiting for creation. To display the value in T433840: Implement case filtering on "edits on shared pages" for SuggestedInvestigations it has to exist first. This value is the one calculated by SuggestedInvestigationsSharedPagesLookup::getSharedPagesForCases.

Additional tickets may be split from this depending on scale of the solution.

Acceptance criteria:

  • On case creation, calculate and cache value of "edits on shared pages count"
  • On edit from an account tied to a case, invalidate the case's cached value and recalculate/rewrite
  • Instrument this, as we need to know if it's too expensive/if we need to downgrade live-ness

Event Timeline

Change #1325437 had a related patch set uploaded (by STran; author: STran):

[mediawiki/extensions/CheckUser@master] SI: Add "count of edits on shared page" case property

https://gerrit.wikimedia.org/r/1325437

Change #1325437 merged by jenkins-bot:

[mediawiki/extensions/CheckUser@master] SI: Add "count of edits on shared page" case property

https://gerrit.wikimedia.org/r/1325437