loading by offset on profile

1 files changed, 4 insertions, 3 deletions

diff --git a/src/database/posts.rs b/src/database/posts.rs
index 6c0a27e..a81d6a7 100644
--- a/src/database/posts.rs
+++ b/src/database/posts.rs
@@ -90,11 +90,12 @@ pub fn get_all_posts() -> Result<Vec<Post>, rusqlite::Error> {
 }
 
 #[instrument()]
-pub fn get_users_posts(user_id: u64) -> Result<Vec<Post>, rusqlite::Error> {
+pub fn get_users_post_page(user_id: u64, page: u64) -> Result<Vec<Post>, rusqlite::Error> {
     tracing::trace!("Retrieving users posts");
+    let page_size = 10;
     let conn = database::connect()?;
-    let mut stmt = conn.prepare("SELECT * FROM posts WHERE user_id = ? ORDER BY post_id DESC")?;
-    let row = stmt.query_map([user_id], |row| {
+    let mut stmt = conn.prepare("SELECT * FROM posts WHERE user_id = ? ORDER BY post_id DESC LIMIT ? OFFSET ?")?;
+    let row = stmt.query_map([user_id, page_size, page_size * page], |row| {
         let row = post_from_row(row)?;
         Ok(row)
     })?;