blob: 14e7f9e318eba3b8027b47e2919d6120b95cbdff (
plain)
1
2
3
4
5
6
7
8
9
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;
|