xxl_job-修改管理平台并使用Python请求日志信息

问题描述

我想知道某个持续时间较长的任务是否已经完成。在不访问数据库的情况下，使用Post请求获取任务的处理状态码。

解决

import os
import requests
from typing import List

# 获取cookie
def get_cookie():
    url = "http://127.0.0.1:8080/xxl-job-admin/login"
    session = requests.Session()
    data = {
        "userName": "admin",
        "password": "123456"
    }
    response = session.post(url, data)
    cookies = session.cookies
    # 转为dict
    cookie = requests.utils.dict_from_cookiejar(cookies)
    return cookie

def check(url:str, cookie:dict, id:int):
    data = {'id': id}
    response = requests.post(url=url, cookies=cookie, data=data)
    if response.status_code == 200:
        # 做一些处理
        pass

if __name__ == "__main__":
    cookie = get_cookie()
    url = "http://localhost:8080/xxl-job-admin/joblog/getstatus"
    check(url, cookie)
    

而getstatus对应JobLogController.java (com.xxl.job.admin.controller)：

	@ResponseBody
	@RequestMapping(value="/getstatus")
	public String getSgrnaLibValResults(@RequestParam("id")Integer id) {
		String result = "";
		XxlJobLog log = this.xxlJobLogDao.getByJobId(id);
		result = String.valueOf(log.getHandleCode());
		return result;
	}

XxlJobLogDao.java (com.xxl.job.admin.dao)

	/**
	 * 只选择处理时间最近的那条
	 * @param jid
	 * @return
	 */
	public XxlJobLog getByJobId(@Param("jid") long jid);

XxlJobLogMapper.xml (src/main/resources/mybatis-mapper)

	<select id="getByJobId" parameterType="java.lang.Long" resultMap="XxlJobLog">
		SELECT <include refid="Base_Column_List" />
		FROM xxl_job_log AS t
		WHERE t.job_id = #{jid}
		order by t.handle_time desc
		limit 1
	</select>

如果运行的时候报错400，405，可以检查一下controller，是不是标记写错了，比如写成了GetMapping或者PostMapping。（我之前用Java同样写是没问题的，但是requests包这样不行。。）