Creacion de intereses

gistfile1.txt

router.post('/api/v1/tander/interes', upload.array(), function (req, res, next) {

    var results = [];

    // Grab data from http request
    var data = {nombre: req.body.interest.value, categoria: req.body.interest.category};
    console.log(req.body);

    // Get a Postgres client from the connection pool
    pg.connect(connectionString, function(err, client, done) {
        // Handle connection errors
        if(err) {
          done();
          console.log(err);
          return res.status(500).json({ success: false, data: err});
        }

        //Busco el id de la categoria
        var id = []
        var consulta = client.query("Select id from categorias where nombre = '"+data.categoria+"'");
        consulta.on('row', function(row) {
            data.categoria = row.id;
        });
        if(data.categoria == undefined){
          done();
          return res.status(500).json({ success: false, data: "Categoria inexistente"});
        }
        consulta.on('end',function(err){
            client.query("INSERT INTO interes (nombre,categoria) values($1,$2)", [data.nombre,data.categoria],function(err,result){
                return res.sendStatus(201);
            });


    });
});
});