Codxplore.com

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

953
Views
TypeORM: How to bind parameters in where clause for SelectQueryBuilder

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
1040
Views
How to use getManyAndCount function in SelectQueryBuilder

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)        
900
Views
Upload and Delete File into AWS S3 using Node.js

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
2671
Views
Typeorm findAndCount relational table filter

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
6052
Views
Generates models for TypeORM from existing databases

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

Subscribe Us


Follow Us