def UpdateExtensionInfo(mssqlDict): mssqlHandle = MssqlAPI(server = mssqlDict['SERVER'], db = mssqlDict['DB'], user = mssqlDict['USER'], pwd = mssqlDict['PWD']) logFile = LogFile(name = 'Indirection') try: mssqlHandle.sqlExecuteProc('usp_UpdateFrom251', ()) mssqlHandle.sqlCommit() logFile.logInfo('Execute SQL Proc "usp_UpdateFrom251" succeed.') except: logFile.logInfo('Execute SQL Proc "usp_UpdateFrom251" failed.') print traceback.format_exc()
class ExtensionInfo(object): ''' Security extension info ''' def __init__(self, server, db, user, pwd): ''' Constructor ''' self.mssqlHandle = MssqlAPI(server, db, user, pwd) def __del__(self): self.mssqlHandle.sqlCommit() del self.mssqlHandle def SetExtensionInfo(self, msg): columnStr = '' valueStr = '' for key in msg['EXT']: columnStr += key + ',' if (key in ('MA5', 'MA10', 'MA13', 'MA14', 'MA20', 'MA25', 'MA43', 'VOL5', 'VOL10', 'VOL30', 'VOL60', 'VOL135')): valueStr += 'convert(numeric(18,4),' + str(msg['EXT'][key]) + '),' elif (key in ('RSV9', 'K9', 'D3', 'J3', 'RSV34', 'K34', 'D9', 'J9', 'EMA5', 'EMA6', 'EMA12', 'EMA13', 'EMA26', 'EMA35', \ 'DIF1', 'DEA1', 'MACD1', 'DIF2', 'DEA2', 'MACD2', 'DIF3', 'DEA3', 'MACD3')): valueStr += 'convert(numeric(9,4),' + str(msg['EXT'][key]) + '),' else: valueStr += "'" + str(msg['EXT'][key]) + "'," columnStr = columnStr[0:-1] valueStr = valueStr[0:-1] sqlCmd = ''' INSERT INTO ''' + dbDict[msg['DB']]['TABLE']['EXT'] + ''' (''' + columnStr + ''') VALUES ('''+ valueStr +'''); ''' self.mssqlHandle.sqlAppend(sqlCmd)