Using in TypeOrm in Nestjs

[EladProject]

Hi,
I'd like to use pg-mem as a mock DB for component testing.
I guess my question is how to incorporate pg-mem into Nestjs' TypeOrmModule?

This is what I tried:

@Module({
  imports: [
    TypeOrmModule.forRootAsync({
      imports: [TypeormLoggerModule],
      inject: [TypeormLoggerService],
      useFactory: async (loggerService: TypeormLoggerService): Promise<any> => {
        const db = newDb({
          // 👉 Recommanded when using Typeorm .synchronize(), which creates foreign keys but not indices !
          autoCreateForeignKeyIndices: true,
        });

        //==== create a Typeorm connection
        const got: Connection = await db.adapters.createTypeormConnection({
          type: 'postgres',
          entities: [BooksEntity, AuthorEntity]
        });

        return got;
      }
    })
  ]
})
export class MockDatabaseModule {
}

but I get a "AlreadyHasActiveConnectionError: Cannot create a new connection named "default", because connection with such name already exist and it now has an active connection session." error when running

Any suggestion how to make it work?

[EladProject]

Ok,
Found my answer here: nestjs/typeorm#719

[EladProject]

Now the issue is:

QueryFailedError: relation "pg_views" does not exist

🐜 This seems to be an execution error, which means that your request syntax seems okay,
but the resulting statement cannot be executed → Probably not a pg-mem error.

*️⃣ Failed SQL statement: SELECT 'DROP VIEW IF EXISTS "' || schemaname || '"."' || viewname || '" CASCADE;' as "query" FROM "pg_views" WHERE "schemaname" IN (current_schema()) AND "viewname" NOT IN ('geography_columns', 'geometry_columns', 'raster_columns', 'raster_overviews');

Does pg-mem support internal tabkes such as pg_views?
If not, is there a way to create them?

[navjotahuja92]

In case someone needs this, I have a working example: https://gist.github.com/navjotahuja92/f51601b17fb248cf4727b5650d945607

[Wellers0n]

how can I use pg-mem as memory database in tests?