So that the new gb_by_central_id column is selectable.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | PRODUCTION ERROR | Zabe | T298707 "InvalidArgumentException: Blocker must be a local user" from GlobalBlocking | ||
| Open | None | T299371 Migrate globalblocks table to use central ids instead of usernames | |||
| Resolved | • Marostegui | T299827 Add gb_by_central_id column to globalblocks table | |||
| Resolved | None | T300988 Recreate views for globalblocks table |
Event Timeline
Comment Actions
Yeah I can do this. Unless it's a high priority I'd like to start automating this.
I can't remember where I saw this, but there's this idea that to go from a manual to fully automated process, a good first step is a script that simply prompts the user to do every manual step, then prompts can be replaced by actual functions once the process is well understood. I think I'll try that :)
Comment Actions
(Got the idea of prompting the user to do the manual steps from https://phabricator.wikimedia.org/phame/post/view/217/runnable_runbooks/, which links to https://blog.danslimmon.com/2019/07/15/do-nothing-scripting-the-key-to-gradual-automation/)
Comment Actions
MariaDB [centralauth_p]> desc globalblocks; +------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+-------+ | gb_id | int(11) | NO | | 0 | | | gb_address | varbinary(255) | NO | | | | | gb_by | varbinary(255) | NO | | | | | gb_by_wiki | varbinary(255) | NO | | | | | gb_reason | varbinary(767) | NO | | NULL | | | gb_timestamp | varbinary(14) | NO | | NULL | | | gb_anon_only | tinyint(1) | NO | | 0 | | | gb_expiry | varbinary(14) | NO | | | | | gb_range_start | varbinary(35) | NO | | NULL | | | gb_range_end | varbinary(35) | NO | | NULL | | | gb_by_central_id | int(10) unsigned | YES | | NULL | | +------------------+------------------+------+-----+---------+-------+ 11 rows in set (0,002 sec) MariaDB [centralauth_p]>