I noticed someone earlier asked about a mulit-insert. I have written
one since I needed it. Seems to work well. Much faster than doing a
loop of single inserts. Maybe it could be added to the library. If
not, at least people will have an example of how to do it. Note, It
expects to recieve a vector.
// insert_multi expects a vector as input
template <class T> SQLQuery& insert_multi(const T &v) {
reset();
(static_cast<std::stringstream&>(*this)) << "INSERT INTO " <<
v[0].table() << " (" << v[0].field_list()
<< ") VALUES (" << v[0].value_list() << ")";
for (unsigned int i = 1; i < v.size(); i++)
{
(static_cast<std::stringstream&>(*this)) << ",(" <<
v[i].value_list() <<
")";
}
return *this;
}
