First time user issue

[DBizz22]

How to perform Bulk operations that support user-defined data types with std::vector.

I think the issue is from the Unknown missing class methods like
void convert_from_base() SOCI_OVERRIDE
void resize(std::size_t sz) SOCI_OVERRIDE
std::size_t size() const SOCI_OVERRIDE

Logs

[main] Building folder: C:/Users/BIZZ/Documents/Vscode/Projects/Stock_Market_Simulator/build/MinGW Debug Config 
[build] Starting build
[proc] Executing command: C:\msys64\ucrt64\bin\cmake.EXE --build "C:/Users/BIZZ/Documents/Vscode/Projects/Stock_Market_Simulator/build/MinGW Debug Config" --target mySqlClient --
[build] Built target databaseClientInterface
[build] Building CXX object bin/lib/database/mysql/CMakeFiles/mySqlClient.dir/mySqlClient.cpp.obj
[build] In file included from C:/msys64/ucrt64/include/soci/column-info.h:12,
[build]                  from C:/msys64/ucrt64/include/soci/soci.h:16,
[build]                  from C:/Users/BIZZ/Documents/Vscode/Projects/Stock_Market_Simulator/src/lib/database/databaseClient.hpp:6,
[build]                  from C:/Users/BIZZ/Documents/Vscode/Projects/Stock_Market_Simulator/src/lib/database/mysql/include/mySqlClient.hpp:4,
[build]                  from C:\Users\BIZZ\Documents\Vscode\Projects\Stock_Market_Simulator\src\lib\database\mysql\mySqlClient.cpp:1:
[build] C:/msys64/ucrt64/include/soci/type-conversion.h: In instantiation of 'class soci::details::conversion_into_type<std::vector<database::ProfileRecord> >':
[build] C:/msys64/ucrt64/include/soci/type-conversion.h:432:26:   required from 'soci::details::into_type_ptr soci::details::do_into(std::vector<T>&, std::vector<soci::indicator>&, user_type_tag) [with T = database::ProfileRecord; into_type_ptr = type_ptr<into_type_base>]'
[build]   432 |     return into_type_ptr(new conversion_into_type<std::vector<T> >(t, ind));
[build]       |                          ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[build] C:/msys64/ucrt64/include/soci/into.h:83:28:   required from 'soci::details::into_type_ptr soci::into(std::vector<T>&, std::vector<indicator>&) [with T = database::ProfileRecord; details::into_type_ptr = details::type_ptr<details::into_type_base>]'
[build]    83 |     return details::do_into(t, ind,
[build]       |            ~~~~~~~~~~~~~~~~^~~~~~~~
[build]    84 |         typename details::exchange_traits<std::vector<T> >::type_family());
[build]       |         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[build] C:\Users\BIZZ\Documents\Vscode\Projects\Stock_Market_Simulator\src\lib\database\mysql\mySqlClient.cpp:187:29:   required from here
[build]   187 |     sql << query, soci::into(profiles, ind);
[build]       |                   ~~~~~~~~~~^~~~~~~~~~~~~~~
[build] C:/msys64/ucrt64/include/soci/type-conversion.h:236:17: error: 'std::size_t soci::details::conversion_into_type<std::vector<T> >::size() const [with T = database::ProfileRecord; std::size_t = long long unsigned int]' marked 'override', but does not override
[build]   236 |     std::size_t size() const SOCI_OVERRIDE
[build]       |                 ^~~~
[build] C:/msys64/ucrt64/include/soci/type-conversion.h:247:10: error: 'void soci::details::conversion_into_type<std::vector<T> >::resize(std::size_t) [with T = database::ProfileRecord; std::size_t = long long unsigned int]' marked 'override', but does not override
[build]   247 |     void resize(std::size_t sz) SOCI_OVERRIDE
[build]       |          ^~~~~~
[build] C:/msys64/ucrt64/include/soci/type-conversion.h:257:10: error: 'void soci::details::conversion_into_type<std::vector<T> >::convert_from_base() [with T = database::ProfileRecord]' marked 'override', but does not override
[build]   257 |     void convert_from_base() SOCI_OVERRIDE

from code

#include "soci/soci.h"
#include "soci/mysql/soci-mysql.h"

namespace soci
{
    template <>
    struct type_conversion<database::ProfileRecord>
    {
        typedef values base_type;

        static void from_base(values const &v, indicator ind, database::ProfileRecord &p)
        {
            p.ID = v.get<unsigned int>("ID", 0);
            p.accountID = v.get<unsigned int>("account", 0);
            p.name = v.get<std::string>("name", "");
            p.currency = v.get<std::string>("currency", "");
            p.initialValue = v.get<double>("initialValue", 0);
        }

        static void to_base(const database::ProfileRecord &p, values &v, indicator &ind)
        {
            v.set("ID", p.ID);
            v.set("account", p.accountID);
            v.set("name", p.name);
            v.set("currency", p.currency);
            v.set("initialValue", p.initialValue);
        }
    };
}

std::vector<database::ProfileRecord> database::mysql::MySQLClient::getProfiles(const unsigned int &accountID)
{
    std::vector<database::ProfileRecord> profiles(MAX_PROFILES);
    std::vector<soci::indicator> ind(MAX_PROFILES);
    std::string query = "SELECT * FROM profiles WHERE account = " + std::to_string(accountID);
    sql << query, soci::into(profiles, ind);
    std::vector<soci::indicator>::iterator ptr = std::find(ind.begin(), ind.end(), soci::i_null);
    if (ptr != ind.end())
        profiles.clear();
    return profiles;
}

[vadz]

How to perform Bulk operations that support user-defined data types with std::vector.

There is the "Into vector of custom type objects" test in tests/common-tests.h checking for this. It's not immediately obvious how is your case different, please try to modify the existing test to show the same problem to make it more clear.

[DBizz22]

How to perform Bulk operations that support user-defined data types with std::vector.

There is the "Into vector of custom type objects" test in tests/common-tests.h checking for this. It's not immediately obvious how is your case different, please try to modify the existing test to show the same problem to make it more clear.

I just read in the issue at
#764 (comment)
with your response at
#764 (comment)
that bulk operations using std::vector with custom data types via object-relational mapping do not work, is that still the case?
This seems to be the same issue I encountered

[vadz]

Ah, yes, I remember this now and also see that you're doing select * in your query — which is definitely not going to work. So, no, mapping multiple columns to a single value like this is not supported currently and I don't think it's going to be possible to implement this efficiently: we need an actual vector of data to perform bulk operations.