Multiple databases with Sequelize about sequelize

[picbenoit]

After a lot of tries and checking TypeORM issues, I find a solution to my issue.

The name of the connection must be outside the useFactory, like this :

  SequelizeModule.forRootAsync({
    imports: [ConfigModule],
    // HERE
    name: 'heroku',
    useFactory: (configService: ConfigService) => ({
      // NOT HERE
      // name: 'heroku',
      dialect: 'postgres',
      host: configService.get<string>('heroku.host'),
      port: configService.get<number>('heroku.port'),
      username: configService.get<string>('heroku.user'),
      password: configService.get<string>('heroku.password'),
      database: configService.get<string>('heroku.database'),
      schema: configService.get<string>('heroku.schema'),
      autoLoadModels: true,
      synchronize: false,
    }),
    inject: [ConfigService],
  })

[kamilmysliwiec]

Please provide a minimum reproduction repository.

[picbenoit]

Hello @kamilmysliwiec

I thought I had put the essentials. Whick parts of code do you need more ?

I was a project with one connection worked well. I tried to put a new postgres connection whom I named heroku. The first one does not have name (default). I create a new module Accounts, with module, service and model files (module and service file are shown above).

I specify "heroku" connection for my account model :
SequelizeModule.forFeature([Account], 'heroku')

@InjectModel(Account, 'heroku')

And I finally obtain "Nest can't resolve dependencies of the AccountsService (?, heroku_AccountRepository). Please make sure that the argument herokuConnection at index [0] is available in the AccountsModule context."

If I do not put "heroku" connection parameter, my app is compiling.