Files
2026-11-16 20:45:22 +08:00

138 lines
4.8 KiB
Python
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
from __future__ import annotations
from datetime import timedelta, timezone
from zoneinfo import ZoneInfo, ZoneInfoNotFoundError
from sqlalchemy import func, select
from sqlalchemy.orm import Session
from sakura_cloud.models.follow import UpdateAlert
from sakura_cloud.models.mixins import utc_now
from sakura_cloud.models.user import User
from sakura_cloud.services.push import send_update_alert_push
DEFAULT_REMINDER_TIMEZONE = "Asia/Shanghai"
DIGEST_PLATFORM = "system"
DIGEST_CREATOR_ID = "daily-reminder"
def _resolve_timezone(name: str | None) -> ZoneInfo:
try:
return ZoneInfo(name or DEFAULT_REMINDER_TIMEZONE)
except ZoneInfoNotFoundError:
return ZoneInfo(DEFAULT_REMINDER_TIMEZONE)
def _display_platform(platform: str) -> str:
if platform.lower() == "pixiv":
return "Pixiv"
if platform.lower() == "x":
return "X"
return platform
def run_daily_reminder_digest(db: Session) -> int:
now_utc = utc_now()
users = db.scalars(select(User).where(User.reminder_enabled.is_(True))).all()
reminders_created = 0
for user in users:
zone = _resolve_timezone(user.reminder_timezone)
local_now = now_utc.astimezone(zone)
scheduled_today = local_now.replace(
hour=user.reminder_hour,
minute=user.reminder_minute,
second=0,
microsecond=0,
)
if local_now < scheduled_today:
continue
if user.last_reminder_sent_at is not None:
last_sent_local = user.last_reminder_sent_at.astimezone(zone)
if last_sent_local.date() == local_now.date():
continue
window_start = (
user.last_reminder_sent_at
if user.last_reminder_sent_at is not None
else (scheduled_today - timedelta(days=1)).astimezone(timezone.utc)
)
new_alert_count = db.scalar(
select(func.count(UpdateAlert.id)).where(
UpdateAlert.user_id == user.id,
UpdateAlert.platform != DIGEST_PLATFORM,
UpdateAlert.created_at > window_start,
)
) or 0
recent_alerts = db.scalars(
select(UpdateAlert)
.where(
UpdateAlert.user_id == user.id,
UpdateAlert.platform != DIGEST_PLATFORM,
UpdateAlert.created_at > window_start,
)
.order_by(UpdateAlert.created_at.desc())
.limit(5)
).all()
creator_names: list[str] = []
platforms: list[str] = []
for alert in recent_alerts:
platform = _display_platform(alert.platform)
if platform not in platforms:
platforms.append(platform)
candidate = (
alert.payload_json.get("creator_name")
or alert.payload_json.get("creator_handle")
or alert.payload_json.get("author")
or alert.creator_id
)
if candidate and candidate not in creator_names:
creator_names.append(str(candidate))
date_text = f"{local_now.month}月{local_now.day}日"
platforms_text = " / ".join(platforms) if platforms else "Pixiv / X"
creators_text = ", ".join(creator_names[:3])
title = f"{date_text},未更新" if not new_alert_count else f"{date_text},更新 {new_alert_count} 条记录"
if not new_alert_count:
body = f"{date_text} 暂未发现关注作者的新内容。云端会在明天 {user.reminder_hour:02d}:{user.reminder_minute:02d} 继续检查。"
elif creators_text:
body = (
f"{date_text},{creators_text} 等作者带来了 {new_alert_count} "
f"条新动态,来自 {platforms_text}。"
)
else:
body = f"{date_text},你关注的作者有 {new_alert_count} 条新动态,来自 {platforms_text}。"
digest_alert = UpdateAlert(
user_id=user.id,
follow_id=None,
platform=DIGEST_PLATFORM,
creator_id=DIGEST_CREATOR_ID,
title=title,
body=body,
content_type="digest",
payload_json={
"kind": "daily_digest",
"window_start": window_start.isoformat(),
"new_alert_count": int(new_alert_count),
"platforms": platforms,
"creators": creator_names[:5],
"date": local_now.date().isoformat(),
"status": "updated" if new_alert_count else "not_updated",
},
)
db.add(digest_alert)
user.last_reminder_sent_at = now_utc
db.commit()
db.refresh(digest_alert)
send_update_alert_push(db, digest_alert)
reminders_created += 1
return reminders_created