sql-query - npm Package Compare versions

Comparing version 0.0.1 to 0.0.2

lib/Dialects/mysql.js

@@ -43,7 +43,7 @@ exports.escapeId = function () {
 			case "\x1a": return "\\Z";
-			default: return "\\"+s;
+			default: return "\\" + s;
 		}
 	});
 
-	return "'"+val+"'";
+	return "'" + val + "'";
 };
@@ -50,0 +50,0 @@

lib/Query.js

 var SelectQuery = require("./Select").SelectQuery;
+var InsertQuery = require("./Insert").InsertQuery;
+var UpdateQuery = require("./Update").UpdateQuery;
+var RemoveQuery = require("./Remove").RemoveQuery;
 
@@ -6,3 +9,7 @@ exports.Query = Query;
 function Query(opts) {
-	opts = opts || {};
+	if (typeof opts == "string") {
+		opts = { dialect: opts };
+	} else {
+		opts = opts || {};
+	}
 
@@ -14,4 +21,13 @@ var Dialect = require("./Dialects/" + (opts.dialect || "mysql"));
 			return new SelectQuery(Dialect);
+		},
+		insert: function () {
+			return new InsertQuery(Dialect);
+		},
+		update: function () {
+			return new UpdateQuery(Dialect);
+		},
+		remove: function () {
+			return new RemoveQuery(Dialect);
 		}
 	};
 }

lib/Select.js

@@ -0,1 +1,3 @@
+var Where = require("./Where");
+
 exports.SelectQuery = SelectQuery;
@@ -130,33 +132,4 @@
 
-			if (sql.where.length > 0) {
-				query.push("WHERE");
+			query = query.concat(Where.build(Dialect, sql.where));
 
-				tmp = [];
-				for (i = 0; i < sql.where.length; i++) {
-					var tmp2 = [];
-
-					for (var j = 0; j < sql.where[i].length; j++) {
-						for (var k in sql.where[i][j].w) {
-							if (sql.where[i][j].t === null) {
-								tmp2.push(
-									Dialect.escapeId(k) +
-									" = " +
-									Dialect.escapeVal(sql.where[i][j].w[k])
-								);
-							} else {
-								tmp2.push(
-									Dialect.escapeId(sql.where[i][j].t, k) +
-									" = " +
-									Dialect.escapeVal(sql.where[i][j].w[k])
-								);
-							}
-						}
-					}
-
-					tmp.push(tmp2.join(" AND "));
-				}
-
-				query.push("(" + tmp.join(") OR (") + ")");
-			}
-
 			return query.join(" ");
@@ -163,0 +136,0 @@ }

package.json

@@ -9,3 +9,3 @@ {
   ],
-  "version": "0.0.1",
+  "version": "0.0.2",
   "license": "MIT",
@@ -12,0 +12,0 @@ "repository": {

Readme.md

 ## NodeJS SQL query builder
 
-[![Build Status](https://secure.travis-ci.org/dresende/node-sql-query.png)](http://travis-ci.org/dresende/node-sql-query)
+[![Build Status](https://secure.travis-ci.org/dresende/node-sql-query.png?branch=master)](http://travis-ci.org/dresende/node-sql-query)
 
@@ -10,1 +10,7 @@ ## Install
 ```
+
+## Dialects
+
+- MySQL
+- PostgreSQL
+- SQLite

test/common.js

@@ -9,1 +9,23 @@ var common = exports;
 };
+
+common.Insert = function () {
+	var q = new Query();
+
+	return q.insert();
+};
+
+common.Update = function () {
+	var q = new Query();
+
+	return q.update();
+};
+
+common.Remove = function () {
+	var q = new Query();
+
+	return q.remove();
+};
+
+common.getDialect = function (dialect) {
+	return require('../lib/Dialects/' + dialect);
+};

New alerts

Dynamic require

Supply chain risk

Dynamic require can indicate the package is performing dangerous or unsafe dynamic code execution.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

17204

increased by69.31%

Number of package files

25

increased by108.33%

Lines of code

649

increased by96.67%

Number of lines in readme file

16

increased by60%

Worsened metrics

Number of low supply chain risk alerts

5

increased by25%

No dependency changes