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
