I wanted to create a dashboard in grafana about copr builds and needed to feed the build data into a postgres database. From there I can consume it in Grafana using a Postgres Data Source.
In order to have a simple conversion at hand I've written the script
copr-json-to-sql.sh which prints SQL-
INSERT-statements for the build information in a denomalized form.
The schema for the
copr_build_logs table can be found in
For example, you can call the script to get information about the builds of the
@kdesig/python-qt6 project which is featured here.