view 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
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]