Sequelize ES6 model syntax

mysql.js

var Promise = require('bluebird');

const Sequelize = require('sequelize');
const fs = Promise.promisifyAll(require('fs'));
const _ = require('lodash');

const sequelize = new Sequelize(connectionString, {
  dialect: 'mysql',
  logging: false,
  pool: { // application-side connection pool configuration
    max: 1000,
    min: 0,
    idle: 50000
  }
});

// Load all models
await fs.readdirAsync('./src/models')
  .map(fileName => {
    // ?? With ES6 should I System.import('./models/' + fileName)?
    let model = require('./models/' + fileName);
    
    /* NEW es6 style...? */
    if(model.init) {
      model.init(sequelize);
    } else {
      model(sequelize, Sequelize);
    }
  });

// associate
const models = sequelize.models;
_.map(Object.keys(models), n => models[n])
  .filter(m => m.associate !== undefined)
  .forEach(m => m.associate(models));

user.js

import { Model, DataTypes } from 'sequelize';

export class User extends Model {
  static init(sequelize) {
    super.init({
      username: {
        type: DataTypes.STRING,
        unique: true,
        allowNull: false
      },
      firstname: DataTypes.STRING,
      lastname: DataTypes.STRING,
      password: {
        type: DataTypes.STRING,
        allowNull: false
      },
      email: {
        type: DataTypes.STRING,
        unique: true,
        allowNull: false
      }}, {
        sequelize
      }
    );
  }

  static associate(sequelize) {
    this.belongsToMany(sequelize.Models.Role, { through: 'userroles' });
  }
}

does this actually work? cuz it's looking good.

I've tried implementing this 15,000 different ways and none of them work. Please, someone put up a working example of this. I think the OP put this up as a nice-to-have.

@BruceHem @peterb0yd I have a working example in this comment which is drawn from my blog repo.

You just need to replace the new Sequelize() variables with your own in index.js.

Thanks for this. Very useful