require('rootpath')();
var createError = require('http-errors');
var express = require('express');
var path = require('path');
var cookieParser = require('cookie-parser');
var logger = require('morgan');
var i18n=require("i18n-express");

var lineConfig=require("controllers/linesConfig");

var session = require('express-session');
var passport = require('passport');

var app = express();

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

app.use(logger('dev'));
app.use(express.json());
app.use(express.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.use(session({
  secret: 'this is supersecret string',
  resave: false,
  saveUninitialized: false, //cookie only for loged in user
  //cookie: { expires: false } // secure: true when https
}));

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

app.use(i18n({
  translationsPath: path.join(__dirname, 'i18n'), // <--- use here. Specify translations files path.
  siteLangs: ["en","cz","de"],
  textsVarName: 'translation'
}));

app.get('/favicon.ico', (req, res) => res.status(204));

app.use(function(req, res, next) {
  app.locals.userID = req.user;
  //console.log(app.locals);
  lineConfig.LineConfig(app.locals.translation);

  //global.db = require("database/psql");


  next();
});


app.use('/test_PG', function (req, res) {

  //console.log("in FC");

  const pg = require('pg');
  const QueryStream = require('pg-query-stream');
  const JSONStream = require('JSONStream');
  var CSV = require('csv-string');
  const stringify = require('csv-stringify')

  var pool = new pg.Pool({
    user: 'postgres',
    host: '127.0.0.1',
    database: 'main_db',
    password: 'flydeo.com',
    port: 5432
  });

  pool.connect((err, client, done) => {
    if (err) throw err;
    res.writeHead(200, {'Access-Control-Allow-Origin': '*'});

    const query = new QueryStream('SELECT * FROM APMB_Meyer_CycleData WHERE tstamp > \'2017-4-14\'');
    const stream = client.query(query);


    //---------- OPTION 1 ----------
    // stream.on('data', function(data) {
    //   res.write(data["tstamp"].toString());
    // });
    //
    // stream.on('end', function() {
    //   res.end();
    // });

    //---------- OPTION 2 ----------
    stream.on('end', done);
    stream.pipe(stringify()).pipe(res);
  });


  pool.end();

});

app.use('/', require('routes/indexRoute'));
app.use('/auth', require('routes/authRoute'));
app.use('/api', require('routes/apiRoute'));
app.use('/line', require('routes/linesRouter'));

// app.use('/index', require('./routes/indexRoute'));
// app.use('/users', require('./routes/usersRoute'));

// catch 404 and forward to error handler
app.use(function(req, res, next) {
  next(createError(404));
});

// error handler
app.use(function(err, req, res, next) {
  // set locals, only providing error in development
  res.locals.message = err.message || "Error";
  res.locals.error = req.app.get('env') === 'development' ? err : {};

  console.log(res.locals.error);
  // render the error page
  res.status(err.status || 500);
  res.render('error');
});

module.exports = app;