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

SQLBot 6

• (BRFA
• Approved BRFAs
• talk
• contribs
• count
• SUL
• logs
• page moves
• block log
• rights log
• flag)

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

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): [1], [2], [3]

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: [4]

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

Discussion

@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)

@JamesR and 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)

Approved for trial (200 edits or 15 days). Please provide a link to the relevant contributions and/or diffs when the trial is complete. — 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)

Trial complete. (Timed out @ 15 days long before hitting 200 edits), @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)

@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)

@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)

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