MikroORM 4.1: Bulk updates

01-batch-insert.ts

for (let i = 1; i <= 5; i++) {
  const u = new User(`Peter ${i}`, `peter+${i}@foo.bar`);
  em.persist(u);
}

await em.flush();

// insert into `user` (`name`, `email`) values
//   ('Peter 1', 'peter+1@foo.bar'),
//   ('Peter 2', 'peter+2@foo.bar'),
//   ('Peter 3', 'peter+3@foo.bar'),
//   ('Peter 4', 'peter+4@foo.bar'),
//   ('Peter 5', 'peter+5@foo.bar');

02-batch-update.ts

for (const user of users) {
  user.name += ' changed!';
}

await em.flush();

// update `user` set
//   `name` = case 
//     when (`id` = 1) then 'Peter 1 changed!' 
//     when (`id` = 2) then 'Peter 2 changed!' 
//     when (`id` = 3) then 'Peter 3 changed!' 
//     when (`id` = 4) then 'Peter 4 changed!' 
//     when (`id` = 5) then 'Peter 5 changed!' 
//     else `priority` end 
//   where `id` in (1, 2, 3, 4, 5)

03-batch-delete.ts

em.remove(users);
await em.flush();

// delete from `user` where `id` in (1, 2, 3, 4, 5)