[feature]The download function of the BDP-DSS tool needs to be limited to 5,000 pieces, and each download operation must pop up an operation risk prompt to the user (prompt words to be added)

[yuankang134]

Search before asking

• I had searched in the issues and found no similar feature requirement.

Problem Description

The download function of the BDP-DSS tool needs to be limited to 5000, and every download operation will pop up an operation risk prompt to the user
(BDP-DSS工具的下载功能需要限制5000条，并且每次下载操作都要向用户弹出操作风险提示)

Prompt information: Data download is currently in progress, which may involve sensitive data, please ensure data security!
(提示信息：当前进行数据下载，可能涉及敏感数据，请保证数据的安全！)

Backend modification:
( 后端修改)

（1）The backend records the user's download records for later auditing.
(后端记录用户的下载记录，供后面做审计)

（2）The download function is limited to 5000 pieces. (It is best to have parameters to support the setting, and subsequent adjustments may be made)
（下载功能限制5000条。（最好有参数支持设置，后续可能调整））

Front-end modification, result set download:
（前端修改，结果集下载）

（1）A prompt message pops up when downloading, such as: Please ensure the security risk of downloaded data and prevent leakage events.
（下载时弹出提示信息，如：请用户保障下载数据安全风险，防止出现泄漏事件等。）

（2）Added the download audit function. At present, external users have contributed related functions, and it is planned to reuse this function directly. And it needs to be adjusted with the front end.
（增加下载审计功能，目前外部用户已经贡献了相关功能，计划先直接复用该功能。并需要和前端联调下。）

Download the audit save interface:
（下载审计保存接口）
/dss/framework/admin/audit/script/download/save

Download the audit query interface:
（下载审计查询接口）
/dss/framework/admin/audit/script/download/query

Libraries involved:
（涉及的库表）

DROP TABLE IF EXISTS dss_download_audit;

CREATE TABLE dss_download_audit (

id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

creator varchar(255) COMMENT '创建者',

tenant varchar(255) COMMENT '租户',

path varchar(255) COMMENT '文件路径',

sql varchar(3000) COMMENT '执行sql脚本',

create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',

     PRIMARY KEY (id)

) ENGINE = INNODB DEFAULT CHARSET = utf8 COMMENT = '文件下载审计';

Description

No response

Use case

No response

solutions

No response

Anything else

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

[yuankang134]

dss-1.1.0 has absolved