'use strict'

// modules > 3rd party
const _ = require('lodash')

// modules > midwest
const factory = require('midwest/factories/rest-handlers')
const { one, many } = require('easy-postgres/result')
const resolveCache = require('../resolve-cache')
const { generateToken } = require('../users/helpers')
const queries = require('./sql')

const columns = [
  'id',
  'email',
  'createdAt',
  'createdById',
  'modifiedAt',
  'modifiedById',
  'consumedAt'
]

module.exports = _.memoize((state) => {
  const config = state.config

  function create (json, client = state.db) {
    const token = generateToken()

    const promise = client.query(queries.create, [json.email, token, json.createdById, json.roles]).then(one)

    if (config.hooks && config.hooks.invite) {
      return promise.then(config.hooks.invite)
    } else {
      return promise
    }
  }

  function find (json, client = state.db) {
    const offset = Math.max(0, json.offset)

    return client.query(queries.find, [offset]).then(many)
  }

  function findById (id, client = state.db) {
    return client.query(queries.findById, [id]).then(one)
  }

  function findByEmail (email, client = state.db) {
    return client.query(queries.findByEmail, [email]).then(one)
  }

  function findByTokenAndEmail (token, email, client = state.db) {
    return client.query(queries.findByTokenAndEmail, [token, email]).then(one)
  }

  function getAll (client = state.db) {
    return client.query(queries.getAll).then(many)
  }

  function consume (id, client = state.db) {
    const query = 'UPDATE invites SET date_consumed = NOW() WHERE id = $1;'

    return client.query(query, [id]).then((result) => {
      if (result.rowCount === 0) throw new Error('Invite not consumed')
    })
  }

  return Object.assign(factory({
    emitter: state.emitter,
    db: state.db,
    table: 'invites',
    columns,
    exclude: ['create', 'getAll', 'find', 'findById']
  }), {
    create,
    find,
    findByEmail,
    findById,
    findByTokenAndEmail,
    getAll,
    consume
  })
}, resolveCache)

@@ -1570,21 +1570,16 @@
 SET 
-date_
 consumed
  = N
@@ -1574,16 +1574,19 @@
 consumed
+_at
  = NOW()
@@ -1713,27 +1713,30 @@
 or('
-Invite not consumed
+Error consuming invite
 ')%0A 

Fix consumtion