mysql-simple-query - npm Package Compare versions

Comparing version 1.0.13 to 1.0.14

lib/util/dbQuery.js

@@ -73,3 +73,3 @@ const select = select => {
         const value = whereObject[key];
-        whereStatement.push(`${key} BETWEEN "${value[0]}" AND "${value[1]}"`);
+        whereStatement.push(`${key} BETWEEN ${value[0]} AND ${value[1]}`);
     }
@@ -76,0 +76,0 @@

package.json

 {
   "name": "mysql-simple-query",
-  "version": "1.0.13",
+  "version": "1.0.14",
   "description": "Simple query wrapper for mysql-promise to make querying, inserting, updating, and deleting easier for developers.",
@@ -5,0 +5,0 @@ "main": "mysqlSimpleQuery.js",

src/util/dbQuery.js

@@ -78,3 +78,3 @@ const select = (select) => {
         const value = whereObject[key];
-        whereStatement.push(`${key} BETWEEN "${value[0]}" AND "${value[1]}"`);
+        whereStatement.push(`${key} BETWEEN ${value[0]} AND ${value[1]}`);
     }
@@ -81,0 +81,0 @@

test/mysqlSimpleQueryTest.js

@@ -86,6 +86,6 @@ const expect = require('chai').expect;
         test.from('table');
-        test.whereBetween('column', ['1', '2']);
+        test.whereBetween('column', [1, 2]);
         const testResults = test.query();
 
-        expect(testResults).to.equal('SELECT * FROM table WHERE column BETWEEN "1" AND "2";');
+        expect(testResults).to.equal('SELECT * FROM table WHERE column BETWEEN 1 AND 2;');
     });
@@ -99,6 +99,6 @@
         test.where('key', '%value%');
-        test.whereBetween('column', ['1', '2']);
+        test.whereBetween('column', [1, 2]);
         const testResults = test.query();
 
-        expect(testResults).to.equal('SELECT * FROM table WHERE key="%value%" AND column BETWEEN "1" AND "2";');
+        expect(testResults).to.equal('SELECT * FROM table WHERE key="%value%" AND column BETWEEN 1 AND 2;');
     });
@@ -105,0 +105,0 @@

No alert changes

Worsened metrics

Total package byte prevSize

29593

decreased by-0.08%

No dependency changes