mysql-simple-query - npm Package Compare versions

Comparing version 1.0.16 to 1.0.17

lib/util/dbQuery.js

@@ -62,3 +62,4 @@ const select = select => {
         const value = whereObject[key];
-        whereStatement.push(`${key} IN (${value.join(',')})`);
+        const inString = `"${value.join('","')}"`;
+        whereStatement.push(`${key} IN (${inString})`);
     }
@@ -65,0 +66,0 @@

package.json

 {
   "name": "mysql-simple-query",
-  "version": "1.0.16",
+  "version": "1.0.17",
   "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

@@ -67,3 +67,4 @@ const select = (select) => {
         const value = whereObject[key];
-        whereStatement.push(`${key} IN (${value.join(',')})`);
+        const inString = `"${value.join('","')}"`;
+        whereStatement.push(`${key} IN (${inString})`);
     }
@@ -70,0 +71,0 @@

test/mysqlSimpleQueryTest.js

@@ -181,4 +181,4 @@ const expect = require('chai').expect;
 
-        expect(testResults).to.equal('SELECT * FROM table WHERE key="%value%" AND column IN (1,2);');
+        expect(testResults).to.equal('SELECT * FROM table WHERE key="%value%" AND column IN ("1","2");');
     });
 });

No alert changes

Improved metrics

Total package byte prevSize

32084

increased by0.29%

Lines of code

823

increased by0.24%

No dependency changes