Latest news:
Sahih al-Bukhari (সহীহ বুখারী) is a free Hadith application for android. This application is advertisement free. Download now https://play.google.com/store/apps/details?id=com.akramhossin.bukharisharif
TypeORM: How to bind parameters in where clause for SelectQueryBuilder
Parameters used for
- As placeholders for the dynamic values in the query
- To prevent SQL injection
Example
let businessArtists: Artists[] = await getRepository(Artists)
.createQueryBuilder('artists')
.leftJoin(LocationArtists, 'location_artists', 'artists.artist_id = location_artists.artist_id')
.where("artists.business_id =:business_id AND artists.is_active =:is_active AND artists.is_deleted=:is_deleted AND location_artists.location_id=:location_id", {
business_id: business.businessId,
is_active: 1,
is_deleted: 0,
location_id: locationId,
})
.getMany()
Tags : javascript, Nodejs, Typeorm, TypeScript,
Views : 954
