Nest Repository Shortcut Methods (TypeORM)

For specific CRUD actions like save, remove, insert, update, delete, count, softDelete, merge, restore.

Simplified Find

• repository.findBy(where: FindOptionsWhere): Equivalent to repository.find({ where: ... }).
• repository.findOneBy(where: FindOptionsWhere): Equivalent to repository.findOne({ where: ... }).
• repository.findAndCountBy(where: -- FindOptionsWhere): Equivalent to repository.findAndCount({ where: ... }).

They don't offer the other options like relations, select, order, skip, take, etc.

FindManyOptions and FindOneOptions

FindManyOptions: Used with repository.find() or repository.findAndCount() to retrieve multiple entities. It allows you to specify:

• where:
• relations: Eager Loading (avoiding N+1 query problems) load in advance.
• select:
• order: order: { createdAt: 'DESC' }
• skip: Offset (current page)
• take: Limit (total page)
• cache: Enables or disables query result caching.
• withDeleted: Includes soft-deleted entities if you're using @DeleteDateColumn.
• lock: Enables locking mechanisms for the query (primarily for findOne).

FindOptionsWhere

const where: FindOptionsWhere<Task> = {};

• where: { id: 1, name: 'Alice' }
• Logical OR: where: [{ name: 'Alice' }, { age: 30 }]
• Nested Relations: where: { project: { name: 'TypeORM' } } TypeORM FindOperators: (for complex query)
• Not: where: { title: Not('About #1') }
• LessThan, LessThanOrEqual: where: { likes: LessThan(10) }
• MoreThan, MoreThanOrEqual: where: { views: MoreThanOrEqual(100) }
• Like, ILike (case-insensitive Like): where: { title: Like('%keyword%') }
• Between: where: { date: Between('2023-01-01', '2023-12-31') }
• In: where: { id: In([1, 2, 3]) }
• Any: where: { tags: Any(['nest', 'typeorm']) } (for array columns)
• IsNull: where: { description: IsNull() }
• Raw: For when you need to write raw SQL within the where clause (use with caution to avoid SQL injection): where: { createdAt: Raw(alias =>${alias} > NOW() - INTERVAL '7 days') }

Query Builder (SelectQueryBuilder, InsertQueryBuilder, UpdateQueryBuilder, DeleteQueryBuilder)

When you need fine-grained control over joins, subqueries, complex WHERE conditions, group by, having, etc.

repository.createQueryBuilder('tablename')

• select(columns: string | string[]): Specifies columns to select.
• addSelect(columns: string | string[]): Adds more columns to select.
• from(entity: EntityTarget, tablename: string): Defines the main entity and its tablename.
• where(condition: string, parameters?: ObjectLiteral): Adds a WHERE condition. You can use parameterized queries for safety.
• andWhere(condition: string, parameters?: ObjectLiteral): Adds an AND condition.
• orWhere(condition: string, parameters?: ObjectLiteral): Adds an OR condition.
• leftJoinAndSelect(relation: string, tablename: string): Joins and selects columns from a related entity.
• innerJoinAndSelect(relation: string, tablename: string): Similar to leftJoinAndSelect but uses an INNER JOIN.
• orderBy(sort: string, order?: 'ASC' | 'DESC', nulls?: 'NULLS FIRST' | 'NULLS LAST'): Sets the ordering.
• groupBy(column: string): Groups results.
• having(condition: string, parameters?: ObjectLiteral): Adds a HAVING condition.
• skip(offset: number): Pagination offset.
• take(limit: number): Pagination limit.
• getMany(): Executes the query and returns multiple entities.
• getOne(): Executes the query and returns a single entity.
• getManyAndCount(): Executes the query and returns both entities and their total count.
• getCount(): Returns only the count of results.
• insert().into().values(): For bulk inserts.
• update().set().where(): For bulk updates.
• delete().from().where(): For bulk deletes.