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
780 B
SQL

--
-- OpenAPI Petstore.
-- Prepared SQL queries for 'Capitalization' definition.
--
--
-- SELECT template for table `Capitalization`
--
SELECT `smallCamel`, `CapitalCamel`, `small_Snake`, `Capital_Snake`, `SCA_ETH_Flow_Points`, `ATT_NAME` FROM `Capitalization` WHERE 1;
--
-- INSERT template for table `Capitalization`
--
INSERT INTO `Capitalization`(`smallCamel`, `CapitalCamel`, `small_Snake`, `Capital_Snake`, `SCA_ETH_Flow_Points`, `ATT_NAME`) VALUES (?, ?, ?, ?, ?, ?);
--
-- UPDATE template for table `Capitalization`
--
UPDATE `Capitalization` SET `smallCamel` = ?, `CapitalCamel` = ?, `small_Snake` = ?, `Capital_Snake` = ?, `SCA_ETH_Flow_Points` = ?, `ATT_NAME` = ? WHERE 1;
--
-- DELETE template for table `Capitalization`
--
DELETE FROM `Capitalization` WHERE 0;