-
Couldn't load subscription status.
- Fork 20
Open
@acidtonic
Description
I have looked all over for an example to simply do a basic select COUNT(*) query.
After wasting a good hour without any success, I'm throwing in the towel.
QUERY(getAllUsersCount,
"SELECT COUNT(*) FROM \"AppUser\";")
Over in the service....
auto dbCountResult = m_database_postgres->getAllUsersCount();
OATPP_ASSERT_HTTP(dbCountResult->isSuccess(), Status::CODE_500, dbCountResult->getErrorMessage());
Fails with error I can't have anything that's not a container.
auto total_count = dbCountResult->fetch<oatpp::data::mapping::type::UInt32>();
auto total_count_list = dbCountResult->fetch<oatpp::Vector<oatpp::Fields<oatpp::Any>>>();
auto total_count_list = dbCountResult->fetch<oatpp::Vector<oatpp::Fields< oatpp::UInt32>>>();
Fails when I try to iterate the result, no methods begin/end and for each not working. Plus I expect one answer not many.
Why is this so hard?
Metadata
Metadata
Assignees
Labels
No labels