I'm currently working on organizing my project by splitting the logic into different folders such as routes, views, models, and controllers.
Within a model named data (models/datamodel.js), I have implemented two methods to retrieve data for populating drop-down lists. These methods utilize sequelize for querying data asynchronously. While I have successfully used sequelize on the same page with resolve and reject callbacks, I am facing an issue in my data.js file. This file serves as a web service page that returns JSON data through a GET function. When using the object created from the dataModel and handling it with .then and .catch, the execution appears to immediately jump to the resolve callback, bypassing the intended flow. Despite multiple attempts to adjust the structures, promises, and await commands, the issue persists.
[models/dataModel.js]
'use strict';
const Sequelize = require('sequelize');
function dataModel() {
}
// Sequelize configuration
const sequelize = new Sequelize('compliance', 'username', 'password', {
host: 'WIN-QFHT5FIC1UQ',
dialect: 'mssql',
operatorsAliases: false,
requestTimeout: 300000,
pool: {
max: 5,
min: 0,
acquire: 30000,
idle: 30000
}
});
// Define models
var selectTo = sequelize.define('SelectTo',
{
to_jid: Sequelize.CHAR(100)
}
);
var selectFrom = sequelize.define('SelectFrom',
{
from_jid: Sequelize.CHAR(255)
}
);
// Asynchronous methods to get data
dataModel.prototype.getSelectTo = async function () {
return sequelize.query('SELECT To_jid from vwTo_jid_select order by to_jid', { model: selectTo });
};
dataModel.prototype.getSelectFrom = async function () {
return sequelize.query('SELECT from_jid from vwFrom_jid_select order by to_jid', { model: selectFrom });
};
module.exports = dataModel;
[routes/data.js]
'use strict';
var express = require('express');
var router = express.Router();
var path = require('path');
var dataModel = require('../models/dataModel.js');
var dm = new dataModel();
router.get('/:type', function (req, res) {
switch (req.params.type) {
case 'selectFrom':
{
dm.getSelectFrom().then(
result => {
res.json(result);
}).catch(err => {
res.send(err);
});
};
case 'selectTo':
{
dm.getSelectTo().then(
result => {
res.json(result);
}).catch(err => {
res.send(err);
});
}
default:
}
});
module.exports = router;