from __future__ import annotations import tempfile from datetime import datetime, timedelta, timezone from pathlib import Path from unittest import TestCase from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from sakura_cloud.db.base import Base from sakura_cloud.models.follow import UpdateAlert from sakura_cloud.models.user import User from sakura_cloud.services.reminders import run_daily_reminder_digest class DailyReminderDigestTest(TestCase): def setUp(self) -> None: self.temp_dir = tempfile.TemporaryDirectory() self.db_path = Path(self.temp_dir.name) / "cloud.db" self.engine = create_engine(f"sqlite:///{self.db_path}", connect_args={"check_same_thread": False}) self.SessionLocal = sessionmaker(bind=self.engine, autoflush=False, autocommit=False) Base.metadata.create_all(self.engine) def tearDown(self) -> None: self.engine.dispose() self.temp_dir.cleanup() def test_digest_is_created_even_when_no_updates(self) -> None: with self.SessionLocal() as db: user = User( id="user-a", username="alice", email="alice@example.test", password_hash="unused", reminder_enabled=True, reminder_hour=0, reminder_minute=0, reminder_timezone="UTC", ) db.add(user) db.commit() self.assertEqual(run_daily_reminder_digest(db), 1) digest = db.query(UpdateAlert).filter(UpdateAlert.platform == "system").one() self.assertIn("未更新", digest.title) self.assertEqual(digest.payload_json["new_alert_count"], 0) self.assertEqual(digest.payload_json["status"], "not_updated") def test_digest_counts_new_update_records(self) -> None: now = datetime.now(timezone.utc) with self.SessionLocal() as db: user = User( id="user-a", username="alice", email="alice@example.test", password_hash="unused", reminder_enabled=True, reminder_hour=0, reminder_minute=0, reminder_timezone="UTC", last_reminder_sent_at=now - timedelta(days=1), ) db.add(user) db.add_all( [ UpdateAlert( user_id="user-a", platform="pixiv", creator_id="123", title="new 1", body="new", payload_json={"creator_name": "Sakura"}, ), UpdateAlert( user_id="user-a", platform="x", creator_id="sakura", title="new 2", body="new", payload_json={"creator_handle": "sakura"}, ), ] ) db.commit() self.assertEqual(run_daily_reminder_digest(db), 1) digest = db.query(UpdateAlert).filter(UpdateAlert.platform == "system").one() self.assertIn("更新 2 条记录", digest.title) self.assertEqual(digest.payload_json["new_alert_count"], 2) self.assertEqual(digest.payload_json["status"], "updated")