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
591 B
SQL
27 lines
591 B
SQL
--
|
|
-- OpenAPI Petstore.
|
|
-- Prepared SQL queries for 'Order' definition.
|
|
--
|
|
|
|
|
|
--
|
|
-- SELECT template for table `Order`
|
|
--
|
|
SELECT `id`, `petId`, `quantity`, `shipDate`, `status`, `complete` FROM `Order` WHERE 1;
|
|
|
|
--
|
|
-- INSERT template for table `Order`
|
|
--
|
|
INSERT INTO `Order`(`id`, `petId`, `quantity`, `shipDate`, `status`, `complete`) VALUES (?, ?, ?, ?, ?, ?);
|
|
|
|
--
|
|
-- UPDATE template for table `Order`
|
|
--
|
|
UPDATE `Order` SET `id` = ?, `petId` = ?, `quantity` = ?, `shipDate` = ?, `status` = ?, `complete` = ? WHERE 1;
|
|
|
|
--
|
|
-- DELETE template for table `Order`
|
|
--
|
|
DELETE FROM `Order` WHERE 0;
|
|
|