json-sql - npm Package Compare versions

Comparing version 0.4.13 to 0.5.0

lib/dialects/postgresql/blocks.js

@@ -12,5 +12,9 @@ 'use strict';
 		if (_.isArray(value)) {
-			result = 'array[' + _(value).map(function(item) {
-				return dialect.builder._pushValue(item);
-			}).join(', ') + ']';
+			if (value.length) {
+				result = 'array[' + _(value).map(function(item) {
+					return dialect.builder._pushValue(item);
+				}).join(', ') + ']';
+			} else {
+				result = dialect.builder._pushValue('{}');
+			}
 		} else if (_.isObject(value)) {
@@ -17,0 +21,0 @@ result = dialect.builder._pushValue(JSON.stringify(value));

lib/dialects/postgresql/operators/comparison.js

@@ -58,2 +58,23 @@ 'use strict';
 	});
+
+	dialect.operators.comparison.add('$arrayContains', {
+		defaultFetchingOperator: '$array',
+		fn: function(field, value) {
+			return buildComparisonCondition(field, '@>', value);
+		}
+	});
+
+	dialect.operators.comparison.add('$arrayIn', {
+		defaultFetchingOperator: '$array',
+		fn: function(field, value) {
+			return buildComparisonCondition(field, '<@', value);
+		}
+	});
+
+	dialect.operators.comparison.add('$arrayOverlap', {
+		defaultFetchingOperator: '$array',
+		fn: function(field, value) {
+			return buildComparisonCondition(field, '&&', value);
+		}
+	});
 };

lib/dialects/postgresql/operators/fetching.js

 'use strict';
 
+var _ = require('underscore');
+
 module.exports = function(dialect) {
@@ -10,2 +12,11 @@ dialect.operators.fetching.add('$json', {
 	});
+
+	dialect.operators.fetching.add('$array', {
+		fn: function(value) {
+			if (!_.isArray(value)) {
+				value = [value];
+			}
+			return dialect.buildBlock('term', {term: value, type: 'value'});
+		}
+	});
 };

package.json

 {
   "name": "json-sql",
   "description": "node.js json to sql queries mapper",
-  "version": "0.4.13",
+  "version": "0.5.0",
   "author": "Artem Zhukov <[e-mail]>",
@@ -6,0 +6,0 @@ "license": "MIT",

No alert changes

Improved metrics

Lines of code

1621

increased by1.95%

Worsened metrics

Total package byte prevSize

59995

decreased by-16.12%

Number of package files

29

decreased by-3.33%

No dependency changes