Skip to main content

ASSET_REF_COUNT_EXPR

yggdrasil::api::assets

Constant ASSET_REF_COUNT_EXPR 

Source 
pub(crate) const ASSET_REF_COUNT_EXPR: &str = "((SELECT COUNT(*) FROM asset_refs r WHERE r.asset_id = a.id) + \
     (SELECT COUNT(*) FROM comments c WHERE c.deleted_at IS NULL \
      AND c.content_html LIKE '%' || a.path || '%') + \
     (SELECT COUNT(*) FROM users u WHERE u.avatar_url = '/uploads/' || a.path) + \
     (SELECT COUNT(*) FROM friend_links f WHERE f.avatar_url = '/uploads/' || a.path))";
Expand description

列表页引用计数表达式，按每个文章/评论/头像使用次数累计。