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

prepared statement SQLs #3

Open
Aleyasen opened this issue May 20, 2016 · 0 comments
Open

prepared statement SQLs #3

Aleyasen opened this issue May 20, 2016 · 0 comments

Comments

@Aleyasen
Copy link
Owner

The SQL statements need to be constructed and submitted differently than they are now. Each kind of call (i.e., with certain clauses in it and kinds of conditions, such as a date range or a user name or app name and group by or order by or whatever) needs to be defined as a template with placeholders for the actual values of dates/username/app name/etc. There might be around 8-10 of these templates. DarshanViz needs to make the MySQL call "Prepare" on each of these templates. This is super important. Then for the actual call, you just make a SQL call with the previously prepared template and the placeholder values that you want to use. This is super important for security.

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

No branches or pull requests

1 participant