/**
 * Created by fedez on 4/3/2016.
 */
var express = require("express");
var bodyParser = require("body-parser");
var app = express();
app.use(bodyParser());
var path = require('path');
var Sequelize = require("sequelize");

// sequelize initialization
var sequelize = new Sequelize('users_DB', 'root', 'fedez_321321', {
    host: 'localhost',
    dialect: 'mysql',

    pool: {
        max: 5,
        min: 0,
        idle: 10000
    },

});

// check database connection
sequelize.authenticate().complete(function(err) {
    if (err) {
        console.log('Unable to connect to the database:', err);
    } else {
        console.log('Connection has been established successfully.');
    }
});

// model definition
var User = sequelize.define("User", {
    username: Sequelize.STRING,
    password: Sequelize.STRING,
    fullname: Sequelize.STRING
});


var createUser = function (req, res) {
    var newUser={
        username: req.body.username,
        password: req.body.password,
        fullname: req.body.fullname
    }

    User.create(newUser).success(function () {
        res.send(200);
    });
};

var getUser = function (req, res) {
    User.findAll().success(function (users) {
        res.send(users);
    });
};

sequelize.sync().success(function (err) {
    app.get("/users", getUser);
    app.post("/users", createUser);
    // initializing a port
    app.listen(5000);

});