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)
