Function buildSequelizeOptions

packages/node-core/src/db/db.module.ts:61–87

(nodeConfig: NodeConfig, option: DbOption)

};

const buildSequelizeOptions = (nodeConfig: NodeConfig, option: DbOption): SequelizeOption => {
  const logger = getLogger('SQL');

  return {
    ...option,
    dialect: 'postgres',
    ssl: nodeConfig.isPostgresSecureConnection,
    dialectOptions: {
      ssl: {
        rejectUnauthorized: false,
        ca: nodeConfig.postgresCACert,
        key: nodeConfig.postgresClientKey,
        cert: nodeConfig.postgresClientCert,
      },
    },
    pool: {
      max: nodeConfig.pgPoolMax,
      min: nodeConfig.pgPoolMin,
      acquire: nodeConfig.pgPoolAqcuire,
      idle: nodeConfig.pgPoolIdle,
      evict: nodeConfig.pgPoolEvict,
    },
    logging: (sql: string, timing?: number) => {
      logger.debug(sql);
    },
  };
};

export async function establishNewSequelize(nodeConfig: NodeConfig): Promise<Sequelize> {
  return sequelizeFactory(buildSequelizeOptions(nodeConfig, DEFAULT_DB_OPTION))();