Use env variables as alternative to ormconfig.json

belayanejnost · February 21, 2020, 2:52pm

I suggest implement check does env variable provided and use it.

If process.env.DB_TYPE === ‘postgres’ => then cp ormconfig.postgres.json to root and fill it by process.env.DB_USERNAME, process.env.DB_PASSWORD e.t.c

it will help host application on SaaS platforms, where you cannot edit application files in runtime.

soge · March 6, 2020, 7:42pm

you can already use env values for db https://typeorm.io/#/using-ormconfig/using-environment-variables

belayanejnost · March 6, 2020, 3:31pm

Yes, but part of bot systems still user json file.

github.com

sogehige/sogeBot/blob/ee741bbe259403df1315afb2f42df003238633b0/src/bot/database/entity/gallery.ts

require('module-alias/register');
import { EntitySchema } from 'typeorm';
import * as configFile from '@ormconfig';

export interface GalleryInterface {
  id?: string;
  type: string;
  data: string;
  name: string;
}

export const Gallery = new EntitySchema<Readonly<Required<GalleryInterface>>>({
  name: 'gallery',
  columns: {
    id: { type: String, primary: true, generated: 'uuid' },
    type: { type: String },
    data: { type: configFile.type === 'mysql' ? 'longtext' : 'text' },
    name: { type: String },
  },
});

github.com

sogehige/sogeBot/blob/ee741bbe259403df1315afb2f42df003238633b0/src/bot/database/entity/howLongToBeatGame.ts

import * as configFile from '@ormconfig';

import { EntitySchema } from 'typeorm';
import { ColumnNumericTransformer } from './_transformer';

export interface HowLongToBeatGameInterface {
  id?: number;
  game: string;
  startedAt?: number;
  isFinishedMain: boolean;
  isFinishedCompletionist: boolean;
  timeToBeatMain?: number;
  timeToBeatCompletionist?: number;
  gameplayMain?: number;
  gameplayCompletionist?: number;
  imageUrl: string;
};

export const HowLongToBeatGame = new EntitySchema<Readonly<Required<HowLongToBeatGameInterface>>>({
  name: 'how_long_to_beat_game',

This file has been truncated. show original

e.t.c

soge · March 6, 2020, 7:42pm

This is already fix in progress https://github.com/sogehige/sogeBot/issues/3328

belayanejnost · March 6, 2020, 4:41pm

Can you also add those variables to docs and change docker-compose.yml to use those variables instead of mounted file?

soge · March 6, 2020, 5:37pm

you can already do it. Preferred way is to use ormconfig.json

soge · March 6, 2020, 6:33pm

nevermind, we will need to move to ENV variables, I cannot get other files to have working.

soge · March 6, 2020, 7:31pm

actually now it will work everything

system · March 8, 2020, 7:31pm

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.