diff options
author | Christopher Baines <mail@cbaines.net> | 2020-06-19 20:57:16 +0100 |
---|---|---|
committer | Christopher Baines <mail@cbaines.net> | 2020-06-19 20:57:16 +0100 |
commit | 5a402642db769aaed61accba54c21708cbfd4978 (patch) | |
tree | 39af45294449a6cbf04ffd4b93888dad5143318f /guix-build-coordinator/datastore/sqlite.scm | |
parent | 9eaa55c0d00982dc28ec079d15132c5da57af318 (diff) | |
download | build-coordinator-5a402642db769aaed61accba54c21708cbfd4978.tar build-coordinator-5a402642db769aaed61accba54c21708cbfd4978.tar.gz |
Report builds by derivation system
Diffstat (limited to 'guix-build-coordinator/datastore/sqlite.scm')
-rw-r--r-- | guix-build-coordinator/datastore/sqlite.scm | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/guix-build-coordinator/datastore/sqlite.scm b/guix-build-coordinator/datastore/sqlite.scm index 0497bab..aa65411 100644 --- a/guix-build-coordinator/datastore/sqlite.scm +++ b/guix-build-coordinator/datastore/sqlite.scm @@ -734,11 +734,17 @@ WHERE setup_failure_id = :id"))) (sqlite-prepare db " -SELECT COUNT(*) FROM builds"))) +SELECT derivations.system, COUNT(*) +FROM builds +INNER JOIN derivations + ON builds.derivation_name = derivations.name"))) (let ((result - (match (sqlite-step statement) - (#(count) count)))) + (sqlite-map + (match-lambda + (#(system count) + (cons system count))) + statement))) (sqlite-reset statement) result))))) |