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
674 B
SQL
27 lines
674 B
SQL
--
|
|
-- OpenAPI Petstore.
|
|
-- Prepared SQL queries for 'User' definition.
|
|
--
|
|
|
|
|
|
--
|
|
-- SELECT template for table `User`
|
|
--
|
|
SELECT `id`, `username`, `firstName`, `lastName`, `email`, `password`, `phone`, `userStatus` FROM `User` WHERE 1;
|
|
|
|
--
|
|
-- INSERT template for table `User`
|
|
--
|
|
INSERT INTO `User`(`id`, `username`, `firstName`, `lastName`, `email`, `password`, `phone`, `userStatus`) VALUES (?, ?, ?, ?, ?, ?, ?, ?);
|
|
|
|
--
|
|
-- UPDATE template for table `User`
|
|
--
|
|
UPDATE `User` SET `id` = ?, `username` = ?, `firstName` = ?, `lastName` = ?, `email` = ?, `password` = ?, `phone` = ?, `userStatus` = ? WHERE 1;
|
|
|
|
--
|
|
-- DELETE template for table `User`
|
|
--
|
|
DELETE FROM `User` WHERE 0;
|
|
|