view cummeRbund_options.py @ 1:aefbcaf15a94 draft

planemo upload for repository https://github.com/galaxyproject/tools-devteam/tree/master/tools/cummerbund commit f3f0bef4a450aafab3c6b05a27647471f93b22f3
author devteam
date Thu, 23 Feb 2017 20:23:50 -0500
parents e462121e8269
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 ]