I have been working on implementing a multi tenancy architecture using postgres. The functionality is all in place within the tenant service, but now I need to import this connection into a different module called shops. Can anyone provide guidance on how to achieve this? The code you are currently looking at relates to the tenant module.
import { TenantService } from './tenant.service';
import { TenantController } from './tenant.controller';
import { Global, Module, Scope } from '@nestjs/common';
import { REQUEST } from '@nestjs/core';
import { Connection, createConnection, getConnectionManager } from 'typeorm';
import * as tenantsOrmconfig from '@config/typeorm/tenant-ormconfig';
import * as ormconfig from '@config/typeorm/ormconfig';
import { ShopModule } from './shop/shop.module';
import { AwsService } from '@config/aws';
const connectionFactory = {
provide: 'CONNECTION',
scope: Scope.REQUEST,
useFactory: async (req) => {
const teamId = req.headers['x-team-id'];
console.log('xxxxxxxxxxxxxxxxxxx', teamId);
if (teamId) {
const connectionName = `${teamId}`;
const connectionManager = getConnectionManager();
if (connectionManager.has(connectionName)) {
const connection = connectionManager.get(connectionName);
return Promise.resolve(
connection.isConnected ? connection : connection.connect(),
);
}
return createConnection({
...tenantsOrmconfig,
entities: [
...(tenantsOrmconfig as any).entities,
...(ormconfig as any).entities,
],
name: connectionName,
type: 'postgres',
schema: connectionName,
});
}
},
inject: [REQUEST],
};
@Module({
imports: [ShopModule],
controllers: [TenantController],
providers: [connectionFactory, TenantService],
exports: ['CONNECTION'],
})
export class TenantModule {}
Below is an example of how the CONNECTION is utilized in the tenant service:
export class TenantService {
gameRepository;
constructor(@Inject('CONNECTION') connection) {
this.gameRepository = connection.getRepository(TenantEntity);
}