def loadTemplate(page=Page(1,10),paramMap={},userId=None,orderBy=text(" job_template.create_time desc "),parentId=None): queryParam = [] # if parentId == None: # queryParam.append(text("(ifnull(job_template.parent_id,'')='' or job_template.parent_id='-1')")) # else: # queryParam.append(JobTemplate.parentId == parentId) if parentId is not None: queryParam.append(JobTemplate.parentId == parentId) if userId != None and userId != "-1" and userId != "": queryParam.append(TaskJob.createUserId == userId) if paramMap and paramMap.has_key("pageNo") and paramMap.has_key("pageSize"): page = Page(paramMap["pageNo"],paramMap["pageSize"]) queryParam.append(JobTemplate.delFlag == False) queryParam = BaseDao.initialQueryParam(paramMap or {}, JobTemplate, queryParam) filterQuery=Session.query(JobTemplate).filter taskList = apply(filterQuery, tuple(queryParam)) if orderBy == None: orderBy = text('task_job.create_time desc') if (parentId == None or parentId == '-1') and page!=None: taskList = taskList.order_by(orderBy).offset(page.offset).limit(page.limit) taskList = taskList.all() count = apply(filterQuery, tuple(queryParam)).count() # if paramMap.has_key('action'): # action = paramMap['action'] # if action == '1': # jobtemp = taskList[0] # jobtemplist = queryAllTempByTaskJob(jobtemp)#递归查询子模板 # if jobtemplist: # taskList.extend(jobtemplist) # count = len(taskList) return {"jobTemplateList": taskList, "count": count}
def getTaskList(page, userId=None, paramMap=None, orderBy=text('search_task_job.create_time desc'), parentId=None, status=None): queryParam = [] # if parentId == None: # queryParam.append(text("(ifnull(task_job.parent_id,'')='' or task_job.parent_id='-1')")) # else: # queryParam.append(SearchTaskJob.childIds == parentId) if userId != None and userId != "-1" and userId != "": queryParam.append(SearchTaskJob.createUserId == userId) queryParam.append(SearchTaskJob.delFlag == False) queryParam = BaseDao.initialQueryParam(paramMap or {}, SearchTaskJob, queryParam) taskList = apply(Session.query(SearchTaskJob).filter, tuple(queryParam)) if orderBy == None: orderBy = text('p_search_task_job.create_time desc') if status != None: taskList = taskList.filter(SearchTaskJob.status == status) if parentId == None: taskList = taskList.order_by(orderBy).offset(page.offset).limit( page.limit) taskList = taskList.all() count = apply(Session.query(SearchTaskJob).filter, tuple(queryParam)).count() return {"taskList": taskList, "count": count}
def getTaskList(page=Page(1, 10), userId=None, paramMap=None, orderBy=text('task_job.create_time desc'), parentId=None): # sql = None # if(userId==None): # sql=text(" del_flag=0") # else: # sql=text("create_user_id='" + userId + "' and del_flag=0") queryParam = [] if parentId == None: queryParam.append( text( "(ifnull(task_job.parent_id,'')='' or task_job.parent_id='-1')" )) else: queryParam.append(TaskJob.parentId == parentId) if userId != None and userId != "-1" and userId != "": queryParam.append(TaskJob.createUserId == userId) queryParam.append(TaskJob.delFlag == False) queryParam = BaseDao.initialQueryParam(paramMap or {}, TaskJob, queryParam) taskList = apply(Session.query(TaskJob).filter, tuple(queryParam)) if orderBy == None: orderBy = text('task_job.create_time desc') if parentId == None: taskList = taskList.order_by(orderBy).offset(page.offset).limit( page.limit) taskList = taskList.all() count = apply(Session.query(TaskJob).filter, tuple(queryParam)).count() return {"taskList": taskList, "count": count}
def countObj(userId, clazz, paramMap): queryParam = [] queryParam.append(text("(ifnull(parent_id,'')='' or parent_id='-1')")) if userId != None and userId != "-1" and userId != "": queryParam.append(TaskJob.createUserId == userId) queryParam.append(clazz.delFlag == False) queryParam = BaseDao.initialQueryParam(paramMap, clazz, queryParam) return apply(Session.query(clazz.id).filter, tuple(queryParam)).count()
def queryDbSourceList(paramMap): queryParam = [] queryParam.append(DbSource.delFlag == 0) queryParam = BaseDao.initialQueryParam(paramMap or {}, DbSource, queryParam) dbSourceList = apply(Session.query(DbSource).filter, tuple(queryParam)) sortlist = dbSourceList.order_by(DbSource.createTime).all() sortlist.reverse() newSortDbSourcelist = sortlist return newSortDbSourcelist