[ea2224]: / inst / queries / sparseDataMatchField.xq

Download this file

13 lines (12 with data), 520 Bytes

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
; sparseDataMatchField
(fn [field dataset names]
(let [getfield (fn [field]
(:id (car (query {:select [:field.id]
:from [:dataset]
:join [:field [:= :dataset.id :field.dataset_id]]
:where [:and [:= :field.name field] [:= :dataset.name dataset]]}))))
genes (getfield field)]
(map :gene (query {:select [:%distinct.gene]
:from [:field_gene]
:join [{:table [[[:name :varchar names]] :T]} [:= :T.name :gene]]
:where [:= :field_gene.field_id genes]}))))