René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"No examples or support for select count(*)","articleBody":"I have looked all over for an example to simply do a basic select COUNT(*) query.\r\n\r\nAfter wasting a good hour without any success, I'm throwing in the towel.\r\n\r\n```\r\n  QUERY(getAllUsersCount,\r\n        \"SELECT COUNT(*) FROM \\\"AppUser\\\";\")\r\n\r\n```\r\n\r\nOver in the service....\r\n\r\n```\r\n\r\n  auto dbCountResult = m_database_postgres-\u003egetAllUsersCount();\r\n  OATPP_ASSERT_HTTP(dbCountResult-\u003eisSuccess(), Status::CODE_500, dbCountResult-\u003egetErrorMessage());\r\n\r\n```\r\n\r\nFails with error I can't have anything that's not a container.\r\n\r\n\r\n```\r\n\r\n  auto total_count = dbCountResult-\u003efetch\u003coatpp::data::mapping::type::UInt32\u003e(); \r\n  auto total_count_list = dbCountResult-\u003efetch\u003coatpp::Vector\u003coatpp::Fields\u003coatpp::Any\u003e\u003e\u003e(); \r\n  auto total_count_list = dbCountResult-\u003efetch\u003coatpp::Vector\u003coatpp::Fields\u003c oatpp::UInt32\u003e\u003e\u003e(); \r\n```\r\n\r\nFails when I try to iterate the result, no methods begin/end and for each not working. Plus I expect one answer not many.\r\n\r\n\r\n\r\nWhy is this so hard?","author":{"url":"https://github.com/acidtonic","@type":"Person","name":"acidtonic"},"datePublished":"2021-05-19T17:38:33.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/2/example-postgresql/issues/2"}