1 files changed, 47 insertions, 0 deletions
diff --git a/app/server/db/crud.js b/app/server/db/crud.js
new file mode 100644
index 0000000..3aa0127
--- /dev/null
+++ b/app/server/db/crud.js
@@ -0,0 +1,47 @@
+module.exports = function(model) {
+  return {
+    index: (q) => {
+      return model.query( (qb) => {
+        const limit = q.limit || 100
+        const offset = q.offset || 0
+        const orderBy = q.orderBy || 'id desc'
+        if (limit) {
+          delete q.limit
+        }
+        if (q.offset) {
+          delete q.offset
+        }
+        delete q.orderBy
+        if (Object.keys(q).length > 0) qb.where(q)
+        if (orderBy) {
+          const ob = orderBy.split(" ")
+          const ob_field = ob[0] || 'id'
+          const ob_dir = ob[1] || 'desc'
+          qb.orderBy(ob_field, ob_dir)
+        }
+        if (limit) qb.limit( limit )
+        if (offset) qb.offset( offset )
+        // console.log(qb)
+        return qb
+      }).fetchAll()
+    },
+    show: (id) => {
+      return new model({'id': id}).fetch()
+    },
+    show_ids: (ids) => {
+      return model.query( (qb) => {
+        qb.whereIn('id', ids)
+        return qb
+      }).fetchAll()
+    },
+    create: (data) => {
+      return new model(data).save()
+    },
+    update: (id, data) => {
+      return new model({'id': id}).save(data)
+    },
+    destroy: (id) => {
+      return new model({'id': id}).destroy()
+    },
+  }
+}