router.post('/handleRegister', function (req, res, next) {

  var file = __dirname+"/"+"webshop.db";
  var exists = fs.existsSync(file);
  var db = new sqlite3.Database(file);

  var myObj = {};
  var name = req.body.username;
  var mail = req.body.email;
  var password = req.body.password;

  db.serialize(function() {
    var sqlControl = `SELECT * FROM user WHERE username = '${name}' OR email = '${mail}' LIMIT 1`;
    db.get(sqlControl, [], function (err, row) {
      if (err){
        res.send(JSON.stringify(myObj = {
          message: err.message
        }));
      }

      if (row){
        myObj = {
          message: "User already exists."
        };
        res.send(JSON.stringify(myObj));
      }
      else {
        var sqlInsert = `INSERT INTO user(username, email, password) VALUES('${name}', '${mail}', '${password}')`;
        db.run(sqlInsert,[], function(err, row) {
          if (err){
            res.send(JSON.stringify(myObj = {
              message: err.message
            }));
          }
          else {
            myObj = {message: "Account has been created."
            };
            res.send(JSON.stringify(myObj));
          }
        });
      }

    });
  });
  db.close();
});

module.exports = router;