def updateJobCountData(strEDIConnection, strEDIDB, strEDINo, strJobID,
intDataCount, intDataVolume):
strSQL = "UPDATE DWWANT.EDI_JOB J " + \
"LEFT JOIN DWWANT.EDI_JOB D " + \
"ON J.EDI_NO=D.EDI_NO AND J.EDI_DEP_JOB_ID=D.EDI_JOB_ID " + \
"SET J.DATA_COUNT={DATA_COUNT}, J.DATA_VOLUME={DATA_VOLUME} " + \
" , J.DATA_COUNT_DIF=(CASE WHEN J.EDI_JOB_TYPE='MariaDBImport' THEN (IFNULL(D.DATA_COUNT,0)-{DATA_COUNT}) ELSE NULL END) " + \
" , J.UPD_USER_ID={UPD_USER_ID}, J.UPD_DT=NOW() " + \
"WHERE J.EDI_NO={EDI_NO} AND J.EDI_JOB_ID={EDI_JOB_ID}; "
dictMariaParameter = {
"DATA_COUNT":
MariaEntity.MariaParameter(
objValue=intDataCount,
enumType=MariaEntity.EnumMariaParameterType.Int),
"DATA_VOLUME":
MariaEntity.MariaParameter(
objValue=intDataVolume,
enumType=MariaEntity.EnumMariaParameterType.Int),
"UPD_USER_ID":
MariaEntity.MariaParameter(
objValue="EDIService",
enumType=MariaEntity.EnumMariaParameterType.Char),
"EDI_NO":
MariaEntity.MariaParameter(
objValue=strEDINo,
enumType=MariaEntity.EnumMariaParameterType.Char),
"EDI_JOB_ID":
MariaEntity.MariaParameter(
objValue=strJobID,
enumType=MariaEntity.EnumMariaParameterType.Char),
}
strSQL = DBEntity.getMariaSQLCommand(strSQL, dictMariaParameter)
return DBEntity.executeMariaData(strEDIConnection, strEDIDB, strSQL)
def updateJobEndData(strEDIConnection, strEDIDB, strEDINo, strJobID,
enumJobResult):
strSQL = "UPDATE DWWANT.EDI_JOB SET " + \
" {STATUS_ID}, {RESULT_ID}, {DT_END} " + \
" , {UPD_USER_ID}, UPD_DT=NOW() " + \
"WHERE {EDI_NO} AND {EDI_JOB_ID}; "
enumEDIResultID = EDIEnum.EnumEDIResultID.F
if enumJobResult == EDIEnum.EnumJobResult.Success:
enumEDIResultID = EDIEnum.EnumEDIResultID.S
elif enumJobResult == EDIEnum.EnumJobResult.Cancel:
enumEDIResultID = EDIEnum.EnumEDIResultID.C
dictMariaParameter = {
"STATUS_ID":
MariaEntity.MariaParameter(
strOperator="=",
objValue=EDIEnum.EnumEDIStatusID.F.name,
enumType=MariaEntity.EnumMariaParameterType.Char),
"RESULT_ID":
MariaEntity.MariaParameter(
strOperator="=",
objValue=enumEDIResultID.name,
enumType=MariaEntity.EnumMariaParameterType.Char),
"DT_END":
MariaEntity.MariaParameter(
strOperator="=",
objValue=datetime.datetime.now(),
enumType=MariaEntity.EnumMariaParameterType.DateTime),
"UPD_USER_ID":
MariaEntity.MariaParameter(
strOperator="=",
objValue="EDIService",
enumType=MariaEntity.EnumMariaParameterType.Char),
"EDI_NO":
MariaEntity.MariaParameter(
strOperator="=",
objValue=strEDINo,
enumType=MariaEntity.EnumMariaParameterType.Char),
"EDI_JOB_ID":
MariaEntity.MariaParameter(
strOperator="=",
objValue=strJobID,
enumType=MariaEntity.EnumMariaParameterType.Char),
}
strSQL = DBEntity.getMariaSQLCommand(strSQL, dictMariaParameter)
return DBEntity.executeMariaData(strEDIConnection, strEDIDB, strSQL)
def insertNewJob(strEDIConnection, strEDIDB, strEDINo, strJobID, strJobType,
strObjectName, strDependOn):
strSQL = "INSERT INTO DWWANT.EDI_JOB VALUES ( " + \
" {EDI_NO}, {EDI_JOB_ID}, {EDI_JOB_TYPE}, {EDI_OBJ_NM}, {EDI_DEP_JOB_ID} " + \
" , {STATUS_ID}, NULL " + \
" , {DT_BEGIN}, NULL, NULL, NULL, NULL " + \
" , {UPD_USER_ID}, NOW() " + \
"); "
dictMariaParameter = {
"EDI_NO":
MariaEntity.MariaParameter(
objValue=strEDINo,
enumType=MariaEntity.EnumMariaParameterType.Char),
"EDI_JOB_ID":
MariaEntity.MariaParameter(
objValue=strJobID,
enumType=MariaEntity.EnumMariaParameterType.Char),
"EDI_JOB_TYPE":
MariaEntity.MariaParameter(
objValue=strJobType,
enumType=MariaEntity.EnumMariaParameterType.Char),
"EDI_OBJ_NM":
MariaEntity.MariaParameter(
objValue=strObjectName,
enumType=MariaEntity.EnumMariaParameterType.Char),
"EDI_DEP_JOB_ID":
MariaEntity.MariaParameter(
objValue=strDependOn,
enumType=MariaEntity.EnumMariaParameterType.Char),
"STATUS_ID":
MariaEntity.MariaParameter(
objValue=EDIEnum.EnumEDIStatusID.B.name,
enumType=MariaEntity.EnumMariaParameterType.Char),
"DT_BEGIN":
MariaEntity.MariaParameter(
objValue=datetime.datetime.now(),
enumType=MariaEntity.EnumMariaParameterType.DateTime),
"UPD_USER_ID":
MariaEntity.MariaParameter(
objValue="EDIService",
enumType=MariaEntity.EnumMariaParameterType.Char),
}
strSQL = DBEntity.getMariaSQLCommand(strSQL, dictMariaParameter)
return DBEntity.executeMariaData(strEDIConnection, strEDIDB, strSQL)
def updateFlowBeginData(strEDIConnection, strEDIDB, strEDINo, strEDIDate,
strEDITime):
strSQL = "UPDATE DWWANT.EDI_FLOW SET " + \
" {EDI_DATE}, {EDI_TIME} " + \
" , {STATUS_ID}, {DT_BEGIN} " + \
" , {UPD_USER_ID}, UPD_DT=NOW() " + \
"WHERE {EDI_NO}; "
dictMariaParameter = {
"EDI_DATE":
MariaEntity.MariaParameter(
strOperator="=",
objValue=strEDIDate,
enumType=MariaEntity.EnumMariaParameterType.Char),
"EDI_TIME":
MariaEntity.MariaParameter(
strOperator="=",
objValue=strEDITime,
enumType=MariaEntity.EnumMariaParameterType.Char),
"STATUS_ID":
MariaEntity.MariaParameter(
strOperator="=",
objValue=EDIEnum.EnumEDIStatusID.B.name,
enumType=MariaEntity.EnumMariaParameterType.Char),
"DT_BEGIN":
MariaEntity.MariaParameter(
strOperator="=",
objValue=datetime.datetime.now(),
enumType=MariaEntity.EnumMariaParameterType.DateTime),
"UPD_USER_ID":
MariaEntity.MariaParameter(
strOperator="=",
objValue="EDIService",
enumType=MariaEntity.EnumMariaParameterType.Char),
"EDI_NO":
MariaEntity.MariaParameter(
strOperator="=",
objValue=strEDINo,
enumType=MariaEntity.EnumMariaParameterType.Char),
}
strSQL = DBEntity.getMariaSQLCommand(strSQL, dictMariaParameter)
return DBEntity.executeMariaData(strEDIConnection, strEDIDB, strSQL)
def insertNextFlow(strEDIConnection, strEDIDB, strEDIDate, strEDIID,
strEDIFlowID, strAutoEDINo, strDataDate):
strSQL = "INSERT INTO DWWANT.EDI_FLOW VALUES ( " + \
" DWWANT.FN_GET_EDI_NO({EDI_DATE}), {EDI_ID}, {EDI_FLOW_ID} " + \
" , NULL, NULL " + \
" , {DATA_DATE}, 'W', NULL, NULL, NULL " + \
" , 'Y', NOW(), {AUTO_EDI_NO}, 'N' " + \
" , {UPD_USER_ID}, NOW() " + \
"); "
dictMariaParameter = {
"EDI_DATE":
MariaEntity.MariaParameter(
objValue=strEDIDate,
enumType=MariaEntity.EnumMariaParameterType.Char),
"EDI_ID":
MariaEntity.MariaParameter(
objValue=strEDIID,
enumType=MariaEntity.EnumMariaParameterType.Char),
"EDI_FLOW_ID":
MariaEntity.MariaParameter(
objValue=strEDIFlowID,
enumType=MariaEntity.EnumMariaParameterType.Char),
"DATA_DATE":
MariaEntity.MariaParameter(
objValue=strDataDate,
enumType=MariaEntity.EnumMariaParameterType.Char),
"AUTO_EDI_NO":
MariaEntity.MariaParameter(
objValue=strAutoEDINo,
enumType=MariaEntity.EnumMariaParameterType.Char),
"UPD_USER_ID":
MariaEntity.MariaParameter(
objValue="EDIService",
enumType=MariaEntity.EnumMariaParameterType.Char),
}
strSQL = DBEntity.getMariaSQLCommand(strSQL, dictMariaParameter)
return DBEntity.executeMariaData(strEDIConnection, strEDIDB, strSQL)
