Mercurial > repos > devteam > cummerbund

comparison cummeRbund_options.py @ 6:c3b54a4b7741 draft default tip

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
"planemo upload for repository https://github.com/galaxyproject/tools-devteam/tree/master/tools/cummerbund commit f929353ffb0623f2218d7dec459c7da62f3b0d24"
author devteam
date Mon, 06 Jul 2020 20:25:47 -0400
parents ac2ebc60ef5d
children
comparison
equal deleted inserted replaced
5:78fcfc04fcfe 6:c3b54a4b7741
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]