NestJS & TypeORM QueryFailedError Exception Filter

query-failed-exception.filter.ts

import { PG_UNIQUE_VIOLATION } from '@drdgvhbh/postgres-error-codes';
import {
  ArgumentsHost,
  Catch,
  ConflictException,
  HttpException,
  InternalServerErrorException,
} from '@nestjs/common';
import { BaseExceptionFilter } from '@nestjs/core';
import { QueryFailedError } from 'typeorm';

@Catch(QueryFailedError)
export class QueryFailedExceptionFilter extends BaseExceptionFilter {
  override catch(exception: QueryFailedError, host: ArgumentsHost) {
    let httpException: HttpException;
    switch (exception.driverError.code) {
      case PG_UNIQUE_VIOLATION:
        httpException = new ConflictException(exception.message);
        break;
      default:
        httpException = new InternalServerErrorException(exception.message);
    }
    super.catch(httpException, host);
  }
}