Insert or update (increment) about sqlite_orm HOT 13 CLOSED

Hello. How would you perform this with raw SQL?

from sqlite_orm.

insert into user_messages
values ('test','test', 1, 999, 4)
on conflict (user_id, guild_id)
do update set 
    message_counter = message_counter + 1,
    word_counter = word_counter + 999,
    attachment_counter = attachment_counter + 4;

from sqlite_orm.

message_counter = message_counter + 1

in SQL is translated to C++ as

assign(&UserMessages::word_counter, add(&UserMessages::word_counter, 1))

or

c(&UserMessages::word_counter) = c(&UserMessages::word_counter) + 1

from sqlite_orm.

I tried a second variant yesterday and thought I was using the wrong syntax.
Today I tried both variants.
But I still have an error..

Can u please see the repo and give me an advice?

from sqlite_orm.

@m1s1da you can debug easily if you print query value. What it contains?

from sqlite_orm.

"INSERT INTO \"user_messages\" 
(\"user_id\", \"guild_id\", \"message_counter\", \"word_counter\", \"attachment_counter\") 
VALUES (?, ?, ?, ?, ?) 
ON CONFLICT (\"user_messages\".\"user_id\") (\"user_messages\".\"guild_id\") 
DO UPDATE SET
 \"message_counter\" = \"user_messages\".\"message_counter\" + ?, 
\"word_counter\" = \"user_messages\".\"word_counter\" + ?, 
\"attachment_counter\" = \"user_messages\".\"attachment_counter\" + ?"

from sqlite_orm.

@m1s1da what error do you get?

from sqlite_orm.

terminate called after throwing an instance of 'std::system_error'
  what():  near "(": syntax error: SQL logic error
Signal: SIGABRT (Aborted)

in

    [[noreturn]] inline void throw_translated_sqlite_error(sqlite3* db) {
        throw sqlite_to_system_error(db);
    }

from sqlite_orm.

looks like a serialization bug in sqlite_orm on this line

ON CONFLICT (\"user_messages\".\"user_id\") (\"user_messages\".\"guild_id\") 

. According to SQLite docs it has to be

ON CONFLICT (\"user_messages\".\"user_id\", \"user_messages\".\"guild_id\") 

from sqlite_orm.

I attached my repo w/ link to request string.
And I commented all other libs and code in this branch.
Hope this can be helpful.

from sqlite_orm.

@m1s1da try to replace on_conflict(&UserMessages::user_id, &UserMessages::guild_id) with on_conflict(columns(&UserMessages::user_id, &UserMessages::guild_id)). Your case have to contain columns call cause this is how it is designed to work https://github.com/fnc12/sqlite_orm/blob/master/tests/statement_serializer_tests/ast/upsert_clause.cpp#L94

from sqlite_orm.

@m1s1da did it work?

from sqlite_orm.

closing due to inactivity. Feel free to reopen in case

from sqlite_orm.