@transform( loadTranscripts, regex(r"(\S+).load"), "gene_name.update.log" )
def updateGeneName( infile, outfile ):
    '''update gene name from ensembl database'''
    dbhandle = sqlite3.connect( PARAMS["database"] )
    cc = dbhandle.cursor()
    query = PARAMS["ensembl_db"] % """ATTACH "%s" as ensembl;"""
    cc.execute( query )
    query = """UPDATE transcript_info SET gene_name=
               (SELECT gene_name from ensembl.transcript_info 
               WHERE transcript_info.gene_id=ensembl.transcript_info.gene_id);"""
    print query
    cc.execute( query )
    cc.close()
    statement = """touch %(outfile)s;"""
    P.run()
                
############################################################
############################################################
############################################################
dataset/ETHPy150Open CGATOxford/cgat/obsolete/pipeline_rnaseq_brawand.py/updateGeneName/swapped operands of `%`