No examples or support for select count(*)

[acidtonic]

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?

[lganzzzo]

Hello @acidtonic ,

Please see this answer - https://github.com/oatpp/oatpp-sqlite/issues/9#issuecomment-719143050 Fro Postgres it works the same way