Skip to main content

wjmask

静态脱敏服务相关接口​

1、查询数据库所有表信息 GET接口​

1.获取数据库表
地址     :http://localhost:10001/v1/tablelist?param=base64
方法     :GET
入参     :BASE64字符串
返回     :code,message,data
{
    "code": 1000,
    "message": "",
    "data": {
       
    }
}

2、查询表字段信息 GET接口​

2.获取表结构
地址     :http://localhost:10001/v1/tableinfo?param=base64
方法     :GET
入参     :BASE64字符串
{
		Address:   "127.0.0.1:3306",
		DBname:    "user",
		Password:  "1FdoM5iC4CHLkKhNxGPLIg==",
		User:      "root",
		TableName: "t_user",
}
返回     :code,message,data
{
    "code": 1000,
    "message": "Success",
    "data": [
        {
            "ColumnName": "id",
            "Type": "int(10)",
            "IfMask": "1"
        },
        {
            "ColumnName": "name",
            "Type": "varchar(50)",
            "IfMask": "1"
        },
        {
            "ColumnName": "age",
            "Type": "int(4)",
            "IfMask": "1"
        },
        {
            "ColumnName": "phone",
            "Type": "varchar(20)",
            "IfMask": "1"
        },
        {
            "ColumnName": "id_card",
            "Type": "varchar(20)",
            "IfMask": "1"
        },
        {
            "ColumnName": "create_time",
            "Type": "datetime",
            "IfMask": "0"
        },
        {
            "ColumnName": "birthday",
            "Type": "varchar(255)",
            "IfMask": "1"
        },
        {
            "ColumnName": "contact_person",
            "Type": "varchar(255)",
            "IfMask": "1"
        },
        {
            "ColumnName": "birthday_cipher",
            "Type": "varchar(255)",
            "IfMask": "1"
        },
        {
            "ColumnName": "name_cipher",
            "Type": "varchar(255)",
            "IfMask": "1"
        },
        {
            "ColumnName": "contact_person_cipher",
            "Type": "varchar(255)",
            "IfMask": "1"
        }
    ]
}

3、执行静态脱敏任务 POST接口​

3.静态脱敏执行
地址     :http://localhost:10001/v1/mask?param=base64  //旧接口
地址     :http://localhost:10001/v1/mask?param=base64&taskId=任务id  
方法     :POST
入参     :BASE64字符串
{
	"OriginDB": {
		"Address": "127.0.0.1:3306",
		"DBname": "ss57",
		"User": "root",
		"Password": "RZBe3knJQ65nXQdabQ6YdQ==",
	},
	"TargetDB": {
		"Address": "127.0.0.1:3306",
		"DBname": "tuo_ss59",
		"User": "root",
		"Password": "RZBe3knJQ65nXQdabQ6YdQ==",
	},
	"Rules": [{
		"TableName": "t_user",
		"Num": 100,
		"WCNum": 0,
		"Columns": [{
			"ColumnName": "name",
			"Start": 1,
			"Length": 1,
			"Replace": "*"
		}, {
			"ColumnName": "mobile",
			"Start": 1,
			"Length": 1,
			"Replace": "*"
		}],
		"WCColumns": []
	}],
	"WcInfo": "",
	"RsInfo":""
}
返回     :code,message,data
{
    "code": 1000,
    "message": "Success",
    "data": "执行成功"
}

4.获取上次任务结果​

4.获取上次任务结果
地址     :http://localhost:10001/v1/task?type=mask或watermark  //旧接口
地址     :http://localhost:10001/v1/task?taskId=任务id
方法     :GET 
入参     :无
返回     :code,message,data
{
    "code": 1000,
    "message": "",
    "data": {
       
    }
}

5.获取静态脱敏总数GET​

5.获取静态脱敏总数GET
地址     :http://localhost:10001/v1/totalcnt
方法     :GET 
入参     :无
返回     :code,message,data
{
    "code": 1000,
    "message": "",
    "data": {
       
    }
}

静态水印服务相关接口​

1.执行静态水印任务​

1.执行静态水印任务
地址     :http://localhost:10001/v1/watermark?param=base64(数据源+规则)    // 旧接口
地址     :http://localhost:10001/v1/watermark?param=base64(数据源+规则)&taskId=任务id
方法     :POST 
入参     :json
{
	"OriginDB": {
		"Address": "127.0.0.1:3306",
		"DBname": "ss57",
		"User": "root",
		"Password": "RZBe3knJQ65nXQdabQ6YdQ==",
	},
	"TargetDB": {
		"Address": "127.0.0.1:3306",
		"DBname": "tuo_ss59",
		"User": "root",
		"Password": "RZBe3knJQ65nXQdabQ6YdQ==",
	},
	"Rules": [{
		"TableName": "t_user",
		"Num": 0,
		"WCNum": 1000,
		"Columns": [],
		"WCColumns": ["name","mobile"]
	}],
	"WcInfo": "AAA",""
	"RsInfo":"01000e030c0108000f0c090e0a050e0c020b0f0c0b0b07090f030f0508060e02030b09010a01080903020a0300020808"
}
返回     :code,message,data
{
    "code": 1000,
    "message": "Success",
    "data": "执行成功"
}
//说明：异步任务，执行成功只代表数据源及规则校验成功，具体执行结果需要调用task接口查看

2.查询任务执行情况​

2.查询任务执行情况
地址     :http://localhost:10001/v1/task?taskType=xxx
方法     :GET 
入参     :无
返回     :code,message,data
{
    "code": 1000,
    "message": "Success",
    "data": {
        "TaskType": "watermark",
        "TotalCount": 1000,
        "FinishCount": 1000,
        "Status": 2,
        "Info": "水印任务执行完成",
        "StartTime": "2024-03-25T20:54:37.026953+08:00",
        "EndTime": "2024-03-25T20:54:37.437356+08:00"
    }
}
说明
  • 说明：taskType为可选参数
  • （1）taskType为空，查询静态脱敏任务执行情况
  • （2）taskType=watermark，查询静态水印任务执行情况