diff options
Diffstat (limited to 'sqitch/sqlite/deploy/build_results_counts.sql')
-rw-r--r-- | sqitch/sqlite/deploy/build_results_counts.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/sqitch/sqlite/deploy/build_results_counts.sql b/sqitch/sqlite/deploy/build_results_counts.sql new file mode 100644 index 0000000..14e7f9e --- /dev/null +++ b/sqitch/sqlite/deploy/build_results_counts.sql @@ -0,0 +1,10 @@ +-- Deploy guix-build-coordinator:build_results_counts to sqlite + +BEGIN; + +CREATE TABLE build_results_counts AS +SELECT agent_id, result, COUNT(*) AS count +FROM build_results +GROUP BY agent_id, result; + +COMMIT; |