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
471 B
SQL
27 lines
471 B
SQL
--
|
|
-- OpenAPI Petstore.
|
|
-- Prepared SQL queries for 'Cat' definition.
|
|
--
|
|
|
|
|
|
--
|
|
-- SELECT template for table `Cat`
|
|
--
|
|
SELECT `className`, `color`, `declawed` FROM `Cat` WHERE 1;
|
|
|
|
--
|
|
-- INSERT template for table `Cat`
|
|
--
|
|
INSERT INTO `Cat`(`className`, `color`, `declawed`) VALUES (?, ?, ?);
|
|
|
|
--
|
|
-- UPDATE template for table `Cat`
|
|
--
|
|
UPDATE `Cat` SET `className` = ?, `color` = ?, `declawed` = ? WHERE 1;
|
|
|
|
--
|
|
-- DELETE template for table `Cat`
|
|
--
|
|
DELETE FROM `Cat` WHERE 0;
|
|
|