Setting up typeorm with nestjs not working migrations

Question

Here is the config:

@Module({
  imports: [
    TypeOrmModule.forRootAsync({
      imports: [ConfigModule],
      inject: [ConfigService],
      useFactory: (configService: ConfigService) => ({
        type: 'postgres',
        host: configService.get('DB_HOST'),
        port: configService.get('DB_PORT'),
        username: configService.get('DB_USER'),
        password: configService.get('DB_PASSWORD'),
        database: configService.get('DB_NAME'),
        entities: [
          __dirname + '/../**/*.entity{.ts,.js}',
        ],
        // synchronize: true,
      })
    }),
  ],
})
export class DatabaseModule {}

The connections with the database itself is working, but when I'm trying to set up the migrations it throws the errors. What I've tried is to add the migration options in the above config and to create additional ormconfig.js with the configurations. Here is what I have in package.json file:

"typeorm": "node --require ts-node/register ./node_modules/typeorm/cli.js"

The problem is when I try to create migration it is not being created in migrations folder as I want and is not using the config above, how to solve it?

do you know that when using typeorm's CLI you didn't have the access to that DatabaseModule, right? — Micael Levi
– Micael Levi, Commented Mar 7, 2022 at 16:49

Empty Brain · Accepted Answer · 2022-05-26 06:34:03Z

1

First, you need to set the migrations path in the module config

TypeOrmModule.forRootAsync({
    // other properties
    entities: [
      __dirname + '/../**/*.entity{.ts,.js}', // from the question
    ],
    migrations:[/*I assume you already know migration file paths*/]
})

then, To generate a migration file

npx typeorm migration:create -n FileName -d src/migrations

At this point, you need to call runMigrations(). add the below code in your main.ts

const conn = await getConnection('default'); // connection name is "default"
await conn.runMigrations();

edited May 26, 2022 at 6:34

answered May 26, 2022 at 6:26

Empty Brain

6379 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matheus Grandi · Accepted Answer · 2022-05-26 14:40:05Z

1

If you're using typeorm or 3.0 or newer versions you should do it straight on the cli:

typeorm migration:create src/migration_path

For older versions, you can add the following command to the ormconfig file:

  "cli": {
    "migrationDir": "./src/migration_path"
  }

edited May 26, 2022 at 14:40

answered May 25, 2022 at 20:42

Matheus Grandi

1911 silver badge5 bronze badges

1 Comment

Shamir Imtiaz Over a year ago

This should be the correct answer. However, just one more thing, if anyone need custom name for migration file then: typeorm migration:create src/migrations/CoffeeRefactor

Terenoth · Accepted Answer · 2022-03-08 10:25:41Z

0

TypeORM CLI reads the configuration in a file ormconfig.json or ormconfig.js at the root of the project.

You need to extract this config in suck a file and then import this file in your DatabaseModule to have both things working.

answered Mar 8, 2022 at 10:25

Terenoth

2,6281 gold badge16 silver badges22 bronze badges

Collectives™ on Stack Overflow

Setting up typeorm with nestjs not working migrations

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related