guni12/bbbnode

View on GitHub
public/javascripts/db/edit-sqlite.js

Summary

Maintainability
A
40 mins
Test Coverage
const reg = require('../status');
const db = require('../../../db/database');
const exv = require('../extractValue');

function update(req, res, next, par) {
    let col = req.body.column;
    let val = exv.extVal(req.body.value);
    let id = req.body.id ? parseInt(req.body.id) : 1;
    let sql = "UPDATE " + par.table + " SET " + col + " = ? WHERE id = ?";
    let params = [val, id];
    let message = {"message": ""};

    db.run(sql,
        params, (err) => {
            if (err) {
                let obj = reg.reterror(500, par.where, err.message);

                return res.status(500).json(obj);
            }
            message.message = col + " updaterat med: " + val;
            req.content = message;
            next();
            return undefined;
        });
}

module.exports = {
    update: update
};