material-framework/lib/crud/controller.js

const { Op } = require('sequelize')

const crudController = ({
  Type
}) => ({
  list: async (req, res) => {
    // TODO Pagination (http://docs.sequelizejs.com/manual/tutorial/querying.html#pagination-limiting)
    if (req.query && req.query.q) {
      const fields = [Type.tableAttributes.name, Type.tableAttributes.tag].filter(x => x)
      if (!fields) throw new Error('Table has no searchable fields')
      const or = fields.map(field => ({
        [field.fieldName]: { [Op.like]: `%${req.query.q}%` }
      }))
      const where = { [Op.or]: or }
      const data = (await Type.findAll({ where })).map(d => d.sanitize ? d.sanitize() : d)
      res.status(200).send(data)
    } else {
      const data = (await Type.findAll()).map(d => d.sanitize ? d.sanitize() : d)
      res.status(200).send(data && data.sanitize ? data.sanitize() : data)
    }
  },
  create: async (req, res) => {
    const data = (await Type.create(req.body))
    res.status(200).send(data && data.sanitize ? data.sanitize() : data)
  },
  read: async (req, res) => {
    const data = (await Type.findOne({where: {id: req.params.id}}))
    res.status(200).send(data && data.sanitize ? data.sanitize() : data)
  },
  update: async (req, res) => {
    const data = (await Type.update(req.body, { where: { id: req.params.id } }))
    res.status(200).send(data && data.sanitize ? data.sanitize() : data)
  },
  delete: async (req, res) => {
    const data = (await Type.destroy({ where: { id: req.params.id } }))
    res.status(204).end()
  },
  trash: async (req, res) => {
    const data = (await Type.findAll({
      model: Type,
      paranoid: false,
      where: {
        deletedAt: { [Op.ne]: null }
      }
    }))
    res.status(200).send(data && data.sanitize ? data.sanitize() : data)
  },
  undelete: async (req, res) => {
    const data = (await Type.update({ deletedAt: null }, {
      paranoid: false,
      where: { id: req.params.id }
    }))
    res.status(200).send(data && data.sanitize ? data.sanitize() : data)
  }
  // TODO: Create, Read, Update, Delete
})

module.exports = crudController