api.js

// ==== USER ACOOUNT API ====
var dbconn = require('./dbconn')
module.exports = function (app) {

    //console.log(dbconn);
    //var con = dbconn.connection
    
    app.get('/account/api/v1/profile', function (req, res) {
        if (req.isAuthenticated()) {
            // read data based on ID
            dbconn.user.query('SELECT title, firstname, lastname, email, industry, organisation, speciality FROM user WHERE email="'+req.user.email+'"', function (err, rows, fields) {
                if (err) throw err
                res.send(rows[0])
            })
        } else {
          res.redirect('/account/');
        }
    });
    
}