adding shader route

3 files changed, 30 insertions, 4 deletions

diff --git a/lib/db/index.js b/lib/db/index.js
index 75ee2ad..e6a9d78 100644
--- a/lib/db/index.js
+++ b/lib/db/index.js
@@ -8,7 +8,11 @@ var knex = connection.knex
 /* MODELS */
 
 var Image = db.Image = bookshelf.Model.extend({
-  tableName: 'images',
+  tableName: 'plops',
+  hasTimestamps: true,
+})
+var ShaderImage = db.ShaderImage = bookshelf.Model.extend({
+  tableName: 'im_cmd',
   hasTimestamps: false,
 })
 
@@ -26,7 +30,9 @@ db.getRandom = function () {
     qb.orderBy(knex.raw('RAND()')).limit(1)
   }).fetch()
 }
-
 db.createImage = function(url){
   return new Image({ url: url }).save()
 }
+db.createShaderImage = function(url){
+  return new ShaderImage({ url: url }).save()
+}
diff --git a/lib/index.js b/lib/index.js
index a53dc34..8c089f5 100644
--- a/lib/index.js
+++ b/lib/index.js
@@ -66,4 +66,24 @@ site.init = function(){
 			}
 		})
   })
+
+  /* shaderblaster / asciiblaster apis */
+  app.post("/cgi-bin/im/shader/upload", multer_upload.single('qqfile'), function(req, res){
+    upload.put("shader", req.file, {
+
+      unacceptable: function(err){
+        res.json({ error: err })
+      },
+      success: function(url){
+        db.createShaderImage({
+          username: req.body.username,
+          tag: req.body.tag,
+          url,
+        }).then(function(image){
+          res.json(image)
+        })
+      }
+    })
+  })
+
 }
diff --git a/migrations/20171225172732_setup.js b/migrations/20171225172732_setup.js
index 430f778..3e25d90 100644
--- a/migrations/20171225172732_setup.js
+++ b/migrations/20171225172732_setup.js
@@ -1,7 +1,7 @@
 
 exports.up = function(knex, Promise) {
 
-  return knex.schema.createTable('images', function (table) {
+  return knex.schema.createTable('plops', function (table) {
     table.increments();
     table.string('url');
     table.string('ip');
@@ -11,5 +11,5 @@ exports.up = function(knex, Promise) {
 };
 
 exports.down = function(knex, Promise) {
-  return knex.schema.dropTable('images')
+  return knex.schema.dropTable('plops')
 };