Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

【BONC 东方国信】百亿市值公司东方国信 CirroData 飞书官方文档链接了 SQLAuto #56

Open
TommyLemon opened this issue Jan 30, 2024 · 0 comments
Labels

Comments

@TommyLemon
Copy link
Owner

image

cirrodata.feishu.cn

image

bonc.com.cn

SQLAuto-智能零代码自动化测试 SQL 语句执行结果的数据库工具

任意增删改查、任意 SQL 模板变量、一键批量生成参数组合、快速构造大量测试数据

018AD342-6A7B-4D4E-ACC2-523196580221

20E6AE40-DEC5-42A7-8978-6BA1C286FB9B

8A127392-68FB-44A8-94A3-2EC6E629ED6D

60F7F4E4-D0B7-44E1-8692-B24CB56D973A

79387E13-179C-4F16-9620-427AD9C526F9

6298F2D3-7894-4CEE-BDE1-5B8936DB0C90

C6B0366D-DAEF-4C60-BCBB-70751E3832C6

A7DEBE5A-8CBD-4B5F-AF1C-CC0CA5EE6F39

018AD342-6A7B-4D4E-ACC2-523196580221

如果 SQL 语句是 INSERT 插入语句,则可以快速生成 1000+ 条测试数据(表记录),方便前后端联调接口,可按规则生成。
例如

INSERT INTO sys.apijson_user(id, sex, name) VALUES(${id}, ${sex}, ${name})

1000 次参数注入 Random Test:

id: new Date().getTime()  // 当前时间毫秒值
sex: RANDOM_IN(0, 1)  // 随机从 0, 1 中取值
name: 'Test ' + new Date().toLocaleTimeString()  // 通过代码自定义

创作不易、坚持更难,打开链接右上角点亮 ⭐Star 支持下本项目吧,谢谢 ^_^
https://gitee.com/TommyLemon/SQLAuto

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant