def addSubDataSource(taskId, name, sqlStatement, requestInfo): '''Add SubDataSource to task which taskId = taskId,you need apply name and sqlStatement,def will check exists''' #print(taskId) dictSubDataSource = dictQuerySubDataSourceList(taskId=taskId, requestInfo=requestInfo) #print(dictSubDataSource) listSubDataSourceName = [] for singleSubDataSource in dictSubDataSource: listSubDataSourceName.append(singleSubDataSource['name']) #print(listSubDataSourceName) if name not in listSubDataSourceName: needurl = requestInfo.rooturl + r'/mdc/Task/AddDataSource' needPostData = {} needPostData['id'] = '' needPostData['taskId'] = taskId needPostData['name'] = name needPostData[ 'databaseSourceId'] = 'cb1ecd13-2dab-4892-b517-34d79ccfcb6d' #默认为ehr needPostData['nameLangid'] = '' needPostData['sqlStatement'] = sqlStatement response = requestNeedurl(needurl=needurl, postData=needPostData, headers=requestInfo.headers, CookieOpener=requestInfo.CookieOpener) print('%s Add Success' % (name)) return response else: print('%s exist SubDataSource,skip Add' % (name))
def addNewTmpl(name, requestInfo): '''Add new tmpl in project which projectId = 2ae753f5-7402-4fa4-88de-2df90a0024ea,you need apply name''' print('11114555:%s' % ('11114555')) restest = queryTmpl(requestInfo=requestInfo) tmplId = [ singleTmpl['id'] for singleTmpl in queryTmpl(requestInfo=requestInfo) if singleTmpl['name'] == name ] if len(tmplId) == 0: needurl = requestInfo.rooturl + r'/mdc/Tmpl/ADD' print('needurl:%s' % (needurl)) needPostData = {} needPostData[ 'projectId'] = '2ae753f5-7402-4fa4-88de-2df90a0024ea' #默认职位人事业务 needPostData['messageTypeId'] = '059dda48-f066-4ffe-b47b-69655434d90a' needPostData['priority'] = '1' needPostData['name'] = name needPostData['id'] = '' response = requestNeedurl(needurl=needurl, postData=needPostData, headers=requestInfo.headers, CookieOpener=requestInfo.CookieOpener) return response else: print('%s exist tmpl,skip Add' % (name))
def addNewTask(name, tmplId, requestInfo): '''Add new task in tmpl,you need apply name and tmplId''' taskId = [ singleTask['id'] for singleTask in queryTaskbyTmpl(tmplId=tmplId, requestInfo=requestInfo) if singleTask['name'] == name ] if len(taskId) == 0: needurl = requestInfo.rooturl + r'/mdc/Task/ADD' needPostData = {} needPostData['templateId'] = tmplId #默认职位人事业务 needPostData['name'] = name needPostData['id'] = '' needPostData['nameLangid'] = '' needPostData['isMail'] = 'true' needPostData['isMsg'] = 'false' needPostData['isSMS'] = 'false' needPostData['agentId'] = '' needPostData['isWeixin'] = 'false' needPostData['description'] = name needPostData['descriptionLangid'] = '' response = requestNeedurl(needurl=needurl, postData=needPostData, headers=requestInfo.headers, CookieOpener=requestInfo.CookieOpener) return response else: print('Add filed,taskname exists')
def dictQueryTmplVars(tmplId, requestInfo): '''Query all TmplVars IN Tmpl which tmplId = tmplId and resquest the dict of tmplvar list''' needurl = requestInfo.rooturl + r'/mdc/Tmpl/QueryVariable' needPostData = {} needPostData['tmplId'] = tmplId response = requestNeedurl(needurl=needurl, postData=needPostData, headers=requestInfo.headers, CookieOpener=requestInfo.CookieOpener) dictResponse = json.loads(response.read().decode())['data'] return dictResponse
def dictQuerySubDataSourceList(taskId, requestInfo): '''Query SubDataSourceList IN task which taskId = taskId and resquest the dict of SubDataSource list''' needurl = requestInfo.rooturl + r'/mdc/Task/SubDataSourceList' needPostData = {} needPostData['taskId'] = taskId needPostData['pageIndex'] = 0 needPostData['pageSize'] = 30 response = requestNeedurl(needurl=needurl, postData=needPostData, headers=requestInfo.headers, CookieOpener=requestInfo.CookieOpener) dictResponse = json.loads(response.read().decode())['records'] return dictResponse
def listRecipientVarsByTmpId(tmplId, requestInfo): needurl = requestInfo.rooturl + r'/mdc/Tmpl/Recipient?tmplId=' + tmplId needPostData = {} response = requestNeedurl(needurl=needurl, postData=needPostData, headers=requestInfo.headers, CookieOpener=requestInfo.CookieOpener) readQueryRecipientVars = response.read().decode() listRecipientVars = re.findall(r'variableList:\[(.*)\],', str(readQueryRecipientVars)) if len(listRecipientVars) > 0: listRecipientVars = '[' + listRecipientVars[0] + ']' listRecipientVars = json.loads(listRecipientVars) return listRecipientVars
def listVariableMappingByTaskId(taskId, requestInfo): needurl = requestInfo.rooturl + r'/mdc/Task/variableMapping?taskId=' + taskId needPostData = {} response = requestNeedurl(needurl=needurl, postData=needPostData, headers=requestInfo.headers, CookieOpener=requestInfo.CookieOpener) readVariableMappings = response.read().decode() listVariableMappings = re.findall(r"variableList':\[(.*)\],", str(readVariableMappings)) if len(listVariableMappings) > 0: listVariableMappings = '[' + listVariableMappings[0] + ']' listVariableMappings = json.loads(listVariableMappings) return listVariableMappings
def queryTaskbyTmpl(tmplId, requestInfo): '''Query tmpl list in project which projectId = 2ae753f5-7402-4fa4-88de-2df90a0024ea ''' needurl = requestInfo.rooturl + r'/mdc/Task/query' needPostData = {} needPostData['tmplId'] = tmplId needPostData['pageIndex'] = '0' needPostData['pageSize'] = '30' response = requestNeedurl(needurl=needurl, postData=needPostData, headers=requestInfo.headers, CookieOpener=requestInfo.CookieOpener) resQueryTask = json.loads(response.read().decode()) josonQueryTask = resQueryTask['records'] return josonQueryTask
def addMainDataSource(taskId, name, sqlStatement, requestInfo): '''Add MainDataSource to task which taskid = taskId,you need apply name and sqlStatement''' if taskId == '': print('Need taskId') else: needurl = requestInfo.rooturl + r'/mdc/Task/dataSource' needPostData = {} needPostData['id'] = '' needPostData['taskId'] = taskId needPostData['name'] = name needPostData[ 'databaseSourceId'] = 'cb1ecd13-2dab-4892-b517-34d79ccfcb6d' #默认为ehr needPostData['nameLangid'] = '' needPostData['sqlStatement'] = sqlStatement response = requestNeedurl(needurl=needurl, postData=needPostData, headers=requestInfo.headers, CookieOpener=requestInfo.CookieOpener) print('%s Add Success' % (name)) return response
def addTmplVar(templateId, name, code, requestInfo): '''Add TmplVar to Tmpl which templateId = tmplId,you need apply name and code,def will check exists''' needurl = requestInfo.rooturl + r'/mdc/Tmpl/AddVariable' needPostData = {} needPostData['id'] = '' needPostData['templateId'] = templateId needPostData['name'] = name needPostData['code'] = code dictTmplVar = dictQueryTmplVars(tmplId=templateId, requestInfo=requestInfo) listTmpVarName = [] for singleTmpVar in dictTmplVar: listTmpVarName.append(singleTmpVar['name']) #print(listTmpVarName) if name not in listTmpVarName: response = requestNeedurl(needurl=needurl, postData=needPostData, headers=requestInfo.headers, CookieOpener=requestInfo.CookieOpener) print('%s Add Success' % (name)) else: print('%s exist vars,skip Add' % (name))