squel - npm Package Compare versions

Comparing version 3.0.1 to 3.1.0

bower.json

 {
   "name": "squel",
-  "version": "3.0.1",
+  "version": "3.1.0",
   "main": "squel.js",
@@ -5,0 +5,0 @@ "ignore": [

CHANGELOG.md

 # Changelog for [squel](https://github.com/hiddentao/squel)
 
+## 21 Mar 2014 (3.1.0)
+* Don't format parameter values returned from the toParam() call, unless their custom value types (#54)
+
 ## 20 Mar 2014 (3.0.1)
@@ -4,0 +7,0 @@ * Added `setFields` and `setFieldRows` to make setting multple fields and inserting multiple rows easier (#50)

package.json

 {
   "name": "squel",
   "description": "SQL query string builder",
-  "version": "3.0.1",
+  "version": "3.1.0",
   "author": "Ramesh Nair <[e-mail]> (http://www.hiddentao.com/)",
@@ -6,0 +6,0 @@ "contributors": [

squel-basic.js

@@ -242,3 +242,3 @@ /*
 
-    BaseBuilder.prototype._formatValue = function(value) {
+    BaseBuilder.prototype._formatCustomValue = function(value) {
       var customHandler;
@@ -249,2 +249,7 @@ customHandler = getValueHandler(value, this.options.valueHandlers, cls.globalValueHandlers);
       }
+      return value;
+    };
+
+    BaseBuilder.prototype._formatValue = function(value) {
+      value = this._formatCustomValue(value);
       if (null === value) {
@@ -763,3 +768,3 @@ value = "NULL";
         str += "" + this.fields[i] + " = ?";
-        vals.push(this._formatValue(this.values[0][i]));
+        vals.push(this._formatCustomValue(this.values[0][i]));
       }
@@ -819,3 +824,3 @@ return {
         for (j = _k = 0, _ref7 = this.values[i].length; 0 <= _ref7 ? _k < _ref7 : _k > _ref7; j = 0 <= _ref7 ? ++_k : --_k) {
-          params.push(this._formatValue(this.values[i][j]));
+          params.push(this._formatCustomValue(this.values[i][j]));
           if ('string' === typeof vals[i]) {
@@ -822,0 +827,0 @@ vals[i] += ', ?';

squel-basic.min.js

@@ -1,1 +0,1 @@
-/*! squel | https://github.com/hiddentao/squel | BSD license */(function(){var a,b,c,d,e,f,g,h,i,j,k=[].slice,l={}.hasOwnProperty,m=function(a,b){function c(){this.constructor=a}for(var d in b)l.call(b,d)&&(a[d]=b[d]);return c.prototype=b.prototype,a.prototype=new c,a.__super__=b.prototype,a};a={},e=function(){var a,b,c,d,e,f,g;if(a=arguments[0],c=2<=arguments.length?k.call(arguments,1):[])for(f=0,g=c.length;g>f;f++)if(d=c[f])for(b in d)l.call(d,b)&&(e=d[b],a[b]=e);return a},a.DefaultQueryBuilderOptions={autoQuoteTableNames:!1,autoQuoteFieldNames:!1,autoQuoteAliasNames:!0,nameQuoteCharacter:"`",tableAliasQuoteCharacter:"`",fieldAliasQuoteCharacter:'"',valueHandlers:[],numberedParameters:!1},a.globalValueHandlers=[],c=function(a,b,c){var d,e,f;if("function"!=typeof b)throw new Error("type must be a class constructor");if("function"!=typeof c)throw new Error("handler must be a function");for(e=0,f=a.length;f>e;e++)if(d=a[e],d.type===b)return void(d.handler=c);return a.push({type:b,handler:c})},b=function(){var a,b,c,d,e,f,g,h;for(d=arguments[0],a=2<=arguments.length?k.call(arguments,1):[],e=0,g=a.length;g>e;e++)for(b=a[e],f=0,h=b.length;h>f;f++)if(c=b[f],d instanceof c.type)return c.handler;return void 0},a.registerValueHandler=function(b,d){return c(a.globalValueHandlers,b,d)},a.Cloneable=function(){function a(){}return a.prototype.clone=function(){var a;return a=new this.constructor,e(a,JSON.parse(JSON.stringify(this)))},a}(),a.BaseBuilder=function(d){function f(b){var c;c=JSON.parse(JSON.stringify(a.DefaultQueryBuilderOptions)),this.options=e({},c,b)}return m(f,d),f.prototype.registerValueHandler=function(a,b){return c(this.options.valueHandlers,a,b),this},f.prototype._getObjectClassName=function(a){var b;return a&&a.constructor&&a.constructor.toString&&(b=a.constructor.toString().match(/function\s*(\w+)/),b&&2===b.length)?b[1]:void 0},f.prototype._sanitizeCondition=function(b){if(b instanceof a.Expression&&(b=b.toString()),"string"!=typeof b)throw new Error("condition must be a string or Expression instance");return b},f.prototype._sanitizeName=function(a,b){if("string"!=typeof a)throw new Error(""+b+" must be a string");return a},f.prototype._sanitizeField=function(a){var b;return b=this._sanitizeName(a,"field name"),this.options.autoQuoteFieldNames?""+this.options.nameQuoteCharacter+b+this.options.nameQuoteCharacter:b},f.prototype._sanitizeTable=function(b,c){var d;if(null==c&&(c=!1),c){if("string"!=typeof b){if(b instanceof a.QueryBuilder&&b.isNestable())return b;throw new Error("table name must be a string or a nestable query instance")}d=b}else d=this._sanitizeName(b,"table name");return this.options.autoQuoteTableNames?""+this.options.nameQuoteCharacter+d+this.options.nameQuoteCharacter:d},f.prototype._sanitizeTableAlias=function(a){var b;return b=this._sanitizeName(a,"table alias"),this.options.autoQuoteAliasNames?""+this.options.tableAliasQuoteCharacter+b+this.options.tableAliasQuoteCharacter:b},f.prototype._sanitizeFieldAlias=function(a){var b;return b=this._sanitizeName(a,"field alias"),this.options.autoQuoteAliasNames?""+this.options.fieldAliasQuoteCharacter+b+this.options.fieldAliasQuoteCharacter:b},f.prototype._sanitizeLimitOffset=function(a){if(a=parseInt(a),0>a||isNaN(a))throw new Error("limit/offset must be >= 0");return a},f.prototype._sanitizeValue=function(c){var d,e;if(d=typeof c,null===c);else if("string"===d||"number"===d||"boolean"===d);else if(e=void 0!==b(c,this.options.valueHandlers,a.globalValueHandlers),!e)throw new Error("field value must be a string, number, boolean, null or one of the registered custom value types");return c},f.prototype._escapeValue=function(a){return a},f.prototype._formatValue=function(c){var d;return d=b(c,this.options.valueHandlers,a.globalValueHandlers),d&&(c=d(c)),null===c?c="NULL":"boolean"==typeof c?c=c?"TRUE":"FALSE":"number"!=typeof c&&(c=this._escapeValue(c),c="'"+c+"'"),c},f}(a.Cloneable),a.Expression=function(a){function b(){var a=this;this.tree={parent:null,nodes:[]},this.current=this.tree,this._begin=function(b){var c;return c={type:b,parent:a.current,nodes:[]},a.current.nodes.push(c),a.current=a.current.nodes[a.current.nodes.length-1],a}}var c;return m(b,a),b.prototype.tree=null,b.prototype.current=null,b.prototype.and_begin=function(){return this._begin("AND")},b.prototype.or_begin=function(){return this._begin("OR")},b.prototype.end=function(){if(!this.current.parent)throw new Error("begin() needs to be called");return this.current=this.current.parent,this},b.prototype.and=function(a){if(!a||"string"!=typeof a)throw new Error("expr must be a string");return this.current.nodes.push({type:"AND",expr:a}),this},b.prototype.or=function(a){if(!a||"string"!=typeof a)throw new Error("expr must be a string");return this.current.nodes.push({type:"OR",expr:a}),this},b.prototype.toString=function(){if(null!==this.current.parent)throw new Error("end() needs to be called");return c(this.tree)},c=function(a){var b,d,e,f,g,h;for(e="",h=a.nodes,f=0,g=h.length;g>f;f++)b=h[f],null!=b.expr?d=b.expr:(d=c(b),""!==d&&(d="("+d+")")),""!==d&&(""!==e&&(e+=" "+b.type+" "),e+=d);return e},b.prototype.clone=function(){var a,b;return a=new this.constructor,(b=function(c){var d,e,f,g,h;for(g=c.nodes,h=[],e=0,f=g.length;f>e;e++)d=g[e],null!=d.expr?h.push(a.current.nodes.push(JSON.parse(JSON.stringify(d)))):(a._begin(d.type),b(d),h.push(!this.current===d?a.end():void 0));return h})(this.tree),a},b}(a.Cloneable),a.Block=function(b){function c(){return f=c.__super__.constructor.apply(this,arguments)}return m(c,b),c.prototype.exposedMethods=function(){var b,c,d;c={};for(b in this)d=this[b],"function"!=typeof d||"_"===b.charAt(0)||a.Block.prototype[b]||(c[b]=d);return c},c.prototype.buildStr=function(){return""},c.prototype.buildParam=function(a){return{text:this.buildStr(a),values:[]}},c}(a.BaseBuilder),a.StringBlock=function(a){function b(a,c){b.__super__.constructor.call(this,a),this.str=c}return m(b,a),b.prototype.buildStr=function(){return this.str},b}(a.Block),a.AbstractTableBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.tables=[]}return m(b,a),b.prototype._table=function(a,b){return null==b&&(b=null),b&&(b=this._sanitizeTableAlias(b)),a=this._sanitizeTable(a,this.options.allowNested||!1),this.options.singleTable&&(this.tables=[]),this.tables.push({table:a,alias:b})},b.prototype.buildStr=function(){var a,b,c,d,e;if(0>=this.tables.length)throw new Error("_table() needs to be called");for(b="",e=this.tables,c=0,d=e.length;d>c;c++)a=e[c],""!==b&&(b+=", "),b+="string"==typeof a.table?a.table:"("+a.table+")",a.alias&&(b+=" "+a.alias);return b},b}(a.Block),a.UpdateTableBlock=function(a){function b(){return g=b.__super__.constructor.apply(this,arguments)}return m(b,a),b.prototype.table=function(a,b){return null==b&&(b=null),this._table(a,b)},b}(a.AbstractTableBlock),a.FromTableBlock=function(a){function b(){return h=b.__super__.constructor.apply(this,arguments)}return m(b,a),b.prototype.from=function(a,b){return null==b&&(b=null),this._table(a,b)},b.prototype.buildStr=function(a){var c;if(0>=this.tables.length)throw new Error("from() needs to be called");return c=b.__super__.buildStr.call(this,a),"FROM "+c},b}(a.AbstractTableBlock),a.IntoTableBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.table=null}return m(b,a),b.prototype.into=function(a){return this.table=this._sanitizeTable(a,!1)},b.prototype.buildStr=function(){if(!this.table)throw new Error("into() needs to be called");return"INTO "+this.table},b}(a.Block),a.GetFieldBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this._fields=[]}return m(b,a),b.prototype.fields=function(a){var b,c,d;d=[];for(c in a)b=a[c],d.push(this.field(c,b));return d},b.prototype.field=function(a,b){return null==b&&(b=null),a=this._sanitizeField(a),b&&(b=this._sanitizeFieldAlias(b)),this._fields.push({name:a,alias:b})},b.prototype.buildStr=function(){var a,b,c,d,e;for(b="",e=this._fields,c=0,d=e.length;d>c;c++)a=e[c],""!==b&&(b+=", "),b+=a.name,a.alias&&(b+=" AS "+a.alias);return""===b?"*":b},b}(a.Block),a.AbstractSetFieldBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.fields=[],this.values=[]}return m(b,a),b.prototype.set=function(a,b){var c;if(this.values.length>1)throw new Error("Cannot call set or setFields on multiple rows of fields.");return void 0!==b&&(b=this._sanitizeValue(b)),c=this.fields.indexOf(this._sanitizeField(a)),-1!==c?this.values[0][c]=b:(this.fields.push(this._sanitizeField(a)),c=this.fields.length-1,Array.isArray(this.values[0])?this.values[0][c]=b:this.values.push([b])),this},b.prototype.setFields=function(a){var b;if("object"!=typeof a)throw new Error("Expected an object but got "+typeof a);for(b in a)l.call(a,b)&&this.set(b,a[b]);return this},b.prototype.setFieldsRows=function(a){var b,c,d,e,f,g,h;if(!Array.isArray(a))throw new Error("Expected an array of objects but got "+typeof a);for(this.fields=[],this.values=[],c=f=0,g=a.length;g>=0?g>f:f>g;c=g>=0?++f:--f){h=a[c];for(b in h)if(l.call(h,b)){if(d=this.fields.indexOf(this._sanitizeField(b)),c>0&&-1===d)throw new Error("All fields in subsequent rows must match the fields in the first row");-1===d&&(this.fields.push(this._sanitizeField(b)),d=this.fields.length-1),e=this._sanitizeValue(a[c][b]),Array.isArray(this.values[c])?this.values[c][d]=e:this.values[c]=[e]}}return this},b.prototype.buildStr=function(){throw new Error("Not yet implemented")},b.prototype.buildParam=function(){throw new Error("Not yet implemented")},b}(a.Block),a.SetFieldBlock=function(a){function b(){return i=b.__super__.constructor.apply(this,arguments)}return m(b,a),b.prototype.setFieldsRows=function(){throw new Error("Cannot call setFieldRows for an UPDATE SET")},b.prototype.buildStr=function(){var a,b,c,d,e,f;if(0>=this.fields.length)throw new Error("set() needs to be called");for(c="",b=e=0,f=this.fields.length;f>=0?f>e:e>f;b=f>=0?++e:--e)a=this.fields[b],""!==c&&(c+=", "),d=this.values[0][b],c+="undefined"==typeof d?a:""+a+" = "+this._formatValue(d);return"SET "+c},b.prototype.buildParam=function(){var a,b,c,d,e;if(0>=this.fields.length)throw new Error("set() needs to be called");for(b="",c=[],a=d=0,e=this.fields.length;e>=0?e>d:d>e;a=e>=0?++d:--d)""!==b&&(b+=", "),b+=""+this.fields[a]+" = ?",c.push(this._formatValue(this.values[0][a]));return{text:"SET "+b,values:c}},b}(a.AbstractSetFieldBlock),a.InsertFieldValueBlock=function(a){function b(){return j=b.__super__.constructor.apply(this,arguments)}return m(b,a),b.prototype.buildStr=function(){var a,b,c,d,e,f,g,h;if(0>=this.fields.length)throw new Error("set() needs to be called");for(d=[],b=e=0,g=this.values.length;g>=0?g>e:e>g;b=g>=0?++e:--e)for(c=f=0,h=this.values[b].length;h>=0?h>f:f>h;c=h>=0?++f:--f)a=this._formatValue(this.values[b][c]),"string"==typeof d[b]?d[b]+=", "+a:d[b]=""+a;return"("+this.fields.join(", ")+") VALUES ("+d.join("), (")+")"},b.prototype.buildParam=function(){var a,b,c,d,e,f,g,h,i,j,k;if(0>=this.fields.length)throw new Error("set() needs to be called");for(d="",e=[],c=[],a=f=0,i=this.fields.length;i>=0?i>f:f>i;a=i>=0?++f:--f)""!==d&&(d+=", "),d+=this.fields[a];for(a=g=0,j=this.values.length;j>=0?j>g:g>j;a=j>=0?++g:--g)for(b=h=0,k=this.values[a].length;k>=0?k>h:h>k;b=k>=0?++h:--h)c.push(this._formatValue(this.values[a][b])),"string"==typeof e[a]?e[a]+=", ?":e[a]="?";return{text:"("+d+") VALUES ("+e.join("), (")+")",values:c}},b}(a.AbstractSetFieldBlock),a.DistinctBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.useDistinct=!1}return m(b,a),b.prototype.distinct=function(){return this.useDistinct=!0},b.prototype.buildStr=function(){return this.useDistinct?"DISTINCT":""},b}(a.Block),a.GroupByBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.groups=[]}return m(b,a),b.prototype.group=function(a){return a=this._sanitizeField(a),this.groups.push(a)},b.prototype.buildStr=function(){var a,b,c,d,e;if(b="",0<this.groups.length){for(e=this.groups,c=0,d=e.length;d>c;c++)a=e[c],""!==b&&(b+=", "),b+=a;b="GROUP BY "+b}return b},b}(a.Block),a.OffsetBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.offsets=null}return m(b,a),b.prototype.offset=function(a){return a=this._sanitizeLimitOffset(a),this.offsets=a},b.prototype.buildStr=function(){return this.offsets?"OFFSET "+this.offsets:""},b}(a.Block),a.WhereBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.wheres=[],this.wheresParam=[]}return m(b,a),b.prototype.where=function(){var a,b,c,d,e,f,g,h,i,j;for(a=arguments[0],e=2<=arguments.length?k.call(arguments,1):[],a=this._sanitizeCondition(a),f={text:a,values:[]},g=0,i=e.length;i>g;g++){if(d=e[g],Array.isArray(d)){for(b=[],h=0,j=d.length;j>h;h++)c=d[h],b.push(this._formatValue(this._sanitizeValue(c)));d="("+b.join(", ")+")",f.text=a.replace("?","("+function(){var a,d,e;for(e=[],a=0,d=b.length;d>a;a++)c=b[a],e.push("?");return e}().join(", ")+")"),f.values=b}else d=this._formatValue(this._sanitizeValue(d)),f.values.push(d);a=a.replace("?",d)}return""!==a&&this.wheres.push(a),""!==f.text?this.wheresParam.push(f):void 0},b.prototype.buildStr=function(){return 0<this.wheres.length?"WHERE ("+this.wheres.join(") AND (")+")":""},b.prototype.buildParam=function(){var a,b;return{text:0<this.wheresParam.length?"WHERE ("+function(){var b,c,d,e;for(d=this.wheresParam,e=[],b=0,c=d.length;c>b;b++)a=d[b],e.push(a.text);return e}.call(this).join(") AND (")+")":"",values:(b=[]).concat.apply(b,function(){var b,c,d,e;for(d=this.wheresParam,e=[],b=0,c=d.length;c>b;b++)a=d[b],e.push(a.values);return e}.call(this))}},b}(a.Block),a.OrderByBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.orders=[]}return m(b,a),b.prototype.order=function(a,b){return null==b&&(b=!0),a=this._sanitizeField(a),this.orders.push({field:a,dir:b?!0:!1})},b.prototype.buildStr=function(){var a,b,c,d,e;if(0<this.orders.length){for(b="",e=this.orders,c=0,d=e.length;d>c;c++)a=e[c],""!==b&&(b+=", "),b+=""+a.field+" "+(a.dir?"ASC":"DESC");return"ORDER BY "+b}return""},b}(a.Block),a.LimitBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.limits=null}return m(b,a),b.prototype.limit=function(a){return a=this._sanitizeLimitOffset(a),this.limits=a},b.prototype.buildStr=function(){return this.limits?"LIMIT "+this.limits:""},b}(a.Block),a.JoinBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.joins=[]}return m(b,a),b.prototype.join=function(a,b,c,d){return null==b&&(b=null),null==c&&(c=null),null==d&&(d="INNER"),a=this._sanitizeTable(a,!0),b&&(b=this._sanitizeTableAlias(b)),c&&(c=this._sanitizeCondition(c)),this.joins.push({type:d,table:a,alias:b,condition:c}),this},b.prototype.left_join=function(a,b,c){return null==b&&(b=null),null==c&&(c=null),this.join(a,b,c,"LEFT")},b.prototype.right_join=function(a,b,c){return null==b&&(b=null),null==c&&(c=null),this.join(a,b,c,"RIGHT")},b.prototype.outer_join=function(a,b,c){return null==b&&(b=null),null==c&&(c=null),this.join(a,b,c,"OUTER")},b.prototype.left_outer_join=function(a,b,c){return null==b&&(b=null),null==c&&(c=null),this.join(a,b,c,"LEFT OUTER")},b.prototype.buildStr=function(){var a,b,c,d,e;for(b="",e=this.joins||[],c=0,d=e.length;d>c;c++)a=e[c],""!==b&&(b+=" "),b+=""+a.type+" JOIN ",b+="string"==typeof a.table?a.table:"("+a.table+")",a.alias&&(b+=" "+a.alias),a.condition&&(b+=" ON ("+a.condition+")");return b},b}(a.Block),a.QueryBuilder=function(a){function b(a,c){var d,e,f,g,h,i,j,k,l=this;for(b.__super__.constructor.call(this,a),this.blocks=c||[],j=this.blocks,h=0,i=j.length;i>h;h++){d=j[h],k=d.exposedMethods(),g=function(a,b,c){return l[b]=function(){return c.apply(a,arguments),l}};for(f in k){if(e=k[f],null!=this[f])throw new Error(""+this._getObjectClassName(this)+" already has a builder method called: "+f);g(d,f,e)}}}return m(b,a),b.prototype.registerValueHandler=function(a,c){var d,e,f,g;for(g=this.blocks,e=0,f=g.length;f>e;e++)d=g[e],d.registerValueHandler(a,c);return b.__super__.registerValueHandler.call(this,a,c),this},b.prototype.updateOptions=function(a){var b,c,d,f,g;for(this.options=e({},this.options,a),f=this.blocks,g=[],c=0,d=f.length;d>c;c++)b=f[c],g.push(b.options=e({},b.options,a));return g},b.prototype.toString=function(){var a;return function(){var b,c,d,e;for(d=this.blocks,e=[],b=0,c=d.length;c>b;b++)a=d[b],e.push(a.buildStr(this));return e}.call(this).filter(function(a){return 0<a.length}).join(" ")},b.prototype.toParam=function(){var a,b,c,d,e;return d={text:"",values:[]},b=function(){var b,c,d,e;for(d=this.blocks,e=[],b=0,c=d.length;c>b;b++)a=d[b],e.push(a.buildParam(this));return e}.call(this),d.text=function(){var c,d,e;for(e=[],c=0,d=b.length;d>c;c++)a=b[c],e.push(a.text);return e}().filter(function(a){return 0<a.length}).join(" "),d.values=(e=[]).concat.apply(e,function(){var c,d,e;for(e=[],c=0,d=b.length;d>c;c++)a=b[c],e.push(a.values);return e}()),this.options.numberedParameters&&(c=0,d.text=d.text.replace(/\?/g,function(){return"$"+ ++c})),d},b.prototype.clone=function(){var a;return new this.constructor(this.options,function(){var b,c,d,e;for(d=this.blocks,e=[],b=0,c=d.length;c>b;b++)a=d[b],e.push(a.clone());return e}.call(this))},b.prototype.isNestable=function(){return!1},b}(a.BaseBuilder),a.Select=function(b){function c(b,d){null==d&&(d=null),d||(d=[new a.StringBlock(b,"SELECT"),new a.DistinctBlock(b),new a.GetFieldBlock(b),new a.FromTableBlock(e({},b,{allowNested:!0})),new a.JoinBlock(e({},b,{allowNested:!0})),new a.WhereBlock(b),new a.GroupByBlock(b),new a.OrderByBlock(b),new a.LimitBlock(b),new a.OffsetBlock(b)]),c.__super__.constructor.call(this,b,d)}return m(c,b),c.prototype.isNestable=function(){return!0},c}(a.QueryBuilder),a.Update=function(b){function c(b,d){null==d&&(d=null),d||(d=[new a.StringBlock(b,"UPDATE"),new a.UpdateTableBlock(b),new a.SetFieldBlock(b),new a.WhereBlock(b),new a.OrderByBlock(b),new a.LimitBlock(b)]),c.__super__.constructor.call(this,b,d)}return m(c,b),c}(a.QueryBuilder),a.Delete=function(b){function c(b,d){null==d&&(d=null),d||(d=[new a.StringBlock(b,"DELETE"),new a.FromTableBlock(e({},b,{singleTable:!0})),new a.JoinBlock(b),new a.WhereBlock(b),new a.OrderByBlock(b),new a.LimitBlock(b)]),c.__super__.constructor.call(this,b,d)}return m(c,b),c}(a.QueryBuilder),a.Insert=function(b){function c(b,d){null==d&&(d=null),d||(d=[new a.StringBlock(b,"INSERT"),new a.IntoTableBlock(b),new a.InsertFieldValueBlock(b)]),c.__super__.constructor.call(this,b,d)}return m(c,b),c}(a.QueryBuilder),d={VERSION:"2.0.0",expr:function(){return new a.Expression},select:function(b,c){return new a.Select(b,c)},update:function(b,c){return new a.Update(b,c)},insert:function(b,c){return new a.Insert(b,c)},"delete":function(b,c){return new a.Delete(b,c)},registerValueHandler:a.registerValueHandler},d.remove=d["delete"],d.cls=a,("undefined"!=typeof define&&null!==define?define.amd:void 0)?define(function(){return d}):("undefined"!=typeof module&&null!==module?module.exports:void 0)?module.exports=d:"undefined"!=typeof window&&null!==window&&(window.squel=d),d.flavours={},d.useFlavour=function(a){if(!(d.flavours[a]instanceof Function))throw new Error("Flavour not available: "+a);return d.flavours[a].call(null,d),d}}).call(this);
+/*! squel | https://github.com/hiddentao/squel | BSD license */(function(){var a,b,c,d,e,f,g,h,i,j,k=[].slice,l={}.hasOwnProperty,m=function(a,b){function c(){this.constructor=a}for(var d in b)l.call(b,d)&&(a[d]=b[d]);return c.prototype=b.prototype,a.prototype=new c,a.__super__=b.prototype,a};a={},e=function(){var a,b,c,d,e,f,g;if(a=arguments[0],c=2<=arguments.length?k.call(arguments,1):[])for(f=0,g=c.length;g>f;f++)if(d=c[f])for(b in d)l.call(d,b)&&(e=d[b],a[b]=e);return a},a.DefaultQueryBuilderOptions={autoQuoteTableNames:!1,autoQuoteFieldNames:!1,autoQuoteAliasNames:!0,nameQuoteCharacter:"`",tableAliasQuoteCharacter:"`",fieldAliasQuoteCharacter:'"',valueHandlers:[],numberedParameters:!1},a.globalValueHandlers=[],c=function(a,b,c){var d,e,f;if("function"!=typeof b)throw new Error("type must be a class constructor");if("function"!=typeof c)throw new Error("handler must be a function");for(e=0,f=a.length;f>e;e++)if(d=a[e],d.type===b)return void(d.handler=c);return a.push({type:b,handler:c})},b=function(){var a,b,c,d,e,f,g,h;for(d=arguments[0],a=2<=arguments.length?k.call(arguments,1):[],e=0,g=a.length;g>e;e++)for(b=a[e],f=0,h=b.length;h>f;f++)if(c=b[f],d instanceof c.type)return c.handler;return void 0},a.registerValueHandler=function(b,d){return c(a.globalValueHandlers,b,d)},a.Cloneable=function(){function a(){}return a.prototype.clone=function(){var a;return a=new this.constructor,e(a,JSON.parse(JSON.stringify(this)))},a}(),a.BaseBuilder=function(d){function f(b){var c;c=JSON.parse(JSON.stringify(a.DefaultQueryBuilderOptions)),this.options=e({},c,b)}return m(f,d),f.prototype.registerValueHandler=function(a,b){return c(this.options.valueHandlers,a,b),this},f.prototype._getObjectClassName=function(a){var b;return a&&a.constructor&&a.constructor.toString&&(b=a.constructor.toString().match(/function\s*(\w+)/),b&&2===b.length)?b[1]:void 0},f.prototype._sanitizeCondition=function(b){if(b instanceof a.Expression&&(b=b.toString()),"string"!=typeof b)throw new Error("condition must be a string or Expression instance");return b},f.prototype._sanitizeName=function(a,b){if("string"!=typeof a)throw new Error(""+b+" must be a string");return a},f.prototype._sanitizeField=function(a){var b;return b=this._sanitizeName(a,"field name"),this.options.autoQuoteFieldNames?""+this.options.nameQuoteCharacter+b+this.options.nameQuoteCharacter:b},f.prototype._sanitizeTable=function(b,c){var d;if(null==c&&(c=!1),c){if("string"!=typeof b){if(b instanceof a.QueryBuilder&&b.isNestable())return b;throw new Error("table name must be a string or a nestable query instance")}d=b}else d=this._sanitizeName(b,"table name");return this.options.autoQuoteTableNames?""+this.options.nameQuoteCharacter+d+this.options.nameQuoteCharacter:d},f.prototype._sanitizeTableAlias=function(a){var b;return b=this._sanitizeName(a,"table alias"),this.options.autoQuoteAliasNames?""+this.options.tableAliasQuoteCharacter+b+this.options.tableAliasQuoteCharacter:b},f.prototype._sanitizeFieldAlias=function(a){var b;return b=this._sanitizeName(a,"field alias"),this.options.autoQuoteAliasNames?""+this.options.fieldAliasQuoteCharacter+b+this.options.fieldAliasQuoteCharacter:b},f.prototype._sanitizeLimitOffset=function(a){if(a=parseInt(a),0>a||isNaN(a))throw new Error("limit/offset must be >= 0");return a},f.prototype._sanitizeValue=function(c){var d,e;if(d=typeof c,null===c);else if("string"===d||"number"===d||"boolean"===d);else if(e=void 0!==b(c,this.options.valueHandlers,a.globalValueHandlers),!e)throw new Error("field value must be a string, number, boolean, null or one of the registered custom value types");return c},f.prototype._escapeValue=function(a){return a},f.prototype._formatCustomValue=function(c){var d;return d=b(c,this.options.valueHandlers,a.globalValueHandlers),d&&(c=d(c)),c},f.prototype._formatValue=function(a){return a=this._formatCustomValue(a),null===a?a="NULL":"boolean"==typeof a?a=a?"TRUE":"FALSE":"number"!=typeof a&&(a=this._escapeValue(a),a="'"+a+"'"),a},f}(a.Cloneable),a.Expression=function(a){function b(){var a=this;this.tree={parent:null,nodes:[]},this.current=this.tree,this._begin=function(b){var c;return c={type:b,parent:a.current,nodes:[]},a.current.nodes.push(c),a.current=a.current.nodes[a.current.nodes.length-1],a}}var c;return m(b,a),b.prototype.tree=null,b.prototype.current=null,b.prototype.and_begin=function(){return this._begin("AND")},b.prototype.or_begin=function(){return this._begin("OR")},b.prototype.end=function(){if(!this.current.parent)throw new Error("begin() needs to be called");return this.current=this.current.parent,this},b.prototype.and=function(a){if(!a||"string"!=typeof a)throw new Error("expr must be a string");return this.current.nodes.push({type:"AND",expr:a}),this},b.prototype.or=function(a){if(!a||"string"!=typeof a)throw new Error("expr must be a string");return this.current.nodes.push({type:"OR",expr:a}),this},b.prototype.toString=function(){if(null!==this.current.parent)throw new Error("end() needs to be called");return c(this.tree)},c=function(a){var b,d,e,f,g,h;for(e="",h=a.nodes,f=0,g=h.length;g>f;f++)b=h[f],null!=b.expr?d=b.expr:(d=c(b),""!==d&&(d="("+d+")")),""!==d&&(""!==e&&(e+=" "+b.type+" "),e+=d);return e},b.prototype.clone=function(){var a,b;return a=new this.constructor,(b=function(c){var d,e,f,g,h;for(g=c.nodes,h=[],e=0,f=g.length;f>e;e++)d=g[e],null!=d.expr?h.push(a.current.nodes.push(JSON.parse(JSON.stringify(d)))):(a._begin(d.type),b(d),h.push(!this.current===d?a.end():void 0));return h})(this.tree),a},b}(a.Cloneable),a.Block=function(b){function c(){return f=c.__super__.constructor.apply(this,arguments)}return m(c,b),c.prototype.exposedMethods=function(){var b,c,d;c={};for(b in this)d=this[b],"function"!=typeof d||"_"===b.charAt(0)||a.Block.prototype[b]||(c[b]=d);return c},c.prototype.buildStr=function(){return""},c.prototype.buildParam=function(a){return{text:this.buildStr(a),values:[]}},c}(a.BaseBuilder),a.StringBlock=function(a){function b(a,c){b.__super__.constructor.call(this,a),this.str=c}return m(b,a),b.prototype.buildStr=function(){return this.str},b}(a.Block),a.AbstractTableBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.tables=[]}return m(b,a),b.prototype._table=function(a,b){return null==b&&(b=null),b&&(b=this._sanitizeTableAlias(b)),a=this._sanitizeTable(a,this.options.allowNested||!1),this.options.singleTable&&(this.tables=[]),this.tables.push({table:a,alias:b})},b.prototype.buildStr=function(){var a,b,c,d,e;if(0>=this.tables.length)throw new Error("_table() needs to be called");for(b="",e=this.tables,c=0,d=e.length;d>c;c++)a=e[c],""!==b&&(b+=", "),b+="string"==typeof a.table?a.table:"("+a.table+")",a.alias&&(b+=" "+a.alias);return b},b}(a.Block),a.UpdateTableBlock=function(a){function b(){return g=b.__super__.constructor.apply(this,arguments)}return m(b,a),b.prototype.table=function(a,b){return null==b&&(b=null),this._table(a,b)},b}(a.AbstractTableBlock),a.FromTableBlock=function(a){function b(){return h=b.__super__.constructor.apply(this,arguments)}return m(b,a),b.prototype.from=function(a,b){return null==b&&(b=null),this._table(a,b)},b.prototype.buildStr=function(a){var c;if(0>=this.tables.length)throw new Error("from() needs to be called");return c=b.__super__.buildStr.call(this,a),"FROM "+c},b}(a.AbstractTableBlock),a.IntoTableBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.table=null}return m(b,a),b.prototype.into=function(a){return this.table=this._sanitizeTable(a,!1)},b.prototype.buildStr=function(){if(!this.table)throw new Error("into() needs to be called");return"INTO "+this.table},b}(a.Block),a.GetFieldBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this._fields=[]}return m(b,a),b.prototype.fields=function(a){var b,c,d;d=[];for(c in a)b=a[c],d.push(this.field(c,b));return d},b.prototype.field=function(a,b){return null==b&&(b=null),a=this._sanitizeField(a),b&&(b=this._sanitizeFieldAlias(b)),this._fields.push({name:a,alias:b})},b.prototype.buildStr=function(){var a,b,c,d,e;for(b="",e=this._fields,c=0,d=e.length;d>c;c++)a=e[c],""!==b&&(b+=", "),b+=a.name,a.alias&&(b+=" AS "+a.alias);return""===b?"*":b},b}(a.Block),a.AbstractSetFieldBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.fields=[],this.values=[]}return m(b,a),b.prototype.set=function(a,b){var c;if(this.values.length>1)throw new Error("Cannot call set or setFields on multiple rows of fields.");return void 0!==b&&(b=this._sanitizeValue(b)),c=this.fields.indexOf(this._sanitizeField(a)),-1!==c?this.values[0][c]=b:(this.fields.push(this._sanitizeField(a)),c=this.fields.length-1,Array.isArray(this.values[0])?this.values[0][c]=b:this.values.push([b])),this},b.prototype.setFields=function(a){var b;if("object"!=typeof a)throw new Error("Expected an object but got "+typeof a);for(b in a)l.call(a,b)&&this.set(b,a[b]);return this},b.prototype.setFieldsRows=function(a){var b,c,d,e,f,g,h;if(!Array.isArray(a))throw new Error("Expected an array of objects but got "+typeof a);for(this.fields=[],this.values=[],c=f=0,g=a.length;g>=0?g>f:f>g;c=g>=0?++f:--f){h=a[c];for(b in h)if(l.call(h,b)){if(d=this.fields.indexOf(this._sanitizeField(b)),c>0&&-1===d)throw new Error("All fields in subsequent rows must match the fields in the first row");-1===d&&(this.fields.push(this._sanitizeField(b)),d=this.fields.length-1),e=this._sanitizeValue(a[c][b]),Array.isArray(this.values[c])?this.values[c][d]=e:this.values[c]=[e]}}return this},b.prototype.buildStr=function(){throw new Error("Not yet implemented")},b.prototype.buildParam=function(){throw new Error("Not yet implemented")},b}(a.Block),a.SetFieldBlock=function(a){function b(){return i=b.__super__.constructor.apply(this,arguments)}return m(b,a),b.prototype.setFieldsRows=function(){throw new Error("Cannot call setFieldRows for an UPDATE SET")},b.prototype.buildStr=function(){var a,b,c,d,e,f;if(0>=this.fields.length)throw new Error("set() needs to be called");for(c="",b=e=0,f=this.fields.length;f>=0?f>e:e>f;b=f>=0?++e:--e)a=this.fields[b],""!==c&&(c+=", "),d=this.values[0][b],c+="undefined"==typeof d?a:""+a+" = "+this._formatValue(d);return"SET "+c},b.prototype.buildParam=function(){var a,b,c,d,e;if(0>=this.fields.length)throw new Error("set() needs to be called");for(b="",c=[],a=d=0,e=this.fields.length;e>=0?e>d:d>e;a=e>=0?++d:--d)""!==b&&(b+=", "),b+=""+this.fields[a]+" = ?",c.push(this._formatCustomValue(this.values[0][a]));return{text:"SET "+b,values:c}},b}(a.AbstractSetFieldBlock),a.InsertFieldValueBlock=function(a){function b(){return j=b.__super__.constructor.apply(this,arguments)}return m(b,a),b.prototype.buildStr=function(){var a,b,c,d,e,f,g,h;if(0>=this.fields.length)throw new Error("set() needs to be called");for(d=[],b=e=0,g=this.values.length;g>=0?g>e:e>g;b=g>=0?++e:--e)for(c=f=0,h=this.values[b].length;h>=0?h>f:f>h;c=h>=0?++f:--f)a=this._formatValue(this.values[b][c]),"string"==typeof d[b]?d[b]+=", "+a:d[b]=""+a;return"("+this.fields.join(", ")+") VALUES ("+d.join("), (")+")"},b.prototype.buildParam=function(){var a,b,c,d,e,f,g,h,i,j,k;if(0>=this.fields.length)throw new Error("set() needs to be called");for(d="",e=[],c=[],a=f=0,i=this.fields.length;i>=0?i>f:f>i;a=i>=0?++f:--f)""!==d&&(d+=", "),d+=this.fields[a];for(a=g=0,j=this.values.length;j>=0?j>g:g>j;a=j>=0?++g:--g)for(b=h=0,k=this.values[a].length;k>=0?k>h:h>k;b=k>=0?++h:--h)c.push(this._formatCustomValue(this.values[a][b])),"string"==typeof e[a]?e[a]+=", ?":e[a]="?";return{text:"("+d+") VALUES ("+e.join("), (")+")",values:c}},b}(a.AbstractSetFieldBlock),a.DistinctBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.useDistinct=!1}return m(b,a),b.prototype.distinct=function(){return this.useDistinct=!0},b.prototype.buildStr=function(){return this.useDistinct?"DISTINCT":""},b}(a.Block),a.GroupByBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.groups=[]}return m(b,a),b.prototype.group=function(a){return a=this._sanitizeField(a),this.groups.push(a)},b.prototype.buildStr=function(){var a,b,c,d,e;if(b="",0<this.groups.length){for(e=this.groups,c=0,d=e.length;d>c;c++)a=e[c],""!==b&&(b+=", "),b+=a;b="GROUP BY "+b}return b},b}(a.Block),a.OffsetBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.offsets=null}return m(b,a),b.prototype.offset=function(a){return a=this._sanitizeLimitOffset(a),this.offsets=a},b.prototype.buildStr=function(){return this.offsets?"OFFSET "+this.offsets:""},b}(a.Block),a.WhereBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.wheres=[],this.wheresParam=[]}return m(b,a),b.prototype.where=function(){var a,b,c,d,e,f,g,h,i,j;for(a=arguments[0],e=2<=arguments.length?k.call(arguments,1):[],a=this._sanitizeCondition(a),f={text:a,values:[]},g=0,i=e.length;i>g;g++){if(d=e[g],Array.isArray(d)){for(b=[],h=0,j=d.length;j>h;h++)c=d[h],b.push(this._formatValue(this._sanitizeValue(c)));d="("+b.join(", ")+")",f.text=a.replace("?","("+function(){var a,d,e;for(e=[],a=0,d=b.length;d>a;a++)c=b[a],e.push("?");return e}().join(", ")+")"),f.values=b}else d=this._formatValue(this._sanitizeValue(d)),f.values.push(d);a=a.replace("?",d)}return""!==a&&this.wheres.push(a),""!==f.text?this.wheresParam.push(f):void 0},b.prototype.buildStr=function(){return 0<this.wheres.length?"WHERE ("+this.wheres.join(") AND (")+")":""},b.prototype.buildParam=function(){var a,b;return{text:0<this.wheresParam.length?"WHERE ("+function(){var b,c,d,e;for(d=this.wheresParam,e=[],b=0,c=d.length;c>b;b++)a=d[b],e.push(a.text);return e}.call(this).join(") AND (")+")":"",values:(b=[]).concat.apply(b,function(){var b,c,d,e;for(d=this.wheresParam,e=[],b=0,c=d.length;c>b;b++)a=d[b],e.push(a.values);return e}.call(this))}},b}(a.Block),a.OrderByBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.orders=[]}return m(b,a),b.prototype.order=function(a,b){return null==b&&(b=!0),a=this._sanitizeField(a),this.orders.push({field:a,dir:b?!0:!1})},b.prototype.buildStr=function(){var a,b,c,d,e;if(0<this.orders.length){for(b="",e=this.orders,c=0,d=e.length;d>c;c++)a=e[c],""!==b&&(b+=", "),b+=""+a.field+" "+(a.dir?"ASC":"DESC");return"ORDER BY "+b}return""},b}(a.Block),a.LimitBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.limits=null}return m(b,a),b.prototype.limit=function(a){return a=this._sanitizeLimitOffset(a),this.limits=a},b.prototype.buildStr=function(){return this.limits?"LIMIT "+this.limits:""},b}(a.Block),a.JoinBlock=function(a){function b(a){b.__super__.constructor.call(this,a),this.joins=[]}return m(b,a),b.prototype.join=function(a,b,c,d){return null==b&&(b=null),null==c&&(c=null),null==d&&(d="INNER"),a=this._sanitizeTable(a,!0),b&&(b=this._sanitizeTableAlias(b)),c&&(c=this._sanitizeCondition(c)),this.joins.push({type:d,table:a,alias:b,condition:c}),this},b.prototype.left_join=function(a,b,c){return null==b&&(b=null),null==c&&(c=null),this.join(a,b,c,"LEFT")},b.prototype.right_join=function(a,b,c){return null==b&&(b=null),null==c&&(c=null),this.join(a,b,c,"RIGHT")},b.prototype.outer_join=function(a,b,c){return null==b&&(b=null),null==c&&(c=null),this.join(a,b,c,"OUTER")},b.prototype.left_outer_join=function(a,b,c){return null==b&&(b=null),null==c&&(c=null),this.join(a,b,c,"LEFT OUTER")},b.prototype.buildStr=function(){var a,b,c,d,e;for(b="",e=this.joins||[],c=0,d=e.length;d>c;c++)a=e[c],""!==b&&(b+=" "),b+=""+a.type+" JOIN ",b+="string"==typeof a.table?a.table:"("+a.table+")",a.alias&&(b+=" "+a.alias),a.condition&&(b+=" ON ("+a.condition+")");return b},b}(a.Block),a.QueryBuilder=function(a){function b(a,c){var d,e,f,g,h,i,j,k,l=this;for(b.__super__.constructor.call(this,a),this.blocks=c||[],j=this.blocks,h=0,i=j.length;i>h;h++){d=j[h],k=d.exposedMethods(),g=function(a,b,c){return l[b]=function(){return c.apply(a,arguments),l}};for(f in k){if(e=k[f],null!=this[f])throw new Error(""+this._getObjectClassName(this)+" already has a builder method called: "+f);g(d,f,e)}}}return m(b,a),b.prototype.registerValueHandler=function(a,c){var d,e,f,g;for(g=this.blocks,e=0,f=g.length;f>e;e++)d=g[e],d.registerValueHandler(a,c);return b.__super__.registerValueHandler.call(this,a,c),this},b.prototype.updateOptions=function(a){var b,c,d,f,g;for(this.options=e({},this.options,a),f=this.blocks,g=[],c=0,d=f.length;d>c;c++)b=f[c],g.push(b.options=e({},b.options,a));return g},b.prototype.toString=function(){var a;return function(){var b,c,d,e;for(d=this.blocks,e=[],b=0,c=d.length;c>b;b++)a=d[b],e.push(a.buildStr(this));return e}.call(this).filter(function(a){return 0<a.length}).join(" ")},b.prototype.toParam=function(){var a,b,c,d,e;return d={text:"",values:[]},b=function(){var b,c,d,e;for(d=this.blocks,e=[],b=0,c=d.length;c>b;b++)a=d[b],e.push(a.buildParam(this));return e}.call(this),d.text=function(){var c,d,e;for(e=[],c=0,d=b.length;d>c;c++)a=b[c],e.push(a.text);return e}().filter(function(a){return 0<a.length}).join(" "),d.values=(e=[]).concat.apply(e,function(){var c,d,e;for(e=[],c=0,d=b.length;d>c;c++)a=b[c],e.push(a.values);return e}()),this.options.numberedParameters&&(c=0,d.text=d.text.replace(/\?/g,function(){return"$"+ ++c})),d},b.prototype.clone=function(){var a;return new this.constructor(this.options,function(){var b,c,d,e;for(d=this.blocks,e=[],b=0,c=d.length;c>b;b++)a=d[b],e.push(a.clone());return e}.call(this))},b.prototype.isNestable=function(){return!1},b}(a.BaseBuilder),a.Select=function(b){function c(b,d){null==d&&(d=null),d||(d=[new a.StringBlock(b,"SELECT"),new a.DistinctBlock(b),new a.GetFieldBlock(b),new a.FromTableBlock(e({},b,{allowNested:!0})),new a.JoinBlock(e({},b,{allowNested:!0})),new a.WhereBlock(b),new a.GroupByBlock(b),new a.OrderByBlock(b),new a.LimitBlock(b),new a.OffsetBlock(b)]),c.__super__.constructor.call(this,b,d)}return m(c,b),c.prototype.isNestable=function(){return!0},c}(a.QueryBuilder),a.Update=function(b){function c(b,d){null==d&&(d=null),d||(d=[new a.StringBlock(b,"UPDATE"),new a.UpdateTableBlock(b),new a.SetFieldBlock(b),new a.WhereBlock(b),new a.OrderByBlock(b),new a.LimitBlock(b)]),c.__super__.constructor.call(this,b,d)}return m(c,b),c}(a.QueryBuilder),a.Delete=function(b){function c(b,d){null==d&&(d=null),d||(d=[new a.StringBlock(b,"DELETE"),new a.FromTableBlock(e({},b,{singleTable:!0})),new a.JoinBlock(b),new a.WhereBlock(b),new a.OrderByBlock(b),new a.LimitBlock(b)]),c.__super__.constructor.call(this,b,d)}return m(c,b),c}(a.QueryBuilder),a.Insert=function(b){function c(b,d){null==d&&(d=null),d||(d=[new a.StringBlock(b,"INSERT"),new a.IntoTableBlock(b),new a.InsertFieldValueBlock(b)]),c.__super__.constructor.call(this,b,d)}return m(c,b),c}(a.QueryBuilder),d={VERSION:"2.0.0",expr:function(){return new a.Expression},select:function(b,c){return new a.Select(b,c)},update:function(b,c){return new a.Update(b,c)},insert:function(b,c){return new a.Insert(b,c)},"delete":function(b,c){return new a.Delete(b,c)},registerValueHandler:a.registerValueHandler},d.remove=d["delete"],d.cls=a,("undefined"!=typeof define&&null!==define?define.amd:void 0)?define(function(){return d}):("undefined"!=typeof module&&null!==module?module.exports:void 0)?module.exports=d:"undefined"!=typeof window&&null!==window&&(window.squel=d),d.flavours={},d.useFlavour=function(a){if(!(d.flavours[a]instanceof Function))throw new Error("Flavour not available: "+a);return d.flavours[a].call(null,d),d}}).call(this);

