server.js

const express = require('express');
const bodyParser = require('body-parser');
const cors = require('cors');
const Sequelize = require('sequelize');

const config = require('./config');
const DB_URL = `mysql://${config.db.user}${config.db.password?':'+config.db.password:''}@${config.db.host}:${config.db.port}/${config.db.name}`;

const sequelizeInstance = new Sequelize(DB_URL);
const chartData = require('./models/chartData.model')(sequelizeInstance);
const talibData = require('./models/talibData.model')(sequelizeInstance);
const transaction = require('./models/transaction.model')(sequelizeInstance);

const app = express();
app.use(bodyParser.json());
app.use(cors());

const APP_PORT = 8888;

Promise.all([
        chartData.sync(),
        transaction.sync(),
        talibData.sync()
    ])
    .then(() => {
        app.listen(APP_PORT, () => {
            console.log('Api is listening on http://localhost:' + APP_PORT);
        });

        app.use('/front', express.static('./front.html'))

        app.get('/raw-data', (req, res) => {
            chartData.findAll({ limit: +req.query.limit || 15, offset: +req.query.offset || 0, order: ['date'] })
                .then((result) => {
                    res.send(result)
                })
                .catch(err => { console.error(err) })
        });

        app.get('/talibData', (req, res) => {
            talibData.findAll()
                .then((result) => {
                    res.send(result)
                })
                .catch(err => { console.error(err) })
        });

        app.get('/transactions', (req, res) => {
            transaction.findAll()
                .then((result) => {
                    res.send(result)
                })
                .catch(err => { console.error(err) })
        });

    })
    .catch(err => { console.error(err) })