CODEWITHSUNDEEP
nestjsmikro-orm
GoldenLab88
GoldenLab88

Reputation: 204

MikroORM: How to use 'insert_id' for subsequent persists?

How can I get the insert_id (or existing id on duplicate key error) from a persist? I'd like to use it in following persists before flush.

In my mind, even though the EntityManager doesn't have an id yet, it could still populate that and use it during flush, but I think my thinking is flawed here, I'm new to MikroORM. From what I can see in the docs, I can only achieve this using the Query Builder.

Thanks for your help!

Upvotes: 0

Views: 248

Answers (1)

Martin Adámek
Martin Adámek

Reputation: 18389

You can just build the entity graph, the entity does not need to have a PK to be used in a relation:

const book = new Book(); // new entity, no PK
user.favorites.push(book); // doesnt matter if it has PK
await em.flush(); // if `user` was a managed entity, this will find the new book and save it to the database

console.log(book.id); // now we have the PK available on entity

In other words, the entity instance is what holds the identity, you use that, not the PK.

Upvotes: 1

Related Questions