Wikipedia:Bots/Requests for approval/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
Programming language(s): JavaScript
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[edit]
Approved for trial (14 days). Please provide a link to the relevant contributions and/or diffs when the trial is complete. ProcrastinatingReader (talk) 10:58, 9 May 2024 (UTC)
- @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)