From 671a85f798ace3b606bd0f83f90774c01e3f97de Mon Sep 17 00:00:00 2001 From: Christopher Baines Date: Sat, 1 Feb 2020 13:59:41 +0100 Subject: Add a function to check how many repositories have x_git_repo_header --- guix-data-service/model/git-repository.scm | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/guix-data-service/model/git-repository.scm b/guix-data-service/model/git-repository.scm index 5b6997c..6873ab6 100644 --- a/guix-data-service/model/git-repository.scm +++ b/guix-data-service/model/git-repository.scm @@ -22,6 +22,7 @@ #:export (all-git-repositories select-git-repository git-repository-id->url + count-git-repositories-with-x-git-repo-header-values git-repository-x-git-repo-header->git-repository-id git-repository-url->git-repository-id git-repositories-containing-commit @@ -60,6 +61,13 @@ (list id)) (((url)) url))) +(define (count-git-repositories-with-x-git-repo-header-values conn) + (match (exec-query + conn + "SELECT COUNT(*) FROM git_repositories WHERE x_git_repo_header IS NOT NULL") + (((count)) + (string->number count)))) + (define (git-repository-x-git-repo-header->git-repository-id conn header) (match (exec-query -- cgit v1.2.3