How do you implement soft deletes in NestJS with TypeORM?

Q: How do you implement soft deletes in NestJS with TypeORM?

@Entity('users') export class User { @PrimaryGeneratedColumn() id: number; @Column() email: string; @DeleteDateColumn() // null = active, timestamp = soft-deleted deletedAt?: Date; } @Injectable() export class UsersService { constructor( @InjectRepository(User) private repo: Repository , ) {} // Soft delete — sets deletedAt, keeps the row async softDelete(id: number): Promise { await this.repo.softDelete(id); } // Hard delete — removes the row permanently async hardDelete(id: number): Promise { await this.repo.delete(id); } // Restore a soft-deleted record async restore(id: number): Promise { await this.repo.restore(id); } // Include soft-deleted records findAllIncludingDeleted(): Promise { return this.repo.find({ withDeleted: true }); } // Only soft-deleted records findDeleted(): Promise { return this.repo.find({ withDeleted: true, where: { deletedAt: Not(IsNull()) }, }); } } @DeleteDateColumn() activates TypeORM's built-in soft delete support — no manual WHERE clause needed. All standard find() queries automatically exclude soft-deleted records when @DeleteDateColumn is present. softDelete() sets the timestamp; delete() permanently removes the row. restore() clears the deletedAt timestamp, making the record visible again in standard queries. Use withDeleted: true in find options when you need to include or operate on soft-deleted records.

Difficulty: 5/10

soft delete, TypeORM decorators, NestJS repository

Add @DeleteDateColumn() to the entity — TypeORM automatically excludes soft-deleted records from all queries when this column is present. Use softDelete() to set the timestamp, delete() to hard delete, restore() to recover, and { withDeleted: true } in find options to include soft-deleted records.

Soft delete with @DeleteDateColumn

Soft delete implementation notes:

1
@DeleteDateColumn() activates TypeORM's built-in soft delete support — no manual WHERE clause needed.
2

How do you implement soft deletes in NestJS with TypeORM?

Difficulty: 5/10

soft delete, TypeORM decorators, NestJS repository

Add @DeleteDateColumn() to the entity — TypeORM automatically excludes soft-deleted records from all queries when this column is present. Use softDelete() to set the timestamp, delete() to hard delete, restore() to recover, and { withDeleted: true } in find options to include soft-deleted records.

Soft delete with @DeleteDateColumn

Soft delete implementation notes:

1
@DeleteDateColumn() activates TypeORM's built-in soft delete support — no manual WHERE clause needed.
2

How do you implement soft deletes in NestJS with TypeORM?

Add @DeleteDateColumn() to the entity — TypeORM automatically excludes soft-deleted records from all queries when this column is present. Use softDelete() to set the timestamp, delete() to hard delete, restore() to recover, and { withDeleted: true } in find options to include soft-deleted records.

How do you implement soft deletes in NestJS with TypeORM?

Add @DeleteDateColumn() to the entity — TypeORM automatically excludes soft-deleted records from all queries when this column is present. Use softDelete() to set the timestamp, delete() to hard delete, restore() to recover, and { withDeleted: true } in find options to include soft-deleted records.

Scenario Questions

Follow-up Questions