def AddNewdRec(dbConn, iBelongEnviruID, iTaskTypeID, ustrContent, ustrParam, ustrWhoRequestName, iTaskRunAlways, createTime=None, requestExecTime=None, iRequestExecStatus=0): ustrContent = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrContent) ustrParam = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrParam) ustrWhoRequestName = CTYLB_MainSys_MiscFunc.SafeGetUnicode( ustrWhoRequestName) iRetNewRecID = CSkLBDB_CommFuncShare.ExecInsertRecField7( dbConn, CSkLBDB_ea_brain_exec_task.s_strTableName, 'belong_envirument_id', str(iBelongEnviruID), "task_type_id", str(iTaskTypeID), 'content', ustrContent, 'param', ustrParam, 'request_exec_status', str(iRequestExecStatus), 'who_request_name', ustrWhoRequestName, 'task_run_always', str(iTaskRunAlways)) if (iRetNewRecID): if (not createTime): createTime = datetime.now() CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_ea_brain_exec_task.s_strTableName, "create_time", createTime, "id", str(iRetNewRecID)) return iRetNewRecID
def SubHandle_OPMonitor_Post_DisplayContent(ustrDisplayContent, ustrMonitorID, ustrDataType): ustrDisplayContent = CTYLB_MainSys_MiscFunc.SafeGetUnicode( ustrDisplayContent) ustrMonitorID = CTYLB_MainSys_MiscFunc.SafeGetUnicode( ustrMonitorID) #{ "RunTypeID" : 902,"TaskRecID" : 24 } ustrDataType = CTYLB_MainSys_MiscFunc.SafeGetUnicode( ustrDataType) #"ShowNetworkAssets" replyJson = json.loads(ustrMonitorID) iRunType = replyJson["RunTypeID"] iTaskRecID = replyJson["TaskRecID"] targetData = json.loads(ustrDisplayContent) res = '' if iRunType == g_i_ExecTypeID_Monitor_ShowNetworkSituation: #请求API提交数据 res = MonitorApiHandler.AddNetworkSituation( target=targetData['target'], target_type=targetData['type']) elif iRunType == g_i_ExecTypeID_Monitor_ShowNetworkAssets: #请求API提交数据 res = MonitorApiHandler.AddNetworkAssets( target=targetData['target'], target_type=targetData['type']) retCommCTUnit = CTYBot_CTUnit_CommonData() retCommCTUnit.SetIntData(g_i_OpMonitor_SubCmd_Reply_Post_DisplayContent) retCommCTUnit.SetStrData(res) #strOrigParamRunParam retCommCTUnit.SetParam(str(iRunType), str(iTaskRecID)) #strRunType strTaskRecID return retCommCTUnit
def __init__(self, ustrCfgFileName, ustrDbFileName): ustrCfgFileName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrCfgFileName) ustrDbFileName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrDbFileName) # 设置运行任务提交 self.s_RunnDTaskArray = [] # 正在运行的任务队列 # 创建机器人框架 self.s_LessTYLB_Bot_FrameThread = CLessTYBotFrameThread(ustrCfgFileName, ustrDbFileName) # 设置默认环境处理 # self.s_LessTYLB_Bot_FrameThread.SetDefaultConsoleCompatible( CtrlCHandle) # 准备运行 self.s_LessTYLB_Bot_FrameThread.Prepare_Start() self.s_strSelfID = self.s_LessTYLB_Bot_FrameThread.GetMyName() # 注册 单元到达的通知,HLSession的新数据单元创建 self.s_LessTYLB_Bot_FrameThread.RegisterNewCTUnit( CTYLB_Bot_BaseDef.s_g_iDataType_TaskRegCenter_sk_v1, CTYLB_Bot_BaseDef.s_g_iMainCmd_TaskRegCenter_ReportResult_V2, CTYLB_Bot_BaseDef.s_g_iSubCmd_TaskRegCenter_ReportResult_V2_PingTraceWebCrawl, CTYBot_CTUnit_TaskRegCenter_CreateNewUnit_V2_ReportResult) self.s_LessTYLB_Bot_FrameThread.RegisterNewCTUnit( CTYLB_Bot_BaseDef.s_g_iDataType_TaskRegCenter_sk_v1, CTYLB_Bot_BaseDef.s_g_iMainCmd_TaskRegCenter_ReportResult, CTYLB_Bot_BaseDef.s_g_iSubCmd_TaskRegCenter_ReportResult_PingTraceWebCrawl, CTYBot_CTUnit_TaskRegCenter_CreateNewUnit_ReportResult) # 获得管套管理对象 self.s_hlSockMang = self.s_LessTYLB_Bot_FrameThread.s_HLSockMang # 读取配置参数 ustrTaskRegCenterID = self.s_LessTYLB_Bot_FrameThread.s_execTYLB_Bot_Sample.ReadIniSectionValue( ustrCfgFileName, u'client', u'taskcenter_id', CTYLB_Bot_BaseDef.s_g_strBotName_TaskRegCenter_sk_v1) self.s_bstrTaskRegCenterID = CTYLB_MainSys_MiscFunc.SafeGetUTF8(ustrTaskRegCenterID) # 创建连接管套 self.s_x_TaskRegCenter_Sock = CTYFBot_OpSession_ConnectSock(self.s_hlSockMang, self.s_bstrTaskRegCenterID, self.s_g_iTaskMang_Listen_Port_PromptTask) pass
def AddNewdRec(dbConn, iExecTaskID, ustrReplyContent, ustrReplyParam, ustrWhoExec, execStartTime=None, execFinishTime=None, iExecStatus=0): ustrReplyContent = CTYLB_MainSys_MiscFunc.SafeGetUnicode( ustrReplyContent) ustrReplyParam = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrReplyParam) ustrWhoExec = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrWhoExec) iRetNewRecID = CSkLBDB_CommFuncShare.ExecInsertRecField5( dbConn, CSkLBDB_ea_brain_exec_result.s_strTableName, 'exec_task_id', str(iExecTaskID), "reply_content", ustrReplyContent, 'reply_param', ustrReplyParam, 'exec_status', str(iExecStatus), 'who_exec_name', ustrWhoExec) if (iRetNewRecID): if (not execStartTime): createTime = datetime.now() CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_ea_brain_exec_result.s_strTableName, "exec_start_time", execStartTime, "id", str(iRetNewRecID)) return iRetNewRecID
def AddNewdRec(dbConn, iBelongDestOPID, strSignIDFieldValue, strParamBlockID, iStatus, operateTime, createTime=None): strSignIDFieldValue = CTYLB_MainSys_MiscFunc.SafeGetUnicode( strSignIDFieldValue) strParamBlockID = CTYLB_MainSys_MiscFunc.SafeGetUnicode( strParamBlockID) iRetNewRecID = CSkLBDB_CommFuncShare.ExecInsertRecField4( dbConn, CSkLBDB_dest_param_status.s_strTableName, "belong_dest_operate_id", str(iBelongDestOPID), "sign_id_field_value", strSignIDFieldValue, "param_block_id", strParamBlockID, "status", str(iStatus)) if ((iRetNewRecID > 0) and (operateTime)): CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_dest_param_status.s_strTableName, "operate_time", operateTime, "id", str(iRetNewRecID)) if (not createTime): createTime = datetime.now() if ((iRetNewRecID > 0) and (createTime)): CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_dest_param_status.s_strTableName, "create_time", createTime, "id", str(iRetNewRecID)) return iRetNewRecID
def SubHandle_OPActionBrain_ReplyExecResult(strPeerName, strTaskValue, strTaskTypeIDRecID, strTaskResultParam): strPeerName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strPeerName) strTaskValue = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strTaskValue) strTaskTypeIDRecID = CTYLB_MainSys_MiscFunc.SafeGetUnicode( strTaskTypeIDRecID) strTaskResultParam = CTYLB_MainSys_MiscFunc.SafeGetUnicode( strTaskResultParam) # 提取参数结果内容 paramCollect = json.loads(strTaskValue) iExecResultCode = paramCollect[g_str_Alarm_Reply_V_ResultCode] strRunResult = paramCollect[g_str_Alarm_Reply_V_RunResult] strNeedUpdateRunParam = paramCollect[ g_str_Alarm_Reply_V_NeedUpdateRunParam] strNeedSendUserContent = paramCollect[g_str_Alarm_Reply_V_SendUserContent] paramCollect = json.loads(strTaskTypeIDRecID) iRunTaskTypeID = paramCollect[g_str_Alarm_Reply_P1_RunTypeID] iTaskRecID = paramCollect[g_str_Alarm_Reply_P1_TaskRecID] iExecBelongEnviruID, iExecTaskTypeID, strExecContent, strExecParam, strExecWhoRequestName, execCreateTime, \ execRequestExecTime, iExecRequestExecStatus, iExecTaskRunAlways, execLastCheckTime, strExecTaskRunParam = \ CSkLBDB_ea_brain_exec_task.ReadByRecID(g_mainOperate_RealActionDB.s_DbConn, iTaskRecID) iDestSetStatus = CTYOp_ReActBrain_Store.s_g_iStatus_Finish if (iExecResultCode == g_i_Code_Finish_Stop_Task): # 0 –完成,可以停止本次任务; pass elif (iExecResultCode == g_i_Code_Finish_Need_Run_Update_RunParam): # 1-本次完成,下次还要继续运行,需要更新运行时参数 iDestSetStatus = CTYOp_ReActBrain_Store.s_g_iStatus_Free CSkLBDB_ea_brain_exec_task.Update_RunParam( g_mainOperate_RealActionDB.s_DbConn, iTaskRecID, strNeedUpdateRunParam) pass elif (iExecResultCode == g_i_Code_Finish_Need_Run): # 2-本次完成,还要继续运行,不修改参数内容 iDestSetStatus = CTYOp_ReActBrain_Store.s_g_iStatus_Free pass # 发送内容用户,提交到微信输出表 if (strNeedSendUserContent): CTYReActBrainBot_Track_Checker.AddReplyTextInfoToUser( g_mainOperate_RealActionDB.s_DbConn, iExecBelongEnviruID, strNeedSendUserContent) # 更新任务状态 CSkLBDB_ea_brain_exec_task.Update_ExStatus( g_mainOperate_RealActionDB.s_DbConn, iTaskRecID, iDestSetStatus) CSkLBDB_ea_brain_exec_task.Update_LastCheckTime( g_mainOperate_RealActionDB.s_DbConn, iTaskRecID) # 构建返回数据包 sendCTUnit = CTYBot_CTUnit_CommonData() sendCTUnit.SetIntData(g_i_OpAction_SubCmd_Reply_ReplyExecResult) retCTUnitArray = [sendCTUnit] return retCTUnitArray
def ExecUpdateRecField1(dbConn, strTable, strClause, strField1, strValue1): strTable = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strTable) strClause = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strClause) strField1 = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strField1) strValue1 = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strValue1) strSetField = strField1 + "='" + strValue1 + "'" strModifySQL = "update " + strTable + " set " + strSetField + " where " + strClause CSkLBDB_CommFuncShare.__ExecUpdateSQL(dbConn, strModifySQL)
def ReConnect(self, strHost, iPort, strUserName, strPasswd, strDatabase): strHost = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strHost) strUserName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strUserName) strPasswd = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strPasswd) strDatabase = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strDatabase) self.CloseConnection() self.s_DbConn = CSkLBDB_MainConn.__ExecPyMysqlConnect( strHost, iPort, strUserName, strPasswd, strDatabase)
def ExecInsertRecField4(dbConn, strTable, strField1, strValue1, strField2, strValue2, strField3, strValue3, strField4, strValue4): strTable = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strTable) strField1 = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strField1) strValue1 = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strValue1) strField2 = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strField2) strValue2 = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strValue2) strField3 = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strField3) strValue3 = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strValue3) strField4 = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strField4) strValue4 = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strValue4) strTotalFields = "%s,%s,%s,%s" % (strField1, strField2, strField3, strField4) strInsertSQL = "insert into " + strTable + " (" + strTotalFields + ") values(%s,%s,%s,%s)" insertCur = dbConn.cursor() try: insertCur.execute(strInsertSQL, (strValue1, strValue2, strValue3, strValue4)) iRetRecID = insertCur.lastrowid dbConn.commit() except Exception as e: iRetRecID = 0 insertCur.close() return iRetRecID
def AddNewdRec(dbConn, strAppName, strSubTaskName): strAppName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strAppName) strSubTaskName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strSubTaskName) iRetNewRecID = CSkLBDB_result_app_task_name.GetRecID_By_App_SubTask_Name( dbConn, strAppName, strSubTaskName) if (iRetNewRecID == 0): iRetNewRecID = CSkLBDB_CommFuncShare.ExecInsertRecField2( dbConn, CSkLBDB_result_app_task_name.s_strTableName, "app_name", strAppName, "sub_task_name", strSubTaskName) return iRetNewRecID
def ExecDeleteFrom(dbConn, strTable, strField, strValue): strTable = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strTable) strField = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strField) strValue = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strValue) strClause = strField + "='" + strValue + "'" strModifySQL = "delete from " + strTable + " where " + strClause deleteCur = dbConn.cursor() deleteCur.execute(strModifySQL) deleteCur.close() dbConn.commit() # 确认更新记录
def GetRecID_By_App_SubTask_Name(dbConn, strAppName, strSubTaskName): strAppName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strAppName) strSubTaskName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strSubTaskName) strClause = "app_name='%s' and sub_task_name='%s'" % (strAppName, strSubTaskName) iRetID = CSkLBDB_CommFuncShare.ReadField_Single_WithClause( dbConn, CSkLBDB_result_app_task_name.s_strTableName, "id", strClause) if (not iRetID): iRetID = 0 return iRetID
def ReadField_Single_WithClause(dbConn, strTable, strField, strClause): strTable = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strTable) strField = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strField) strClause = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strClause) objRetFieldValue = None strQueryReply = "select " + strField + " from " + strTable + " where " + strClause recFrameReply = pd.read_sql_query(strQueryReply, dbConn) # 转成DataFrame recCount = len(recFrameReply) # 记录个数 if (recCount > 0): objRetFieldValue = recFrameReply[strField][0] return objRetFieldValue
def GetRecCount(dbConn, strTable, strClause=''): strTable = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strTable) strClause = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strClause) iRetCount = 0 # 初始化 strQuery = "select count(*) from " + strTable if (strClause and (len(strClause) > 0)): strQuery = strQuery + " where " + strClause recFrame = pd.read_sql_query(strQuery, dbConn) # 转成DataFrame recCount = len(recFrame) # 记录个数 if (recCount > 0): iRetCount = recFrame["count(*)"][0] return iRetCount
def UpdateRecordContent(dbConn, iRecID, ustrURL, ustrImage, execDateTime): ustrURL = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrURL) ustrImage = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrImage) strClause = 'id=%d' % (iRecID) CSkLBDB_CommFuncShare.ExecUpdateRecField2( dbConn, CSkLBDB_ow_bot_out_logincode.s_strTableName, strClause, 'url', ustrURL, 'qrcodecontent', ustrImage) if (execDateTime): CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_ow_bot_out_logincode.s_strTableName, 'create_time', execDateTime, 'id', str(iRecID)) pass
def ExecInsertRecField1(dbConn, strTable, strField, strValue): strTable = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strTable) strField = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strField) strValue = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strValue) strInsertSQL = "insert into " + strTable + " (" + strField + ") values(%s)" # insert into table (field) values(%s) insertCur = dbConn.cursor() try: insertCur.execute(strInsertSQL, (strValue)) iRetRecID = insertCur.lastrowid dbConn.commit() except Exception as e: iRetRecID = 0 insertCur.close() return iRetRecID
def AddNewdRec(dbConn, iBelongEnviruID, ustrPropName, ustrPropValue): ustrPropName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrPropName) ustrPropValue = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrPropValue) iRetNewRecID = CSkLBDB_ea_brain_enviru_property.GetRecID_By_EnviruID_PropName( dbConn, iBelongEnviruID, ustrPropName) if (not iRetNewRecID): iRetNewRecID = CSkLBDB_CommFuncShare.ExecInsertRecField3( dbConn, CSkLBDB_ea_brain_enviru_property.s_strTableName, 'belong_envirument_id', str(iBelongEnviruID), "prop_name", ustrPropName, 'prop_value', ustrPropValue) else: CSkLBDB_ea_brain_enviru_property.Update_PropValue( dbConn, iRetNewRecID, ustrPropValue) return iRetNewRecID
def ExecUpdateRecField_To_DateTime(dbConn, strTable, strTimeField, dateTimeValue, strClauseField, strClauseValue): strTable = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strTable) strTimeField = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strTimeField) strClauseField = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strClauseField) strClauseValue = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strClauseValue) strClause = strClauseField + "='" + strClauseValue + "'" strModifyRecSameID = "update " + strTable + " set " + strTimeField + "=CAST('" + dateTimeValue.strftime("%Y-%m-%d %H:%M:%S") \ + "' as datetime) where " + strClause updateCur = dbConn.cursor() updateCur.execute(strModifyRecSameID) updateCur.close() dbConn.commit() #确认更新记录
def __connect_to_basic_handle(self, sock_id, sock_port, eachCTUnit, is_last_package): if (eachCTUnit.s_iMyDataType == CTYLB_Bot_BaseDef.s_g_iDataType_CommonTask): if eachCTUnit.s_iValue in self.__connect_to_callbacks[sock_id][ sock_port]['recv'].keys(): eachRetCommCTUnitArray = self.__connect_to_callbacks[sock_id][ sock_port]['recv'][eachCTUnit.s_iValue]( CTYLB_MainSys_MiscFunc.SafeGetUnicode( eachCTUnit.s_strValue), CTYLB_MainSys_MiscFunc.SafeGetUnicode( eachCTUnit.s_strParam1), CTYLB_MainSys_MiscFunc.SafeGetUnicode( eachCTUnit.s_strParam2), is_last_package) return eachRetCommCTUnitArray
def GetMinValue(dbConn, strTable, strField): strTable = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strTable) strField = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strField) iRetValue = 0 # 初始化 strMaxQueryField = "min(" + strField + ")" strQuery = "select " + strMaxQueryField + " from " + strTable recFrame = pd.read_sql_query(strQuery, dbConn) # 转成DataFrame recCount = len(recFrame) # 记录个数 if (recCount > 0): iRetValue = recFrame[strMaxQueryField][0] if (not iRetValue): iRetValue = 0 else: iRetValue = 0 return iRetValue
def GetRecList_By_GroupName(dbConn, ustrGroupName): ustrGroupName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrGroupName) strClause = "belong_group_name='%s'" % (ustrGroupName) iRetRecIDArray = CSkLBDB_CommFuncShare.ReadField_Array_WithClause( dbConn, CSkLBDB_ea_brain_envirument.s_strTableName, "id", strClause) return iRetRecIDArray
def Update_RequestName(dbConn, iRecID, ustrRequestorName): ustrRequestorName = CTYLB_MainSys_MiscFunc.SafeGetUnicode( ustrRequestorName) strClause = "id=%d" % (iRecID) CSkLBDB_CommFuncShare.ExecUpdateRecField1( dbConn, CSkLBDB_ea_brain_exec_task.s_strTableName, strClause, "who_request_name", ustrRequestorName)
def Update_RecID_ShowContentStatus(dbConn, iRecID, ustrShowContent, iContentType, iExecStatus=0, createTime=None, showTime=None): ustrShowContent = CTYLB_MainSys_MiscFunc.SafeGetUnicode( ustrShowContent) strClause = "id=%d" % (iRecID) CSkLBDB_CommFuncShare.ExecUpdateRecField3( dbConn, CSkLBDB_funcbot_op_display.s_strTableName, strClause, "last_content", ustrShowContent, 'content_type', str(iContentType), 'exec_status', str(iExecStatus)) if (not createTime): createTime = datetime.now() if (not showTime): showTime = datetime.now() CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_funcbot_op_display.s_strTableName, "create_time", createTime, "id", str(iRecID)) CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_funcbot_op_display.s_strTableName, "show_time", showTime, "id", str(iRecID))
def GetRecID_By_UserName(dbConn, ustrUserName): ustrUserName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrUserName) strClause = "username='******'" % (ustrUserName) iRetID = CSkLBDB_CommFuncShare.ReadField_Single_WithClause( dbConn, CSkLBDB_ea_brain_usermang.s_strTableName, "id", strClause) if (not iRetID): iRetID = 0 return iRetID
def GetRecID_By_MonitorID(dbConn, ustrMonitorID): ustrMonitorID = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrMonitorID) strClause = "monitor_id='%s'" % (ustrMonitorID) iRetID = CSkLBDB_CommFuncShare.ReadField_Single_WithClause( dbConn, CSkLBDB_funcbot_op_display.s_strTableName, "id", strClause) if (not iRetID): iRetID = 0 return iRetID
def AddNewdRec( dbConn, ustrMonitorID, ustrLastContent, iContentType, iExecStatus=0, showTime=None): ustrMonitorID = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrMonitorID) ustrLastContent = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrLastContent) iRetNewRecID = CSkLBDB_CommFuncShare.ExecInsertRecField4(dbConn, CSkLBDB_funcbot_op_display.s_strTableName, u"monitor_id", ustrMonitorID, u"last_content", ustrLastContent, u"exec_status", str(iExecStatus), u'content_type', str(iContentType)) if( iRetNewRecID > 0): createTime = datetime.now() CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_funcbot_op_display.s_strTableName, u"create_time", createTime, u"id", str(iRetNewRecID)) if( showTime): CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime(dbConn, CSkLBDB_funcbot_op_display.s_strTableName, u"show_time", showTime, u"id", str(iRetNewRecID)) return iRetNewRecID
def GetRecID_By_Name(dbConn, strObjName): strObjName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strObjName) strClause = "obj_name='%s'" % (strObjName) iRetID = CSkLBDB_CommFuncShare.ReadField_Single_WithClause( dbConn, CSkLBDB_dest_operate.s_strTableName, "id", strClause) if (not iRetID): iRetID = 0 return iRetID
def GetRecID_by_UID(dbConn, strTable, iUID): strTable = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strTable) strClause = "unique_id=%d" % (iUID) iRetID = CSkLBDB_CommFuncShare.ReadField_Single_WithClause( dbConn, strTable, "id", strClause) if (not iRetID): iRetID = 0 return iRetID
def __listen_basic_handle(self, sockManager, clientSock, ctUnitArray): strPeerName, iPeerPort = sockManager.GetSockPeerAddr(clientSock) if isinstance(strPeerName, bytes): strPeerName = strPeerName.decode() retDataArray = [] isNonePackageReply = True arrayLen = len(ctUnitArray) packageCount = 0 for eachCTUnit in ctUnitArray: packageCount += 1 eachRetCommCTUnitArray = [] if (eachCTUnit.s_iMyDataType == CTYLB_Bot_BaseDef.s_g_iDataType_CommonTask): if eachCTUnit.s_iValue in self.__listen_callbacks.keys(): eachRetCommCTUnitArray = self.__listen_callbacks[ eachCTUnit.s_iValue]( CTYLB_MainSys_MiscFunc.SafeGetUnicode(strPeerName), CTYLB_MainSys_MiscFunc.SafeGetUnicode( eachCTUnit.s_strValue), CTYLB_MainSys_MiscFunc.SafeGetUnicode( eachCTUnit.s_strParam1), CTYLB_MainSys_MiscFunc.SafeGetUnicode( eachCTUnit.s_strParam2), packageCount == arrayLen) if (eachRetCommCTUnitArray): isNonePackageReply = False retDataArray.extend(eachRetCommCTUnitArray) # 如果没有内容,那么,放一个空单元 if isNonePackageReply: sendCTUnit = CTYBot_CTUnit_CommonData() retDataArray.append(sendCTUnit) sockManager.PassiveSend_To_AcceptSock(clientSock, retDataArray) if self.__report_status: if strPeerName in self.__node_status.SocksInfo['Socks'].keys(): self.__node_status.SocksInfo['Socks'][strPeerName][ 'Status'] = "Up" self.__node_status.SocksInfo['Socks'][strPeerName][ 'TotalSend'] += len(ctUnitArray) self.__node_status.SocksInfo['Socks'][strPeerName][ 'LastSendTime'] = NodeStatus.get_now_timestamp() self.__node_status.SocksInfo['TotalSend'] += len(ctUnitArray)
def __ExecUpdateSQL(dbConn, strUpdateSQL): strUpdateSQL = CTYLB_MainSys_MiscFunc.SafeGetUnicode(strUpdateSQL) updateCur = dbConn.cursor() try: updateCur.execute(strUpdateSQL) except Exception as e: pass updateCur.close() dbConn.commit() # 确认更新记录