def test_085_reset_data_for_later_test_runs(self): """Reseting data to enable later test runs to to be valid""" # logged in as admin_user # Clean up admin_user # Unshare history3 - shared with regular_user1, regular_user2, regular_user3 self.unshare_history(self.security.encode_id(history3.id), self.security.encode_id(regular_user1.id)) self.unshare_history(self.security.encode_id(history3.id), self.security.encode_id(regular_user2.id)) self.unshare_history(self.security.encode_id(history3.id), self.security.encode_id(regular_user3.id)) # Unshare history4 - shared with regular_user2, regular_user3 self.unshare_history(self.security.encode_id(history4.id), self.security.encode_id(regular_user2.id)) self.unshare_history(self.security.encode_id(history4.id), self.security.encode_id(regular_user3.id)) # Unshare history5 - shared with regular_user1 self.unshare_history(self.security.encode_id(history5.id), self.security.encode_id(regular_user1.id)) # Delete histories self.delete_history(id=self.security.encode_id(history3.id)) self.delete_history(id=self.security.encode_id(history3_clone2.id)) self.delete_history(id=self.security.encode_id(history3_clone3.id)) self.delete_history(id=self.security.encode_id(history4.id)) self.delete_history(id=self.security.encode_id(history5.id)) # Eliminate Sharing role for: [email protected], [email protected] self.mark_role_deleted(self.security.encode_id(sharing_role.id), sharing_role.name) self.purge_role(self.security.encode_id(sharing_role.id), sharing_role.name) # Manually delete the sharing role from the database sa_session.refresh(sharing_role) sa_session.delete(sharing_role) sa_session.flush() # Clean up regular_user_1 self.logout() self.login(email=regular_user1.email) self.delete_history(id=self.security.encode_id(history3_clone1.id)) self.delete_history(id=self.security.encode_id(history5_clone1.id))
def delete_request_type_permissions( id ): rtps = sa_session.query( galaxy.model.RequestTypePermissions ) \ .filter( and_( galaxy.model.RequestTypePermissions.table.c.request_type_id==id ) ) \ .order_by( desc( galaxy.model.RequestTypePermissions.table.c.create_time ) ) for rtp in rtps: sa_session.delete( rtp ) sa_session.flush()
def delete_request_type_permissions(id): rtps = sa_session.query( galaxy.model.RequestTypePermissions ) \ .filter( and_( galaxy.model.RequestTypePermissions.table.c.request_type_id==id ) ) \ .order_by( desc( galaxy.model.RequestTypePermissions.table.c.create_time ) ) for rtp in rtps: sa_session.delete(rtp) sa_session.flush()
def test_00_metadata_edit(self): """test_metadata_edit: Testing metadata editing""" self.logout() self.login(email='*****@*****.**', username='******') admin_user = sa_session.query( galaxy.model.User ) \ .filter( galaxy.model.User.table.c.email=='*****@*****.**' ) \ .one() self.new_history(name='Test Metadata Edit') history1 = sa_session.query( galaxy.model.History ) \ .filter( and_( galaxy.model.History.table.c.deleted==False, galaxy.model.History.table.c.user_id==admin_user.id ) ) \ .order_by( desc( galaxy.model.History.table.c.create_time ) ) \ .first() self.upload_file('1.bed') latest_hda = sa_session.query( galaxy.model.HistoryDatasetAssociation ) \ .order_by( desc( galaxy.model.HistoryDatasetAssociation.table.c.create_time ) ) \ .first() self.home() # Due to twill not being able to handle the permissions forms, we'll eliminate # DefaultHistoryPermissions prior to uploading a dataset so that the permission # form will not be displayed on ted edit attributes page. for dp in latest_hda.dataset.actions: sa_session.delete(dp) sa_session.flush() sa_session.refresh(latest_hda.dataset) self.check_history_for_string('1.bed') self.check_metadata_for_string( '1.bed uploaded file unspecified (\?) chromCol value="1" selected endCol value="3" is_strandCol value="true" checked', hid=str(latest_hda.hid)) """test editing attributes""" self.edit_hda_attribute_info(hda_id=str(latest_hda.id), new_name='Testdata', new_info="Uploaded my file", new_dbkey='hg16', new_startcol='6') self.check_metadata_for_string( 'Testdata bed Uploaded my file hg16 "bed" selected="yes" "startCol" value="6" selected', hid=str(latest_hda.hid)) """test Auto-detecting attributes""" self.auto_detect_metadata(hda_id=str(latest_hda.id)) self.check_metadata_for_string( 'Testdata bed Uploaded my file hg16 "bed" selected="yes" "startCol" value="2" selected', hid=str(latest_hda.hid)) """test converting formats""" self.convert_format(hda_id=str(latest_hda.id), target_type='gff') self.check_metadata_for_string('"gff" selected="yes"', hid=str(latest_hda.hid)) """test changing data type""" self.change_datatype(hda_id=str(latest_hda.id), datatype='gff3') self.check_metadata_for_string('gff3', hid=str(latest_hda.hid)) self.delete_history(id=self.security.encode_id(history1.id)) self.logout()
def test_00_metadata_edit( self ): """test_metadata_edit: Testing metadata editing""" self.logout() self.login( email='*****@*****.**' ) admin_user = sa_session.query( galaxy.model.User ) \ .filter( galaxy.model.User.table.c.email=='*****@*****.**' ) \ .one() self.new_history( name='Test Metadata Edit' ) history1 = sa_session.query( galaxy.model.History ) \ .filter( and_( galaxy.model.History.table.c.deleted==False, galaxy.model.History.table.c.user_id==admin_user.id ) ) \ .order_by( desc( galaxy.model.History.table.c.create_time ) ) \ .first() self.upload_file( '1.bed' ) latest_hda = sa_session.query( galaxy.model.HistoryDatasetAssociation ) \ .order_by( desc( galaxy.model.HistoryDatasetAssociation.table.c.create_time ) ) \ .first() self.home() # Due to twill not being able to handle the permissions forms, we'll eliminate # DefaultHistoryPermissions prior to uploading a dataset so that the permission # form will not be displayed on ted edit attributes page. for dp in latest_hda.dataset.actions: sa_session.delete( dp ) sa_session.flush() sa_session.refresh( latest_hda.dataset ) self.check_history_for_string( '1.bed' ) self.check_metadata_for_string( '1.bed uploaded file unspecified (\?) chromCol value="1" selected endCol value="3" is_strandCol value="true" checked', hid=str( latest_hda.hid ) ) """test editing attributes""" self.edit_hda_attribute_info( hda_id=str( latest_hda.id ), new_name='Testdata', new_info="Uploaded my file", new_dbkey='hg16', new_startcol='6' ) self.check_metadata_for_string( 'Testdata bed Uploaded my file hg16 "bed" selected="yes" "startCol" value="6" selected', hid=str( latest_hda.hid ) ) """test Auto-detecting attributes""" self.auto_detect_metadata( hda_id=str( latest_hda.id ) ) self.check_metadata_for_string('Testdata bed Uploaded my file hg16 "bed" selected="yes" "startCol" value="2" selected', hid=str( latest_hda.hid ) ) """test converting formats""" self.convert_format( hda_id=str( latest_hda.id ), target_type='gff' ) self.check_metadata_for_string( '"gff" selected="yes"', hid=str( latest_hda.hid ) ) """test changing data type""" self.change_datatype( hda_id=str( latest_hda.id ), datatype='gff3' ) self.check_metadata_for_string( 'gff3', hid=str( latest_hda.hid ) ) self.delete_history( id=self.security.encode_id( history1.id ) ) self.logout()
def delete_obj(obj): sa_session.delete(obj) sa_session.flush()
def delete_user_roles(user): for ura in user.roles: sa_session.delete(ura) sa_session.flush()
def delete_obj( obj ): sa_session.delete( obj ) sa_session.flush()
def delete_user_roles( user ): for ura in user.roles: sa_session.delete( ura ) sa_session.flush()
def test_get_DNAseHSS_flanked_genes( self ): self.logout() self.login( email='*****@*****.**' ) admin_user = sa_session.query( galaxy.model.User ) \ .filter( galaxy.model.User.table.c.email=='*****@*****.**' ) \ .one() self.new_history( name='DNAseHSS_flanked_genes' ) history1 = sa_session.query( galaxy.model.History ) \ .filter( and_( galaxy.model.History.table.c.deleted==False, galaxy.model.History.table.c.user_id==admin_user.id ) ) \ .order_by( desc( galaxy.model.History.table.c.create_time ) ) \ .first() track_params = dict( db="hg17", hgta_group="regulation", hgta_table="dukeDnaseCd4Sites", hgta_track="dukeDnaseCd4Sites", hgta_regionType="range", position="chr22", hgta_outputType="bed", sendToGalaxy="1" ) output_params = dict( fbQual="whole", ) # Test 1 self.run_ucsc_main( track_params, output_params ) self.wait() self.verify_dataset_correctness('DNAseHSS.dat') latest_hda = sa_session.query( galaxy.model.HistoryDatasetAssociation ) \ .order_by( desc( galaxy.model.HistoryDatasetAssociation.table.c.create_time ) ) \ .first() # Due to twill not being able to handle the permissions forms, we'll eliminate # DefaultHistoryPermissions prior to uploading a dataset so that the permission # form will not be displayed on ted edit attributes page. for dp in latest_hda.dataset.actions: sa_session.delete( dp ) sa_session.flush() sa_session.refresh( latest_hda.dataset ) self.edit_hda_attribute_info( str( latest_hda.id ), new_name="DNAse HS" ) self.check_metadata_for_string( "DNAse HS" ) track_params = dict( db="hg17", hgta_group="genes", hgta_table="knownGene", hgta_track="knownGene", hgta_regionType="range", position="chr22", hgta_outputType="bed", sendToGalaxy="1" ) output_params = dict( fbQual="whole", ) # Test 2 self.run_ucsc_main( track_params, output_params ) self.wait() self.verify_dataset_correctness('hg17chr22KnownGenes.dat') latest_hda = sa_session.query( galaxy.model.HistoryDatasetAssociation ) \ .order_by( desc( galaxy.model.HistoryDatasetAssociation.table.c.create_time ) ) \ .first() for dp in latest_hda.dataset.actions: sa_session.delete( dp ) sa_session.flush() sa_session.refresh( latest_hda.dataset ) self.edit_hda_attribute_info( str( latest_hda.id ), new_name="Genes" ) self.check_metadata_for_string( "Genes" ) # Test 3 self.run_tool( 'get_flanks1', input="2", region="whole", direction="Upstream", offset="0", size="500" ) self.wait() self.verify_dataset_correctness( 'knownGeneUpstream500Flanks.dat' ) latest_hda = sa_session.query( galaxy.model.HistoryDatasetAssociation ) \ .order_by( desc( galaxy.model.HistoryDatasetAssociation.table.c.create_time ) ) \ .first() for dp in latest_hda.dataset.actions: sa_session.delete( dp ) sa_session.flush() sa_session.refresh( latest_hda.dataset ) self.edit_hda_attribute_info( str( latest_hda.id ), new_name="Flanks" ) self.check_metadata_for_string( "Flanks" ) # Test 4 self.run_tool( 'gops_join_1', input1="3", input2="1", min="1", fill="none" ) self.wait() # We cannot verify this dataset, because this tool spits out data in a non-deterministic order #self.verify_dataset_correctness( 'joinFlanksDNAse.dat' ) # Test 5 self.run_tool( 'Filter1', input="4", cond="c17==1000" ) self.wait() self.verify_dataset_correctness( 'filteredJoinedFlanksDNAse.dat' ) self.delete_history( self.security.encode_id( history1.id ) ) self.logout()