Transactions with postgres

authRouter.post('/register', async (req, res) => {
  console.log(req.body)
  const { email, password, password2, role } = req.body
  // [TODO] validate email
  if (password !== password2) {
    return res.status(401).send('BAD REQUEST')
  }

  console.log('inserting')
  const collection = collections[role]
  console.log('got collection', !!collection)
  const [user] = await db.insert(Users).values({ email, password }).returning()
  const [person] = await db.insert(Customers).values({ email }).returning()

  res.send(person)
})

const [user] = await db.insert(Users).values({ email, password }).returning()
  const [person] = await db.insert(Customers).values({ email }).returning()