home.rs
home.rs
use axum::{
Json,
extract::{Query, State},
};
use serde::{Deserialize, Serialize};
use sqlx::FromRow;
use crate::{error::AppError, state::AppState};
#[derive(Debug, Deserialize)]
pub struct DigestQuery {
/// 'en' | 'ja' | 'ko' | 'zh-CN';省略或未知 → 用來源語言(繁中)。
pub locale: Option<String>,
}
/// locale → 文章標題欄位運算式。欄名取自白名單(不是把使用者輸入拼進 SQL);
/// 譯文為空字串或 NULL 都 fallback 回原文標題。prefix 是表別名(如 "p.")。
fn title_expr(locale: Option<&str>, prefix: &str) -> String {
let col = match locale.unwrap_or_default() {
"en" => Some("title_en"),
"ja" => Some("title_ja"),
"ko" => Some("title_ko"),
"zh-CN" | "zh-cn" => Some("title_zh_cn"),
_ => None,
};
match col {
Some(c) => format!("COALESCE(NULLIF({prefix}{c}, ''), {prefix}title)"),
None => format!("{prefix}title"),
}
}
#[derive(Debug, Serialize, FromRow, specta::Type, utoipa::ToSchema)]
pub struct DigestPost {
#[specta(type = specta_typescript::Number)]
pub id: i64,
pub slug: Option<String>,
pub title: String,
pub category: Option<String>,
pub created_at: String,
}
#[derive(Debug, Serialize, FromRow, specta::Type, utoipa::ToSchema)]
pub struct DigestThought {
#[specta(type = specta_typescript::Number)]
pub id: i64,
pub content: String,
pub ref_type: Option<String>,
pub created_at: String,
}
#[derive(Debug, Serialize, FromRow, specta::Type, utoipa::ToSchema)]
pub struct DigestComment {
#[specta(type = specta_typescript::Number)]
pub id: i64,
pub author: String,
pub content: String,
pub created_at: String,
#[specta(type = Option<specta_typescript::Number>)]
pub post_id: Option<i64>,
#[specta(type = Option<specta_typescript::Number>)]
pub thought_id: Option<i64>,
pub post_title: Option<String>,
/// 前端用來組 canonical 網址(`/blog/<slug>`)。少了它只能連到 `/blog/<id>`,
/// 那得多走一次 301。
pub post_slug: Option<String>,
}
#[derive(Debug, Serialize, FromRow, specta::Type, utoipa::ToSchema)]
pub struct DigestTimeline {
#[specta(type = specta_typescript::Number)]
pub id: i64,
pub slug: Option<String>,
pub title: String,
pub created_at: String,
}
#[derive(Debug, Serialize, specta::Type, utoipa::ToSchema)]
pub struct DigestResponse {
pub message: String,
pub posts: Vec<DigestPost>,
pub thoughts: Vec<DigestThought>,
pub comments: Vec<DigestComment>,
pub timeline: Vec<DigestTimeline>,
}
/// `GET /api/home/digest` —— 首頁動態帶(近期文章/碎念/留言迴聲/年度軌跡)。
/// Express 有 60s 記憶體快取,這裡每次都讀同一 DB(資料一致即等價,不複製快取);
/// 4 條查詢與欄位逐字照抄,回應 key 順序 message→posts→thoughts→comments→timeline。
#[utoipa::path(get, path = "/api/home/digest", tag = "home", responses((status = 200, body = DigestResponse)))]
pub async fn home_digest(
State(state): State<AppState>,
Query(q): Query<DigestQuery>,
) -> Result<Json<DigestResponse>, AppError> {
// 文章標題依語系取 i18n 欄(沒譯文就 fallback 回原文)。欄名走白名單、非拼接使用者輸入。
let title = title_expr(q.locale.as_deref(), "");
let p_title = title_expr(q.locale.as_deref(), "p.");
let posts = sqlx::query_as::<_, DigestPost>(sqlx::AssertSqlSafe(format!(
"SELECT id, slug, {title} AS title, category, created_at FROM posts \
WHERE status = 'published' ORDER BY created_at DESC LIMIT 5"
)))
.fetch_all(&state.pool)
.await?;
// 只附了作品、沒寫字的碎念用作品名頂上(首頁那一行不該是空的)。
// json_valid 先擋:舊資料的 ref_json 壞掉的話 json_extract 會讓整條查詢失敗
let thoughts = sqlx::query_as::<_, DigestThought>(
"SELECT id, substr(CASE WHEN trim(content) <> '' THEN content \
WHEN json_valid(ref_json) THEN COALESCE(json_extract(ref_json, '$.title'), '') \
ELSE '' END, 1, 120) AS content, \
ref_type, created_at FROM thoughts \
ORDER BY created_at DESC LIMIT 3",
)
.fetch_all(&state.pool)
.await?;
let comments = sqlx::query_as::<_, DigestComment>(sqlx::AssertSqlSafe(format!(
"SELECT c.id, c.author, substr(c.content, 1, 80) AS content, c.created_at, \
c.post_id, c.thought_id, {p_title} AS post_title, p.slug AS post_slug \
FROM comments c LEFT JOIN posts p ON p.id = c.post_id \
WHERE c.status = 'approved' AND c.is_admin = 0 \
ORDER BY c.created_at DESC LIMIT 4"
)))
.fetch_all(&state.pool)
.await?;
let timeline = sqlx::query_as::<_, DigestTimeline>(sqlx::AssertSqlSafe(format!(
"SELECT id, slug, {title} AS title, created_at FROM posts \
WHERE status = 'published' AND created_at >= date('now', 'start of year') \
ORDER BY created_at ASC"
)))
.fetch_all(&state.pool)
.await?;
Ok(Json(DigestResponse { message: "success".to_string(), posts, thoughts, comments, timeline }))
}
/// `GET /api/health` —— 純文字 `OK`(Express `res.status(200).send('OK')`)。
#[utoipa::path(get, path = "/api/health", tag = "home",
responses((status = 200, description = "健康檢查,回純文字 OK")))]
pub async fn health() -> axum::response::Response {
use axum::response::IntoResponse;
([(axum::http::header::CONTENT_TYPE, "text/html; charset=utf-8")], "OK").into_response()
}