REDAME
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 copr_build_logs.sql
.
For example, you can call the script to get information about the builds of the @kdesig/python-qt6
project which is featured here.