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/

  • snaggen
    3·
    1 year 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·
      1 year 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.

    • nerdbloodOP
      1·
      1 year ago

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