"Driver not connected"

[nmacherey]

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');
}

[ronenlu]

@nmacherey Thanks for reporting the issue. We found an issue with how the provider handles enums. We are working on a fix and will report back

[ronenlu]

@nmacherey Postgres enums are now supported.
You can install the latest version of the provider:
npm i @ariga/[email protected]

Thank you for reporting the bug :)

[nmacherey]

@ronenlu Thank you for your feed back but the db connexion does not work with postgres...
Or you should give in arguments all TYPEORM_* environment variables
and create the :memory: database.

My I have missed something ?

I also have issues with postgres SQL schema and extensions, as extensions can only be installed in a single schema and there is no way to specifiy the extension search path.

[ronenlu]

@nmacherey Can you share the error trace you are getting and the command you are running?

The reason Im not passing the TYPEORM_* args inside the loadEntities function, because there a lot of scenarios where you cannot connet to the DB instace ( CI etc ).
So Im not really connecting to the DB., rather I just use the Driver to parse the given Entities to DDL of the schema.