Is there a sea-orm equivalent to findOrCreate? How else would I do this? (programming.dev)

submitted 2 years ago by nerdblood@programming.dev to c/rust@programming.dev

11 comments fedilink hide all child comments

in sequelize (javascript) it's pretty straightforward to either find a record, or create it if it doesn't exist. I don't see anything similar with sea-orm. There's a 'save' method that seems to insert or update, but I need to know details about the record ahead of time :/

Any ideas?

https://sequelize.org/docs/v6/core-concepts/model-querying-finders/

you are viewing a single comment's thread
view the rest of the comments

[-] snaggen@programming.dev 3 points 2 years ago

I have never used sea-orm, but I wonder if .on_conflict could be used to simplify the code above?

[-] BitSound@lemmy.world 3 points 2 years ago

This is likely what OP will have to do. It actually looks like ANSI SQL now has merge, but you can scroll down a bit and see how each DB handles it slightly differently if you don't use merge.

[-] nerdblood@programming.dev 1 points 2 years ago

I think I had that in a few attempts, I can't remember why I removed it. Thanks for pointing this out.

this post was submitted on 24 Sep 2023

10 points (100.0% liked)

Rust

8258 readers

5 users here now

Welcome to the Rust community! This is a place to discuss about the Rust programming language.

Wormhole

!performance@programming.dev

Credits

The icon is a modified version of the official rust logo (changing the colors to a gradient and black background)

founded 3 years ago

MODERATORS

snowe@programming.dev

Ategon@programming.dev

EdTheLegendary@programming.dev

torcherist@programming.dev