def insertValueToNormId(schema, normdataid, sincerun, corrector, amodetag, egev, parameters, comment=''): ''' insert into LUMINORMSV2DATA(DATA_ID,SINCERUN,CORRECTOR,...) values(normdataid,)sincerun,corrector,...); require len(parameters)>=1. input: parameterDict {'NORM_OCC1':normocc1,'NORM_OCC2':normocc2,'NORM_ET':normet,'NORM_PU':normpu,'DRIFT':drift,'A1':a1,...} output: ''' if len(parameters) == 0: raise ValueError('appendValueToNormId: at least one value is required') try: db = dbUtil.dbUtil(schema) tabrowDefDict = {} tabrowDefDict['DATA_ID'] = 'unsigned long long' tabrowDefDict['CORRECTOR'] = 'string' tabrowDefDict['SINCE'] = 'unsigned int' tabrowDefDict['AMODETAG'] = 'string' tabrowDefDict['NOMINALEGEV'] = 'unsigned int' tabrowDefDict['COMMENT'] = 'string' tabrowValueDict = {} tabrowValueDict['DATA_ID'] = normdataid tabrowValueDict['CORRECTOR'] = corrector tabrowValueDict['SINCE'] = sincerun tabrowValueDict['AMODETAG'] = amodetag tabrowValueDict['NOMINALEGEV'] = egev tabrowValueDict['COMMENT'] = comment for paramname, paramvalue in parameters.items(): try: floatparam = float(paramvalue) tabrowDefDict[paramname.upper()] = 'float' tabrowValueDict[paramname.upper()] = float(paramvalue) except ValueError: tabrowDefDict[paramname.upper()] = 'string' tabrowValueDict[paramname.upper()] = paramvalue db.insertOneRow(nameDealer.luminormv2dataTableName(), tabrowDefDict, tabrowValueDict) except: raise
def normValueById(schema, normid): ''' select * from luminormsv2data where data_id=normid output: {since:[corrector(0),{paramname:paramvalue}(1),amodetag(2),egev(3),comment(4)]} ''' result = {} l = nameDealer.luminormv2dataTableName() paramdict = {} qHandle = schema.newQuery() try: qHandle.addToTableList(l) qConditionStr = 'DATA_ID=:normid' qCondition = coral.AttributeList() qCondition.extend('normid', 'unsigned long long') qCondition['normid'].setData(normid) qResult = coral.AttributeList() qHandle.setCondition(qConditionStr, qCondition) cursor = qHandle.execute() while cursor.next(): since = cursor.currentRow()['SINCE'].data() corrector = cursor.currentRow()['CORRECTOR'].data() amodetag = cursor.currentRow()['AMODETAG'].data() nominalegev = cursor.currentRow()['NOMINALEGEV'].data() comment = '' if not cursor.currentRow()['COMMENT'].isNull(): comment = cursor.currentRow()['COMMENT'].data() (correctorfunc, params) = CommonUtil.parselumicorrector(corrector) paramdict = {} for param in params: paramvalue = 0.0 if not cursor.currentRow()[param.upper()].isNull(): paramvalue = cursor.currentRow()[param.upper()].data() paramdict[param] = paramvalue result[since] = [ correctorfunc, paramdict, amodetag, nominalegev, comment ] except: raise return result
def normValueById(schema,normid): ''' select * from luminormsv2data where data_id=normid output: {since:[corrector(0),{paramname:paramvalue}(1),amodetag(2),egev(3),comment(4)]} ''' result={} l=nameDealer.luminormv2dataTableName() paramdict={} qHandle=schema.newQuery() try: qHandle.addToTableList(l) qConditionStr='DATA_ID=:normid' qCondition=coral.AttributeList() qCondition.extend('normid','unsigned long long') qCondition['normid'].setData(normid) qResult=coral.AttributeList() qHandle.setCondition(qConditionStr,qCondition) cursor=qHandle.execute() while cursor.next(): since=cursor.currentRow()['SINCE'].data() corrector=cursor.currentRow()['CORRECTOR'].data() amodetag=cursor.currentRow()['AMODETAG'].data() nominalegev=cursor.currentRow()['NOMINALEGEV'].data() comment='' if not cursor.currentRow()['COMMENT'].isNull(): comment=cursor.currentRow()['COMMENT'].data() (correctorfunc,params)=CommonUtil.parselumicorrector(corrector) paramdict={} for param in params: paramvalue=0.0 if not cursor.currentRow()[param.upper()].isNull(): paramvalue=cursor.currentRow()[param.upper()].data() paramdict[param]=paramvalue result[since]=[correctorfunc,paramdict,amodetag,nominalegev,comment] except: raise return result
def insertValueToNormId(schema,normdataid,sincerun,corrector,amodetag,egev,parameters,comment=''): ''' insert into LUMINORMSV2DATA(DATA_ID,SINCERUN,CORRECTOR,...) values(normdataid,)sincerun,corrector,...); require len(parameters)>=1. input: parameterDict {'NORM_OCC1':normocc1,'NORM_OCC2':normocc2,'NORM_ET':normet,'NORM_PU':normpu,'DRIFT':drift,'A1':a1,...} output: ''' if len(parameters)==0: raise ValueError('appendValueToNormId: at least one value is required') try: db=dbUtil.dbUtil(schema) tabrowDefDict={} tabrowDefDict['DATA_ID']='unsigned long long' tabrowDefDict['CORRECTOR']='string' tabrowDefDict['SINCE']='unsigned int' tabrowDefDict['AMODETAG']='string' tabrowDefDict['NOMINALEGEV']='unsigned int' tabrowDefDict['COMMENT']='string' tabrowValueDict={} tabrowValueDict['DATA_ID']=normdataid tabrowValueDict['CORRECTOR']=corrector tabrowValueDict['SINCE']=sincerun tabrowValueDict['AMODETAG']=amodetag tabrowValueDict['NOMINALEGEV']=egev tabrowValueDict['COMMENT']=comment for paramname,paramvalue in parameters.items(): try: floatparam=float(paramvalue) tabrowDefDict[paramname.upper()]='float' tabrowValueDict[paramname.upper()]=float(paramvalue) except ValueError: tabrowDefDict[paramname.upper()]='string' tabrowValueDict[paramname.upper()]=paramvalue db.insertOneRow(nameDealer.luminormv2dataTableName(),tabrowDefDict,tabrowValueDict) except: raise