mirror of
https://github.com/OpenAPITools/openapi-generator.git
synced 2025-05-13 05:00:50 +00:00
1c51d4138e
* Add basic SQL queries template * Add namedParametersEnabled option * Move model related SQLs into Model folder * Update README template * Refresh samples
27 lines
561 B
SQL
27 lines
561 B
SQL
--
|
|
-- OpenAPI Petstore.
|
|
-- Prepared SQL queries for 'Pet' definition.
|
|
--
|
|
|
|
|
|
--
|
|
-- SELECT template for table `Pet`
|
|
--
|
|
SELECT `id`, `category`, `name`, `photoUrls`, `tags`, `status` FROM `Pet` WHERE 1;
|
|
|
|
--
|
|
-- INSERT template for table `Pet`
|
|
--
|
|
INSERT INTO `Pet`(`id`, `category`, `name`, `photoUrls`, `tags`, `status`) VALUES (?, ?, ?, ?, ?, ?);
|
|
|
|
--
|
|
-- UPDATE template for table `Pet`
|
|
--
|
|
UPDATE `Pet` SET `id` = ?, `category` = ?, `name` = ?, `photoUrls` = ?, `tags` = ?, `status` = ? WHERE 1;
|
|
|
|
--
|
|
-- DELETE template for table `Pet`
|
|
--
|
|
DELETE FROM `Pet` WHERE 0;
|
|
|