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
482
Views
Views
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.busi
478
Views
Views
How to use getManyAndCount function in SelectQueryBuilder
TypeScript code snippets using typeorm.SelectQueryBuilder.getManyAndCount
const [models, pageCount] = await getRepository(Businesses)
.createQueryBuilder('businesses')
.leftJoinAndSelect("businesses.locations", "locations")
.where("is_active = 1")
.andWhere("is_deleted = 0")
.skip(offset)
741
Views
Views
Upload and Delete File into AWS S3 using Node.js
In this blog post i will explain how to upload and delete file in AWS S3 using aws-sdk.
To getting started we need to install aws-sdk npm package to our Node.js application. To install aws-sdk in any Node.js project
run the following command in your terminal
$ npm install aws-sdk
After successful installation of aws-sdk package. You need to provide credentials to AWS so that only your account
2415
Views
Views
Typeorm findAndCount relational table filter
To filter relational table in TypeORM using findAndCount there is a workaround. To filtering based on relation fields for findAndCount.
We need to use ObjectLiteral-style where using this style conditions are works perfectly.
Assume that we have Three entities – products,attributeSet and woodType. products belongs to one attributeSet and one woodType,
attributeSet and woodType has many prod
5387
Views
Views
Generates models for TypeORM from existing databases
Typeorm is an ORM Which run in NodeJS, PhoneGap, Cordova, Ionic, Browser, NativeScript, Expo, React Native and Electron platforms.
We can use TypeORM with TypeScript and JavaScript (ES5, ES6, ES7, ES8).
TypeORM is highly influenced by other ORMs such as Entity Framework, Hibernate, Doctrine.
To generate model using TypeORM from existing database we need to install typeorm-model-generator. To
