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.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); });
router.post('/', function(req, res) { db.insert(req.body).returning('*').into('todo').then(function(data) { res.send(data); }) console.log(req.body); // INSERT INTO table_name(column1, column2) VALUES(value_1, value_2) // SELECT * FROM table WHERE id = inserted_row });
async function createUser({ name, username: email, password }) { const hashedPass = await bcrypt.hash(password, 5); const [user] = await knex('users') .insert({ name, email, password: hashedPass, created_at: new Date(), updated_at: new Date(), email_verified_at: new Date(), }) .returning(['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 = '' });
.returning('id') .where('id', '=', id) .update({
lastlogondate: null }) .returning('id') .then((response) => {
console.time('insert'); db.from('users') .returning('id') .where('username', '=', req.user.username) .update({
db.from('capcodes') .returning('id') .where('id', '=', id) .modify(function (queryBuilder) {
var pluginconf = JSON.stringify(capcode.pluginconf) || "{}"; await db('capcodes') .returning('id') .where('address', '=', address) .first()
const id = await db("contacts") .insert({ ...contact }) .returning("id") .then(([id]) => id) .catch(error => {
.returning('id') .then((result) => { res.status(200);