Page MenuHomeDevCentral

Update reports automatically on Agora
Open, WishlistPublic

Description

The reports repository contains two reports to publish and update Agora content:

Database serverReport for Agora pageCommitQuery file
AcquisitariatAI contentbb14cdd26c66tokens-language-models.sql
db-BOperations grimoire/Old content report3c94fd688d3eoperations-grimoire-older-pages.sql

It would make sense if this could be automated.

Plan is to:

  • tag the pages to help machine to identify automated report section
  • write helpers script to run the query and format the output as MediaWiki table
  • run an automated bot to run the report generator and update the relevant page

Event Timeline

dereckson triaged this task as Wishlist priority.Fri, Sep 12, 19:04
dereckson created this task.

Naming

On Agora, an account name is required for the automated agent / bot.
The agent will be called Rhyne-Wyse [1].

Credentials

Saved the following credentials into Vault:

ServicePurposeVault pathAccount status
AgoraEdit the wikiapps/rhyne-wyse/agora
db-BRun MariaDB queries against Agora databaseops/secrets/dbserver/cluster-B/users/rhyne-wyseD3667
acquisitariatRun MySQL queries against DevCentral databaseapps/rhyne-wyse/acquisitariatTo do, manually

Notes

[1] Generated with the help of https://donjon.bin.sh/scifi/name/ (cyberpunk, megacorp), like usual for the bots.

dereckson updated the task description. (Show Details)

Claiming temporarily for credentials and if time allows this evening write helpers script. Will release afterwards, so anyone can create the bot.