From f366ff807a24eff4f34c716ef04483e5c2bc8430 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Alexis=20Laferri=C3=A8re?= Date: Tue, 10 Nov 2015 08:18:20 -0500 Subject: [PATCH] contrib/tnitter: replace `latest_posts` by a 2 args `list_posts` MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Signed-off-by: Alexis Laferrière --- contrib/tnitter/src/action.nit | 2 +- contrib/tnitter/src/database.nit | 6 +++--- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/contrib/tnitter/src/action.nit b/contrib/tnitter/src/action.nit index 9eaae5b..21418fa 100644 --- a/contrib/tnitter/src/action.nit +++ b/contrib/tnitter/src/action.nit @@ -208,7 +208,7 @@ class Tnitter else error_html = "" # Load the last 16 Tnits - var posts = db.latest_posts(16) + var posts = db.list_posts(0, 16) db.close var html_posts = new Array[String] diff --git a/contrib/tnitter/src/database.nit b/contrib/tnitter/src/database.nit index 4c88b51..b38fa9b 100644 --- a/contrib/tnitter/src/database.nit +++ b/contrib/tnitter/src/database.nit @@ -79,10 +79,10 @@ class DB end end - # Get the latest tnits - fun latest_posts(count: Int): Array[Post] + # List `count` of the latest Tnits skipping `offset` + fun list_posts(offset, count: Int): Array[Post] do - var stmt = select("user, text FROM posts ORDER BY datetime(posted) DESC LIMIT {count}") + var stmt = select("user, text FROM posts ORDER BY datetime(posted) DESC LIMIT {count} OFFSET {offset}") assert stmt != null else print error or else "?" var posts = new Array[Post] -- 1.7.9.5