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)