From cd868747703585661efac3b85a423b6dae9b71c2 Mon Sep 17 00:00:00 2001 From: Pjotr Prins Date: Sun, 19 Nov 2023 14:53:12 +0100 Subject: Iterate precompute datasets --- gn/data/hits.scm | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'gn/data') diff --git a/gn/data/hits.scm b/gn/data/hits.scm index 91be81f..a66eee5 100644 --- a/gn/data/hits.scm +++ b/gn/data/hits.scm @@ -9,7 +9,13 @@ #:use-module (dbi dbi) #:use-module (gn db mysql) #:use-module (gn data group) + #:use-module (gn util convert) #:use-module (web gn-uri) #:export ( + get-next-hit-for-precompute )) + +(define (get-next-hit-for-precompute db prev-id) + (dbi-query db (string-append "select Locus, DataId, ProbeSetId from ProbeSetXRef where DataId>" (int-to-string prev-id) " AND Locus_old is NULL ORDER BY DataId LIMIT 1")) + (get-row db)) -- cgit v1.2.3