From b0a286bd89525eb1a15cddc7934f1da54485ecf5 Mon Sep 17 00:00:00 2001 From: schneefux Date: Sat, 28 May 2016 21:06:08 +0200 Subject: rank globally and not per page --- app.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/app.py b/app.py index 51059d1..766b835 100644 --- a/app.py +++ b/app.py @@ -40,9 +40,9 @@ class dbProxy(object): return int(l/perpage)+1 def getJokes(self, perpage, page): - jokes = self.c.execute("SELECT * FROM jokes LIMIT ? OFFSET ?", (perpage, perpage*page)).fetchall() + jokes = self.c.execute("SELECT * FROM jokes").fetchall() jokes = sorted(jokes, key=self.sort, reverse=True) - return jokes + return jokes[page*perpage:(page+1)*perpage] def addJoke(self, text): self.c.execute("INSERT INTO jokes(text, upvotes, downvotes, reports) VALUES (?, 0, 0, 0)", (text, )) -- cgit v1.3.1