Mercurial > repos > brinkmanlab > microbedb

diff all_fasta.sql @ 6:b7884a377566 draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
"planemo upload for repository https://github.com/brinkmanlab/galaxy-tools/tree/master/microbedb commit 7ea4cbe9a0f7347379e245223cc2c40021c586f9"
author brinkmanlab
date Mon, 09 Nov 2020 18:37:30 +0000
parents 40d14d5c8125
children
line wrap: on
line diff
--- a/all_fasta.sql	Mon Nov 09 01:09:50 2020 +0000
+++ b/all_fasta.sql	Mon Nov 09 18:37:30 2020 +0000
@@ -1,4 +1,4 @@
-SELECT json_group_array(json_object('value', unique_build_id, 'dbkey', dbkey, 'name', label, 'path', file_path))
+SELECT json_object('data_tables', json_object('all_fasta', json_group_array(json_object('value', unique_build_id, 'dbkey', dbkey, 'name', label, 'path', file_path))))
 FROM (
  SELECT (r.rep_accnum || '.' || r.rep_version)                                           AS unique_build_id,
         (r.rep_accnum || '_' || r.rep_version)                                           AS dbkey,