Sequelize support for Node.js

Introduction

Sequelize is a promise-based Node.js ORM tool for Postgres, MySQL, SQLite, Microsoft SQL Server, Oracle Database - see https://sequelize.org/docs/  for more information.

Objects

This extension creates the entity, entity operation and query objects:

• a ‘NodeJS Entity’ object when the APIs ‘define’ or ‘init’ of a Sequelize.Model instance is found.
• a ‘NodeJS Entity Operation’ object when one of the supported Sequelize APIs is used and linked to one of the entities.
• a ‘NodeJS SQL Query’ object when the API ‘query’ is found.

Icon	Description
	NodeJS Entity
	NodeJS Entity Operation
	NodeJS SQL Query

Supported persistence SQL databases

Supported operations

‘Model’ above can be defined by ‘Sequelize.define’ or using a class extending ‘Sequelize.Model’.

Supported links

Example

Take the following codes of javascript file:

const Sequelize = require('sequelize');
const sequelize = new Sequelize('sqlite::memory:');

class User extends Sequelize.Model { }
User.init(
  {
    // ... (attributes)
  },
  {
    sequelize,
    modelName: 'user',
  }
);

await User.findAll().then(t_user=> { });

const Post = sequelize.define(
  'post',
  {
    // ... (attributes)
  },
  {
    freezeTableName: true,
  },
);

await Post.update({ isClos: true });

function userSearch (req) {
    var query = "SELECT name,id FROM Users WHERE login='" + req.body.login + "'";
    db.sequelize.query(query, {
        model: db.User
    })
      .then(user => {
    })
};

In this example, two ‘NodeJS Entity’ objects, two ‘NodeJS Entity Operation’ objects, and a ‘NodeJS SQL Query’ object are created. A ‘relyOn’ link is added when entity ‘user’ is defined using a class extending ‘Sequelize.Model’. The SQL Analyzer or Missing tables and procedures for Node.js links these entity operations and this query with the corresponding tables. In the present case, this extension creates two ‘useSelect’ and a ‘useUpdate’ links to the missing tables ‘Users’ and ‘post’: