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

[Feature Request] - strict update mode #46

Open
imiskolee opened this issue Aug 22, 2019 · 0 comments
Open

[Feature Request] - strict update mode #46

imiskolee opened this issue Aug 22, 2019 · 0 comments
Labels
discussion This issue needs further discussion enhancement New feature or request

Comments

@imiskolee
Copy link

hi,team:

I am trying to design a feature called strict update mode. it's meaning just allow execute UPDATE SQL with the primary key or which configured fields. the proxy will reject the update SQL when can't match configure.

Samples:

configure:

table1: just allow update with the primary key.
table2: just allow update when included user_id or id on where clause.

examples:

update table1 field_1 = 1 where id = 1. [pass]
update table1 field_1 = 1 where field_2 = 1. [reject]
update table2 field_1 = 1 where id = 1. [pass]
update table2 field_1 = 1 where user_id = 1 [pass]
update table2 field_1 = 1 where field_2 = 1. [reject].

how about the idea?

@teckick teckick added discussion This issue needs further discussion enhancement New feature or request labels Aug 22, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
discussion This issue needs further discussion enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants