How to get soci::rowset in sql query

Question

I have a table with a column name and age.

And I am trying to get all name as

soci::session& sql_session(conn->Session());
soci::rowset<std::string> rs = sql_session.prepare << select name from Person;
std::vector<std::string> plist;
std::copy(rs.begin(), rs.end(), plist.begin());

But my program crashes at std::copy. Seems like both the containers(source and destination) are not same for std::copy. can we do this using ORM, how?

[std::back_inserter](https://en.cppreference.com/w/cpp/iterator/back_inserter) — rafix07, Oct 30 '19 at 08:25

score 0 · Answer 1 · answered Dec 01 '19 at 12:00

If you need to read only strings it is not to use rowset, in that case you don't need to copy:

const size_t namesLimit = 100;
std::vector<std::string> plist(namesLimit);
soci::session sql_session(...); // connection details
sql_session << "select name from Person;", into(plist);

Of course if you need to get all names without hardcoding limit you can use earlier:

size_t namesLimit ;
sql_session << "select count(*) from Person", into(namesLimit);

How to get soci::rowset in sql query

1 Answers1