def delSearchTask(id):
ids = id.split(",")
arr = []
for i in ids:
arr.append("'" + i + "'")
sql = 'update p_search_task_job set del_flag = 1 where id IN (%s) ' % ",".join(
arr)
Session.execute(sql)
Session.flush()
Session.commit()
def getRunningTaskJobList():
sql = text(
"""SELECT * FROM task_job,( SELECT id AS task_id_sequence,task_job_id,create_time history_create_time
FROM (select * from task_job_history order by create_time desc) A WHERE del_flag = 0 GROUP BY task_job_id ORDER BY
create_time DESC ) A WHERE A.task_job_id = task_job.id AND task_job. STATUS = 1 AND task_job.del_flag = 0"""
)
return Session.execute(sql)
def anayse(type, taskJobSequenceId):
fieldWeightList = Session.query(FieldWeight).filter(
FieldWeight.type == type).all()
whileData = []
fieldNameList = []
for fieldWeight in fieldWeightList:
weight = int(fieldWeight.weight)
fieldNameEn = fieldWeight.fieldNameEn
fieldNameList.append(fieldNameEn)
whileData.append((fieldNameEn, weight or 0))
filterSql = text(
"(SELECT parent_id FROM job_template where del_flag=0 GROUP BY parent_id)"
)
# whiteJobTemplateList=Session.query(JobTemplate).filter(JobTemplate.id.notin_(filterSql),JobTemplate.delFlag==False,JobTemplate.objectType==1).all()
blackJobTemplateList = Session.query(JobTemplate).filter(
JobTemplate.jobTemplateType == type, JobTemplate.id.notin_(filterSql),
JobTemplate.delFlag == False, JobTemplate.objectType != 1).all()
# anaValue=[]
jobTemplateInfo = []
for jobTemplate in blackJobTemplateList:
# anaMap={"jobTemplate":jobTemplate}
tableName = jobTemplate.tableName
jobTemplateId = jobTemplate.id
# objectType=jobTemplate.objectType
jobTemplateFieldList = Session.query(JobTemplateField).filter(
JobTemplateField.jobTemplateId == jobTemplateId,
JobTemplateField.delFlag == False).all()
fieldList = []
for jobTemplateField in jobTemplateFieldList:
fieldNameEn = jobTemplateField.fieldNameEn
fieldList.append(fieldNameEn)
dataSql = text("select %s from %s where task_job_id_sequence='%s'" %
(",".join(fieldList), tableName, taskJobSequenceId))
rs = Session.execute(dataSql).fetchall()
blackValue = []
for row in rs:
map = {}
print row
for name in fieldNameList:
value = row[name] if row.has_key(name) else ""
map[name] = value
blackValue.append(map)
jobTemplateInfo.append({
"value": blackValue,
"fieldName": fieldNameList,
"jobTemplateInfo": jobTemplate
})
return {"value": jobTemplateInfo}
def getRunnginTaskJob():
sql=text("select * from p_search_task_Job,(select id as task_id_sequence " \
" ,task_job_id,create_time history_create_time from task_job_history where del_flag=0 group by task_job_id order by create_time desc ) A " \
"where A.task_job_id=p_search_task_job.id and p_search_task_job.status=1 and p_search_task_job.del_flag=0")
return Session.execute(sql)
