Bulk update via raw query in typeorm

typeorm bulkupdate
Max picture Max · Dec 15, 2018 · Viewed 9.1k times · Source

How can I do bulk update via raw query in typeorm?
For example we have model User with property name
How can I change names of few users in one transaction?

typeorm version: 0.2.7
database: postgress

Answer

aitchkhan picture aitchkhan · Jun 1, 2020

To bulk update, you can use update with set method, it is always recommended to not use raw queries when you can use orm functions.


import {getConnection, In} from "typeorm";
const userIds = [1,2,3];

await getConnection()
  .createQueryBuilder()
  .update(User)
  .set({ isaSeniorCitizen: true })
  .where({ id: In(userIds) })
  .execute();

Related questions

TypeError: Class extends value undefined is not a function or null

I am getting the following error when trying to create these entities. TypeError: Class extends value undefined is not a function or null I am assuming this has something to do with circular dependencies, but how is that supposed to …

Read More
TypeORM subqueries

Based on typeORM docs on using subqueries, there are explained how to create subqueries. Example: const qb = await getRepository(Post).createQueryBuilder("post"); const posts = qb .where("post.title IN " + qb.subQuery().select("user.name").from(User, "user").where("user.registered = :…

Read More
TypeORM upsert - create if not exist

Does TypeORM include some functionnality to avoid this : let contraption = await thingRepository.findOne({ name : "Contraption" }); if(!contraption) // Create if not exist { let newThing = new Thing(); newThing.name = "Contraption" await thingRepository.save(newThing); contraption = newThing; } Something like : let contraption = await thingRepository.…

Read More