blob: 0d14776d8816c14562cf33d8893329aa8ecaec4e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
|
-- Deploy guix-build-coordinator:build_counts to sqlite
BEGIN;
CREATE TABLE builds_counts AS
SELECT derivations.system_id, COUNT(*) AS count
FROM builds
INNER JOIN derivations
ON builds.derivation_id = derivations.id
GROUP BY derivations.system_id;
COMMIT;
|