1 files changed, 11 insertions, 0 deletions
diff --git a/src/database/postgres/mod.rs b/src/database/postgres/mod.rs
index 8d67bb4..1a1b98d 100644
--- a/src/database/postgres/mod.rs
+++ b/src/database/postgres/mod.rs
@@ -1,5 +1,6 @@
 use std::borrow::Cow;
 
+use futures::{Stream, StreamExt};
 use kittybox_util::{micropub::Channel as MicropubChannel, MentionType};
 use sqlx::{ConnectOptions, Executor, PgPool};
 use crate::micropub::{MicropubUpdate, MicropubPropertyDeletion};
@@ -72,6 +73,16 @@ impl Storage for PostgresStorage {
 
     }
 
+    async fn all_posts<'this>(&'this self, user: &url::Url) -> Result<impl Stream<Item = serde_json::Value> + Send + 'this> {
+        let authority = user.authority().to_owned();
+        Ok(
+            sqlx::query_scalar::<_, serde_json::Value>("SELECT mf2 FROM kittybox.mf2_json WHERE owner = $1 ORDER BY (mf2_json.mf2 #>> '{properties,published,0}') DESC")
+                .bind(authority)
+                .fetch(&self.db)
+                .filter_map(|f| std::future::ready(f.ok()))
+        )
+    }
+
     #[tracing::instrument(skip(self))]
     async fn categories(&self, url: &str) -> Result<Vec<String>> {
         sqlx::query_scalar::<_, String>("