Page MenuHomePhabricator

Backfill the restrictions table with redirect data
Closed, DeclinedPublic

Description

The new access-control and redirect-control model assumes that restrictions table got the information about redirects. For newer revisions that's true, but we need to backfill it for the old revisions same as we did for deletions and revision restrictions.

Obviously, we cannot switch to the new access checking model before that's done.

This should be done after T149965

Event Timeline

Here's the SQL query we could use to export info about all the redirects: SELECT page.page_namespace, page.page_title, page.page_latest, redirect.rd_namespace, redirect.rd_title FROM page RIGHT JOIN redirect ON page.page_id = redirect.rd_from ORDER BY rd_from LIMIT 10

Change 323092 had a related patch set uploaded (by Ppchelko):
Added script to export redirects

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

GWicke triaged this task as Medium priority.Aug 8 2017, 9:49 PM

It's been decided we will no longer pursue restriction table access control due to it's complexity, so this is no longer required.

Change 323092 abandoned by Ppchelko:
Added script to export redirects

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