hapiest-mysql - npm Package Compare versions

Comparing version 0.0.44 to 0.0.46

lib/mysqlDaoQueryHelper.js

		@@ -30,2 +30,3 @@ 'use strict';
		nin: 'NOT IN',
		not_in: 'NOT IN', // supporting a more readable version of nin
		raw: ''
		@@ -421,3 +422,3 @@ };
		static _cleanValueForOperator(operator, value) {
		if (_.includes(['in', 'nin'], operator) && _.isArray(value)) {
		if (_.includes(['in', 'nin', 'not_in'], operator) && _.isArray(value)) {
		const joinedValues = value.join(',');
		@@ -424,0 +425,0 @@ return `(${joinedValues})`;

package.json

		{
		"name": "hapiest-mysql",
		"version": "0.0.44",
		"version": "0.0.46",
		"description": "A wrapper around mysql that provides a very descriptive way of running queries.",
		@@ -31,3 +31,3 @@ "main": "index.js",
		"lodash": "4.17.4",
		"mysql": "2.13.0",
		"mysql": "2.14.0",
		"squel": "5.9.1"
		@@ -34,0 +34,0 @@ },

test/unit/test-mysqlDaoQueryHelper.js

		@@ -249,5 +249,12 @@ 'use strict';

		sql.should.eql('SELECT * FROM users WHERE (id NOT IN (\'apple\',\'banana\',\'pear\'))');
		sql.should.eql("SELECT * FROM users WHERE (id NOT IN ('apple','banana','pear'))");
		});

		it('Should generate a SELECT statement with a query object and notIn operator', function() {
		const sql = mysqlDaoQueryHelper.getAll({id: { not_in: ['apple', 'banana', 'pear'] }});
		Should.exist(sql);

		sql.should.eql("SELECT * FROM users WHERE (id NOT IN ('apple','banana','pear'))");
		});

		it('Should generate a SELECT statement with a query object and in/nin operators', function() {
		@@ -254,0 +261,0 @@ const sql = mysqlDaoQueryHelper.getAll({id: { in: [7,8,9], nin: [1,2,3] }});

Improved metrics