sql-bricks - npm Package Compare versions

Comparing version 2.0.1 to 2.0.2

package.json

 {
   "name": "sql-bricks",
-  "version": "2.0.1",
+  "version": "2.0.2",
   "author": "Peter Rust <[e-mail]>",
@@ -5,0 +5,0 @@ "description": "Transparent, Schemaless SQL Generation",

sql-bricks.js

@@ -378,8 +378,11 @@ (function() {
   Insert.defineClause('values', function(opts) {
-    if (this._select)
+    if (this._select) {
       return this._select._toString(opts);
-    else
+    }
+    else {
+      var pickOrder = _.keys(this._values[0]);
       return 'VALUES ' + _.map(this._values, function(values) {
-        return '(' + handleValues(_.values(values), opts).join(', ') + ')';
+        return '(' + handleValues(_.values(_.pick(values, pickOrder)), opts).join(', ') + ')';
       }).join(', ');
+    }
   });
@@ -386,0 +389,0 @@

tests/tests.js

@@ -203,2 +203,6 @@ (function() {
     });
+    it('should support value objects with differing field orders', function() {
+      check(insert('user').values([{id: 1, name: 'Fred'}, {name: 'Barney', id: 2}]),
+        "INSERT INTO \"user\" (id, name) VALUES (1, 'Fred'), (2, 'Barney')")
+    })
 
@@ -205,0 +209,0 @@ describe('.toString() value conversions', function() {

No alert changes

Improved metrics

Total package byte prevSize

342220

0.1%

Lines of code

8072

0.09%

No dependency changes