357:
457:
334:
48:
463:
Trial looks fine to me. I've only skimmed the code but that looks fine too. I'd note that it doesn't appear to be sanitising the user input, but SQL accounts are limited to select queries anyway. Probably best to keep pages of database reports managed by this bot under either bot userspace, subpages
508:
297:? Wikilinks! Page titles & usernames can be made clickable, unlike in Quarry results. For articles and draft pages, the bot can include excerpts; also not possible in Quarry.
290:. When that template is transcluded to a page (user/WP namespaces), SDZeroBot will run the provided SQL query and update the page (once immediately and then every 24h).
313:
438:), as it makes it easier to type. Hope this is alright. In theory, another bot could take over the task and reuse the same templates at some point. –
21:
377:
for the trial. The 1st and 3rd edits are updates done immediately on page creation while the other 3 are the scheduled daily updates. –
87:
473:
345:
304:
parameter, limited usage of concurrent db connections, and won’t save to mainspace if someone transcludes the template there).
82:
415:
287:
152:
338:
Approved for trial (5 edits). Please provide a link to the relevant contributions and/or diffs when the trial is complete.
490:
465:
40:
432:
140:
117:
469:
395:
341:
283:
102:
477:
449:
422:
409:
388:
349:
327:
300:
There are some sane checks to prevent abuse of resources (10 min enforced timeout implemented using MariaDB's
164:
221:
97:
92:
207:
77:
158:
146:
17:
445:
405:
384:
323:
279:
134:
58:
502:
250:
439:
399:
378:
317:
216:
129:
374:
229:
Allows users to create wikified database reports and keeps them updated.
483:
The above discussion is preserved as an archive of the debate.
489:
To request review of this BRFA, please start a new section at
294:
194:
39:
To request review of this BRFA, please start a new section at
371:
369:
367:
365:
363:
182:
176:
170:
112:
107:
72:
509:Approved Knowledge (XXG) bot requests for approval
233:Links to relevant discussions (where appropriate):
316:(though these are all rather simple examples). –
314:Category:SDZeroBot database report subscriptions
33:The following discussion is an archived debate.
8:
418:and its end template to template namespace (
373:-- picked up some random queries off
7:
244:Estimated number of pages affected:
28:
201:Automatic, Supervised, or Manual:
45:The result of the discussion was
491:Knowledge (XXG):Bots/Noticeboard
466:Knowledge (XXG):Database reports
455:
355:
332:
293:Why we want this in addition to
286:. Instructions for usage are at
46:
41:Knowledge (XXG):Bots/Noticeboard
416:User:SDZeroBot/Database report
288:User:SDZeroBot/Database report
1:
193:18:07, Monday, May 24, 2021 (
340:Trial for 5 report updates.
468:, or userspace in general.
525:
478:17:04, 16 June 2021 (UTC)
450:13:20, 16 June 2021 (UTC)
410:12:01, 16 June 2021 (UTC)
486:Please do not modify it.
389:13:33, 25 May 2021 (UTC)
350:18:53, 24 May 2021 (UTC)
328:18:10, 24 May 2021 (UTC)
36:Please do not modify it.
278:This is basically the
264:Already has a bot flag
212:TypeScript on Node.js
470:ProcrastinatingReader
396:ProcrastinatingReader
342:ProcrastinatingReader
22:Requests for approval
208:Programming language
18:Knowledge (XXG):Bots
433:database report end
251:Exclusion compliant
375:recent Quarry runs
312:Example uses: see
302:max_statement_time
227:Function overview:
284:database replicas
276:Function details:
516:
488:
459:
458:
442:
437:
431:
427:
421:
402:
398:any concerns? –
381:
359:
358:
336:
335:
320:
303:
187:
186:
50:
49:
38:
524:
523:
519:
518:
517:
515:
514:
513:
499:
498:
497:
484:
456:
440:
435:
429:
425:
423:database report
419:
400:
379:
361:Trial complete.
356:
333:
318:
310:
301:
238:Edit period(s):
132:
128:
123:
62:
47:
34:
26:
25:
24:
12:
11:
5:
522:
520:
512:
511:
501:
500:
496:
495:
480:
392:
391:
309:
306:
122:
121:
115:
110:
105:
100:
95:
90:
85:
80:
75:
73:Approved BRFAs
70:
63:
61:
56:
55:
54:
29:
27:
15:
14:
13:
10:
9:
6:
4:
3:
2:
521:
510:
507:
506:
504:
494:
492:
487:
481:
479:
475:
471:
467:
462:
454:
453:
452:
451:
447:
443:
434:
424:
417:
412:
411:
407:
403:
397:
390:
386:
382:
376:
372:
370:
368:
366:
364:
362:
354:
353:
352:
351:
347:
343:
339:
330:
329:
325:
321:
315:
307:
305:
298:
296:
291:
289:
285:
281:
277:
273:
271:
268:
265:
261:
259:
256:
253:
252:
247:
245:
241:
239:
235:
234:
230:
228:
224:
223:
220:
218:
213:
211:
209:
204:
202:
198:
196:
192:
188:
184:
181:
178:
175:
172:
169:
166:
163:
160:
157:
154:
151:
148:
145:
142:
139:
136:
131:
127:
119:
116:
114:
111:
109:
106:
104:
101:
99:
96:
94:
91:
89:
86:
84:
81:
79:
76:
74:
71:
69:
65:
64:
60:
57:
53:
44:
42:
37:
31:
30:
23:
19:
485:
482:
460:
414:Note: moved
413:
393:
360:
337:
331:
311:
299:
292:
275:
274:
269:
266:
263:
262:
257:
254:
249:
248:
243:
242:
237:
236:
232:
231:
226:
225:
215:
214:
206:
205:
200:
199:
190:
189:
179:
173:
167:
161:
155:
149:
143:
137:
125:
124:
67:
59:SDZeroBot 10
51:
35:
32:
280:ListeriaBot
217:Source code
191:Time filed:
308:Discussion
219:available:
203:automatic
183:ANI search
177:rights log
165:page moves
153:edit count
113:rights log
103:page moves
461:Approved.
171:block log
126:Operator:
108:block log
52:Approved.
503:Category
267:(Yes/No)
255:(Yes/No)
141:contribs
83:contribs
20: |
441:SD0001
428:&
401:SD0001
380:SD0001
319:SD0001
295:Quarry
240:Daily
222:github
130:SD0001
88:count
16:<
474:talk
446:talk
406:talk
385:talk
346:talk
324:talk
282:for
272:Yes
210:(s):
159:logs
135:talk
118:flag
98:logs
78:talk
68:BRFA
464:of
260:No
195:UTC
147:SUL
93:SUL
505::
476:)
448:)
436:}}
430:{{
426:}}
420:{{
408:)
387:)
348:)
326:)
246:-
197:)
493:.
472:(
444:(
404:(
394:@
383:(
344:(
322:(
270::
258::
185:)
180:·
174:·
168:·
162:·
156:·
150:·
144:·
138:·
133:(
120:)
66:(
43:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.