Sequelize, nodejs, postgres

[Kiquenet]

Es buena práctica ?

Sequelize

import config from './config.js'

import Sequelize from 'sequelize'

import logger from './logger.js';

const sslDialectOptions = config.postgres.caCert ? { ssl: { require: true, ca: config.postgres.caCert } } : {}

const sequelize = new Sequelize(config.postgres.name, config.postgres.user, config.postgres.password, {

    host: config.postgres.host,

    port: config.postgres.port,

    dialect: 'postgres',

    dialectOptions: sslDialectOptions,

    logging: (message)=>logger.debug(message)

  }

);

export default {

    Sequelize : Sequelize,

    sequelize : sequelize

};

Modelo

// Definición modelo de tenant

const TenantModel = (sequelize) => {

  // Definimos el modelo

  const tenantModel = sequelize.define('Tenant', {

    id: {

      type: DataTypes.UUID,

      allowNull: false,

      primaryKey: true

    },

    name: {

      type: DataTypes.STRING,

      allowNull: false

    },

    description: {

      type: DataTypes.STRING,

      allowNull: false

    },

    blobcontainer: {

      type: DataTypes.STRING,

      allowNull: false

    }

  }, { tableName: 'tenants' });