From d5b7f7b180b487c01616763559fa38cbed8bb45e Mon Sep 17 00:00:00 2001 From: Vika Date: Fri, 28 Jul 2023 19:11:45 +0300 Subject: postgres: Fix pretty permalinks not being shown --- kittybox-rs/src/database/postgres/mod.rs | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'kittybox-rs/src/database/postgres/mod.rs') diff --git a/kittybox-rs/src/database/postgres/mod.rs b/kittybox-rs/src/database/postgres/mod.rs index 4477b9c..9176d12 100644 --- a/kittybox-rs/src/database/postgres/mod.rs +++ b/kittybox-rs/src/database/postgres/mod.rs @@ -259,7 +259,7 @@ SELECT jsonb_set( '{properties,author,0}', (SELECT mf2 FROM kittybox.mf2_json WHERE uid = mf2 #>> '{properties,author,0}') -) FROM kittybox.mf2_json WHERE uid = $1 +) FROM kittybox.mf2_json WHERE uid = $1 OR mf2['properties']['url'] ? $1 ") .bind(url) .fetch_optional(&self.db) @@ -324,7 +324,7 @@ ORDER BY mf2 #>> '{properties,published,0}' DESC .await?; tracing::debug!("Started txn: {:?}", txn); let mut feed = match sqlx::query_scalar::<_, serde_json::Value>(" -SELECT kittybox.hydrate_author(mf2) FROM kittybox.mf2_json WHERE uid = $1 +SELECT kittybox.hydrate_author(mf2) FROM kittybox.mf2_json WHERE uid = $1 OR mf2['properties']['url'] ? $1 ") .bind(url) .fetch_optional(&mut *txn) -- cgit 1.4.1