squel.js

@@ -242,3 +242,3 @@ /*
 
-    BaseBuilder.prototype._formatValue = function(value) {
+    BaseBuilder.prototype._formatCustomValue = function(value) {
       var customHandler;
@@ -249,2 +249,7 @@ customHandler = getValueHandler(value, this.options.valueHandlers, cls.globalValueHandlers);
       }
+      return value;
+    };
+
+    BaseBuilder.prototype._formatValue = function(value) {
+      value = this._formatCustomValue(value);
       if (null === value) {
@@ -763,3 +768,3 @@ value = "NULL";
         str += "" + this.fields[i] + " = ?";
-        vals.push(this._formatValue(this.values[0][i]));
+        vals.push(this._formatCustomValue(this.values[0][i]));
       }
@@ -819,3 +824,3 @@ return {
         for (j = _k = 0, _ref7 = this.values[i].length; 0 <= _ref7 ? _k < _ref7 : _k > _ref7; j = 0 <= _ref7 ? ++_k : --_k) {
-          params.push(this._formatValue(this.values[i][j]));
+          params.push(this._formatCustomValue(this.values[i][j]));
           if ('string' === typeof vals[i]) {
@@ -822,0 +827,0 @@ vals[i] += ', ?';

No alert changes

Improved metrics

Total package byte prevSize

125187

increased by0.42%

Lines of code

2719

increased by0.3%

No dependency changes