ariga / atlas-provider-typeorm Goto Github PK

The module si not working with postgres dialect, postgres does not have in memory databases.

There are various issues:

1. The loadEntities method is missing a call to await mockDb.initialize() actually it throws Driver not connected exception
2. To terminate the process, await mockDB.destroy(); should be added at the end of the method before returning the queries.
3. Postgres does not offers in-memory databases. You have various approaches, one of them would be to use pg-mem but it is not officially supported by postgres. Or really connect to a non vistrual DB. To to so additional parameters should be added to the script such as the dbname, username and password. Or the function should allow to add environment variables.
4. The method does not export all objects required for our database. Enums are not exported which make the initial migration to fail.

Please find a modified version here:

export async function loadEntities(
  dialect: Dialect,
  // eslint-disable-next-line @typescript-eslint/ban-types
  entities: (Function | EntitySchema | string)[],
) {
  const mockDB = new DataSource({
    type: dialect,
    host: process.env.TYPEORM_HOST,
    port: Number(process.env.TYPEORM_PORT),
    username: process.env.TYPEORM_USERNAME,
    password: process.env.TYPEORM_PASSWORD,
    database: process.env.TYPEORM_DATABASE,
    schema: process.env.TYPEORM_SCHEMA,
    entities,
    logging: false,
    synchronize: false,
  });

  await mockDB.initialize();

  const driver = mockDB.driver;
  const sqlInMemory = await driver.createSchemaBuilder().log();

  const queries = sqlInMemory.upQueries.map((query) => query.query);

  await mockDB.destroy();
  return queries.join(';\n');
}