forked from loafle/openapi-generator-original
1c51d4138e
* Add basic SQL queries template * Add namedParametersEnabled option * Move model related SQLs into Model folder * Update README template * Refresh samples
27 lines
462 B
SQL
27 lines
462 B
SQL
--
|
|
-- OpenAPI Petstore.
|
|
-- Prepared SQL queries for 'Dog' definition.
|
|
--
|
|
|
|
|
|
--
|
|
-- SELECT template for table `Dog`
|
|
--
|
|
SELECT `className`, `color`, `breed` FROM `Dog` WHERE 1;
|
|
|
|
--
|
|
-- INSERT template for table `Dog`
|
|
--
|
|
INSERT INTO `Dog`(`className`, `color`, `breed`) VALUES (?, ?, ?);
|
|
|
|
--
|
|
-- UPDATE template for table `Dog`
|
|
--
|
|
UPDATE `Dog` SET `className` = ?, `color` = ?, `breed` = ? WHERE 1;
|
|
|
|
--
|
|
-- DELETE template for table `Dog`
|
|
--
|
|
DELETE FROM `Dog` WHERE 0;
|
|
|