【无标题】

最新推荐文章于 2024-06-21 12:52:40 发布

DisguiseR6

最新推荐文章于 2024-06-21 12:52:40 发布

阅读量171

点赞数 1

分类专栏： Spring 源码文章标签： python

本文链接：https://blog.csdn.net/qq_25614773/article/details/139454724

版权

Spring 源码专栏收录该内容

2 篇文章 0 订阅

订阅专栏

1-task_groups

http://demo.sqle.actionsky.com/sqle/v1/projects/default/task_groups

{"instances":[{"instance_name":"test"}]}

{"code":0,"message":"ok","data":{"task_group_id":199}}

2-audit

task_group_id: 199
sql: SELECT * FROM WHERE test

{
    "code": 0,
    "message": "ok",
    "data": {
        "task_group_id": 199,
        "tasks": [
            {
                "task_id": 471,
                "instance_name": "test",
                "instance_db_type": "MySQL",
                "instance_schema": "",
                "audit_level": "warn",
                "score": 35,
                "pass_rate": 0,
                "status": "audited",
                "sql_source": "form_data"
            }
        ]
    }
}

3-
http://demo.sqle.actionsky.com/sqle/v1/projects/default/workflow_template

{
    "code": 0,
    "message": "ok",
    "data": {
        "workflow_template_name": "700300-WorkflowTemplate",
        "desc": "700300 默认模板",
        "allow_submit_when_less_audit_level": "warn",
        "workflow_step_template_list": [
            {
                "number": 1,
                "type": "sql_review",
                "approved_by_authorized": true,
                "execute_by_authorized": false,
                "assignee_user_id_list": []
            },
            {
                "number": 2,
                "type": "sql_execute",
                "approved_by_authorized": false,
                "execute_by_authorized": true,
                "assignee_user_id_list": []
            }
        ],
        "update_time": "0001-01-01T00:00:00Z"
    }
}

4-
http://demo.sqle.actionsky.com/sqle/v2/tasks/audits/471/sqls?page_index=1&page_size=20&no_duplicate=false

{
    "code": 0,
    "message": "ok",
    "data": [
        {
            "number": 1,
            "exec_sql": "SELECT * FROM WHERE test",
            "sql_source_file": "",
            "sql_start_line": 1,
            "audit_result": [
                {
                    "level": "warn",
                    "message": "语法错误或者解析器不支持，请人工确认SQL正确性",
                    "rule_name": "",
                    "db_type": "MySQL"
                }
            ],
            "audit_level": "warn",
            "audit_status": "finished",
            "exec_result": "",
            "exec_status": "initialized",
            "description": "",
            "sql_type": "ddl"
        }
    ],
    "total_nums": 1
}