contrib/tnitter: replace `latest_posts` by a 2 args `list_posts`

Signed-off-by: Alexis Laferrière <alexis.laf@xymus.net>

diff --git a/contrib/tnitter/src/action.nit b/contrib/tnitter/src/action.nit
index 9eaae5b..21418fa 100644 (file)
--- 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 (file)
--- 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]