//save a new cat, cat is an object so I can insert directly function saveOne(cat) { return db("cats") .insert(cat) .then(data => { // bring some data back otherwise 'data' logs as the ID of our newly saved cat return db("cats").select(); }); }
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; }
async function updateSubscription({ app, environment, origTxId, userId, validationResponse, latestReceipt, startDate, endDate, productId, isCancelled, }) { const data = { app, environment, user_id: userId, orig_tx_id: origTxId, validation_response: JSON.stringify(validationResponse), latest_receipt: latestReceipt, start_date: startDate, end_date: endDate, product_id: productId, is_cancelled: isCancelled, }; try { await knex('subscriptions').insert(data); } catch (err) { if (err.code !== 'ER_DUP_ENTRY') throw err; await knex('subscriptions').where('orig_tx_id', origTxId).update(data); } }
.insert({ username: req.body.username, password: hash,
.modify(function (queryBuilder) { if (id == null) { queryBuilder.insert({ id: id, address: address,
const db = database; const id = await db("contacts") .insert({ ...contact }) .returning("id") .then(([id]) => id)
if (id == null) { userobj.lastlogondate = null queryBuilder.insert(userobj) } else { queryBuilder.update(userobj)
} else { return db('users') .insert({ username: req.body.username, password: hash,
} else { return db('capcodes').insert({ id: null, address: address,
.modify(function (queryBuilder) { if (id == null) { queryBuilder.insert({ id: id, address: address,
function addUser(body) { return db('users') .insert(body) .then(ids => ids[0]); }