tableAPI.js

"use strict";

var fs = require('fs');

function setup(Model, sequelize) {
  return {
    model: Model,
    list: function (req, res) {
      var search = { $or: { }};
      if (req.query) {
        if ((req.query.search) && (req.query.search.length > 0)) {
          for (var attr in Model.attributes) {
            if (attr === 'id') continue;
            search.$or[attr] = sequelize.where(sequelize.cast(sequelize.col(attr), 'text'), { $ilike: '%' + req.query.search + '%' });
          }
        }
      }
      return Model.findAll({ where: search }).then(function(entries) {
        res.json(entries);
      });
    },
    create: function (req, res) {
      var neItem = req.body;
      return Model.create(neItem).then(function(entry) {
        res.json(entry);
      });
    },
    read: function (req, res) {
      var id = ~~req.params.id;
      return Model.findOne({ where: {id: id} }).then(function(entry) {
          res.json(entry);
      });
    },
    update: function (req, res) {
      var id = ~~req.params.id;
      var updateData = req.body;

      return Model.update(updateData, {
        where: {
          id: id
        }
      }).then(function(entry) {
        res.json(updateData);
      });
    },
    delete: function (req, res) {
      var id = ~~req.params.id
      return Model.destroy({
        where: {
          id: id
        }
      }).then(function() {
        res.json({});
      });
    },
    upload: function (req, res) {
      var oldPath = req.files.file.path;
      var dir = './uploaded/';
      var newPath = dir + req.files.file.name;

      if (!fs.existsSync(dir)) {
        fs.mkdirSync(dir);
      }

      fs.readFile(oldPath, function(err, data) {
        fs.writeFile(newPath, data, function(err) {
          fs.unlink(oldPath, function(){
            if (err) { res.json({ status: 'err' }); return; };
            res.send({
              status: 'err',
              msg: 'File uploaded to: ' + newPath
            });
          });
        });
      });
    }
  };
}


module.exports = {
  setup: setup
};