var express = require('express');
var app = express();

require('dotenv').config();
var bodyParser = require('body-parser')
var database = require('./database');

app.set('port', (process.env.PORT || 5000));

app.use(bodyParser.json());

var router = express.Router();

//app.use(express.static(__dirname + '/public'));

// views is directory for all template files
//app.set('views', __dirname + '/views');
//app.set('view engine', 'ejs');

router.post('/validate', function(request, response) {
  var emailAndPass = request.body;

  database.query('SELECT * FROM Salesforce.User WHERE Email = $1', emailAndPass.email).then(function(results) {
    if(results.length > 0)
    {
      var user = results[0];
      response.send(user);
    }
    response.send('no such user');
  }).catch(function(error) {
    response.status(500).send(JSON.stringify(error));
  });
});

//app.get('/times', function(request, response) {
//    var result = ''
//    var times = process.env.TIMES || 5
//    for (i=0; i < times; i++)
//      result += i + ' ';
//  response.send(result);
//});

//app.get('/db', function (request, response) {
//  pg.connect(process.env.DATABASE_URL, function(err, client, done) {
//    client.query('SELECT * FROM test_table', function(err, result) {
//      done();
//      if (err)
//       { console.error(err); response.send("Error " + err); }
//      else
//       { response.render('pages/db', {results: result.rows} ); }
//    });
//  });
//});

app.use('/api/v1', router);

app.listen(app.get('port'), function() {
  console.log('Node app is running on port', app.get('port'));
});