Page MenuHomePhabricator

Review tools/repos/quary-queries making use of rev_user/rev_user_text
Open, Needs TriagePublic

Description

With T223406/T167246: Refactor "user" & "user_text" fields into "actor" reference table the [[ https://www.mediawiki.org/wiki/Manual:Revision_table#rev_user | revisions.rev_user ]] and revisions.rev_user_text will be replaced by the [[ https://www.mediawiki.org/wiki/Manual:Actor_table | actor table ]].

Some of our tools e.g. WLM-stats make use of the old columns and need to be updated.

Event Timeline

Lokal_Profil updated the task description. (Show Details)
Lokal_Profil renamed this task from Review tools/repos making use of rev_user/rev_user_text to Review tools/repos/quary-queries making use of rev_user/rev_user_text.Jun 3 2019, 10:28 AM
Lokal_Profil updated the task description. (Show Details)

WLM-stats just hammers the api it seems so that should be safe. still worth taking a look at our tools to make sure.

hostbot might be affected but I don’t believe we are supporting that any more (@Sebastian_Berlin-WMSE ?)

Fae's reportGLAMdashboard still uses these (but I'm not sure that's the code currently deployed)

And similar to T224866: Review queries on quarry using rev_comment field this also affects some of the queries on quary which we make use of for reporting purposes

hostbot might be affected but I don’t believe we are supporting that any more (@Sebastian_Berlin-WMSE ?)

It hasn't been running for quite some time, no.