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

Parameterize Select queries #10

Open
siggib007 opened this issue Jul 4, 2022 · 3 comments
Open

Parameterize Select queries #10

siggib007 opened this issue Jul 4, 2022 · 3 comments
Labels
enhancement New feature or request Internal only only approved contributors please

Comments

@siggib007
Copy link
Owner

Create a function that takes in

  • array of field names
  • table name
  • associated array with filter criteria
    Makes a parameterized SQL query using those outputs, collects the response into an associated array and returns that, similar to what we do in python.
@siggib007 siggib007 self-assigned this Jul 4, 2022
@siggib007 siggib007 added Internal only only approved contributors please enhancement New feature or request labels Jul 4, 2022
@siggib007
Copy link
Owner Author

Wrote function QuerySQL($strQuery) that makes it easier to standardize making queries. The this can be updated to be parameterized, etc

@siggib007
Copy link
Owner Author

working my way through all the files and updating them to use QuerySQL instead of making direct DB calls. Gone through A-E at this point.

@siggib007
Copy link
Owner Author

Everywhere should be using the functions for all DB interaction, instead of calling the DB handle directly. Need to do some QC to validate.

@siggib007 siggib007 removed their assignment Sep 21, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request Internal only only approved contributors please
Projects
None yet
Development

No branches or pull requests

1 participant