Function models

backend/src/database/models/index.ts:48–141

(queryTimeoutMilliseconds: number)

}

function models(queryTimeoutMilliseconds: number) {
  const database = {} as any

  const credentials = getCredentials()

  const sequelize = new (<any>Sequelize)(
    DB_CONFIG.database,
    credentials.username,
    credentials.password,
    {
      dialect: DB_CONFIG.dialect,
      dialectOptions: {
        application_name: SERVICE,
        connectionTimeoutMillis: 5000,
        query_timeout: queryTimeoutMilliseconds,
        idle_in_transaction_session_timeout: 10000,
      },
      port: DB_CONFIG.port,
      replication: {
        read: [
          {
            host:
              SERVICE === configTypes.ServiceType.API ? DB_CONFIG.readHost : DB_CONFIG.writeHost,
          },
        ],
        write: { host: DB_CONFIG.writeHost },
      },
      pool: {
        max: SERVICE === configTypes.ServiceType.API ? 20 : 10,
        min: 0,
        acquire: 50000,
        idle: 10000,
      },
      logging: DB_CONFIG.logging
        ? (dbLog) =>
            log.info(
              highlight(dbLog, {
                language: 'sql',
                ignoreIllegals: true,
              }),
              'DB LOG',
            )
        : false,
    },
  )

  const modelClasses = [
    require('./activity').default,
    require('./auditLog').default,
    require('./member').default,
    require('./memberIdentity').default,
    require('./file').default,
    require('./integration').default,
    require('./report').default,
    require('./settings').default,
    require('./tag').default,
    require('./tenant').default,
    require('./tenantUser').default,