squlize with express js

https://github.com/sequelize/express-example/blob/master/routes/users.js

http://zetcode.com/javascript/sequelize/


https://sequelize.org/master/manual/raw-queries.html
https://stackoverflow.com/questions/20460270/how-to-make-join-queries-using-sequelize-on-node-js
https://stackoverflow.com/questions/23361022/sequelize-in-nodejs-inner-join-implementation-failure

https://stackoverflow.com/questions/31983885/create-multiple-inner-joins-with-sequelize-orm

https://stackoverflow.com/questions/27465850/typeerror-router-use-requires-middleware-function-but-got-a-object


how to do join query in sequlize

const mysql = require('mysql2');

const Sequelize = require('sequelize');

const configData=require("../config/config.json");

// Option 1: Passing parameters separately

const sequelize = new Sequelize(configData.DATABASE_NAME, configData.USER_NAME, configData.PASSWORD, {

  host: configData.HOST,

  dialect:'mysql'

});

sequelize

.authenticate()

.then(() => {

  console.log('Connection has been established successfully.'); // eslint-disable-line no-console

})

.catch((err) => {

  console.error('Unable to connect to the database:', err); // eslint-disable-line no-console

});

module.exports = {sequelize};

let sequelize = require("../database/mysqldb.js").sequelize;

let jobList = await sequelize.query("SELECT * FROM job_details INNER JOIN job_info ON job_details.job_id = job_info.job_id",{

        type: sequelize.QueryTypes.SELECT

      });