• Index
• Search by APIs
• Search by Words
• Project Search

• Java
• Python
• JavaScript
• TypeScript
• C++
• Scala
• Blog

• MyAPI-master
  • src
    • security.ts
    • database
      • index.ts
      • ormconfig.ts
      • database.module.ts
      • migrations
        • 1569118664968-Initialize.ts
      • utils.ts
      • database.providers.ts
    • views
      • home.ejs
    • public
    • models
      • documentType.ts
      • user.ts
      • auth.ts
      • role.ts
    • app.module.ts
    • app.service.ts
    • repositories
      • utils
        • index.ts
      • documentType
        • documentType.service.ts
        • documentType.providers.ts
        • index.ts
        • documentType.module.ts
      • user
        • index.ts
        • user.service.ts
        • user.providers.ts
        • user.module.ts
      • index.ts
      • role
        • index.ts
        • role.module.ts
        • role.providers.ts
        • role.service.ts
    • controllers
      • auth.controller.ts
      • user.controller.ts
      • role.controller.ts
      • index.ts
      • documentType.controller.ts
    • app.controller.spec.ts
    • swagger.ts
    • constants
      • errors.ts
      • index.ts
      • postgres.ts
    • logger.ts
    • main.ts
    • app.controller.ts
    • auth
      • local.strategy.ts
      • auth.service.spec.ts
      • jwt.strategy.ts
      • auth.service.ts
      • index.ts
      • utils.ts
      • guards
        • index.ts
        • roles.decorator.ts
        • roles.guard.ts
      • auth.module.ts
  • img
  • Procfile
  • .prettierrc
  • LICENSE
  • test
    • app.e2e-spec.ts
    • jest-e2e.json
  • __mocks__
    • winston.js
  • tsconfig.build.json
  • README.md
  • package.json
  • .eslintrc.js
  • tsconfig.json
  • .gitignore
  • .vscode
    • settings.json
    • launch.json
  • nest-cli.json

import { join } from 'path'
import { ConnectionOptions } from 'typeorm'

import { PROD_ENV } from '../constants'

const config = {
  host: process.env.SQL_HOST,
  user: process.env.SQL_USER,
  password: process.env.SQL_PASSWORD,
  database: process.env.SQL_DATABASE,
}

// FOR GOOGLE CLOUD SQL
if (
  process.env.INSTANCE_CONNECTION_NAME &&
  process.env.NODE_ENV === PROD_ENV
) {
  config.host = `/cloudsql/${process.env.INSTANCE_CONNECTION_NAME}`
}

const connectionOptions: ConnectionOptions = {
  type: 'postgres',
  host: config.host || 'localhost',
  port: 5432,
  username: config.user || 'postgres',
  password: config.password || 'postgres',
  database: config.database || 'my_database',
  ssl: process.env.NODE_ENV === PROD_ENV
    ? { rejectUnauthorized: false }
    : false,
  entities: [
    join(__dirname, '../models/*{.ts,.js}'),
  ],
  // We are using migrations, synchronize should be set to false.
  synchronize: false,
  dropSchema: false,
  // Run migrations automatically,
  // you can disable this if you prefer running migration manually.
  migrationsRun: true,
  logging: ['warn', 'error'],
  logger: process.env.NODE_ENV === PROD_ENV ? 'file' : 'debug',
  migrations: [
    join(__dirname, 'migrations/*{.ts,.js}')
  ],
  cli: {
    migrationsDir: 'src/database/migrations'
  }
}

export = connectionOptions