Created by: ybelenko
This enhancement adds basic SQL queries for each model(SELECT/INSERT/UPDATE,DELETE). You usually see these templates in PHPMyAdmin when you hit SQL tab. These SQLs are absolutely useless in original state, but they can be a good starting point, especially when you need to write queries with huge list of columns. I think that most of server side developers remember the time when you copypaste column names one by one into your code.
My next PR will create PHP classes(traits) with these SQLs. I think about PHP methods to create SQL prepared statements for PDO driver.
PR checklist
-
Read the contribution guidelines. -
If contributing template-only or documentation-only changes which will change sample output, build the project before. -
Run the shell script(s) under ./bin/(or Windows batch scripts under.\bin\windows) to update Petstore samples related to your fix. This is important, as CI jobs will verify all generator outputs of your HEAD commit, and these must match the expectations made by your contribution. You only need to run./bin/{LANG}-petstore.sh,./bin/openapi3/{LANG}-petstore.shif updating the code or mustache templates for a language ({LANG}) (e.g. php, ruby, python, etc). -
File the PR against the correct branch: master,4.3.x,5.0.x. Default:master. -
Copy the technical committee to review the pull request if your PR is targeting a particular programming language.
Closes #5666 (closed)
Personal invitation to @jimschubert. I assume that you skilled in database development, tell me what you think.