Connection probleme

[gondfreecs]

How did u connect back end to the database ?

i got this probleme

[wesleyfeitosa]

@gondfreecs You have to adjust the "entities" and "migrations" attributes in your ormconfig.js for Typeorm to correctly read your entities and migations in your project's src folder.

Here is an example of ormconfig.js configured with different runtime environments.

const devConfig =  [
  {
    name: 'default',
    type: 'postgres',
    host: process.env.DATABASE_HOST,
    port: process.env.DATABASE_PORT,
    username: process.env.DATABASE_USER,
    password: process.env.DATABASE_PASSWORD,
    database: process.env.DATABASE_NAME,
    entities: [
      './src/modules/**/infra/typeorm/entities/*.ts'
    ],
    migrations: [
      './src/shared/infra/typeorm/migrations/*.ts'
    ],
    cli: {
      migrationsDir: './src/shared/infra/typeorm/migrations'
    }
  }
]

const prodConfig =  [
  {
    name: 'default',
    type: 'postgres',
    host: process.env.DATABASE_HOST,
    port: process.env.DATABASE_PORT,
    username: process.env.DATABASE_USER,
    password: process.env.DATABASE_PASSWORD,
    database: process.env.DATABASE_NAME,
    entities: [
      './dist/modules/**/infra/typeorm/entities/*.js'
    ],
    migrations: [
      './dist/shared/infra/typeorm/migrations/*.js'
    ],
    cli: {
      migrationsDir: './dist/shared/infra/typeorm/migrations'
    }
  }
]

const homoConfig =  [
  {
    name: 'default',
    type: 'postgres',
    host: process.env.DATABASE_HOST,
    port: process.env.DATABASE_PORT,
    username: process.env.DATABASE_USER,
    password: process.env.DATABASE_PASSWORD,
    database: process.env.DATABASE_NAME,
    ssl: true,
    extra: {
      ssl: {
        rejectUnauthorized: false,
      },
    },
    entities: [
      './dist/modules/**/infra/typeorm/entities/*.js'
    ],
    migrations: [
      './dist/shared/infra/typeorm/migrations/*.js'
    ],
    cli: {
      migrationsDir: './dist/shared/infra/typeorm/migrations'
    }
  }
]

let config;

if(process.env.NODE_ENV === 'production') {
  if (process.env.DATABASE_SSL === 'true') {
    console.log('Usando database de: HOMOLOGAÇÃO');
    config = homoConfig;
  } else {
    console.log('Usando database de: PRODUÇÃO');
    config = prodConfig;
  }
} else {
  console.log('Usando database de: DESENVOLVIMENTO');
  config = devConfig;
}

module.exports = config;