diff options
author | Vika <vika@fireburn.ru> | 2023-07-28 19:11:45 +0300 |
---|---|---|
committer | Vika <vika@fireburn.ru> | 2023-07-28 19:20:44 +0300 |
commit | d5b7f7b180b487c01616763559fa38cbed8bb45e (patch) | |
tree | d13887bc549a88370a194795dfa2804cc8aee193 /kittybox-rs/src | |
parent | cf9d3a46742c5e81e91b498b9542602b059245f5 (diff) | |
download | kittybox-d5b7f7b180b487c01616763559fa38cbed8bb45e.tar.zst |
postgres: Fix pretty permalinks not being shown
Diffstat (limited to 'kittybox-rs/src')
-rw-r--r-- | kittybox-rs/src/database/mod.rs | 20 | ||||
-rw-r--r-- | kittybox-rs/src/database/postgres/mod.rs | 4 |
2 files changed, 22 insertions, 2 deletions
diff --git a/kittybox-rs/src/database/mod.rs b/kittybox-rs/src/database/mod.rs index 4f1c4de..b4b70b2 100644 --- a/kittybox-rs/src/database/mod.rs +++ b/kittybox-rs/src/database/mod.rs @@ -717,6 +717,25 @@ mod tests { assert_eq!(read_post["properties"]["comment"][0], reply); } + async fn test_pretty_permalinks<Backend: Storage>(db: Backend) { + const PERMALINK: &str = "https://fireburn.ru/posts/pretty-permalink"; + + let post = { + let mut post = gen_random_post("fireburn.ru"); + let urls = post["properties"]["url"].as_array_mut().unwrap(); + urls.push(serde_json::Value::String( + PERMALINK.to_owned() + )); + + post + }; + db.put_post(&post, "fireburn.ru").await.unwrap(); + + for i in post["properties"]["url"].as_array().unwrap() { + let (read_post, _) = db.read_feed_with_cursor(i.as_str().unwrap(), None, 20, None).await.unwrap().unwrap(); + assert_eq!(read_post, post); + } + } /// Automatically generates a test suite for macro_rules! test_all { ($func_name:ident, $mod_name:ident) => { @@ -727,6 +746,7 @@ mod tests { $func_name!(test_update); $func_name!(test_feed_pagination); $func_name!(test_webmention_addition); + $func_name!(test_pretty_permalinks); } }; } 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) |