simple-sql-parser - npm Package Compare versions

Comparing version 1.3.0 to 1.3.1

bower.json

@@ -0,0 +0,0 @@ {

package.json

 {
   "name": "simple-sql-parser",
   "description": "Javascript library to parse CRUD (Create Retrieve Update Delete) SQL queries.",
-  "version": "1.3.0",
+  "version": "1.3.1",
   "main": "simpleSqlParser.js",
@@ -20,2 +20,7 @@ "keywords": [
       "url": "https://github.com/RienNeVaPlus"
+    },
+    {
+      "name": "Joshua Cole",
+      "url": "https://github.com/joshuafcole",
+      "email": "[e-mail]"
     }
@@ -22,0 +27,0 @@ ],

README.md

@@ -74,3 +74,3 @@ simpleSqlParser
 The MIT License (MIT)
-Copyright (c) 2013 David Sferruzza
+Copyright (c) 2013-2014 David Sferruzza
  
@@ -77,0 +77,0 @@ Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

simpleSqlParser.js

@@ -212,3 +212,3 @@ (function(exports) {
 		};
-		
+
 		analysis['GROUP BY'] = function (str) {
@@ -369,3 +369,4 @@ str = str.split(',');
 		readNextChar: function () {
-			this.currentChar = this.source[this.cursor++] || "";
+			if (typeof this.source != 'string') this.currentChar = "";
+			else this.currentChar = this.source[this.cursor++] || "";
 		},
@@ -417,3 +418,3 @@
 			if (/^(AND|OR)$/i.test(tokenValue)) return {type: 'logic', value: tokenValue};
-			if (/^(IS|NOT)$/i.test(tokenValue)) return {type: 'operator', value: tokenValue};
+			if (/^(IN|IS|NOT|LIKE)$/i.test(tokenValue)) return {type: 'operator', value: tokenValue};
 			else return {type: 'word', value: tokenValue};
@@ -632,3 +633,3 @@ },
 		}
-		
+
 		function group_by(ast) {
@@ -645,3 +646,3 @@ if (typeof ast['GROUP BY'] != 'undefined') {
 		}
-		
+
 		function limit(ast) {
@@ -754,3 +755,8 @@ if (typeof ast['LIMIT'] != 'undefined' && typeof ast['LIMIT'].nb != 'undefined' && parseInt(ast['LIMIT'].nb, 10) > 0) {
 				if (typeof cond.right != 'undefined') {
-					result += ' ' + cond.right;
+					if (cond.operator === 'IN') {
+						result += ' (' + cond.right + ')';
+					}
+					else {
+						result += ' ' + cond.right;
+					}
 				}
@@ -757,0 +763,0 @@ }

No alert changes

Improved metrics

Total package byte prevSize

27015

1.49%

Lines of code

689

0.88%

No dependency changes