William Cheng 56da2c00ca
Migrate schema samples to use OAS3 samples instead (#6294)
* migrate mysql samples to oas 3.0

* update apache2 to use oas3 spec

* migrate graphql samples to use oas3 spec

* move avro script under bin

* update protobuf samples to use openapi3 spec

* add new files
2020-05-14 17:24:19 +08:00

27 lines
1.3 KiB
SQL

--
-- OpenAPI Petstore.
-- Prepared SQL queries for 'NullableClass' definition.
--
--
-- SELECT template for table `NullableClass`
--
SELECT `integer_prop`, `number_prop`, `boolean_prop`, `string_prop`, `date_prop`, `datetime_prop`, `array_nullable_prop`, `array_and_items_nullable_prop`, `array_items_nullable`, `object_nullable_prop`, `object_and_items_nullable_prop`, `object_items_nullable` FROM `NullableClass` WHERE 1;
--
-- INSERT template for table `NullableClass`
--
INSERT INTO `NullableClass`(`integer_prop`, `number_prop`, `boolean_prop`, `string_prop`, `date_prop`, `datetime_prop`, `array_nullable_prop`, `array_and_items_nullable_prop`, `array_items_nullable`, `object_nullable_prop`, `object_and_items_nullable_prop`, `object_items_nullable`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
--
-- UPDATE template for table `NullableClass`
--
UPDATE `NullableClass` SET `integer_prop` = ?, `number_prop` = ?, `boolean_prop` = ?, `string_prop` = ?, `date_prop` = ?, `datetime_prop` = ?, `array_nullable_prop` = ?, `array_and_items_nullable_prop` = ?, `array_items_nullable` = ?, `object_nullable_prop` = ?, `object_and_items_nullable_prop` = ?, `object_items_nullable` = ? WHERE 1;
--
-- DELETE template for table `NullableClass`
--
DELETE FROM `NullableClass` WHERE 0;