def writeTransformToDB(db, frameId, pfiTransform, cameraName):
"""
write transformation coefficients to database
"""
trans=pfiTransform.mcsDistort.getArgs()
res = db.session.execute('select * FROM "mcs_pfi_transformation" where false')
colnames = tuple(res.keys())
realcolnames = colnames[0:]
line = '%d,%f,%f,%f,%e,%e,%f,%s' % (frameId, trans[0].astype('float64'),
trans[1], trans[3], trans[4],trans[2],
pfiTransform.alphaRot, 'canon50M')
buf = io.StringIO()
buf.write(line)
buf.seek(0, 0)
_writeData('mcs_pfi_transformation', realcolnames, buf)
data = {'mcs_frame_id': [frameId],
'x0': [trans[0]],
'y0': [trans[1]],
'dscale': [trans[2]],
'scale2': [trans[3]],
'theta': [trans[4]],
'alpha_rot': [pfiTransform.alphaRot],
'camera_name': [cameraName]}
df = pd.DataFrame(data=data)
return df['mcs_frame_id'].values,df['x0'].values,df['y0'].values,df['dscale'].values, \
df['scale2'].values,df['theta'].values,df['alpha_rot'].values,df['camera_name'].values