⚓ T259377 Migrate AbuseFilter to Abstract Schema

	Subject	Repo	Branch	Lines +/-
	Convert to abstract schema	mediawiki/extensions/AbuseFilter	master	+680 -245

Status	Assigned	Task
Resolved	None	T254646 Reconsidering how we name things
Open	None	T281536 Schema:EditAttemptStep uses non-inclusive language.
Open	None	T279275 Move all the functionality of {Spam,Title}Blacklist extensions into AbuseFilter and retire them
Resolved	None	T290934 Expand the set of bundled extensions and skins in MediaWiki 1.38
Resolved	Daimona	T191740 Bundle AbuseFilter extension with MediaWiki
Resolved	Daimona	T199544 Make AbuseFilter work on PostgreSQL and SQLite (epic)
Resolved	Ladsgroup	T191231 RFC: Abstract schemas and schema changes
Open	None	T259374 Convert extensions to using abstract schema
Resolved	None	T261911 Convert Bundled Extensions to Abstract Schema
Resolved	None	T261912 Convert WMF Deployed Extensions to Abstract Schema
Resolved	Umherirrender	T259377 Migrate AbuseFilter to Abstract Schema
Resolved	Daimona	T220791 afl_filter should be split in afl_filter_id and afl_global
Resolved	• Marostegui	T234052 Add abuse_filter_log.afl_filter_id and afl_global columns
Resolved	• Bstorm	T234615 Wikireplicas changes for abuse_filter_log including two new columns
Resolved	Daimona	T269712 Migrate afl_filter to afl_filter_id and afl_global
Resolved	• Urbanecm	T269713 Run the MigrateAflFilter script for AbuseFilter
Resolved	• Marostegui	T291719 Remove abuse_filter_log.afl_filter column and adjust schema consequently from Wikimedia production
Resolved	rook	T291806 Remove afl_filter column from the views

Reedy created this task.Jul 31 2020, 5:15 PM

Reedy added a parent task: T199544: Make AbuseFilter work on PostgreSQL and SQLite (epic).

Reedy renamed this task from Convert AbuseFilter to Abstract Schema to Migrate AbuseFilter to Abstract Schema.Jul 31 2020, 5:27 PM

Reedy updated the task description. (Show Details)

I think T220791 should be finished first but yes, this would be a huge improvement. Perhaps something to consider for the upcoming AF overhaul (depending on whether T220791 really is necessary, and if so, whether it makes it to prod in time).

Daimona moved this task from Backlog to Ideas for overhaul on the User-Daimona board.Aug 20 2020, 11:58 AM

Reedy added a parent task: T261912: Convert WMF Deployed Extensions to Abstract Schema.Sep 3 2020, 3:07 AM

Reedy removed a parent task: T259374: Convert extensions to using abstract schema.

Reedy mentioned this in T261912: Convert WMF Deployed Extensions to Abstract Schema.Sep 3 2020, 1:00 PM

Daimona edited projects, added AbuseFilter (Overhaul-2020); removed User-Daimona, AbuseFilter.Sep 16 2020, 3:19 PM

Daimona moved this task from Backlog to Stretch on the AbuseFilter (Overhaul-2020) board.Sep 16 2020, 3:21 PM

Daimona edited projects, added AbuseFilter; removed AbuseFilter (Overhaul-2020).Feb 5 2021, 3:32 PM

Daimona added a subtask: T220791: afl_filter should be split in afl_filter_id and afl_global.

This is a very technical expression of a requirement, though not certain what it actually means, or the actual impact. A pointer to what is envisaged, or what change it would make to implementers, rather than hackers, would be great.

In T259377#6971525, @Billinghurst wrote:

This is a very technical expression of a requirement,

Necessarily so, yes.

though not certain what it actually means, or the actual impact. A pointer to what is envisaged, or what change it would make to implementers, rather than hackers, would be great.

See the parent task, T261912: Convert WMF Deployed Extensions to Abstract Schema, and especially the grandparent task T191231: RFC: Abstract schemas and schema changes for the impact.