def AddNewdRec(dbConn, ustrContent, ustrTypeS, ustrToS, ustrToType, ustrToGroupName, ustrStatusS, execSendTime=None): ustrContent = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrContent) ustrTypeS = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrTypeS) ustrToS = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrToS) ustrToType = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrToType) ustrToGroupName = CTYLB_MainSys_MiscFunc.SafeGetUnicode( ustrToGroupName) ustrStatusS = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrStatusS) iRetNewRecID = CSkLBDB_CommFuncShare.ExecInsertRecField6( dbConn, CSkLBDB_ow_bot_in_sendchatcontent.s_strTableName, "content", ustrContent, "type_s", ustrTypeS, "to_s", ustrToS, "to_type", ustrToType, "to_group_name", ustrToGroupName, "status_s", ustrStatusS) if (iRetNewRecID > 0): createTime = datetime.now() CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_ow_bot_in_sendchatcontent.s_strTableName, "createtime", createTime, "id", str(iRetNewRecID)) if (execSendTime): CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_ow_bot_in_sendchatcontent.s_strTableName, "exec_send_time", execSendTime, "id", str(iRetNewRecID)) return iRetNewRecID
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 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 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 Update_ExTime_Status(dbConn, iRecID, execTime, iNewStatus): CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_ea_brain_chatcontent.s_strTableName, "exec_time", execTime, "id", str(iRecID)) strClause = "id=%d" % (iRecID) CSkLBDB_CommFuncShare.ExecUpdateRecField1( dbConn, CSkLBDB_ea_brain_chatcontent.s_strTableName, strClause, "exec_status", str(iNewStatus))
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 Update_RequestExecTime(dbConn, iRecID, requestExecTime): strClause = "id=%d" % (iRecID) if (not requestExecTime): requestExecTime = datetime.now() CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_ea_brain_exec_task.s_strTableName, "request_exec_time", requestExecTime, "id", str(iRecID))
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 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 GetRecList_By_TaskTypeID_ExecStatus(dbConn, iTaskTypeID, iExecStatus): strClause = "task_type_id=%d and request_exec_status=%d" % ( iTaskTypeID, iExecStatus) iRetRecIDArray = CSkLBDB_CommFuncShare.ReadField_Array_WithClause_limit( dbConn, CSkLBDB_ea_brain_exec_task.s_strTableName, "id", strClause, 1) return iRetRecIDArray
def Update_LastCheckTime(dbConn, iRecID, lastCheckTime=None): strClause = "id=%d" % (iRecID) if (not lastCheckTime): lastCheckTime = datetime.now() CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_ea_brain_exec_task.s_strTableName, "last_check_time", lastCheckTime, "id", str(iRecID))
def Read_RequestExecTime_By_RecID(dbConn, iRecID): strClause = "id=%d" % (iRecID) retRequestExecTime = CSkLBDB_CommFuncShare.ReadField_Single_WithClause( dbConn, CSkLBDB_ea_brain_exec_task.s_strTableName, 'request_exec_time', strClause) return retRequestExecTime
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 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_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 GetRecList_By_BelongEnvID_Direction_ExecStatus(dbConn, iBelongEnvID, iDirection, iExecStatius): strClause = "belong_envirument_id=%d and chat_direction=%d and exec_status=%d" % ( iBelongEnvID, iDirection, iExecStatius) iRetRecIDArray = CSkLBDB_CommFuncShare.ReadField_Array_WithClause( dbConn, CSkLBDB_ea_brain_chatcontent.s_strTableName, "id", strClause) return iRetRecIDArray
def AddNewdRec(dbConn, ustrContent, iTypeS, ustrFromS, iFromType, ustrFromGroupName, iExecStatus): ustrContent = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrContent) ustrFromS = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrFromS) ustrFromGroupName = CTYLB_MainSys_MiscFunc.SafeGetUnicode( ustrFromGroupName) iRetNewRecID = CSkLBDB_CommFuncShare.ExecInsertRecField6( dbConn, CSkLBDB_ow_bot_out_chatcontent.s_strTableName, "content", ustrContent, "type_s", str(iTypeS), "from_s", ustrFromS, "fromtype", str(iFromType), "from_group_name", ustrFromGroupName, "ex_status", str(iExecStatus)) if (iRetNewRecID > 0): createTime = datetime.now() CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_ow_bot_out_chatcontent.s_strTableName, "createtime", createTime, "id", str(iRetNewRecID)) return iRetNewRecID
def GetRecID_By_EnviruID_PropName(dbConn, iBelongEnviruID, ustrPropName): ustrPropName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrPropName) strClause = "belong_envirument_id=%d and prop_name='%s'" % ( iBelongEnviruID, ustrPropName) iRetID = CSkLBDB_CommFuncShare.ReadField_Single_WithClause( dbConn, CSkLBDB_ea_brain_enviru_property.s_strTableName, "id", strClause) if (not iRetID): iRetID = 0 return iRetID
def SearchNextRec_By_Direction_ExecStatus(dbConn, iDirection, iExecStatus): strClause = "chat_direction=%d and exec_status=%d" % (iDirection, iExecStatus) iRetRecIDArray = CSkLBDB_CommFuncShare.ReadField_Array_WithClause_limit( dbConn, CSkLBDB_ea_brain_chatcontent.s_strTableName, "id", strClause, 1) iRetExecRecID = 0 if (iRetRecIDArray): iRetExecRecID = iRetRecIDArray[0] return iRetExecRecID
def AddNewdRec(dbConn, ustrUserName): ustrUserName = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrUserName) iOrigRecID = CSkLBDB_ea_brain_usermang.GetRecID_By_UserName( dbConn, ustrUserName) if (not iOrigRecID): iRetNewRecID = CSkLBDB_CommFuncShare.ExecInsertRecField1( dbConn, CSkLBDB_ea_brain_usermang.s_strTableName, "username", ustrUserName) else: iRetNewRecID = iOrigRecID return iRetNewRecID
def GetRecID_By_UserID_GroupName(dbConn, iUserNameID, ustrBelongGroupName): ustrBelongGroupName = CTYLB_MainSys_MiscFunc.SafeGetUnicode( ustrBelongGroupName) strClause = "belong_usermang_id=%d and belong_group_name='%s'" % ( iUserNameID, ustrBelongGroupName) iRetID = CSkLBDB_CommFuncShare.ReadField_Single_WithClause( dbConn, CSkLBDB_ea_brain_envirument.s_strTableName, "id", strClause) if (not iRetID): iRetID = 0 return iRetID
def AddNewdRec(dbConn, iUserNameID, ustrBelongGroupName): ustrBelongGroupName = CTYLB_MainSys_MiscFunc.SafeGetUnicode( ustrBelongGroupName) iOrigRecID = CSkLBDB_ea_brain_envirument.GetRecID_By_UserID_GroupName( dbConn, iUserNameID, ustrBelongGroupName) if (not iOrigRecID): iRetNewRecID = CSkLBDB_CommFuncShare.ExecInsertRecField2( dbConn, CSkLBDB_ea_brain_envirument.s_strTableName, "belong_usermang_id", str(iUserNameID), 'belong_group_name', ustrBelongGroupName) else: iRetNewRecID = iOrigRecID return iRetNewRecID
def AddNewdRec(dbConn, iBelongEnviruID, ustrChatContent, iContentType, iDirection, createTime=None, execTime=None, iExecStatus=0): ustrChatContent = CTYLB_MainSys_MiscFunc.SafeGetUnicode( ustrChatContent) iRetNewRecID = CSkLBDB_CommFuncShare.ExecInsertRecField5( dbConn, CSkLBDB_ea_brain_chatcontent.s_strTableName, "chat_content", ustrChatContent, 'belong_envirument_id', str(iBelongEnviruID), 'chat_content_type', str(iContentType), 'chat_direction', str(iDirection), 'exec_status', str(iExecStatus)) if (iRetNewRecID): if (not createTime): createTime = datetime.now() CSkLBDB_CommFuncShare.ExecUpdateRecField_To_DateTime( dbConn, CSkLBDB_ea_brain_chatcontent.s_strTableName, "create_time", createTime, "id", str(iRetNewRecID)) return iRetNewRecID
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 Update_ExStatus(dbConn, iRecID, iNewStatus): strClause = "id=%d" % (iRecID) CSkLBDB_CommFuncShare.ExecUpdateRecField1( dbConn, CSkLBDB_funcbot_op_display.s_strTableName, strClause, "exec_status", str(iNewStatus))
def Update_ExStatus(dbConn, iRecID, iNewStatus): strClause = "id=%d" % (iRecID) CSkLBDB_CommFuncShare.ExecUpdateRecField1( dbConn, CSkLBDB_ea_brain_exec_result.s_strTableName, strClause, "exec_status", str(iNewStatus))
def Update_PropValue(dbConn, iRecID, ustrPropValue): ustrPropValue = CTYLB_MainSys_MiscFunc.SafeGetUnicode(ustrPropValue) strClause = "id=%d" % (iRecID) CSkLBDB_CommFuncShare.ExecUpdateRecField1( dbConn, CSkLBDB_ea_brain_enviru_property.s_strTableName, strClause, "prop_value", ustrPropValue)
def ReadValueField_By_RecID(dbConn, iRecID): strClause = "id=%d" % (iRecID) strPropValue = CSkLBDB_CommFuncShare.ReadField_Single_WithClause( dbConn, CSkLBDB_ea_brain_enviru_property.s_strTableName, 'prop_value', strClause) return strPropValue
def Update_ExStatus(dbConn, iRecID, iNewStatus): strClause = "id=%d" % (iRecID) CSkLBDB_CommFuncShare.ExecUpdateRecField1( dbConn, CSkLBDB_ow_bot_out_chatcontent.s_strTableName, strClause, "ex_status", str(iNewStatus))
def GetRecList_By_StatusNotEquValue(dbConn, iCheckStatus): strClause = "ex_status is NULL or ex_status<>%d" % (iCheckStatus) iRetRecIDArray = CSkLBDB_CommFuncShare.ReadField_Array_WithClause( dbConn, CSkLBDB_ow_bot_out_chatcontent.s_strTableName, "id", strClause) return iRetRecIDArray