Upsert Support? about sqlpp11 HOT 4 CLOSED

On 2014-09-22 21:13, Thomas marsh wrote:

SQLite supports the "INSERT OR REPLACE" syntax for MERGE statements.
It doesn't look like this is supported in sqlpp11. Are there plans to
add this?

—
Reply to this email directly or view it on GitHub
#16.

As far as I can tell, INSERT OR REPLACE is not equivalent to MERGE
because it replaces ALL columns, not just those which are given in the
statement. Thus, INSERT OR REPLACE should be added to the sqlite connector.

That should be very simple, copy insert.h, move it into the sqlite3
namespace, replace the insert_t struct with an insert_or_replace struct
and add an insert_or_replace method. You might want to give that a try
(and send a pull request afterwards).

Otherwise, it will probably take a few more days :-)

Best,

Roland

from sqlpp11.

I just pushed a few commits to the develop branch of the sqlite3 connector. They give you insert_or_replace_into and insert_or_ignore_into, see tests/Sample.cpp (last two statements).

Please check and let me know.

from sqlpp11.

This looks good. Thank you for implementing that!

from sqlpp11.

Thanks for the request and the review.

It is the first extension of this kind. I am glad it worked out exactly as I had expected (and advertised at CppCon) :-)

from sqlpp11.