Research talk:Revision scoring as a service/Work log/2015-09-06

Sunday, September 6, 2015

Today I'm trying to figure out the flaggedrevs equivalent of a revert.

So, it looks like we have some flaggedrevs in enwiki. See http://quarry.wmflabs.org/query/5084

I wonder if this table gets updated when a flagged revision is reviewed. I should be able to find the event in the log somehow.

http://quarry.wmflabs.org/query/5085:

log_type        log_action  
-----------------------------
...
review		approve
newusers	create
newusers	autocreate
delete		delete
thanks		thank
review		approve-a
...

So it looks like we have a couple of review actions. Those correspond to what I see in mw:Extension:FlaggedRevs#Logging.

http://quarry.wmflabs.org/query/5086

log_action	count(*)
------------------------
approve		160
approve-a	831
approve-ia	6
unapprove	3

So, it looks like these actions are aimed towards an explicit "approval", but not a disapproval. Regretfully, I can't find a mention of "approve-a" or "approve-ia" in the docs.

http://quarry.wmflabs.org/query/5087:

log_id		log_action	log_timestamp	log_user	log_namespace	log_title	log_comment	log_params	log_deleted	log_user_text	log_page
68858515	approve	20150906155240	19204020	0	2015–16_Premier_League	([[WP:TW|TW]])	679754059 679754059 20150906155239	0	Qed237	44818119
68858349	approve	20150906154020	553121	0	Luke_Shaw	([[WP:TW|TW]])	679752502 679752502 20150906154019	0	Mattythewhite	34529343
68858124	approve	20150906152211	22632709	0	Tony_Hawk		679750291 679231484 20150906152157	0	RegistryKey	87474
68858917	approve-a	20150906161856	16818327	0	Cameron_Boyce	automatic	679757380 679757202 20150906161856	0	Philip J Fry	18725383
68858897	approve-a	20150906161722	16818327	0	Cameron_Boyce	automatic	679757202 676677152 20150906161722	0	Philip J Fry	18725383
68858863	approve-a	20150906161513	17585538	0	September_25	automatic	679756931 679552255 20150906161513	0	Telfordbuck	28203
68857445	approve-ia	20150906144303	409043	0	Leigh-Allyn_Baker	automatic	679745858 0 20150906144303	0	NeilN	2060861
68857436	approve-ia	20150906144245	9661331	0	Mukesh_Ambani	automatic	679745821 0 20150906144244	0	SpacemanSpiff	1200969
68849804	approve-ia	20150906055633	409043	0	Disk_compression	automatic	679692935 0 20150906055633	0	NeilN	3120542
68850560	unapprove	20150906070542	18794213	0	New_Zealand_flag_debate	doesn't currently link anywhere	679695468 679695468 20150906062320	0	Haminoon	17777260
68842050	unapprove	20150905194739	23085006	0	FIFA_World_Rankings		679627855 679627855 20150905192500	0	Rubbish computer	719095
68836483	unapprove	20150905141403	14419815	0	Spectre_(2015_film)	Needs a valid citation	679587850 679587850 20150905140358	0	SchroCat	44853982

It looks like approve-a and approve-ia are automatic approvals. For the unapproved, it looks like a revert still happens. See title=New_Zealand_flag_debate&diff=next&oldid=679695468. So I don't think we need to worry about this. We still want to be looking for reverts. --EpochFail (talk) 16:25, 6 September 2015 (UTC)