Update using Query Builder
You can create UPDATE
queries using QueryBuilder
. Examples:
await dataSource
.createQueryBuilder()
.update(User)
.set({ firstName: "Timber", lastName: "Saw" })
.where("id = :id", { id: 1 })
.execute()
This is the most efficient way in terms of performance to update entities in your database.
Raw SQL support
In some cases when you need to execute SQL queries you need to use function style value:
await dataSource
.createQueryBuilder()
.update(User)
.set({
firstName: "Timber",
lastName: "Saw",
age: () => "age + 1",
})
.where("id = :id", { id: 1 })
.execute()
Warning: When using raw SQL, ensure that values are properly sanitized to prevent SQL injection.
Last updated
Was this helpful?