def generate_location_record(
oasis_files_directory, progoasis_directory, filename):
location_id = db.fetch_one(
"exec dbo.generateLocationRecord ?, ?, ?",
oasis_files_directory, progoasis_directory, filename)
return location_id
def get_prog_oasis_details(progoasisid):
(progid, modelid, fileid) = db.fetch_one("exec dbo.getProgOasisDetails ?",
progoasisid)
logging.getLogger().debug("Prog ID={}; Model ID = {}; File ID = {}".format(
progid, modelid, fileid))
if progid is None or modelid is None or fileid is None:
raise Exception("Failed to get ProgOasis details")
return (progid, modelid, fileid)
def get_filename(file_id):
(filelocation, filename) = db.fetch_one(
"""
SELECT
L.LocationPathUnix AS LocationName,
F.FileName
FROM
[dbo].[File] as F,
Location as L
WHERE
L.LocationID = F.LocationID
AND
F.FileId = ?
""", file_id)
return filelocation + "/" + filename
def get_prog_oasis_location(processrunid):
return db.fetch_one(
"exec dbo.getLocationNameForProcessRunId ?", processrunid)[0]
def load_programme_model_details(progoasisid):
status = db.fetch_one(
"exec dbo.LoadProgrammeModelData ?", progoasisid)
return status
def get_model_file_extension(progoasisid):
extension = db.fetch_one(
"exec dbo.getModelFileExtension ?", progoasisid)
return extension
def get_transform_file_names_progoasis(progoasisid):
return db.fetch_one(
"exec dbo.getTransformInputFilesForProgOasis ?", progoasisid)
def get_base_url(runid):
base_url = db.fetch_one("exec dbo.getOasisURL ?", runid)[0]
logging.getLogger().debug("Base URL = {}".format(base_url))
return base_url
def generate_oasis_files(progoasisid):
status = db.fetch_one(
"exec dbo.generateOasisFiles2 ?", progoasisid)[0]
return status
def get_api_uri_and_systemname(modelid):
(targetURI, systemname) = db.fetch_one(
"exec dbo.getAPIURL ?", modelid)
if targetURI is None or systemname is None:
raise Exception("Failed to get API URL")
return (targetURI, systemname)
def get_process_run_locationid(
prog_oasis_location, process_dir, processrunid):
return db.fetch_one(
"exec dbo.generateLocationRecord ?, ?, ?",
prog_oasis_location, process_dir, "ProcessRun_{}".format(processrunid))[0]
def get_ProgId_For_ProgOasis(progoasisid):
return db.fetch_one("exec dbo.getProgIdForProgOasis ?", progoasisid)
def get_source_reinsurance_scope_file_for_prog(progid):
return db.fetch_one("exec dbo.getSourceFileReinsuranceScopeForProg ?",
progid)
def get_source_acc_file_for_prog(progid):
return db.fetch_one("exec dbo.getSourceFileAccForProg ?", progid)
