Wikipedia:Bots/Requests for approval/SQLBot 6

{{Newbot|SQLBot|6}}

Operator: {{botop|SQL}}

Time filed: 01:07, Wednesday, March 21, 2018 (UTC)

Automatic, Supervised, or Manual: automatic

Programming language(s): PHP

Source code available: https://tools.wmflabs.org/botwatch/source.php?file=parse.php

Function overview: After an AIV report hasn't been acted on in 6 hours - it is stale, and should be removed.

Links to relevant discussions (where appropriate): [https://en.wikipedia.org/w/index.php?title=Wikipedia_talk:Administrator_intervention_against_vandalism&oldid=831270473#Bot_to_clear_stale_reports], [https://en.wikipedia.org/wiki/Wikipedia:Bot_requests/Archive_76#Archiving_stale_reports_at_AIV], [https://en.wikipedia.org/wiki/Wikipedia:Administrators%27_noticeboard/Archive295#Backlog_at_WP:UAA_(and_WP:AIV)...]

Edit period(s): Continuous

Estimated number of pages affected: 1

Exclusion compliant (Yes/No): No

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

Function details: SQLBot would remove AIV reports (and associated comments) after the parent report is 6 hours old.

I would run the bot every 30 mins looking for these reports.

Tests can be seen at: [https://en.wikipedia.org/w/index.php?title=User:SQL/AIVTest&action=history]

Changing User:SQLBot/AIVStop from "go" to anything other than "go" results in the bot stopping (page is full protected)

:{{ping|JamesR}} any concerns with conflicts to :User:HBC AIV helperbot5? — xaosflux ^Talk 12:59, 22 March 2018 (UTC)

::Should the bot be simply removing stale requests, I do not believe this will cause any issues. Can we trial this as part of the BRFA to be sure? — JamesR (talk) 22:51, 25 March 2018 (UTC)

:::{{re|JamesR|Xaosflux}} - Yep, the only plan is removing stale requests. In the future I may look at removing declined requests as well, but that'll be a different BRFA (and require more discussion) SQL^{Query me!} 01:00, 26 March 2018 (UTC)

::::From the test edits, it looks as if a declined request has been so for the time limit, it would be removed just the same, yes? ~ Amory (u • t • c) 10:57, 26 March 2018 (UTC)

:::::This is true - declines that aren't removed within 6 hours would be auto-removed as stale. I think the part that seems different to me is having the bot remove declines on the very next run. SQL^{Query me!} 23:56, 26 March 2018 (UTC)

:{{BotTrial|days=15|edits=200}} — xaosflux ^Talk 15:56, 30 March 2018 (UTC)

::Thank you, I set the bot to shut off after 200 edits, or 15 days - whichever comes first. SQL^{Query me!} 20:41, 30 March 2018 (UTC)

{{BotTrialComplete}} (Timed out @ 15 days long before hitting 200 edits), {{re|Xaosflux}} - diffs for every last edit can be found at User:SQLBot/Trial6, or quarry:query/25979. Bot is shut down until approved or further trial is requested. SQL^{Query me!} 05:40, 15 April 2018 (UTC)

:{{re|SQL}} looking good, question on operations: are the edits that will be made for task going to include or avoid asserting the bot parameter? (i.e. Is it desirable for them to show up on RC/Watchlists?) — xaosflux ^Talk 15:58, 15 April 2018 (UTC)

::{{re|Xaosflux}} I would not want to hide the edits from RC / WL - so at this time I wouldn't want/need the bot flag. SQL^{Query me!} 16:04, 15 April 2018 (UTC)

:{{BotApproved}} task approved, to run unflagged. — xaosflux ^Talk 17:05, 15 April 2018 (UTC)

:The above discussion is preserved as an archive of the debate. Please do not modify it. To request review of this BRFA, please start a new section at WT:BRFA.