cormo - npm Package Compare versions

Comparing version 0.6.0 to 0.6.1

lib/adapters/mongodb.js

@@ -724,3 +724,4 @@ // Generated by CoffeeScript 1.6.2
       client_options = {
-        limit: options.limit
+        limit: options.limit,
+        skip: options.skip
       };
@@ -727,0 +728,0 @@ if (fields) {

lib/adapters/mysql.js

@@ -401,2 +401,7 @@ // Generated by CoffeeScript 1.6.2
         sql += ' LIMIT ' + options.limit;
+        if ((options != null ? options.skip : void 0) != null) {
+          sql += ' OFFSET ' + options.skip;
+        }
+      } else if ((options != null ? options.skip : void 0) != null) {
+        sql += ' LIMIT 2147483647 OFFSET ' + options.skip;
       }
@@ -403,0 +408,0 @@ return this._query(sql, params, function(error, result) {

lib/adapters/postgresql.js

@@ -381,5 +381,2 @@ // Generated by CoffeeScript 1.6.2
       }
-      if ((options != null ? options.limit : void 0) != null) {
-        sql += ' LIMIT ' + options.limit;
-      }
       if ((options != null ? options.orders.length : void 0) > 0) {
@@ -395,2 +392,10 @@ orders = options.orders.map(function(order) {
       }
+      if ((options != null ? options.limit : void 0) != null) {
+        sql += ' LIMIT ' + options.limit;
+        if ((options != null ? options.skip : void 0) != null) {
+          sql += ' OFFSET ' + options.skip;
+        }
+      } else if ((options != null ? options.skip : void 0) != null) {
+        sql += ' LIMIT ALL OFFSET ' + options.skip;
+      }
       return this._query(sql, params, function(error, result) {
@@ -397,0 +402,0 @@ var rows;

lib/adapters/sqlite3.js

@@ -323,5 +323,2 @@ // Generated by CoffeeScript 1.6.2
       }
-      if ((options != null ? options.limit : void 0) != null) {
-        sql += ' LIMIT ' + options.limit;
-      }
       if ((options != null ? options.orders.length : void 0) > 0) {
@@ -337,2 +334,10 @@ orders = options.orders.map(function(order) {
       }
+      if ((options != null ? options.limit : void 0) != null) {
+        sql += ' LIMIT ' + options.limit;
+        if ((options != null ? options.skip : void 0) != null) {
+          sql += ' OFFSET ' + options.skip;
+        }
+      } else if ((options != null ? options.skip : void 0) != null) {
+        sql += ' LIMIT 2147483647 OFFSET ' + options.skip;
+      }
       return this._query('all', sql, params, function(error, result) {
@@ -339,0 +344,0 @@ if (error) {

lib/query.js

@@ -130,2 +130,7 @@ // Generated by CoffeeScript 1.6.2
 
+    Query.prototype.skip = function(skip) {
+      this._options.skip = skip;
+      return this;
+    };
+
     Query.prototype.return_raw_instance = function() {
@@ -132,0 +137,0 @@ this._options.return_raw_instance = true;

package.json

 {
   "name": "cormo",
   "description": "ORM framework for Node.js",
-  "version": "0.6.0",
+  "version": "0.6.1",
   "keywords": [
@@ -6,0 +6,0 @@ "orm",

No alert changes

Improved metrics

Total package byte prevSize

209034

increased by0.42%

Lines of code

5173

increased by0.39%

No dependency changes