Merge pull request balderdashy#56 from huafu/patch-1

particlebanana · particlebanana · commit cb8d1e9e73a2 · 2013-10-31T09:44:13.000-07:00
Fixing the IS NOT NULL condition
diff --git a/lib/sql.js b/lib/sql.js
@@ -149,7 +149,7 @@ var sql = {
       else if (key === '>' || key === 'greaterThan') return attrStr + '>' + valueStr;
       else if (key === '>=' || key === 'greaterThanOrEqual') return attrStr + '>=' + valueStr;
       else if (key === '!' || key === 'not') {
-        if (value === null) return attrStr + 'IS NOT NULL';
+        if (value === null) return attrStr + ' IS NOT NULL';
         else return attrStr + '<>' + valueStr;
       }
       else if (key === 'like') return attrStr + ' LIKE \'' + nakedButClean + '\'';

Original file line number	Diff line number	Diff line change
`@@ -149,7 +149,7 @@ var sql = {`
`149`	`149`	`else if (key === '>' \|\| key === 'greaterThan') return attrStr + '>' + valueStr;`
`150`	`150`	`else if (key === '>=' \|\| key === 'greaterThanOrEqual') return attrStr + '>=' + valueStr;`
`151`	`151`	`else if (key === '!' \|\| key === 'not') {`
`152`		`- if (value === null) return attrStr + 'IS NOT NULL';`
	`152`	`+ if (value === null) return attrStr + ' IS NOT NULL';`
`153`	`153`	`else return attrStr + '<>' + valueStr;`
`154`	`154`	`}`
`155`	`155`	`else if (key === 'like') return attrStr + ' LIKE \'' + nakedButClean + '\'';`