diff options
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))))) |