def reset_dataPreProcessing_replicates(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_name':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);
def reset_dataStage01_mutations(self, tables_I = [], experiment_id_I = None, warn_I=True): try: 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_name':table}]; query['where'] = [{ 'table_name':table, 'column_name':'experiment_id', 'value':experiment_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);
def reset_dataStage02_physiology_pairWiseTest(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_name": table}] query["where"] = [ { "table_name": table, "column_name": "analysis_id", "value": 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)