#NEWLINE# def setUp( self ) : #NEWLINE# #INDENT# TestBase . setUp ( self ) #NEWLINE# logger . debug ( 'accessing ensembldb.ensembl.org' ) #NEWLINE# conn = sqlgraph . DBServerInfo ( host = 'ensembldb.ensembl.org' , user = 'anonymous' , passwd = '' ) #NEWLINE# try : #NEWLINE# #INDENT# translationDB = sqlgraph . SQLTable ( 'homo_sapiens_core_47_36i.translation' , serverInfo = conn ) #NEWLINE# exonDB = sqlgraph . SQLTable ( 'homo_sapiens_core_47_36i.exon' , serverInfo = conn ) #NEWLINE# sql_statement = 'SELECT t3.exon_id FROM\nhomo_sapiens_core_47_36i.translation AS tr,\nhomo_sapiens_core_47_36i.exon_transcript AS t1,\nhomo_sapiens_core_47_36i.exon_transcript AS t2,\nhomo_sapiens_core_47_36i.exon_transcript AS t3 WHERE tr.translation_id = %s\nAND tr.transcript_id = t1.transcript_id AND t1.transcript_id =\nt2.transcript_id AND t2.transcript_id = t3.transcript_id AND t1.exon_id =\ntr.start_exon_id AND t2.exon_id = tr.end_exon_id AND t3.rank >= t1.rank AND\nt3.rank <= t2.rank ORDER BY t3.rank\n' #NEWLINE# translationExons = sqlgraph . GraphView ( translationDB , exonDB , sql_statement , serverInfo = conn ) #NEWLINE# #UNINDENT# except ImportError : #NEWLINE# #INDENT# raise SkipTest ( 'missing MySQLdb module?' ) #NEWLINE# #UNINDENT# translationExons . __doc__ = 'test saving exon graph' #NEWLINE# self . pygrData . Bio . Ensembl . TranslationExons = translationExons #NEWLINE# self . metabase . commit ( ) #NEWLINE# self . metabase . clear_cache ( )