Photo by Eugene Lim on Unsplash The ES2015 or ES6 specification introduced to . Libraries like React went from to , ie went from rolling their own constructor to leveraging a language built-in to convey the programmer’s intent. class JavaScript React.createClass class MyComponent extends React.Component For a web application’s persistence layer, a few databases come to mind like (possibly paired with ), or a key-value store like . Node.js MongoDB mongoose Redis To run a relational database with a Node application, , “An easy-to-use multi SQL dialect ORM for Node.js” is a good option. It allows the application to run backed by a MySQL or PostgreSQL instance and provides an easy way to map from entities’ representation in the database to JavaScript and vice versa. Sequelize Sequelize’s API for model definitions looks like the following (from the docs ): http://docs.sequelizejs.com/manual/tutorial/upgrade-to-v4.html const MyModel = sequelize.define("MyModel", { // fields and methods}); To add class and instance methods you would write the following: // Class MethodMyModel.associate = function (models) {}; // Instance MethodMyModel.prototype.someMethod = function () {..} This is necessary pre-ES6 since there was no concept of classical inheritance. Since we have class now, why not leverage them? For developers who are used to having classes, the following would likely look familiar: class MyModel extends Sequelize.Model { static associate(models) {} someMethod() {}} Sequelize actually supports this, but the documentation is a bit lacking. One of the only place to find a reference to how to do this is in a GitHub issue: . https://github.com/sequelize/sequelize/issues/6524 Here’s a cheat sheet for things you would want to do and how to achieve it using ES6 classes + inheriting from : Sequelize.Model Defining fields on a model Creating associations Custom table name Custom model name Wrap queries Instance methods Initialising all models Initialise the model with typed field(s) const Sequelize = require("sequelize");class MyModel extends Sequelize.Model { static init(sequelize, DataTypes) { return super.init({ myField: DataTypes.STRING }, { sequelize }); }} Associate your model to other models const Sequelize = require("sequelize");class MyModel extends Sequelize.Model {static associate(models) {this.myAssociation = this.belongsTo(models.OtherModel);// orthis.myAssociation = models.MyModel.belongsTo(models.OtherModel);}} Setting a custom table name for your model const Sequelize = require("sequelize");class MyModel extends Sequelize.Model {static init(sequelize, DataTypes) {return super.init({// field definitions}, {tableName: "myModels",sequelize});}} Setting a custom model name for your model (for Sequelize) const Sequelize = require("sequelize");class MyModel extends Sequelize.Model {static init(sequelize, DataTypes) {return super.init({// field definitions}, {modelName: "myModel",sequelize});}} Wrap queries const Sequelize = require("sequelize");class MyModel extends Sequelize.Model {static getId(where) {return this.findOne({where,attributes: ["id"],order: [["createdAt", "DESC"]]});}} Instance methods const Sequelize = require("sequelize");class MyModel extends Sequelize.Model {getFullName() {return `${this.firstName} ${this.lastName}`;}} Initialise all your models followed by is an alternative to , it’s a bit clearer what is and isn’t imported and under what name. require() model.init() sequelize.import(path) const Sequelize = require("sequelize");const sequelize = new Sequelize();// pass your sequelize config here const FirstModel = require("./first-model");const SecondModel = require("./second-model");const ThirdModel = require("./third-model"); const models = { First: FirstModel.init(sequelize, Sequelize), Second: SecondModel.init(sequelize, Sequelize), Third: ThirdModel.init(sequelize, Sequelize)}; // Run `.associate` if it exists,// ie create relationships in the ORMObject.values(models) .filter(model => typeof model.associate === "function") .forEach(model => model.associate(models)); const db = { ...models, sequelize}; module.exports = db; For any questions about using Sequelize in this manner or developing Node apps backed by relational databases, feel free to comment below or tweet to me . @hugo__df Originally published at codewithhugo.com on May 9, 2018.
