db.from('capcodes') .del() .where('id', 'in', idList) .then((result) => { res.status(200).send({ 'status': 'ok' }); if (!updateRequired || updateRequired == 0) { nconf.set('database:aliasRefreshRequired', 1); nconf.save(); } }).catch((err) => { res.status(500).send(err); })
async function getUser(id) { const [user] = await knex('users') .where('id', id) .select('email', 'name'); return user; }
router.put('/:id', function(req, res) { db('todo').where({id: req.params.id}).update({ title: req.body.title || null, is_done: req.body.is_done || false }).returning('*').then(function(data) { res.send(data); }); console.log(req.params.id); // UPDATE table_name SET title='', is_done='' WHERE id = '' });
async function updateUserInfo({ name, username: email, id }) { const [user] = await knex('users') .where({ id }) .update({ name, email, updated_at: new Date(), }) .returning(['email', 'name']); return user; }
router.route('/capcodes/agency/:id') .get(authHelper.isAdmin, function (req, res, next) { var id = req.params.id; db.from('capcodes') .select('*') .where('agency', 'like', id) .then((rows) => { res.status(200); res.json(rows); }) .catch((err) => { logger.main.error(err); return next(err); }) });
function findUser(body) { return db('users') .where({ username: body.username }) .first(); }
//edit cat (cat data here includes everything we need to edit). Tip: you need the ID of cat to update otherwise //we have no idea which cat we're updating. function editOne(cat) { return db("cats") .where({ id: cat.id }) // find the cat to update .update({ name: cat.name, location: cat.location, age: cat.age }) //change the cat info to the new stuff .then(data => { return db("cats").where({ id: cat.id }); //return the cat we updated }); }
before('fetch list data', done => { db.select().from('lists').where({ id: listId }).then(lists => { data = lists[0]; done(); }); });
async function getUser(query) { const [user] = await knex('users') .select(['id', 'email', 'name', 'created_at']) .where(query) .limit(1); return user; }
router.patch('/:id', function(req, res) { db('todo').where({id: req.params.id}).update(req.body).returning('*').then(function(data) { res.send(data); }); console.log(req.params.id); });
//delete cat by ID function deleteOne(id) { return db("cats") .where({ id }) .del() .then(data => { // the data callback here doesn't return any cats as we've deleted the cat. So returning whole DB. return db("cats").select(); }); }
db.from('users') .del() .where('id', id) .then((result) => { res.status(200).send({ 'status': 'ok' }); }) .catch((err) => { res.status(500).send(err); logger.main.error(err) })
//get one cat by ID from db function getOne(id) { return db("cats") .where({ id }) .first(); }
db.from('capcodes') .del() .where('id', id) .then((result) => { res.status(200).send({ 'status': 'ok' }); if (!updateRequired || updateRequired == 0) { nconf.set('database:aliasRefreshRequired', 1); nconf.save(); } }) .catch((err) => { res.status(500).send(err); })