cossacklabs / acra

Database security suite. Database proxy with field-level encryption, search through encrypted data, SQL injections prevention, intrusion detection, honeypots. Supports client-side and proxy-side ("transparent") encryption. SQL, NoSQL.
https://www.cossacklabs.com/acra/
Apache License 2.0
1.35k stars 127 forks source link

support datagrip which is database GUI tool #634

Closed jercheng closed 1 year ago

jercheng commented 1 year ago

Checklist

In the initialization phase, datagrip will execute select schema(); and select table_name, auto_increment from information_schema.tables where table_schema = 'db_name and auto_increment is not null; but the current parsing tools do not support parsing these two SQL statements

Lagovas commented 1 year ago

wow, you have updated one of the hardest components in acra - SQL parser, cool ) but can you describe your case where you need correct parsing of these queries? do you apply any security controls as encryption or tokenization, or use acra-censor for them?

About PR, can you add this new SQL to the unit-tests - https://github.com/cossacklabs/acra/blob/master/sqlparser/parse_test.go#L30. To be sure that acra parses it now in expected way.

Lagovas commented 1 year ago

great, thanks for contribution

vixentael commented 1 year ago

💃💃💃