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

咱们这个apiauto有生成sql的功能吗 #43

Open
shouziws opened this issue Jun 12, 2023 · 1 comment
Open

咱们这个apiauto有生成sql的功能吗 #43

shouziws opened this issue Jun 12, 2023 · 1 comment
Labels

Comments

@shouziws
Copy link

比如以下配置应该生成 2个sql
{
"User[]": {
"User": {
"id|{}": "<30000,>80000"
}
},
"s[]": {
"B_stone": {
"@column": "id"
}
}
}

select * from User where id < 30000 or id > 80000
select id from B_stone limit等

@TommyLemon
Copy link
Owner

TommyLemon commented Jun 22, 2023

你写的是 APIJSON 请求 JSON,只要最外层或表对象内传 "@explain": true 就会返回 SQL,和 APIAuto 无关。
用 SQLAuto 可以点表名右侧按钮自动生成增删改查 SQL
https://github.com/TommyLemon/SQLAuto
image

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

2 participants