In my efforts to reset the TypeORM MySQL database upon server shutdown in NestJS, I am exploring different approaches

Question

In my efforts to reset the TypeORM MySQL database upon server shutdown in NestJS, I am exploring different approaches

I am looking for a way to clear all entries in my database when the server shuts down. Can anyone help with this?

export class RoomsService {
  async onApplicationShutdown() {
    await this.roomService.deleteAll()
  }

async deleteAll(): Promise<DeleteResult> {
    const res = await this.roomRepository.delete('*');
    return res;
  }

During shutdown, I encounter this error message (even without using async/await)

Error: Pool is closed.
at C:\Users\Admin\Desktop\sites\UltimatePartyRoom\upr-server\node_modules\mysql2\lib\pool.js:39:40
at processTicksAndRejections (node:internal/process/task_queues:77:11)

mysql typescript express nestjs typeorm

Answer 1

Answer №1

The issue arises when attempting to close the application (onApplicationShutdown) as the database connection is already severed. To resolve this, it is necessary to clear the database before reaching this point.

Instead of using onApplicationShutdown, consider utilizing OnModuleDestroy as shown below:

export class RoomsService implements OnModuleDestroy {
  async onModuleDestroy() {
    await this.roomService.deleteAll()
  }
}

Answer 2

The issue arises when attempting to close the application (onApplicationShutdown) as the database connection is already severed. To resolve this, it is necessary to clear the database before reaching this point.

Instead of using onApplicationShutdown, consider utilizing OnModuleDestroy as shown below:

export class RoomsService implements OnModuleDestroy {
  async onModuleDestroy() {
    await this.roomService.deleteAll()
  }
}

In my efforts to reset the TypeORM MySQL database upon server shutdown in NestJS, I am exploring different approaches

Answer №1

Similar questions

To overcome the 401 (Unauthorized) error on specific requests, how can one bypass it when trying to access http://localhost:3000/user/auth

Updating Angular model remotely without relying solely on the controller

Ways to display information that lacks significance

What are the most effective methods for handling extensive "task queues" or "input queues"?

Encountering Angular Material UI issues following the transition from version 11 to 12

Error: Visual Studio unable to locate Firebase node module

What is the best way to utilize the next-env.d.ts file within Next.js?

An asynchronous function operates incessantly

Struggling to make type definitions work in react-hook-form 7

Typescript's dynamic React component and its conditional types

Utilizing Next.js with a unique custom Node.js backend implementation

Experiment with redirect testing in Jest with Express

What is the best way to enable the delete function exclusively for users who are logged in?

The data type 'string | boolean | null' cannot be assigned to type 'boolean'. Specifically, the type 'null' cannot be assigned to type 'boolean'

Save the file to a specific folder and compress the entire folder into a

When considering Angular directives, which is more suitable for this scenario: structural or attribute?

What Google Domain Verification APIs are needed for verifying domains in Pub/Sub?

The `forEach` method cannot be called on an undefined node.js

Issue with special characters while exporting PHP data to Excel

The authentication method "discord" is not recognized