def drop_dataPreProcessing_replicates(self, tables_I = [],): try: if not tables_I: tables_I = list(self.get_supportedTables().keys()); querydrop = sbaas_base_query_drop(session_I=self.session,engine_I=self.engine,settings_I=self.settings,data_I=self.data); for table in tables_I: model_I = self.convert_tableString2SqlalchemyModel(table); querydrop.drop_table_sqlalchemyModel(model_I); except Exception as e: print(e);
def drop_dataStage02_physiology_simulatedData(self, tables_I=[]): try: if not tables_I: tables_I = list(self.get_supportedTables().keys()) querydrop = sbaas_base_query_drop( session_I=self.session, engine_I=self.engine, settings_I=self.settings, data_I=self.data ) for table in tables_I: model_I = self.convert_tableString2SqlalchemyModel(table) querydrop.drop_table_sqlalchemyModel(model_I) except Exception as e: print(e)
def drop_data_stage01_rnasequencing_softwareParameters(self, tables_I = [],): try: if not tables_I: tables_I = list(self.get_supportedTables().keys()); querydrop = sbaas_base_query_drop(session_I=self.session,engine_I=self.engine,settings_I=self.settings,data_I=self.data); for table in tables_I: model_I = self.convert_tableString2SqlalchemyModel(table); querydrop.drop_table_sqlalchemyModel(model_I); except Exception as e: print(e); #def reset_data_stage01_rnasequencing_softwareParameters(self, # tables_I = [], # analysis_id_I = None, # warn_I=True): # try: # if not tables_I: # tables_I = list(self.get_supportedTables().keys()); # querydelete = sbaas_base_query_delete(session_I=self.session,engine_I=self.engine,settings_I=self.settings,data_I=self.data); # for table in tables_I: # query = {}; # query['delete_from'] = table; # query['where'] = [{ # 'table_name':table, # 'column_name':'analysis_id', # 'value':analysis_id_I, # #'value':self.convert_string2StringString(analysis_id_I), # 'operator':'LIKE', # 'connector':'AND' # } # ]; # table_model = self.convert_tableStringList2SqlalchemyModelDict([table]); # query = querydelete.make_queryFromString(table_model,query); # querydelete.reset_table_sqlalchemyModel(query_I=query,warn_I=warn_I); # except Exception as e: # print(e);