guni12/bbbnode

const asyn = require('./sqliteAsync');
const th = require('../throw');

async function getOne(req, res, next, params) {
    let id = params.table === "settings" ? 1 : parseInt(req.params.id, 10);
    let sql = "SELECT * FROM " + params.table + " WHERE id = " + id + ";";

    await asyn.Async(sql, 'get')
        .then((data) => {
            //console.log("Row", data);
            if (!data) {
                let text = 'Detta id finns inte';
                let obj = th.throwerror("Bad Request", 400, "getOneRow", text);

                throw { obj, error: new Error() };
            } else {
                req[params.what] = data;
                return data;
            }
        })
        .catch(er => {
            next(er);
        });
}

module.exports = {
    getOne: getOne
};