view cummeRbund_options.py @ 0:e462121e8269 draft

planemo upload for repository https://github.com/galaxyproject/tools-devteam/tree/master/tools/cummerbund commit 5a4e0ca9992af3a6e5ed2b533f04bb82ce761e0b
author devteam
date Mon, 09 Nov 2015 11:27:38 -0500
parents
children 4bbfacecedd3
line wrap: on
line source

import sqlite3

def get_genes( database_path ):
    conn = sqlite3.connect( database_path )
    gene_ids = conn.execute( 'SELECT gene_short_name, gene_id FROM genes ORDER BY gene_short_name' )
    return [ ( gene_id[ 0 ], gene_id[ 1 ], False ) for gene_id in gene_ids ]

def get_samples( database_path ):
    conn = sqlite3.connect( database_path )
    samples = conn.execute( 'SELECT sample_name FROM samples ORDER BY sample_name' )
    return [ ( sample[ 0 ], sample[ 0 ], False ) for sample in samples ]