Building Secure RESTful APIs with NestJS: A Practical Guide/

...

/

Configure TypeORM and Database Connection

Configure TypeORM and Database Connection

Explore how to set up TypeORM and manage multiple runtime settings.

We'll cover the following...

Set up TypeORM in NestJS

In this lesson, we’ll delve into TypeORM configuration and establish a database connection in the NestJS app. We’ll also explore how to manage and store database settings in different environments securely.

Install the dependencies

First, we must install the dependencies.

npm install typeorm @nestjs/typeorm mysql
Install the dependencies

The packages are given below:

  • typeorm: This is the main package for TypeORM.

  • @nestjs/typeorm: This is a package for the integration of TypeORM with NestJS.

  • mysql: This is a package that provides a JavaScript API for connecting, querying, and managing MySQL databases.

Create the database

Then, we create a new database in the MySQL database using the following SQL scripts. Note that the database is already provisioned in the live code editor. Therefore, the script is for reference.

Press + to interact
// Script to create a database
CREATE DATABASE AddressBook;

TypeORM configuration

To integrate TypeORM into the app, we need to add the following code to AppModule:

Press + to interact
// app.module.ts
@Module({
  imports: [
    ...,
    TypeOrmModule.forRoot(
      {
        type: 'mysql',
        host: 'localhost',
        port: 3306,
        username: 'appuser',
        password: 'password',
        database: 'AddressBook',
        entities: [AddressEntity],
        synchronize: true,
      }
    ),
    ...
  ],
  ...
})

Here, we use the TypeOrmModule.forRoot method to set up the configuration for TypeORM. ...