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
