Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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: '******',
- 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: '******',
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement