Wikipedia:Bots/Requests for approval/DannyS712 bot III 74

DannyS712 bot III 74

Operator: DannyS712 (talk · contribs · SUL · edit count · logs · page moves · block log · rights log · ANI search)

Time filed: 00:02, Thursday, May 9, 2024 (UTC)

Automatic, Supervised, or Manual: automatic

Source code available: TBD

Function overview: Automatically mark redirects created by Wikipedia:Page movers as part of a page move as "patrolled" in the new page patrol / page curation system

Links to relevant discussions (where appropriate): Wikipedia talk:New pages patrol/Reviewers/Archive 51#Idea to reduce redirect backlog

Edit period(s): Continuous

Estimated number of pages affected: Lots

Exclusion compliant (Yes/No): No

Already has a bot flag (Yes/No): Yes

Function details: The code will be added to my current redirect patrolling bot rules (see User:DannyS712 bot III/rules for the current rules) once I write it. You can see the implementation I intend to use is to patrol all redirects based on the query below.

If possible, I'd like to request speedy approval and/or a time-based trial, so that I don't need to add a whole bunch of logic to the bot to count how many redirects have already been patrolled in the trial.

Query to run

SELECT
	page_id AS 'pageid',
	page_title AS 'title',
	ptrpt_value AS 'target',
	actor_name AS 'creator'
FROM
	page
	JOIN pagetriage_page ON page_id = ptrp_page_id
	JOIN pagetriage_page_tags ON ptrp_page_id = ptrpt_page_id
	JOIN revision rv ON page_latest = rev_id
	JOIN actor ON rev_actor = actor_id
	JOIN user_groups ON actor_user = ug_user
WHERE
	ptrp_reviewed = 0
	AND ptrpt_tag_id = 9 # Snippet
	AND page_namespace = 0
	AND page_is_redirect = 1
	AND EXISTS (
		# Only 1 revision based on rev_count page triage tag
		SELECT 1
		FROM pagetriage_page_tags tags2
		WHERE tags2.ptrpt_page_id = page_id
		AND tags2.ptrpt_tag_id = 7
		AND tags2.ptrpt_value = 1
	)
	AND EXISTS (
		# Move log from the same time by the same person
		SELECT 1
		FROM logging_logindex lgl2
		WHERE log_namespace = page_namespace
		AND log_title = page_title
		AND log_timestamp = rev_timestamp
		AND log_actor = rev_actor
		AND log_type = 'move'
		AND log_action = 'move'
	)
	AND ug_group = 'extendedmover'

LIMIT 100;

Discussion

Approved for trial (100 edits or 14 days, whichever happens first). Please provide a link to the relevant contributions and/or diffs when the trial is complete. ProcrastinatingReader (talk) 10:58, 9 May 2024 (UTC) count updated. Primefac (talk) 17:03, 29 June 2024 (UTC)[reply]

@ProcrastinatingReader the bot reports to User:DannyS712 bot III/Redirects.json every 15 minutes with the redirects that it patrols and why - a 14 day trial will be 1344 entries to scan through, and I would expect that almost all of the relevant entries would be on the first run (for any existing backlog) - would a shorter trial be okay? Like a day (or even less)? --DannyS712 (talk) 16:13, 9 May 2024 (UTC)[reply]

(

Peanut gallery comment) I am BOLDly adding {{BAG assistance needed}}: {{BAG assistance needed}} House Blaster (talk · he/they) 03:32, 29 June 2024 (UTC)[reply]

I've tweaked the trial numbers. Primefac (talk) 17:03, 29 June 2024 (UTC)[reply]

Is there a reason that a single day trial (as requested by Danny) would be a Bad Thing? Of course, I am not a bot op, so there might be something I am unaware of :) House Blaster (talk · he/they) 22:39, 29 June 2024 (UTC)[reply]

I'm also wondering that - also the "whichever happens first" means I would still need to add some logic to count how many redirects have been patrolled in the trial already --DannyS712 (talk) 12:18, 1 July 2024 (UTC)[reply]

{{bag assistance needed}} (apologies for using this a lot as of late...) House Blaster (talk · he/they) 22:45, 6 July 2024 (UTC)[reply]

Though I cannot speak on his behalf, I imagine a concern that @Primefac: may have had would be that the bot might be done within a day. What are your thoughts, Primefac? Provided that it won't actually complete within a day, I don't see an issue with a 1 day trial. cc @DannyS712: --TheSandDoctor ^Talk 04:24, 9 July 2024 (UTC)[reply]

I had no concerns; I thought I was giving the botop what they wanted. They said 14 days was too long and there would be too many actions to look at. I threw out 100 as our standard number (which does happen to be "about a day's worth" when you do the maths) because on these "not sure how many per day" requests it might be only a few dozen over 14 days. Danny is a trusted botop and while it needs to go through a trial to make sure everything is working, we are not going to begrudge a handful of edits on either side of 100 if the task can be shown to be operating within expected parameters. So sure, run it for a day and see where you end up. Primefac (talk) 00:03, 10 July 2024 (UTC)[reply]

And yes, HouseBlaster, using the assistance template twice in ten days is a bit excessive. Primefac (talk) 00:03, 10 July 2024 (UTC)[reply]

@DannyS712: did you see the above? TheSandDoctor ^Talk 22:20, 13 July 2024 (UTC)[reply]

Yes, sorry, I was out of town for a while but am back and will do bot stuff again soon --DannyS712 (talk) 02:39, 21 July 2024 (UTC)[reply]

A user has requested the attention of the operator. Once the operator has seen this message and replied, please deactivate this tag. (user notified) @DannyS712: is there still interest in pursuing this task? or are you happy to mark this as withdrawn for the time being? ProcrastinatingReader (talk) 10:58, 29 September 2024 (UTC)[reply]

@DannyS712 seems to be away at the moment. I think we can safely mark this as inactive until they return or if the stand-in botop is willing to take over this item. pinging @DreamRimmer for attention. – robertsky (talk) 02:12, 5 October 2024 (UTC)[reply]

Out of 414 page movers, about 300 are either listed for redirect autopatrol or already have autopatrolled rights. Since this query shows no backlog, I think if we see a backlog of 100 or more, I will go ahead and add this functionality. For now, let's wait a little longer for Danny. – DreamRimmer (talk) 07:43, 6 October 2024 (UTC)[reply]