aboutsummaryrefslogtreecommitdiff
path: root/gn/data/hits.scm
diff options
context:
space:
mode:
authorPjotr Prins2023-11-19 14:53:12 +0100
committerPjotr Prins2023-11-19 14:53:12 +0100
commitcd868747703585661efac3b85a423b6dae9b71c2 (patch)
tree1eb7eb14514d7a127a16aa7fcf4bd0a26a4f9292 /gn/data/hits.scm
parentb1db013cc01c94e27edf982be9b027a2b0bb9712 (diff)
downloadgn-guile-cd868747703585661efac3b85a423b6dae9b71c2.tar.gz
Iterate precompute datasets
Diffstat (limited to 'gn/data/hits.scm')
-rw-r--r--gn/data/hits.scm6
1 files changed, 6 insertions, 0 deletions
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))