94 lines
3.4 KiB
Python
94 lines
3.4 KiB
Python
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")
|
||
|
|
|