def get_output_file_details(processrunid): return db.fetchall( """ select lower(p.perspectivename) + '_S' + convert(nvarchar,[or].outputid) + '_' + case when at.LECFlag = 1 then 'leccalc_' else '' end + at.AnalysisFileNameStub + '.csv' as [FileName], 'Output ' + SummaryLevelName + ' Level ' + PerspectiveName + ' ' + AnalysisTypeName AS [FileDesc], p.PerspectiveName AS [PerspectiveName], convert(nvarchar,[or].OutputID) AS [OutputID], convert(nvarchar,LECFlag) AS [LECFlag], at.AnalysisFileNameStub AS [AnalysisFileNameStub], SummaryLevelName AS [SummaryLevelName] from processrun as pr join elementrun as er on er.ProcessRunID = pr.ProcessRunID join OutputRun as [or] on er.ElementRunID = [or].ElementRunID join OutputType as ot on [or].OutputTypeID = ot.OutputTypeID join AnalysisType as at on ot.AnalysisTypeID = at.AnalysisTypeID join perspective as p on ot.PerspectiveID = p.PerspectiveID join summarylevel as sl on ot.SummaryLevelID = sl.SummaryLevelID where pr.ProcessRunID = ? """, processrunid)
def get_element_run_ids(processrunid): return db.fetchall( """ SELECT ElementRunID FROM ElementRun WHERE ProcessRunID = ? ORDER BY WorkflowElementID asc """, processrunid)
def get_profile_details(progid): return db.fetchall( "exec dbo.getProfileDetailsForIni ?", progid)
def get_il_summaries(processrunid): return db.fetchall( "exec dbo.getParametersJSONSummariesIL ?", processrunid)
def get_model_settings(processrunid): return db.fetchall( "exec dbo.getParametersJSONModel ?", processrunid)
def get_general_settings(processrunid): return db.fetchall( "exec dbo.getParametersJSONGeneral ?", processrunid)