Can we exec a upsert?

[niuhuan]

I need the upsert function. I'm not found it form docs and issues.
I hope this operation will be implemented in SeaOrm. This can reduce error of writing raw sql.
I am a novice with rust. These codes are just my imagination.

let pear = fruit::ActiveModel {
    name: Set("Pear".to_owned()),     // update column if row exists
    nickname: SetOrKeep("pear chan"),     // not modify if row exists
    f_count: SetOrIncrease(1),     // Increase if row exists
    ..Default::default()
};

Their effect should be like this in the database

       
INSERT INTO fruit(id, name, nickname, f_count)
        VALUE ("Pear","pear chan",1) ON DUPLICATE KEY UPDATE name="Pear", f_count = f_count+1;

[RomainMazB]

The upsert function is not available yet, there is an active PR in sea-query that needs to be merged before this append in sea-orm.

Mentionned in:

• with 'ON CONFLICT DO UPDATE ' support? #187
• [Draft] support upsert sql  sea-query#167

[kudlatyamroth]

as Sebastien said here: #187 (comment)
on conflict is merged in sea orm in 0.24 :)