var mysql = require('mysql');
//
var http = require('http');
var url = require('url');

var server = http.createServer(function(req, res) {
  query = decodeURIComponent(url.parse(req.url).pathname).split('/')[1];//получаем sql запрос
  console.log(query);

   //Если запрос состоит из строки 'kill', завершаем работу сервиса
    if (query === 'kill') {
      res.writeHead(200, {"Content-Type": "text/html; charset=UTF-8"});
      res.end("<h1>Server кирдык<h1>");
      server.close('');
      req.connection.destroy('');
      console.log("кирдык");
      process.exit('');
      return;
    }

  res.writeHead(200, {"Content-Type": "application/json; charset=UTF-8","Access-Control-Allow-Origin":"*",
                      "Access-Control-Allow-Headers":"Origin, X-Requested-With, Content-Type, Accept"});

  var sql = query;
  var connection = mysql.createConnection({
  host: 'airs.ce5k6a6fvfk2.us-east-1.rds.amazonaws.com',
  user: 'userairs',
  password: 'userairs',
  database : 'airs'
});
connection.connect();
//выполняем запрос
connection.query(sql,
  function(err, rows, fields) {
    connection.end();
    if (err)
    {
      console.log('Неверный запрос');
      res.writeHead(200, {"Content-Type": "text/html; charset=UTF-8"});
      res.end("<h1>Неверный запрос<h1>");
    }
    else
    {
      //формируем ответ
      author ={"autor":"is10-99", "script":"C:\\Dropbox\\edunet\\2014\\is10-99\\nodejsXmlServer\\coffee\\XmlServer.coffee", "versionOf":"2016-05-12", "/SQL":query};
      var arr = [author, rows];
      res.end(JSON.stringify(arr));
    }
  }
);

});

server.listen(8080);
console.log('Сервер стартовал на порту 8080')