yggdrasil/api/assets/
mod.rs

1//! 素材管理 API 模块。
2//!
3//! 管理 `uploads/` 图片的注册表（assets 表）与引用关系（asset_refs 表）：
4//! 分页列表、删除保护、孤儿清理、全量重建索引。
5//! 全部为 Dioxus server function，仅 admin 可用。
6// 与 posts / comments 模块一致：Dioxus `#[server]` 宏触发 deprecated/unit 提示，按项目惯例放行。
7#![allow(clippy::unused_unit, deprecated, unused_imports)]
8
9/// 素材引用判定 SQL 片段（表别名固定为 `a`，即 assets）。
10///
11/// 引用来源包括文章关联（`asset_refs`）、存活评论 HTML、用户头像和友链头像。
12/// 文章关联由索引重建维护；后三者保存的是直接 URL，因此在查询时按素材路径判断。
13#[cfg(feature = "server")]
14pub(crate) const ASSET_REF_CLAUSE: &str =
15    "(EXISTS (SELECT 1 FROM asset_refs r WHERE r.asset_id = a.id) \
16     OR EXISTS (SELECT 1 FROM note_asset_refs r WHERE r.asset_id = a.id) \
17     OR EXISTS (SELECT 1 FROM comments c \
18               WHERE c.deleted_at IS NULL AND c.content_html LIKE '%' || a.path || '%') \
19     OR EXISTS (SELECT 1 FROM users u WHERE u.avatar_url = '/uploads/' || a.path) \
20     OR EXISTS (SELECT 1 FROM friend_links f WHERE f.avatar_url = '/uploads/' || a.path))";
21
22/// 存活评论引用判定，供单删接口返回更具体的业务提示。
23#[cfg(feature = "server")]
24pub(crate) const COMMENT_REF_CLAUSE: &str = "EXISTS (SELECT 1 FROM comments c \
25     WHERE c.deleted_at IS NULL AND c.content_html LIKE '%' || a.path || '%')";
26
27/// 直接头像引用判定，供单删接口区分评论引用。
28#[cfg(feature = "server")]
29pub(crate) const AVATAR_REF_CLAUSE: &str =
30    "(EXISTS (SELECT 1 FROM users u WHERE u.avatar_url = '/uploads/' || a.path) \
31     OR EXISTS (SELECT 1 FROM friend_links f WHERE f.avatar_url = '/uploads/' || a.path))";
32
33/// 列表页引用计数表达式，按每个文章/评论/头像使用次数累计。
34#[cfg(feature = "server")]
35pub(crate) const ASSET_REF_COUNT_EXPR: &str =
36    "((SELECT COUNT(*) FROM asset_refs r WHERE r.asset_id = a.id) + \
37      (SELECT COUNT(DISTINCT note_id) FROM note_asset_refs r WHERE r.asset_id = a.id) + \
38     (SELECT COUNT(*) FROM comments c WHERE c.deleted_at IS NULL \
39      AND c.content_html LIKE '%' || a.path || '%') + \
40     (SELECT COUNT(*) FROM users u WHERE u.avatar_url = '/uploads/' || a.path) + \
41     (SELECT COUNT(*) FROM friend_links f WHERE f.avatar_url = '/uploads/' || a.path))";
42
43/// 素材删除与孤儿清理。
44pub mod delete;
45/// 素材分页列表。
46pub mod list;
47/// 素材索引全量重建。
48pub mod rebuild;
49/// 请求与响应数据结构。
50pub mod types;
51
52pub use delete::{batch_delete_assets, delete_asset, purge_orphan_assets, update_asset_alt};
53pub use list::list_assets;
54pub use rebuild::rebuild_assets_index;
55pub use types::{
56    AssetListResponse, AssetOpResponse, BatchDeleteAssetsResponse, PurgeOrphansResponse,
57    RebuildAssetsResponse,
58};
59
60#[cfg(all(test, feature = "server"))]
61mod tests {
62    use super::ASSET_REF_CLAUSE;
63
64    #[test]
65    fn asset_reference_clause_protects_profile_avatar() {
66        assert!(
67            ASSET_REF_CLAUSE.contains("users u")
68                && ASSET_REF_CLAUSE.contains("u.avatar_url = '/uploads/' || a.path"),
69            "素材引用判定必须包含用户头像路径"
70        );
71    }
72}
yggdrasil/api/assets/mod.rs

yggdrasil/api/assets/
mod.rs
