Wikipedia:Bots/Requests for approval/SQLBot 6


 * The following discussion is an archived debate. Please do not modify it. To request review of this BRFA, please start a new section at WT:BRFA. The result of the discussion was

SQLBot 6
Operator:

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):, ,

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:

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

Discussion

 * 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? &mdash; JamesR  ( talk ) 22:51, 25 March 2018 (UTC)
 * - 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)


 * — 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)

(Timed out @ 15 days long before hitting 200 edits), - diffs for every last edit can be found at User:SQLBot/Trial6, or query/25979. Bot is shut down until approved or further trial is requested. SQL Query me! 05:40, 15 April 2018 (UTC)
 * 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)
 * 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)


 * 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.