Changes between Version 9 and Version 10 of ServerSidePagination

Timestamp:

01/20/10 03:19:47 (15 years ago)

Author:

Fran Boon

Comment:

--

ServerSidePagination

@@ -10 +10 @@
 fractalis has offered to look at this
 
-Will need to patch into the {{{models\01_RESTlike_Controller}}}.
+=== Status ===
+ * The Back-end is now done for HTML representation
+ * The Back-end needs doign for JSON representation
+ * The Front-end still needs doing
 
-We already have options to filter the results within a busy REST controller, so could do something like:
+=== HTML Back-end implmentation ===
+Patched the {{{models\01_RESTlike_Controller}}}.
 {{{
-if request.vars.page and request.vars.pagesize:
-    start = (int(request.vars.page) - 1) * int(request.vars.pagesize)
-    stop = int(request.vars.page) * int(request.vars.pagesize)
-    response.s3.filter = (db['%s_%s' % (module, resource)].id > 0).select(limitby=(start, stop))
+shn_list()
+...
+    if request.vars.limit:
+        limit = int(request.vars.limit)
+        if request.vars.page:
+            page = int(request.vars.page)
+            start = (page - 1) * limit
+            stop = page * limit
+            limitby = (start, stop)
+        else:
+            limitby = (0, limit)
+    else:
+        limitby = None
+...
+items = crud.select(table, query=query,
+            ...
+            limitby=limitby, 
+            ...
+            )
 }}}
-Unfortunately query doesn't include the .select()
 
-We already use request.vars.limit in the search.json method/representation.
- * we could use this & add a request.vars.page in shn_list()
-
+=== Other Options ===
 Maybe look at the currently-unused {{{modules/webgrid.py}}}.