Repository navigation
No examples or support for select count(*) #2
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?
Activity
lganzzzo commentedon May 19, 2021
Hello @acidtonic ,
Please see this answer - oatpp/oatpp-sqlite#9 (comment)
Fro Postgres it works the same way