Mercurial > repos > devteam > cummerbund
comparison cummeRbund_options.py @ 2:4bbfacecedd3 draft default tip
"planemo upload for repository https://github.com/galaxyproject/tools-devteam/tree/master/tools/cummerbund commit f929353ffb0623f2218d7dec459c7da62f3b0d24"
author | devteam |
---|---|
date | Mon, 06 Jul 2020 18:11:20 +0000 |
parents | e462121e8269 |
children |
comparison
equal
deleted
inserted
replaced
1:aefbcaf15a94 | 2:4bbfacecedd3 |
---|---|
1 import sqlite3 | 1 import sqlite3 |
2 | 2 |
3 def get_genes( database_path ): | |
4 conn = sqlite3.connect( database_path ) | |
5 gene_ids = conn.execute( 'SELECT gene_short_name, gene_id FROM genes ORDER BY gene_short_name' ) | |
6 return [ ( gene_id[ 0 ], gene_id[ 1 ], False ) for gene_id in gene_ids ] | |
7 | 3 |
8 def get_samples( database_path ): | 4 def get_genes(database_path): |
9 conn = sqlite3.connect( database_path ) | 5 conn = sqlite3.connect(database_path) |
10 samples = conn.execute( 'SELECT sample_name FROM samples ORDER BY sample_name' ) | 6 gene_ids = conn.execute('SELECT gene_short_name, gene_id FROM genes ORDER BY gene_short_name') |
11 return [ ( sample[ 0 ], sample[ 0 ], False ) for sample in samples ] | 7 return [(gene_id[0], gene_id[1], False) for gene_id in gene_ids] |
8 | |
9 | |
10 def get_samples(database_path): | |
11 conn = sqlite3.connect(database_path) | |
12 samples = conn.execute('SELECT sample_name FROM samples ORDER BY sample_name') | |
13 return [(sample[0], sample[0], False) for sample in samples] |