app.js

var express = require('express');
var path = require('path');
var favicon = require('serve-favicon');
var logger = require('morgan');
var cookieParser = require('cookie-parser');
var bodyParser = require('body-parser');
var session = require('express-session');
var passport = require('passport');
var LocalStrategy = require('passport-local').Strategy;
var MySQLStore = require('express-mysql-session')(session);

var flash = require('connect-flash');
var Database = require('./routes/sql');
var md5 = require('md5');

var app = express();
var engine = require('ejs-mate');

// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'ejs');
app.engine('ejs', engine);

let db_pass = "ubuntu34";
let db_name = "chess";
if (process.env.NODE_ENV === "dev-linux") {
    db_pass = "ubuntu34";
}


var pool = new Database({
    host: 'localhost',
    user: 'root',
    password: db_pass,
    database: db_name,
    connectionLimit: 10,
    acquireTimeout: 1000
});
app.pool = pool;


var sessionStore = new MySQLStore({}, pool.getConnection());


//app.use(favicon());
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded());
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));


app.use(session({
    key: 'session_cookie_name',
    secret: 'session_cookie_secret',
    store: sessionStore,
    resave: true,
    saveUninitialized: false,
    cookie: {
        maxAge: 1000 * 60 * 60 * 24 * 30 * 12,
    }
}));
app.use(flash());



app.use(passport.initialize());
app.use(passport.session());

app.use(function(req, res, next) {
    res.locals.user = req.session.passport;
    next();
});


const MongoClient = require('mongodb').MongoClient;
const assert = require('assert');

// Connection URL
const url = 'mongodb://localhost:27017';

// Database Name

// Use connect method to connect to the server
MongoClient.connect(url, { useNewUrlParser: true }, function(err, client) {
    assert.equal(null, err);
    console.log("Connected successfully to MONGODB server");
    const dbName = 'myproject';
    app.mongoDB = client.db(dbName);

});



var getUser = function(email, password, cb) {
    pool.query("SELECT * FROM users WHERE email = ? AND password = ? LIMIT 1", [email, md5(password)])
        .then(function (rows) {
            if (rows.length > 0) {
                cb(null, rows[0]);
            } else {
                return cb(null, null);
            }
        }).catch(function (err) {
        console.log(err);
    });
};


passport.serializeUser(function(user, done) {
    let is_sbornik = false;

    done(null, {
        id : user.id,
        name : user.name,
        role : user.role,
        rating : user.rating,
        is_team_owner : user.is_team_owner,
        is_league_owner : user.is_league_owner,
        is_paid : user.is_paid,
        country : user.country,
        image : user.image,
        is_sbornik : is_sbornik,
        school_id : user.school_id
    });
});

passport.deserializeUser(function(user, done) {
    pool.query("SELECT * FROM users WHERE id = ? LIMIT 1", user.id)
        .then(function (rows) {
            done(null, user.id);
        }).catch(function (err) {
        console.log(err);
    });
});

var i18n = require('i18n-2');



// Attach the i18n property to the express request object
// And attach helper methods for use in templates
i18n.expressBind(app, {
    // setup some locales - other locales default to en silently
    locales: [ 'en'],
    extension: '.json',

});

passport.use("local-login",new LocalStrategy({
        usernameField: 'username',
        passwordField: 'password',
        passReqToCallBack: true
    },
    function(username, password, done) {
        // return done(null, false, {message: 'Pas d\'utilisateur avec ce login.'});
        getUser(username, password, function(err, user) {
            if (err)
                return done(err);
            if (!user)
                return done(null, false, {message: 'Check password and login.'});
            /*if (!user.validPassword(password))
             return done(null, false, {message: 'Oops! Mauvais password.'});*/


            return done(null, user);
        });

    }
));

var users = require('./routes/users')(app, passport, pool);
var routes = require('./routes/index')(app, passport, pool);
var puzzles = require('./routes/puzzles')(app, passport, pool, i18n);


//legacy
/*var teams = require('./routes/teams')(app, passport, pool);
var leagues = require('./routes/leagues')(app, passport, pool);
var tournament = require('./routes/tournament')(app, passport, pool, i18n);
var play = require('./routes/play')(app, passport, pool, i18n);
app.use('/tournament', tournament);
app.use('/play', play);
app.use('/teams', teams);
app.use('/leagues', leagues);*/




// This is how you'd set a locale from req.cookies.
// Don't forget to set the cookie either on the client or in your Express app.
app.use(function(req, res, next) {
    req.i18n.setLocaleFromCookie();
    next();
});

app.use('/', routes);
app.use('/users', users);
app.use('/puzzles', puzzles);

/// catch 404 and forwarding to error handler
app.use(function(req, res, next) {
    var err = new Error('Not Found');
    err.status = 404;
    next(err);
});

/// error handlers

// development error handler
// will print stacktrace
if (app.get('env') === 'development') {
    app.use(function(err, req, res, next) {
        res.status(err.status || 500);
        res.render('error', {
            message: err.message,
            error: err
        });
    });
}

// production error handler
// no stacktraces leaked to user
app.use(function(err, req, res, next) {
    res.status(err.status || 500);
    res.render('error', {
        message: err.message,
        error: err
    });
});


module.exports = app;