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