– Extensions
CREATE EXTENSION IF NOT EXISTS “uuid-ossp”; CREATE EXTENSION IF NOT EXISTS “plv8”;
– PLV8 Functions CREATE OR REPLACE FUNCTION plv8_startup() RETURNS void AS $$
(function(){ (function(){var root=this;var previousUnderscore=root._;var ArrayProto=Array.prototype,ObjProto=Object.prototype,FuncProto=Function.prototype;var push=ArrayProto.push,slice=ArrayProto.slice,concat=ArrayProto.concat,toString=ObjProto.toString,hasOwnProperty=ObjProto.hasOwnProperty;var nativeIsArray=Array.isArray,nativeKeys=Object.keys,nativeBind=FuncProto.bind;var _=function(obj){if(obj instanceof _)return obj;if(!(this instanceof _))return new _(obj);this._wrapped=obj};if(typeof exports!=='undefined'){if(typeof module!=='undefined'&&module.exports){exports=module.exports=_}exports._=_}else{root._=_}_.VERSION='1.7.0';var createCallback=function(func,context,argCount){if(context===void 0)return func;switch(argCount==null?3:argCount){case 1:return function(value){return func.call(context,value)};case 2:return function(value,other){return func.call(context,value,other)};case 3:return function(value,index,collection){return func.call(context,value,index,collection)};case 4:return function(accumulator,value,index,collection){return func.call(context,accumulator,value,index,collection)}}return function(){return func.apply(context,arguments)}};_.iteratee=function(value,context,argCount){if(value==null)return _.identity;if(_.isFunction(value))return createCallback(value,context,argCount);if(_.isObject(value))return _.matches(value);return _.property(value)};_.each=_.forEach=function(obj,iteratee,context){if(obj==null)return obj;iteratee=createCallback(iteratee,context);var i,length=obj.length;if(length===+length){for(i=0;i<length;i++){iteratee(obj[i],i,obj)}}else{var keys=_.keys(obj);for(i=0,length=keys.length;i<length;i++){iteratee(obj[keys[i]],keys[i],obj)}}return obj};_.map=_.collect=function(obj,iteratee,context){if(obj==null)return[];iteratee=_.iteratee(iteratee,context);var keys=obj.length!==+obj.length&&_.keys(obj),length=(keys||obj).length,results=Array(length),currentKey;for(var index=0;index<length;index++){currentKey=keys?keys[index]:index;results[index]=iteratee(obj[currentKey],currentKey,obj)}return results};var reduceError='Reduce of empty array with no initial value';_.reduce=_.foldl=_.inject=function(obj,iteratee,memo,context){if(obj==null)obj=[];iteratee=createCallback(iteratee,context,4);var keys=obj.length!==+obj.length&&_.keys(obj),length=(keys||obj).length,index=0,currentKey;if(arguments.length<3){if(!length)throw new TypeError(reduceError);memo=obj[keys?keys[index++]:index++]}for(;index<length;index++){currentKey=keys?keys[index]:index;memo=iteratee(memo,obj[currentKey],currentKey,obj)}return memo};_.reduceRight=_.foldr=function(obj,iteratee,memo,context){if(obj==null)obj=[];iteratee=createCallback(iteratee,context,4);var keys=obj.length!==+obj.length&&_.keys(obj),index=(keys||obj).length,currentKey;if(arguments.length<3){if(!index)throw new TypeError(reduceError);memo=obj[keys?keys[--index]:--index]}while(index--){currentKey=keys?keys[index]:index;memo=iteratee(memo,obj[currentKey],currentKey,obj)}return memo};_.find=_.detect=function(obj,predicate,context){var result;predicate=_.iteratee(predicate,context);_.some(obj,function(value,index,list){if(predicate(value,index,list)){result=value;return true}});return result};_.filter=_.select=function(obj,predicate,context){var results=[];if(obj==null)return results;predicate=_.iteratee(predicate,context);_.each(obj,function(value,index,list){if(predicate(value,index,list))results.push(value)});return results};_.reject=function(obj,predicate,context){return _.filter(obj,_.negate(_.iteratee(predicate)),context)};_.every=_.all=function(obj,predicate,context){if(obj==null)return true;predicate=_.iteratee(predicate,context);var keys=obj.length!==+obj.length&&_.keys(obj),length=(keys||obj).length,index,currentKey;for(index=0;index<length;index++){currentKey=keys?keys[index]:index;if(!predicate(obj[currentKey],currentKey,obj))return false}return true};_.some=_.any=function(obj,predicate,context){if(obj==null)return false;predicate=_.iteratee(predicate,context);var keys=obj.length!==+obj.length&&_.keys(obj),length=(keys||obj).length,index,currentKey;for(index=0;index<length;index++){currentKey=keys?keys[index]:index;if(predicate(obj[currentKey],currentKey,obj))return true}return false};_.contains=_.include=function(obj,target){if(obj==null)return false;if(obj.length!==+obj.length)obj=_.values(obj);return _.indexOf(obj,target)>=0};_.invoke=function(obj,method){var args=slice.call(arguments,2);var isFunc=_.isFunction(method);return _.map(obj,function(value){return(isFunc?method:value[method]).apply(value,args)})};_.pluck=function(obj,key){return _.map(obj,_.property(key))};_.where=function(obj,attrs){return _.filter(obj,_.matches(attrs))};_.findWhere=function(obj,attrs){return _.find(obj,_.matches(attrs))};_.max=function(obj,iteratee,context){var result=-Infinity,lastComputed=-Infinity,value,computed;if(iteratee==null&&obj!=null){obj=obj.length===+obj.length?obj:_.values(obj);for(var i=0,length=obj.length;i<length;i++){value=obj[i];if(value>result){result=value}}}else{iteratee=_.iteratee(iteratee,context);_.each(obj,function(value,index,list){computed=iteratee(value,index,list);if(computed>lastComputed||computed===-Infinity&&result===-Infinity){result=value;lastComputed=computed}})}return result};_.min=function(obj,iteratee,context){var result=Infinity,lastComputed=Infinity,value,computed;if(iteratee==null&&obj!=null){obj=obj.length===+obj.length?obj:_.values(obj);for(var i=0,length=obj.length;i<length;i++){value=obj[i];if(value<result){result=value}}}else{iteratee=_.iteratee(iteratee,context);_.each(obj,function(value,index,list){computed=iteratee(value,index,list);if(computed<lastComputed||computed===Infinity&&result===Infinity){result=value;lastComputed=computed}})}return result};_.shuffle=function(obj){var set=obj&&obj.length===+obj.length?obj:_.values(obj);var length=set.length;var shuffled=Array(length);for(var index=0,rand;index<length;index++){rand=_.random(0,index);if(rand!==index)shuffled[index]=shuffled[rand];shuffled[rand]=set[index]}return shuffled};_.sample=function(obj,n,guard){if(n==null||guard){if(obj.length!==+obj.length)obj=_.values(obj);return obj[_.random(obj.length-1)]}return _.shuffle(obj).slice(0,Math.max(0,n))};_.sortBy=function(obj,iteratee,context){iteratee=_.iteratee(iteratee,context);return _.pluck(_.map(obj,function(value,index,list){return{value:value,index:index,criteria:iteratee(value,index,list)}}).sort(function(left,right){var a=left.criteria;var b=right.criteria;if(a!==b){if(a>b||a===void 0)return 1;if(a<b||b===void 0)return-1}return left.index-right.index}),'value')};var group=function(behavior){return function(obj,iteratee,context){var result={};iteratee=_.iteratee(iteratee,context);_.each(obj,function(value,index){var key=iteratee(value,index,obj);behavior(result,value,key)});return result}};_.groupBy=group(function(result,value,key){if(_.has(result,key))result[key].push(value);else result[key]=[value]});_.indexBy=group(function(result,value,key){result[key]=value});_.countBy=group(function(result,value,key){if(_.has(result,key))result[key]++;else result[key]=1});_.sortedIndex=function(array,obj,iteratee,context){iteratee=_.iteratee(iteratee,context,1);var value=iteratee(obj);var low=0,high=array.length;while(low<high){var mid=low+high>>>1;if(iteratee(array[mid])<value)low=mid+1;else high=mid}return low};_.toArray=function(obj){if(!obj)return[];if(_.isArray(obj))return slice.call(obj);if(obj.length===+obj.length)return _.map(obj,_.identity);return _.values(obj)};_.size=function(obj){if(obj==null)return 0;return obj.length===+obj.length?obj.length:_.keys(obj).length};_.partition=function(obj,predicate,context){predicate=_.iteratee(predicate,context);var pass=[],fail=[];_.each(obj,function(value,key,obj){(predicate(value,key,obj)?pass:fail).push(value)});return[pass,fail]};_.first=_.head=_.take=function(array,n,guard){if(array==null)return void 0;if(n==null||guard)return array[0];return _.initial(array,array.length-n)};_.initial=function(array,n,guard){return slice.call(array,0,Math.max(0,array.length-(n==null||guard?1:n)))};_.last=function(array,n,guard){if(array==null)return void 0;if(n==null||guard)return array[array.length-1];return _.rest(array,Math.max(0,array.length-n))};_.rest=_.tail=_.drop=function(array,n,guard){return slice.call(array,n==null||guard?1:n)};_.compact=function(array){return _.filter(array,_.identity)};var flatten=function(input,shallow,strict,output){if(shallow&&_.every(input,_.isArray)){return concat.apply(output,input)}for(var i=0,length=input.length;i<length;i++){var value=input[i];if(!_.isArray(value)&&!_.isArguments(value)){if(!strict)output.push(value)}else if(shallow){push.apply(output,value)}else{flatten(value,shallow,strict,output)}}return output};_.flatten=function(array,shallow){return flatten(array,shallow,false,[])};_.without=function(array){return _.difference(array,slice.call(arguments,1))};_.uniq=_.unique=function(array,isSorted,iteratee,context){if(array==null)return[];if(!_.isBoolean(isSorted)){context=iteratee;iteratee=isSorted;isSorted=false}if(iteratee!=null)iteratee=_.iteratee(iteratee,context);var result=[];var seen=[];for(var i=0,length=array.length;i<length;i++){var value=array[i];if(isSorted){if(!i||seen!==value)result.push(value);seen=value}else if(iteratee){var computed=iteratee(value,i,array);if(_.indexOf(seen,computed)<0){seen.push(computed);result.push(value)}}else if(_.indexOf(result,value)<0){result.push(value)}}return result};_.union=function(){return _.uniq(flatten(arguments,true,true,[]))};_.intersection=function(array){if(array==null)return[];var result=[];var argsLength=arguments.length;for(var i=0,length=array.length;i<length;i++){var item=array[i];if(_.contains(result,item))continue;for(var j=1;j<argsLength;j++){if(!_.contains(arguments[j],item))break}if(j===argsLength)result.push(item)}return result};_.difference=function(array){var rest=flatten(slice.call(arguments,1),true,true,[]);return _.filter(array,function(value){return!_.contains(rest,value)})};_.zip=function(array){if(array==null)return[];var length=_.max(arguments,'length').length;var results=Array(length);while(length-->0){results[length]=_.pluck(arguments,length)}return results};_.unzip=function(array){return _.zip.apply(null,array)};_.object=function(list,values){if(list==null)return{};var result={};for(var i=0,length=list.length;i<length;i++){if(values){result[list[i]]=values[i]}else{result[list[i][0]]=list[i][1]}}return result};_.indexOf=function(array,item,isSorted){if(array==null)return-1;var i=0,length=array.length;if(isSorted){if(typeof isSorted=='number'){i=isSorted<0?Math.max(0,length+isSorted):isSorted}else{i=_.sortedIndex(array,item);return array[i]===item?i:-1}}for(;i<length;i++)if(array[i]===item)return i;return-1};_.lastIndexOf=function(array,item,from){if(array==null)return-1;var idx=array.length;if(typeof from=='number'){idx=from<0?idx+from+1:Math.min(idx,from+1)}while(--idx>=0)if(array[idx]===item)return idx;return-1};_.range=function(start,stop,step){if(arguments.length<=1){stop=start||0;start=0}step=step||1;var length=Math.max(Math.ceil((stop-start)/step),0);var range=Array(length);for(var idx=0;idx<length;idx++,start+=step){range[idx]=start}return range};var Ctor=function(){};_.bind=function(func,context){var args,bound;if(nativeBind&&func.bind===nativeBind)return nativeBind.apply(func,slice.call(arguments,1));if(!_.isFunction(func))throw new TypeError('Bind must be called on a function');args=slice.call(arguments,2);bound=function(){if(!(this instanceof bound))return func.apply(context,args.concat(slice.call(arguments)));Ctor.prototype=func.prototype;var self=new Ctor;Ctor.prototype=null;var result=func.apply(self,args.concat(slice.call(arguments)));if(_.isObject(result))return result;return self};return bound};_.partial=function(func){var boundArgs=slice.call(arguments,1);return function(){var position=0;var args=boundArgs.slice();for(var i=0,length=args.length;i<length;i++){if(args[i]===_)args[i]=arguments[position++]}while(position<arguments.length)args.push(arguments[position++]);return func.apply(this,args)}};_.bindAll=function(obj){var i,length=arguments.length,key;if(length<=1)throw new Error('bindAll must be passed function names');for(i=1;i<length;i++){key=arguments[i];obj[key]=_.bind(obj[key],obj)}return obj};_.memoize=function(func,hasher){var memoize=function(key){var cache=memoize.cache;var address=''+(hasher?hasher.apply(this,arguments):key);if(!_.has(cache,address))cache[address]=func.apply(this,arguments);return cache[address]};memoize.cache={};return memoize};_.delay=function(func,wait){var args=slice.call(arguments,2);return setTimeout(function(){return func.apply(null,args)},wait)};_.defer=function(func){return _.delay.apply(_,[func,1].concat(slice.call(arguments,1)))};_.throttle=function(func,wait,options){var context,args,result;var timeout=null;var previous=0;if(!options)options={};var later=function(){previous=options.leading===false?0:_.now();timeout=null;result=func.apply(context,args);if(!timeout)context=args=null};return function(){var now=_.now();if(!previous&&options.leading===false)previous=now;var remaining=wait-(now-previous);context=this;args=arguments;if(remaining<=0||remaining>wait){if(timeout){clearTimeout(timeout);timeout=null}previous=now;result=func.apply(context,args);if(!timeout)context=args=null}else if(!timeout&&options.trailing!==false){timeout=setTimeout(later,remaining)}return result}};_.debounce=function(func,wait,immediate){var timeout,args,context,timestamp,result;var later=function(){var last=_.now()-timestamp;if(last<wait&&last>=0){timeout=setTimeout(later,wait-last)}else{timeout=null;if(!immediate){result=func.apply(context,args);if(!timeout)context=args=null}}};return function(){context=this;args=arguments;timestamp=_.now();var callNow=immediate&&!timeout;if(!timeout)timeout=setTimeout(later,wait);if(callNow){result=func.apply(context,args);context=args=null}return result}};_.wrap=function(func,wrapper){return _.partial(wrapper,func)};_.negate=function(predicate){return function(){return!predicate.apply(this,arguments)}};_.compose=function(){var args=arguments;var start=args.length-1;return function(){var i=start;var result=args[start].apply(this,arguments);while(i--)result=args[i].call(this,result);return result}};_.after=function(times,func){return function(){if(--times<1){return func.apply(this,arguments)}}};_.before=function(times,func){var memo;return function(){if(--times>0){memo=func.apply(this,arguments)}else{func=null}return memo}};_.once=_.partial(_.before,2);var hasEnumBug=!({toString:null}).propertyIsEnumerable('toString');var nonEnumerableProps=['constructor','valueOf','isPrototypeOf','toString','propertyIsEnumerable','hasOwnProperty','toLocaleString'];_.keys=function(obj){if(!_.isObject(obj))return[];if(nativeKeys)return nativeKeys(obj);var keys=[];for(var key in obj)if(_.has(obj,key))keys.push(key);if(hasEnumBug){var nonEnumIdx=nonEnumerableProps.length;while(nonEnumIdx--){var prop=nonEnumerableProps[nonEnumIdx];if(_.has(obj,prop)&&!_.contains(keys,prop))keys.push(prop)}}return keys};_.values=function(obj){var keys=_.keys(obj);var length=keys.length;var values=Array(length);for(var i=0;i<length;i++){values[i]=obj[keys[i]]}return values};_.pairs=function(obj){var keys=_.keys(obj);var length=keys.length;var pairs=Array(length);for(var i=0;i<length;i++){pairs[i]=[keys[i],obj[keys[i]]]}return pairs};_.invert=function(obj){var result={};var keys=_.keys(obj);for(var i=0,length=keys.length;i<length;i++){result[obj[keys[i]]]=keys[i]}return result};_.functions=_.methods=function(obj){var names=[];for(var key in obj){if(_.isFunction(obj[key]))names.push(key)}return names.sort()};_.extend=function(obj){if(!_.isObject(obj))return obj;var source,prop;for(var i=1,length=arguments.length;i<length;i++){source=arguments[i];for(prop in source){obj[prop]=source[prop]}}return obj};_.pick=function(obj,iteratee,context){var result={},key;if(obj==null)return result;if(_.isFunction(iteratee)){iteratee=createCallback(iteratee,context);for(key in obj){var value=obj[key];if(iteratee(value,key,obj))result[key]=value}}else{var keys=concat.apply([],slice.call(arguments,1));obj=new Object(obj);for(var i=0,length=keys.length;i<length;i++){key=keys[i];if(key in obj)result[key]=obj[key]}}return result};_.omit=function(obj,iteratee,context){if(_.isFunction(iteratee)){iteratee=_.negate(iteratee)}else{var keys=_.map(concat.apply([],slice.call(arguments,1)),String);iteratee=function(value,key){return!_.contains(keys,key)}}return _.pick(obj,iteratee,context)};_.defaults=function(obj){if(!_.isObject(obj))return obj;for(var i=1,length=arguments.length;i<length;i++){var source=arguments[i];for(var prop in source){if(obj[prop]===void 0)obj[prop]=source[prop]}}return obj};_.clone=function(obj){if(!_.isObject(obj))return obj;return _.isArray(obj)?obj.slice():_.extend({},obj)};_.tap=function(obj,interceptor){interceptor(obj);return obj};var eq=function(a,b,aStack,bStack){if(a===b)return a!==0||1/a===1/b;if(a==null||b==null)return a===b;if(a instanceof _)a=a._wrapped;if(b instanceof _)b=b._wrapped;var className=toString.call(a);if(className!==toString.call(b))return false;switch(className){case'[object RegExp]':case'[object String]':return''+a===''+b;case'[object Number]':if(+a!==+a)return+b!==+b;return+a===0?1/+a===1/b:+a===+b;case'[object Date]':case'[object Boolean]':return+a===+b}var areArrays=className==='[object Array]';if(!areArrays){if(typeof a!='object'||typeof b!='object')return false;var aCtor=a.constructor,bCtor=b.constructor;if(aCtor!==bCtor&&!(_.isFunction(aCtor)&&aCtor instanceof aCtor&&_.isFunction(bCtor)&&bCtor instanceof bCtor)&&('constructor'in a&&'constructor'in b)){return false}}var length=aStack.length;while(length--){if(aStack[length]===a)return bStack[length]===b}aStack.push(a);bStack.push(b);var size,result;if(areArrays){size=a.length;result=size===b.length;if(result){while(size--){if(!(result=eq(a[size],b[size],aStack,bStack)))break}}}else{var keys=_.keys(a),key;size=keys.length;result=_.keys(b).length===size;if(result){while(size--){key=keys[size];if(!(result=_.has(b,key)&&eq(a[key],b[key],aStack,bStack)))break}}}aStack.pop();bStack.pop();return result};_.isEqual=function(a,b){return eq(a,b,[],[])};_.isEmpty=function(obj){if(obj==null)return true;if(_.isArray(obj)||_.isString(obj)||_.isArguments(obj))return obj.length===0;for(var key in obj)if(_.has(obj,key))return false;return true};_.isElement=function(obj){return!!(obj&&obj.nodeType===1)};_.isArray=nativeIsArray||function(obj){return toString.call(obj)==='[object Array]'};_.isObject=function(obj){var type=typeof obj;return type==='function'||type==='object'&&!!obj};_.each(['Arguments','Function','String','Number','Date','RegExp','Error'],function(name){_['is'+name]=function(obj){return toString.call(obj)==='[object '+name+']'}});if(!_.isArguments(arguments)){_.isArguments=function(obj){return _.has(obj,'callee')}}if(typeof/./!=='function'){_.isFunction=function(obj){return typeof obj=='function'||false}}_.isFinite=function(obj){return isFinite(obj)&&!isNaN(parseFloat(obj))};_.isNaN=function(obj){return _.isNumber(obj)&&obj!==+obj};_.isBoolean=function(obj){return obj===true||obj===false||toString.call(obj)==='[object Boolean]'};_.isNull=function(obj){return obj===null};_.isUndefined=function(obj){return obj===void 0};_.has=function(obj,key){return obj!=null&&hasOwnProperty.call(obj,key)};_.noConflict=function(){root._=previousUnderscore;return this};_.identity=function(value){return value};_.constant=function(value){return function(){return value}};_.noop=function(){};_.property=function(key){return function(obj){return obj==null?void 0:obj[key]}};_.matches=function(attrs){var pairs=_.pairs(attrs),length=pairs.length;return function(obj){if(obj==null)return!length;obj=new Object(obj);for(var i=0;i<length;i++){var pair=pairs[i],key=pair[0];if(pair[1]!==obj[key]||!(key in obj))return false}return true}};_.times=function(n,iteratee,context){var accum=Array(Math.max(0,n));iteratee=createCallback(iteratee,context,1);for(var i=0;i<n;i++)accum[i]=iteratee(i);return accum};_.random=function(min,max){if(max==null){max=min;min=0}return min+Math.floor(Math.random()*(max-min+1))};_.now=Date.now||function(){return new Date().getTime()};var escapeMap={'&':'&','<':'<','>':'>','"':'"',"'":''','`':'`'};var unescapeMap=_.invert(escapeMap);var createEscaper=function(map){var escaper=function(match){return map[match]};var source='(?:'+_.keys(map).join('|')+')';var testRegexp=RegExp(source);var replaceRegexp=RegExp(source,'g');return function(string){string=string==null?'':''+string;return testRegexp.test(string)?string.replace(replaceRegexp,escaper):string}};_.escape=createEscaper(escapeMap);_.unescape=createEscaper(unescapeMap);_.result=function(object,property,fallback){var value=object==null?void 0:object[property];if(value===void 0){return fallback}return _.isFunction(value)?object[property]():value};var idCounter=0;_.uniqueId=function(prefix){var id=++idCounter+'';return prefix?prefix+id:id};_.templateSettings={evaluate:/<%([\s\S]+?)%>/g,interpolate:/<%=([\s\S]+?)%>/g,escape:/<%-([\s\S]+?)%>/g};var noMatch=/(.)^/;var escapes={"'":"'",'\\':'\\','\r':'r','\n':'n','\u2028':'u2028','\u2029':'u2029'};var escaper=/\\|'|\r|\n|\u2028|\u2029/g;var escapeChar=function(match){return'\\'+escapes[match]};_.template=function(text,settings,oldSettings){if(!settings&&oldSettings)settings=oldSettings;settings=_.defaults({},settings,_.templateSettings);var matcher=RegExp([(settings.escape||noMatch).source,(settings.interpolate||noMatch).source,(settings.evaluate||noMatch).source].join('|')+'|$','g');var index=0;var source="__p+='";text.replace(matcher,function(match,escape,interpolate,evaluate,offset){source+=text.slice(index,offset).replace(escaper,escapeChar);index=offset+match.length;if(escape){source+="'+\n((__t=("+escape+"))==null?'':_.escape(__t))+\n'"}else if(interpolate){source+="'+\n((__t=("+interpolate+"))==null?'':__t)+\n'"}else if(evaluate){source+="';\n"+evaluate+"\n__p+='"}return match});source+="';\n";if(!settings.variable)source='with(obj||{}){\n'+source+'}\n';source="var __t,__p='',__j=Array.prototype.join,"+"print=function(){__p+=__j.call(arguments,'');};\n"+source+'return __p;\n';try{var render=new Function(settings.variable||'obj','_',source)}catch(e){e.source=source;throw e}var template=function(data){return render.call(this,data,_)};var argument=settings.variable||'obj';template.source='function('+argument+'){\n'+source+'}';return template};_.chain=function(obj){var instance=_(obj);instance._chain=true;return instance};var result=function(instance,obj){return instance._chain?_(obj).chain():obj};_.mixin=function(obj){_.each(_.functions(obj),function(name){var func=_[name]=obj[name];_.prototype[name]=function(){var args=[this._wrapped];push.apply(args,arguments);return result(this,func.apply(_,args))}})};_.mixin(_);_.each(['pop','push','reverse','shift','sort','splice','unshift'],function(name){var method=ArrayProto[name];_.prototype[name]=function(){var obj=this._wrapped;method.apply(obj,arguments);if((name==='shift'||name==='splice')&&obj.length===0)delete obj[0];return result(this,obj)}});_.each(['concat','join','slice'],function(name){var method=ArrayProto[name];_.prototype[name]=function(){return result(this,method.apply(this._wrapped,arguments))}});_.prototype.value=function(){return this._wrapped};if(typeof define==='function'&&define.amd){define('underscore',[],function(){return _})}}.call(this)); (function(){ var root=this, Jrec = (function() { function Jrec() {} var Builder = (function() { function Builder(schema_name, table_name, search_path, query) { var _base; this.schema_name = schema_name; this.table_name = table_name; this.search_path = search_path; this.query = query; if ((_base = this.query).select == null) { _base.select = "*"; } this.params = []; this.i = 0; } Builder.prototype.qm = function() { return "$" + (this.i += 1); }; Builder.prototype.make_distinct = function() { return _.map(this.query.distinct.split(","), function(f) { return "data->>'" + f + "' AS " + f; }).join(", "); }; Builder.prototype.make_select = function() { if (this.query.select === "*") { return "data"; } else if (_.isArray(this.query.select)) { this.params.push(this.query.select.join(",")); return "jrec_select(data, " + (this.qm()) + ") as data"; } else { return this.query.select; } }; Builder.prototype.make_where = function(q, join_by) { var comparisons, k, sql, subquery, symbol, value, _i, _len; if (join_by == null) { join_by = 'AND'; } sql = []; for (k in q) { subquery = q[k]; switch (k) { case 'and': case 'AND': case '&': case '&&': sql.push("(" + (this.make_where(subquery, 'AND')) + ")"); break; case 'or': case 'OR': case '|': case '||': sql.push("(" + (this.make_where(subquery, 'OR')) + ")"); break; case 'not': case 'NOT': case '!': sql.push("NOT (" + (this.make_where(subquery, 'AND')) + ")"); break; case 'raw': sql.push(subquery); break; default: if (_.isArray(subquery)) { this.params.push(k); this.params.push(subquery[1]); sql.push("" + (this.plv8_key(subquery[1])) + " " + subquery[0] + " " + (this.plv8_qm(subquery[1]))); } else if (_.isObject(subquery)) { comparisons = []; for (value = _i = 0, _len = subquery.length; _i < _len; value = ++_i) { symbol = subquery[value]; comparisons.push("" + symbol + " " + (this.plv8_qm(value))); this.params.push(k); this.params.push(value); } sql.push(_.map(comparisons, function(comparison) { return "" + (this.plv8_key(value)) + " " + comparison; }).join(" AND ")); } else { this.params.push(k); this.params.push(subquery); sql.push("" + (this.plv8_key(subquery)) + " = " + (this.plv8_qm(subquery))); } } } return sql.join("\n" + join_by + " "); }; Builder.prototype.make_order_by = function() { var k, ord, str, v, _i, _len; str = []; ord = this.query.order_by; if (_.isArray(ord)) { this.params.push(ord[0]); str.push("" + (this.plv8_key(ord[1])) + " " + (ord[1].toUpperCase())); } else if (_.isObject(ord)) { for (v = _i = 0, _len = ord.length; _i < _len; v = ++_i) { k = ord[v]; this.params.push(v); str.push("" + (this.plv8_key(k)) + " " + (k.toUpperCase())); } } else if (ord != null) { str.push(ord); } return str.join(","); }; Builder.prototype.make_group_by = function() { var k, ord, str, v, _i, _len; str = []; ord = this.query.group_by; if (this.query.distinct) { str.push(_.map(this.query.distinct.split(","), function(f) { return "data->>'" + f + "'"; })); } if (_.isArray(ord)) { this.params.push(ord[0]); str.push("" + (this.plv8_key(ord[1])) + " " + (ord[1].toUpperCase())); } else if (_.isObject(ord)) { for (v = _i = 0, _len = ord.length; _i < _len; v = ++_i) { k = ord[v]; this.params.push(v); str.push("" + (this.plv8_key(k)) + " " + (k.toUpperCase())); } } else if (ord != null) { str.push(ord); } return _.flatten(str).join(","); }; Builder.prototype.make_limit = function() { this.params.push(this.query.limit); return this.qm(); }; Builder.prototype.make_offset = function() { this.params.push(this.query.offset); return this.qm(); }; Builder.prototype.build_select = function() { var sql; sql = []; sql.push("SET search_path TO " + this.search_path + ";"); sql.push("SELECT"); if (this.query.distinct != null) { sql.push("DISTINCT " + (this.make_distinct()) + ","); } sql.push("" + (this.make_select()) + " FROM " + this.schema_name + "." + this.table_name); if (!_.isEmpty(this.query.where)) { sql.push("WHERE " + (this.make_where(this.query.where))); } if ((this.query.group_by != null) || (this.query.distinct != null)) { sql.push("GROUP BY " + (this.make_group_by())); } if (this.query.order_by != null) { sql.push("ORDER BY " + (this.make_order_by())); } if (this.query.limit != null) { sql.push("LIMIT " + (this.make_limit())); } if (this.query.offset != null) { sql.push("OFFSET " + (this.make_offset())); } return [sql.join("\n"), this.params]; }; Builder.prototype.build_delete = function() { var sql; sql = []; sql.push("SET search_path TO " + this.search_path + ";"); sql.push("DELETE FROM " + this.schema_name + "." + this.table_name); if (!_.isEmpty(this.query.where)) { sql.push("WHERE " + (this.make_where(this.query.where))); } sql.push("RETURNING data::json;"); return [sql.join("\n"), this.params]; }; Builder.prototype.build_update = function(data, merge) { var sql; if (merge == null) { merge = true; } this.params.push(data); this.params.push(merge); sql = []; sql.push("SET search_path TO " + this.search_path + ";"); sql.push("UPDATE " + this.schema_name + "." + this.table_name + " SET data = jrec_patch(data," + (this.qm()) + "," + (this.qm()) + ")"); if (!_.isEmpty(this.query.where)) { sql.push("WHERE " + (this.make_where(this.query.where))); } sql.push("RETURNING data::json;"); return [sql.join("\n"), this.params]; }; Builder.prototype.build_insert = function(data, merge) { var sql; if (merge == null) { merge = true; } this.params.push(data); this.params.push(merge); sql = []; sql.push("SET search_path TO " + this.search_path + ";"); sql.push("INSERT INTO " + this.schema_name + "." + this.table_name + " (data) VALUES (jrec_patch(jrec_defaults()," + (this.qm()) + "," + (this.qm()) + "))"); sql.push("RETURNING data::json;"); return [sql.join("\n"), this.params]; }; Builder.prototype.plv8_key = function(value) { return "" + (this.typecast(value, true)) + "(data, " + (this.qm()) + "::text)"; }; Builder.prototype.plv8_qm = function(value) { return "" + (this.qm()) + "::" + (this.typecast(value)); }; Builder.prototype.typecast = function(value, is_func) { var type; if (is_func == null) { is_func = false; } type = is_func ? "jrec_" : ""; if (_.isBoolean(value)) { type += "bool"; } else if (_.isDate(value)) { type += "timestamp"; } else if (_.isNumber(value)) { type += "integer"; } else if (_.isObject(value)) { type += (is_func ? "text" : "json"); } else if (_.isArray(value)) { type += (is_func ? "text" : "array"); } else { type += (is_func ? "string" : "text"); } return type; }; return Builder; })(); Jrec.prototype.json = function(_data, _key) { var ret; ret = valueAt(_data, _key); if (ret == null) { return null; } return JSON.stringify(ret); }; Jrec.prototype.string = function(_data, _key) { var ret; ret = valueAt(_data, _key); if (ret == null) { return null; } return ret.toString(); }; Jrec.prototype.integer = function(_data, _key) { var ret; ret = valueAt(_data, _key); if (ret == null) { return null; } return parseInt(ret); }; Jrec.prototype.integer_array = function(_data, _key) { var ret; ret = valueAt(_data, _key); if (ret == null) { return null; } return (ret instanceof Array ? ret : [ret]); }; Jrec.prototype.float = function(_data, _key) { var ret; ret = valueAt(_data, _key); if (ret == null) { return null; } return parseFloat(ret); }; Jrec.prototype.bool = function(_data, _key) { var ret; ret = valueAt(_data, _key); if (ret == null) { return null; } return !!ret; }; Jrec.prototype.timestamp = function(_data, _key) { var ret; ret = valueAt(_data, _key); if (ret == null) { return null; } return new Date(ret); }; Jrec.prototype.patch = function(_data, _value, _sync) { var changes, data, defaults, isObject, k, sync; data = _data; changes = _value; isObject = false; sync = _sync != null ? _sync : true; defaults = _.pick(data, _.keys(JSON.parse(this.defaults()))); for (k in changes) { if (data.hasOwnProperty(k)) { isObject = typeof data[k] === "object" && typeof changes[k] === "object"; data[k] = isObject && sync ? _.extend(data[k], changes[k]) : changes[k]; } else { data[k] = changes[k]; } } if (!sync) { for (k in data) { if (changes[k] == null) { delete data[k]; } } } _.extend(data, defaults); return JSON.stringify(data); }; Jrec.prototype.select = function(_data, _fields) { var data, fields, ret; data = _data; fields = _fields; ret = _.pick(data, fields.split(",")); return JSON.stringify(ret); }; Jrec.prototype.push = function(_data, _key, _value) { var data, field, i, keys, last_field, len, value; data = _data; value = _value; keys = _key.split("."); len = keys.length; last_field = data; field = data; i = 0; while (i < len) { last_field = field; if (field) { field = field[keys[i]]; } ++i; } if (field) { field.push(value); } else { if (!(value instanceof Array)) { value = [value]; } last_field[keys.pop()] = value; } return JSON.stringify(data); }; Jrec.prototype.uuid = function() { var ary; ary = plv8.execute('SELECT uuid_generate_v4() as uuid;'); return JSON.stringify(ary[0]); }; Jrec.prototype.defaults = function() { var timestamp, uuid; uuid = JSON.parse(this.uuid()); timestamp = new Date(); return JSON.stringify({ uuid: uuid.uuid, created_at: timestamp, updated_at: timestamp }); }; Jrec.prototype.create_table = function(schema_name, table_name) { plv8.execute(" CREATE TABLE " + schema_name + "." + table_name + " (\n id serial NOT NULL,\n data json DEFAULT jrec_uuid() NOT NULL,\n CONSTRAINT " + schema_name + "_" + table_name + "_pkey PRIMARY KEY (id));\n\n CREATE UNIQUE INDEX indx_" + schema_name + "_" + table_name + "_unique_uuid ON " + schema_name + "." + table_name + " (jrec_string(data,'uuid'));"); return JSON.stringify(table_name); }; Jrec.prototype.drop_table = function(schema_name, table_name) { plv8.execute("DROP TABLE IF EXISTS " + schema_name + "." + table_name + " CASCADE;"); return JSON.stringify(table_name); }; Jrec.prototype.create_index = function(schema_name, table_name, optns) { var cols, index_name, meth, name, sql, type, _ref, _ref1; index_name = "indx_" + schema_name + "_" + table_name; _ref = optns.cols; for (name in _ref) { type = _ref[name]; index_name += "_" + name; } sql = ["CREATE"]; if (optns.unique) { sql.push("UNIQUE"); } sql.push("INDEX"); if (optns.concurrently) { sql.push("CONCURRENTLY"); } sql.push("" + index_name + " on " + schema_name + "." + table_name); sql.push("("); cols = []; _ref1 = optns.cols; for (name in _ref1) { type = _ref1[name]; meth = "jrec_" + (type === 'text' ? 'string' : type); cols.push("" + meth + "(data,'" + name + "'::" + type + ")"); } sql.push(cols.join(",")); sql.push(")"); sql = sql.join(" "); plv8.execute("DROP INDEX IF EXISTS " + index_name); plv8.execute(sql); return JSON.stringify(index_name); }; Jrec.prototype.drop_index = function(schema_name, table_name, optns) { var index_name, name, type, _ref; index_name = "indx_" + schema_name + "_" + table_name; _ref = optns.cols; for (name in _ref) { type = _ref[name]; index_name += "_" + name; } plv8.execute("DROP INDEX IF EXISTS " + index_name); return JSON.stringify(index_name); }; Jrec.prototype.create_trigger = function(schema_name, table_name) { var sql, trigger_name; trigger_name = schema_name + "_" + table_name + "_trigger"; sql = "CREATE TRIGGER " + trigger_name + " " + "AFTER INSERT OR UPDATE OR DELETE ON " + schema_name + "." + table_name + " " + "FOR EACH ROW EXECUTE PROCEDURE jrec_collection_trigger();"; plv8.execute(sql); return JSON.stringify(trigger_name); }; Jrec.prototype.query = function(_schema_name, _table_name, _query) { var builder, params, result, rows, search_path, sql, _ref; search_path = _schema_name === "public" ? _schema_name : "" + _schema_name + ", public"; builder = new Builder(_schema_name, _table_name, search_path, _query); _ref = builder.build_select(), sql = _ref[0], params = _ref[1]; rows = plv8.execute(sql, params); builder = null; if (_query.select === "*" || _.isArray(_query.select)) { result = _.pluck(rows, 'data'); } else { result = rows; } return JSON.stringify(result); }; Jrec.prototype.upsert = function(_schema_name, _table_name, _data) { var builder, data, params, query, result, rows, search_path, sql, sync, _ref, _ref1; data = _data; search_path = _schema_name === "public" ? _schema_name : "" + _schema_name + ",public"; if (data.uuid != null) { query = { where: { uuid: data.uuid } }; builder = new Builder(_schema_name, _table_name, search_path, query); sync = _data.__sync || true; delete _data.__sync; _ref = builder.build_update(data, sync), sql = _ref[0], params = _ref[1]; } else { builder = new Builder(_schema_name, _table_name, search_path, {}); _ref1 = builder.build_insert(data), sql = _ref1[0], params = _ref1[1]; } rows = plv8.execute(sql, params); result = _.pluck(rows, 'data'); if (result.length === 1) { result = result[0]; } builder = null; return JSON.stringify(result); }; Jrec.prototype.update = function(_schema_name, _table_name, _data, _cond) { var builder, params, result, rows, search_path, sql, sync, _ref; search_path = _schema_name === "public" ? _schema_name : "" + _schema_name + ",public"; builder = new Builder(_schema_name, _table_name, search_path, { where: _cond }); sync = _data.__sync || true; delete _data.__sync; _ref = builder.build_update(_data, sync), sql = _ref[0], params = _ref[1]; rows = plv8.execute(sql, params); result = _.pluck(rows, 'data'); if (result.length === 1) { result = result[0]; } builder = null; return JSON.stringify(result); }; Jrec.prototype.delete = function(_schema_name, _table_name, _cond) { var builder, params, plan, result, rows, search_path, sql, _ref; search_path = _schema_name === "public" ? _schema_name : "" + _schema_name + ",public"; builder = new Builder(_schema_name, _table_name, search_path, { where: _cond }); _ref = builder.build_delete(), sql = _ref[0], params = _ref[1]; plan = plv8.prepare(sql); rows = plan.execute(params); result = _.pluck(rows, 'data'); if (result.length === 1) { result = result[0]; } builder = null; return JSON.stringify(result); }; Jrec.prototype.collection_trigger = function(TG_TABLE_NAME, TG_OP, NEW, OLD) { var live_data; live_data = JSON.stringify({ table_name: TG_TABLE_NAME, op: TG_OP, data: (NEW || OLD).data }); plv8.execute("SELECT pg_notify('live', $1);", [live_data]); } var valueAt = function(data, key) { var i, keys; keys = key.split("."); for (i in keys) { if (data != null) { data = data[keys[i]]; } } return data; }; return Jrec; })(); return root.Jrec = new Jrec(); }.call(this)); })();
$$ LANGUAGE plv8 STABLE STRICT;
SELECT plv8_startup();
CREATE or REPLACE FUNCTION jrec_json(_data json, _key text) RETURNS JSON AS $$
return Jrec.json(_data, _key);
$$ LANGUAGE plv8 IMMUTABLE STRICT;
CREATE or REPLACE FUNCTION jrec_string(_data json, _key text) RETURNS TEXT AS $$
return Jrec.string(_data, _key);
$$ LANGUAGE plv8 IMMUTABLE STRICT;
CREATE or REPLACE FUNCTION jrec_integer(_data json, _key text) RETURNS INT AS $$
return Jrec.integer(_data, _key);
$$ LANGUAGE plv8 IMMUTABLE STRICT;
CREATE or REPLACE FUNCTION jrec_integer_array(_data json, _key text) RETURNS INT[] AS $$
return Jrec.integer_array(_data, _key);
$$ LANGUAGE plv8 IMMUTABLE STRICT;
CREATE or REPLACE FUNCTION jrec_float(_data json, _key text) RETURNS DOUBLE PRECISION AS $$
return Jrec.float(_data, _key);
$$ LANGUAGE plv8 IMMUTABLE STRICT;
CREATE or REPLACE FUNCTION jrec_bool(_data json, _key text) RETURNS BOOLEAN AS $$
return Jrec.bool(_data, _key);
$$ LANGUAGE plv8 IMMUTABLE STRICT;
CREATE or REPLACE FUNCTION jrec_timestamp(_data json, _key text) RETURNS TIMESTAMP AS $$
return Jrec.timestamp(_data, _key);
$$ LANGUAGE plv8 IMMUTABLE STRICT;
CREATE or REPLACE FUNCTION jrec_select(_data json, _fields text) RETURNS JSON AS $$
return Jrec.select(_data, _fields);
$$ LANGUAGE plv8 STABLE STRICT;
CREATE or REPLACE FUNCTION jrec_patch(_data json, _value json, _sync boolean) RETURNS JSON AS $$
return Jrec.patch(_data, _value, _sync);
$$ LANGUAGE plv8 VOLATILE STRICT;
CREATE or REPLACE FUNCTION jrec_push(_data json, _key text, _value json) RETURNS JSON AS $$
return Jrec.push(_data, _key, _value);
$$ LANGUAGE plv8 VOLATILE STRICT;
CREATE or REPLACE FUNCTION jrec_uuid() RETURNS JSON AS $$
return Jrec.uuid();
$$ LANGUAGE plv8 VOLATILE STRICT;
CREATE or REPLACE FUNCTION jrec_defaults() RETURNS JSON AS $$
return Jrec.defaults();
$$ LANGUAGE plv8 VOLATILE STRICT;
CREATE or REPLACE FUNCTION jrec_create_table(schema_name text, table_name text) RETURNS void AS $$
Jrec.create_table(schema_name, table_name);
$$ LANGUAGE plv8 VOLATILE STRICT;
CREATE or REPLACE FUNCTION jrec_create_trigger(schema_name text, table_name text) RETURNS void AS $$
Jrec.create_trigger(schema_name, table_name);
$$ LANGUAGE plv8 VOLATILE STRICT;
CREATE or REPLACE FUNCTION jrec_drop_table(schema_name text, table_name text) RETURNS void AS $$
Jrec.drop_table(schema_name, table_name);
$$ LANGUAGE plv8 VOLATILE STRICT;
CREATE or REPLACE FUNCTION jrec_create_index(schema_name text, table_name text, optns json) RETURNS void AS $$
Jrec.create_index(schema_name, table_name, optns);
$$ LANGUAGE plv8 VOLATILE STRICT;
CREATE or REPLACE FUNCTION jrec_drop_index(schema_name text, table_name text, optns json) RETURNS void AS $$
Jrec.drop_index(schema_name, table_name, optns);
$$ LANGUAGE plv8 VOLATILE STRICT;
– ## – # Select data – # SELECT query(_schema_name, _table_name, {where: {uuid: “12345”}});
CREATE or REPLACE FUNCTION jrec_query(_schema_name text, _table_name text, _query json) RETURNS json AS $$
return Jrec.query(_schema_name, _table_name, _query);
$$ LANGUAGE plv8 STABLE STRICT;
– ## – # Insert ot update row through validation! – # SELECT upsert('User', '{“name”:“foo”}');
CREATE or REPLACE FUNCTION jrec_upsert(_schema_name text, _table_name text, _data json) RETURNS json AS $$
return Jrec.upsert(_schema_name, _table_name, _data);
$$ LANGUAGE plv8 VOLATILE STRICT;
– ## – # Delete single row by uuid – # SELECT remove('users',uuid-1234567);
CREATE or REPLACE FUNCTION jrec_update(_schema_name text, _table_name text, _data json, _cond json) RETURNS json AS $$
return Jrec.update(_schema_name, _table_name, _data, _cond);
$$ LANGUAGE plv8 VOLATILE STRICT;
– ## – # Delete single row by uuid – # SELECT remove('users',uuid-1234567);
CREATE or REPLACE FUNCTION jrec_delete(_schema_name text, _table_name text, _cond json) RETURNS json AS $$
return Jrec.delete(_schema_name, _table_name, _cond);
$$ LANGUAGE plv8 VOLATILE STRICT;
CREATE or REPLACE FUNCTION jrec_collection_trigger() RETURNS trigger AS $$
Jrec.collection_trigger(TG_TABLE_NAME, TG_OP, NEW, OLD)
$$ LANGUAGE plv8 STABLE STRICT;