[0bdad5]: / inst / queries / sparseDataMatchFieldSlow.xq

Download this file

15 lines (13 with data), 502 Bytes

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
; sparseDataMatchFieldSlow
(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]
:where [:and
[:= :field_gene.field_id genes]
[:in :%lower.gene names]]}))))