Yuriy Belenko 1c51d4138e
[mysql] Add basic SQL queries (#5757)
* Add basic SQL queries template

* Add namedParametersEnabled option

* Move model related SQLs into Model folder

* Update README template

* Refresh samples
2020-04-12 16:49:50 +08:00

27 lines
589 B
SQL

--
-- OpenAPI Petstore.
-- Prepared SQL queries for '$special[model.name]' definition.
--
--
-- SELECT template for table `$special[model.name]`
--
SELECT `$special[property.name]` FROM `$special[model.name]` WHERE 1;
--
-- INSERT template for table `$special[model.name]`
--
INSERT INTO `$special[model.name]`(`$special[property.name]`) VALUES (?);
--
-- UPDATE template for table `$special[model.name]`
--
UPDATE `$special[model.name]` SET `$special[property.name]` = ? WHERE 1;
--
-- DELETE template for table `$special[model.name]`
--
DELETE FROM `$special[model.name]` WHERE 0;