// PersonaCursoPrincipal.js
module.exports = (sequelize, DataTypes) => {
  const PersonaCursoPrincipal = sequelize.define(
    'PersonaCursoPrincipal',
    {
      id: {
        type: DataTypes.INTEGER(10),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
      },
      id_curso_principal: {
        type: DataTypes.INTEGER(5),
        allowNull: false,
        defaultValue: 0
      },
      id_producto_agrupador: {
        type: DataTypes.INTEGER(5),
        allowNull: false,
        defaultValue: 0
      },
      deleted: {
        type: DataTypes.INTEGER(1),
        allowNull: false,
        defaultValue: 0
      },
      created: {
        type: DataTypes.DATE,
        allowNull: false,
        defaultValue: new Date()
      },
      modified: {
        type: DataTypes.DATE,
        allowNull: false,
        defaultValue: new Date()
      }
    },
    {
      tableName: 'personas_cursos_principales',
      timestamps: false,
      defaultScope: {
        where: {
          deleted: 0
        }
      }
    }
  )
  PersonaCursoPrincipal.associate = models => {
    PersonaCursoPrincipal.belongsTo(models.CursoPrincipal, {
      foreignKey: 'id_curso_principal',
      constraints: false
    })
    PersonaCursoPrincipal.belongsTo(models.ProductoAgrupador, {
      foreignKey: 'id_producto_agrupador',
      constraints: false
    })
  }
  return PersonaCursoPrincipal
}

// CursoPrincipal.js
module.exports = (sequelize, DataTypes) => {
  const CursoPrincipal = sequelize.define(
    'CursoPrincipal',
    {
      id: {
        type: DataTypes.INTEGER(3),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
      },
      nombre: {
        type: DataTypes.STRING(255),
        allowNull: false,
        defaultValue: ''
      },
      deleted: {
        type: DataTypes.INTEGER(1),
        allowNull: false,
        defaultValue: 0
      },
      created: {
        type: DataTypes.DATE,
        allowNull: false,
        defaultValue: new Date()
      },
      modified: {
        type: DataTypes.DATE,
        allowNull: false,
        defaultValue: new Date()
      }
    },
    {
      tableName: 'cursos_principales',
      timestamps: false,
      defaultScope: {
        where: {
          deleted: 0
        }
      }
    }
  )
  return CursoPrincipal
}

// ProductoAgrupador.js
module.exports = (sequelize, DataTypes) => {
  const ProductoAgrupador = sequelize.define(
    'ProductoAgrupador',
    {
      id: {
        type: DataTypes.INTEGER(11),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
      },
      deleted: {
        type: DataTypes.INTEGER(1),
        allowNull: false,
        defaultValue: 0
      },
      created: {
        type: DataTypes.DATE,
        allowNull: false,
        defaultValue: new Date()
      },
      modified: {
        type: DataTypes.DATE,
        allowNull: false,
        defaultValue: new Date()
      }
    },
    {
      tableName: 'productos_agrupadores',
      timestamps: false,
      defaultScope: {
        where: {
          deleted: 0
        }
      }
    }
  )
  return ProductoAgrupador
}

// index.js
const fs = require('fs')
const path = require('path')
const Sequelize = require('sequelize')
const logging = console.log // eslint-disable-line
const DATABASE = process.env.DATABASE || 'mysql://root:root@localhost/test'
const sequelize = new Sequelize(DATABASE, {
  logging: process.env.SEQUELIZE_DEBUG === 'true' ? logging : false,
  operatorsAliases: false
})
const db = {}
const models = fs
  .readdirSync(__dirname)
  .filter(
    file =>
      file.indexOf('.') !== 0 &&
      file !== path.basename(module.filename) &&
      file.slice(-3) === '.js'
  )
  .reduce((acc, file) => {
    const model = sequelize.import(path.join(__dirname, file))
    acc[model.name] = model
    return acc
  }, {})
Object.assign(db, models)
Object.keys(db).forEach(modelName => {
  if (db[modelName].associate) {
    db[modelName].associate(db)
  }
})
db.sequelize = sequelize
db.Sequelize = Sequelize
db.CursoPrincipal.belongsToMany(db.ProductoAgrupador, {
  through: 'PersonaCursoPrincipal',
  foreignKey: 'id_curso_principal'
})
db.ProductoAgrupador.belongsToMany(db.CursoPrincipal, {
  through: 'PersonaCursoPrincipal',
  foreignKey: 'id_producto_agrupador'
})
db.sequelize.sync()