var express = require("express");
var bodyParser = require("body-parser");
var http = require("http");
var app = express();
const url = require('url');



var port = 3000;
var mysql = require('mysql');

var dataBaseScript = "" +
    "CREATE TABLE IF NOT EXISTS " +
    "`events`.`users` " +
    "(" +
    "`userId` INT UNSIGNED AUTO_INCREMENT ," +
    "`name` VARCHAR(32)  DEFAULT NULL ," +
    "`password` VARCHAR(32)  DEFAULT NULL ," +
    "`shown_name` VARCHAR(32)  DEFAULT NULL ," +
    "`token` VARCHAR(64)  DEFAULT NULL ," +
    "PRIMARY KEY (`userId`), " +
    "UNIQUE `name` (`name`)" +
    ");";
var insertScript = "INSERT INTO `users` (`userId`, `name`, `password`, `shown_name`, `token`) VALUES (NULL, '_NAME_', '_PASS_', NULL, NULL);"
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'events'
});
connection.query(dataBaseScript, function (err, res, fields) {
    console.log(err);
});


app.use(bodyParser.urlencoded({extended: false}));
app.use(bodyParser.json());
app.listen(port, function () {
    console.log("Started on PORT " + port);
});
app.get('/', function (req, res) {
    console.log("index");
    res.sendfile("index.html");
});
app.get('/login', function (req, res) {
    console.log("login");
    res.sendfile("login.html");
});
app.get('/register', function (req, res) {
    console.log("register");
    res.sendfile("register.html");
});


app.get('/sendNamePassword', function (req, res) {
    req.on('data', function () {
        // console.log(e);
    });

    req.on('end', function () {
        // console.log(req.query);
        name = req.query.name;
        pass = req.query.pass;

        var sqlScript = 'select password from users where ?';
        connection.query(sqlScript, {name: name}, function (err, sqlRes) {
            var result = {};
            // console.log(err);
            // console.log(res);
            if (sqlRes.length == 0) {
                result.status = 'error';
                result.reason = 'userNotFound';
            } else if (pass == sqlRes[0].password) {
                result.status = 'ok';
                result.reason = 'passwordConfirmed';
            } else {
                result.status = 'error';
                result.reason = 'userAndPasswordNotMatches';
            }
            res.end(JSON.stringify(result));
        });
        // res.end(JSON.stringify(result));
        // console.log(dbPass);
        // console.log(pass);
        // console.log(query);
    });
});