From f886ab318b4bde2063c4319c49bf98b5146fa639 Mon Sep 17 00:00:00 2001 From: Jules Date: Mon, 2 Apr 2018 10:17:32 -0400 Subject: im_cmd counts api --- lib/db/index.js | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'lib/db') diff --git a/lib/db/index.js b/lib/db/index.js index 6e36602..a9e29be 100644 --- a/lib/db/index.js +++ b/lib/db/index.js @@ -46,3 +46,15 @@ db.createImage = function(url){ db.createShaderImage = function(data){ return new ShaderImage(data).save() } +// select name,dir,newfile,count(*) as count from im_cmd where tag='ascii' group by name order by count desc; +db.getUserCounts = function(){ + return knex.column('name').column('dir').column('newfile').count('* as count').from('im_cmd').where('tag','ascii').groupBy('name').orderBy(knex.raw('count'), 'desc') +} +db.getLatestByUser = function(){ + return knex.max('id as id').count('* as count').column('name').from('im_cmd').where('tag','ascii').groupBy('name').orderBy('count', 'desc') + // raw('SELECT MAX(id) as id, COUNT(*) as count, name FROM im_cmd WHERE tag='ascii' GROUP BY name') +} +db.getPhotoblasterImages = function(ids) { + return ShaderImage.query(qb => { return qb.where('id', 'in', ids) }).fetchAll() +} + -- cgit v1.2.3-70-g09d2