hapiest-mysql - npm Package Compare versions

Comparing version 0.0.20 to 0.0.21

lib/mysqlDaoQueryHelper.js

@@ -196,2 +196,4 @@ 'use strict';
                 sqlObject = sqlObject.where(`${columnName} IS NULL`);
+            } else if (cleanValue === 'IS NULL' || cleanValue === 'IS NOT NULL') {
+                sqlObject = sqlObject.where(`${columnName} ${cleanValue}`);
             } else {
@@ -198,0 +200,0 @@ sqlObject = sqlObject.where(`${columnName} = ${cleanValue}`);

package.json

 {
   "name": "hapiest-mysql",
-  "version": "0.0.20",
+  "version": "0.0.21",
   "description": "A wrapper around mysql that provides a very descriptive way of running queries.",
@@ -5,0 +5,0 @@ "main": "index.js",

test/unit/test-mysqlDaoQueryHelper.js

@@ -372,4 +372,15 @@ 'use strict';
 
+        it('Should generate good WHERE clause when input contains special functions', function() {
+            const sqlObj = Squel.select().from('users');
+
+            const someObj = {firstName: 'John'};
+            mysqlDaoQueryHelper._appendWhereClause(sqlObj, {dateCreated: 'CURRENT_TIMESTAMP', dateUpdated: 'NOW()', email: 'IS NULL', firstName: 'IS NOT NULL'});
+
+            const sqlString = sqlObj.toString();
+
+            sqlString.should.eql("SELECT * FROM users WHERE (date_created = CURRENT_TIMESTAMP) AND (date_updated = NOW()) AND (email IS NULL) AND (first_name IS NOT NULL)");
+        });
+
     });
 
 });

No alert changes

Improved metrics

Total package byte prevSize

137752

increased by0.56%

Lines of code

3090

increased by0.29%

No dependency changes