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)
