TIL 2020/10/6

typeOrm 쿼리빌더 where in문 사용법

const pet= await getConnection()
   .createQueryBuilder()
   .update(Pet)
   .set({deletedAt:new Date()})
   .whereInIds(petList)
   .returning('id')
   .execute()

const pet= await getConnection()
   .createQueryBuilder()
   .update(Pet)
   .set({deletedAt:new Date()})
   .where("id IN (:id)", { id: petList })
   .returning('id')
   .execute()