'use strict';
var mysql = require('mysql');

var connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: '',
  database: 'concesionaria'
});

connection.connect();

module.exports = function(router) {
    router.get('/', function(req, res) {
      var id_auto;
      if(req.query.id_auto === undefined){
        connection.query('SELECT * FROM autos', function(error, results, fields){
          if(error) throw error;
          res.send(results);
        });
      }else{
        id_auto = req.query.id_auto;
        connection.query('SELECT * FROM autos WHERE id_auto = ' + id_auto, function(error, results, fields){
          if(error) throw error;
          res.send(results);
        });
      }
    });

    router.post('/', function(req, res) {
        var modelo, precio, anio;

        modelo = req.body.modelo;
        precio = req.body.precio;
        anio = req.body.anio;

        connection.query('INSERT INTO autos(modelo, precio, anio) VALUES("' + modelo + '", "' + precio + '", "' + anio +'")', function(error, results, fields) {
          if(error) res.send(false);
          res.send(true);
        });
    });

    router.put('/', function(req, res) {

    });

    router.delete('/', function(req, res) {

    });
};