anydb-sql - npm Package Compare versions

Comparing version 0.1.5 to 0.1.6

anydb-sql.js

@@ -105,4 +105,15 @@ var anyDB = require('any-db');
 
+
+        self.allOf = function() {
+            var tables = [].slice.call(arguments);
+            return tables.reduce(function (all, table) {
+                var tableName = table.alias || table._name;
+                return all.concat(table.columns.map(function(c) {
+                    return c.as(tableName + '.' + c.name);
+                }));
+            }, []);
+        };
+
         return self;
 
     };

package.json

 {
   "name": "anydb-sql",
-  "version": "0.1.5",
+  "version": "0.1.6",
   "description": "anydb-sql combines node-anydb and node-sql",
@@ -5,0 +5,0 @@ "main": "anydb-sql.js",

test/index.js

@@ -78,4 +78,13 @@ var test = require('tap').test;
       });
-    })
+    });
 
+    t.test('allof', function(t) {
+        var q = user.select(db.allOf(user, user));
+        var text = 'SELECT "users"."id" AS "users.id",'
+            + ' "users"."name" AS "users.name", "users"."id" AS "users.id",'
+            +' "users"."name" AS "users.name" FROM "users"';
+        t.equals(q.toQuery().text, text);
+        t.end();
+    });
+
     t.test('db.close', function(t) {
@@ -82,0 +91,0 @@ t.plan(1);

No alert changes

Improved metrics

Total package byte prevSize

9689

increased by8.14%

Lines of code

200

increased by9.29%

No dependency changes