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);
