Mercurial > repos > brinkmanlab > microbedb

comparison builds.sql @ 2:258826db8291 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 668759e2fc5d53432092d7c1395b402385733171"
author brinkmanlab
date Fri, 06 Nov 2020 21:26:52 +0000
parents 40d14d5c8125
children
comparison
equal deleted inserted replaced
1:5e94458c2dde 2:258826db8291
1 DROP TABLE IF EXISTS builds_temp; 1 DROP TABLE IF EXISTS builds_temp;
2 CREATE TEMP TABLE builds_temp(dbkey unique, label); 2 CREATE TEMP TABLE builds_temp(dbkey unique, label);
3 .mode csv 3 .mode csv
4 .separator ' ' 4 .separator ' '
5 .import $__app__.config.builds_file_path builds_temp 5 .import '$__app__.config.builds_file_path' builds_temp
6 INSERT OR REPLACE INTO builds_temp (dbkey, label) 6 INSERT OR REPLACE INTO builds_temp (dbkey, label)
7 SELECT (r.rep_accnum || '_' || r.rep_version) AS dbkey, 7 SELECT (r.rep_accnum || '_' || r.rep_version) AS dbkey,
8 (REPLACE(r.definition, ', complete genome.', '') || ' [' || r.rep_accnum || '.' || r.rep_version || 8 (REPLACE(r.definition, ', complete genome.', '') || ' [' || r.rep_accnum || '.' || r.rep_version ||
9 ']') AS label 9 ']') AS label
10 FROM genomeproject 10 FROM genomeproject
13 AND genomeproject.file_types IS NOT NULL 13 AND genomeproject.file_types IS NOT NULL
14 AND genomeproject.file_types LIKE '%.fna%' 14 AND genomeproject.file_types LIKE '%.fna%'
15 AND r.rep_type = 'chromosome'; 15 AND r.rep_type = 'chromosome';
16 .mode list 16 .mode list
17 .separator ' ' 17 .separator ' '
18 .once $__app__.config.builds_file_path 18 .once '$__app__.config.builds_file_path'
19 SELECT dbkey, label FROM builds_temp ORDER BY dbkey; 19 SELECT dbkey, label FROM builds_temp ORDER BY dbkey;