From 0721d15f275ce9abd55e60955265997f0e39db3d Mon Sep 17 00:00:00 2001 From: Pjotr Prins Date: Thu, 4 Jan 2024 12:51:45 +0100 Subject: Call precompute with population name - BXD only, for now --- gn/data/population.scm | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 gn/data/population.scm (limited to 'gn/data') diff --git a/gn/data/population.scm b/gn/data/population.scm new file mode 100644 index 0000000..46ef04c --- /dev/null +++ b/gn/data/population.scm @@ -0,0 +1,28 @@ +(define-module (gn data population) + #:use-module (json) + #:use-module (ice-9 match) + #:use-module (ice-9 format) + #:use-module (ice-9 iconv) + #:use-module (ice-9 receive) + #:use-module (ice-9 string-fun) + ;; #:use-module (gn db sparql) + #:use-module (dbi dbi) + #:use-module (gn data group) + #:use-module (gn db mysql) + #:use-module (gn util convert) + #:use-module (web gn-uri) + + #:export ( + population-info + )) + +(define* (population-info id) + " +Return population (InbredSet) info by GN ID +" + (call-with-db + (lambda (db) + (dbi-query db (string-append + "SELECT InbredSetId,InbredSetName,Name,SpeciesId,FullName WHERE" + (int-to-string id) " LIMIT 1")) + (get-row db)))) -- cgit v1.2.3