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 relyOnLink 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 useSelectLink and a useUpdateLink to the missing tables Users and post: