def CallUpdateFracHitMultipliers():
"""Interface Package Description"""
interface = {
"LEName": str,
"CorpID": str,
"Date_Key": str,
"Multiplier": float,
"UpdateUser": str
}
pkg, success, msg = InitializePayload(request, interface)
if success:
LEName = pkg['LEName']
CorpID = pkg['CorpID']
Date_Key = pkg['Date_Key']
Multiplier = pkg['Multiplier']
UpdateUser = pkg['UpdateUser']
FracHitRow = m.FracHitMultipliersRow(LEName, CorpID, Date_Key,
Multiplier, '')
success, msg = FracHitRow.Update(UpdateUser, datetime.now())
output = ConfigureOutput('', success, msg)
return output
def WriteDefaultMultipliers(LE_Name, DefaultValue, Update_User, Update_Date,
SuppressMessages):
import datetime as datetime
from Model import BPXDatabase as bpx
from Model import ModelLayer as m
Success = True
Messages = []
try:
config = m.GetConfig()
DBObj = bpx.BPXDatabase(config['server'], config['database'],
config['UID'])
#Query the LE results
LE_query = 'select * from [LEForecastDatabase].[dbo].[LE_Data] where HeaderName = \'' + LE_Name + '\''
res, df = DBObj.Query(LE_query)
count = 1
for idx, row in df.iterrows():
FracHitObj = m.FracHitMultipliersRow(row['HeaderName'],
row['CorpID'],
row['Date_Key'],
str(DefaultValue), DBObj)
Success, Message = FracHitObj.Write(Update_User, Update_Date)
if not Success:
Messages.append(Message)
if not SuppressMessages:
callprogressbar(count, df.shape[0])
count = count + 1
except Exception as ex:
Success = False
Messages.append(
'Error during write of default frac hit multipliers. ' + str(ex))
return Success, Messages
def CallUpdateFracMultiplier():
"""Interface Package Description"""
interface = {
"WellorArea": str,
"CorpID": str,
"LEName": str,
"Multipliers": list,
"Dates": list,
"UserName": str
}
pkg, success, msg = InitializePayload(request, interface)
msgs = []
if success:
LEName = pkg['LEName']
WellName = pkg['WellorArea']
CorpID = pkg['CorpID']
Dates = pkg['Dates']
Multipliers = pkg['Multipliers']
UserName = pkg['UserName']
#Check CorpID if Wellname is passed and vice versa
WellName, CorpID = iu.GetWellandCorpID(WellName, CorpID)
idx = 0
for date in Dates:
row = m.FracHitMultipliersRow(LEName, CorpID, date,
Multipliers[idx], '')
success, msg = row.Update(UserName, datetime.now())
if not success:
msgs.append(msg)
else:
msgs.append(CorpID + ' : ' + date +
' successfully updated frac hit multiplier.')
idx = idx + 1
output = ConfigureOutput('', success, msgs)
return output
