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