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 mysql = require('mysql');
var session = require('client-sessions');


global.connection = mysql.createConnection({
	host: 'localhost',
	port: 3306,
	user: 'root' ,
	password: 'root', 
	database: 'travelPortal'
})

connection.connect(function(err){
	if(err){
		console.log("Error connecting to db")
		return
	}
	console.log("Connection Established")
});

var routes = require('./routes/index');
var login = require('./routes/login');
var search = require('./routes/search');
var signup = require('./routes/signup');
var tourDetails = require('./routes/tourDetails')
var logout = require('./routes/logout')
var booking = require('./routes/booking')
var feedback = require('./routes/feedback')

var app = express();

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

// uncomment after placing your favicon in /public
//app.use(favicon(path.join(__dirname, 'public', 'favicon.ico')));
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: true }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.use(session({
	cookieName: 'session',
	secret: 'random_string',
	duration: 30 * 60 * 1000,
	activeDuration: 5 *60 *1000
}))



app.use('/', routes);
app.use('/signup', signup);
app.use('/login', login);
app.use('/search',search);
app.use('/tourDetails',tourDetails);
app.use('/logout',logout);
app.use('/booking',booking);
app.use('/book',booking);
app.use('/feedback',feedback);
app.use("/public",express.static("./public"));


// catch 404 and forward 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: {}
  });
});


module.exports = app;