def get_rows_dataStage02PhysiologySimulatedData(self, tables_I, query_I, output_O, dictColumn_I=None):
"""get rows by analysis ID from data_stage02_physiology_simulatedData"""
data_O = []
try:
table_model = self.convert_tableStringList2SqlalchemyModelDict(tables_I)
queryselect = sbaas_base_query_select(
session_I=self.session, engine_I=self.engine, settings_I=self.settings, data_I=self.data
)
query = queryselect.make_queryFromString(table_model, query_I)
data_O = queryselect.get_rows_sqlalchemyModel(query_I=query, output_O=output_O, dictColumn_I=dictColumn_I)
except Exception as e:
print(e)
return data_O
def get_rows_dataPreProcessingReplicates(self,
tables_I,
query_I,
output_O,
dictColumn_I=None):
"""get rows by analysis ID from data_preProcessing_replicates"""
data_O = [];
try:
table_model = self.convert_tableStringList2SqlalchemyModelDict(tables_I);
queryselect = sbaas_base_query_select(session_I=self.session,engine_I=self.engine,settings_I=self.settings,data_I=self.data);
query = queryselect.make_queryFromString(table_model,query_I);
data_O = queryselect.get_rows_sqlalchemyModel(
query_I=query,
output_O=output_O,
dictColumn_I=dictColumn_I);
except Exception as e:
print(e);
return data_O;
