René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Having Role enum name in createUser from swagger fails with error.","articleBody":"Hi dear Leo.\r\nI have problem with enum in DTO_FIELD in createUser api execution.\r\nIf i remove the role from request, it works. couldn't figure it out why.\r\nAlso my db encoding is UTF8\r\nThanks in advance.\r\n\r\nRequest body:\r\n```json\r\n{\r\n  \"username\": \"string2\",\r\n  \"email\": \"string2\",\r\n  \"password\": \"string2\",\r\n  \"role\": \"ROLE_GUEST\"\r\n}\r\n```\r\nResponse:\r\n```json\r\n{\r\n  \"status\": \"ERROR\",\r\n  \"code\": 500,\r\n  \"message\": \"ERROR:  invalid byte sequence for encoding \\\"UTF8\\\": 0xdd 0xdd\\nCONTEXT:  unnamed portal parameter $4\\n\"\r\n}\r\n```\r\nAnd this is my DTO:\r\n\r\n```cpp\r\n#include OATPP_CODEGEN_BEGIN(DTO)\r\n\r\nENUM(Role, v_int32,\r\n     VALUE(GUEST, 0, \"ROLE_GUEST\"),\r\n     VALUE(ADMIN, 1, \"ROLE_ADMIN\")\r\n)\r\n\r\nclass UserDto : public oatpp::DTO {\r\n  \r\n  DTO_INIT(UserDto, DTO)\r\n\r\n  DTO_FIELD(String, id);\r\n  DTO_FIELD(String, userName, \"username\");\r\n  DTO_FIELD(String, email, \"email\");\r\n  DTO_FIELD(String, password, \"password\");\r\n  DTO_FIELD(Enum\u003cRole\u003e::AsString, role, \"role\");\r\n\r\n};\r\n\r\n#include OATPP_CODEGEN_END(DTO)\r\n```\r\nUserDb:\r\n```cpp\r\n  QUERY(createUser,\r\n        \"INSERT INTO AppUser\"\r\n        \"(id, username, email, password, role) VALUES \"\r\n        \"(uuid_generate_v4(), :user.username, :user.email, :user.password, :user.role)\"\r\n        \"RETURNING *;\",\r\n        PREPARE(true), // user prepared statement!\r\n        PARAM(oatpp::Object\u003cUserDto\u003e, user))\r\n```","author":{"url":"https://github.com/NoWhereMan1979","@type":"Person","name":"NoWhereMan1979"},"datePublished":"2024-03-12T12:27:06.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/8/example-postgresql/issues/8"}