"""D3 回归:dashboard 与配额使用 SQL 聚合,不再整表载入。 用混合数据(文本/文件、过期/活跃、分块)验证聚合结果与语义一致。 """ import asyncio import datetime import unittest from tortoise import Tortoise from apps.admin.services import FileService from apps.admin.views import dashboard from apps.base.models import FileCodes from apps.base.quota import get_storage_usage from tests.helpers import init_memory_db from core.utils import get_now class DashboardQuotaAggregationTests(unittest.TestCase): def test_dashboard_counters_and_storage_usage_match_data(self): asyncio.run(self._scenario()) async def _scenario(self): await init_memory_db() try: now = await get_now() past = now - datetime.timedelta(days=2) future = now + datetime.timedelta(days=30) # 活跃文件(时间式) await FileCodes.create( code="f1", size=100, expired_count=-1, expired_at=future, text=None, prefix="doc", suffix=".txt", ) # 已过期(时间式) await FileCodes.create( code="f2", size=200, expired_count=-1, expired_at=past, text=None, prefix="old", suffix=".bin", ) # 次数耗尽(count 式,带过期时间) await FileCodes.create( code="f3", size=300, expired_count=0, expired_at=future, text=None, prefix="cnt", suffix=".zip", ) # 文本分享 await FileCodes.create( code="t1", size=50, expired_count=-1, expired_at=future, text="hello", ) # 永久 await FileCodes.create( code="p1", size=400, expired_count=-1, expired_at=None, text=None ) detail = (await dashboard(FileService())).detail self.assertEqual(detail["total_files"], 5) self.assertEqual(detail["storage_used"], "1050") self.assertEqual(detail["expired_count"], 2, "时间过期+次数耗尽都算过期") self.assertEqual(detail["active_count"], 3) self.assertEqual(detail["text_count"], 1) self.assertEqual(detail["file_count"], 4) self.assertEqual(detail["used_count"], 0) usage = await get_storage_usage() self.assertEqual(usage["used"], 1050, "配额聚合应与手工求和一致") self.assertIsNone(usage["available"]) # 未设 storage_limit finally: await Tortoise.close_connections() from tests.helpers import close_db as _c await _c() if __name__ == "__main__": unittest.main() class ExpiredCountDefaultTests(unittest.TestCase): """D4 回归:默认 expired_count 不再是 0(0 语义 = 次数耗尽即过期)。""" def test_record_without_explicit_count_is_not_instantly_expired(self): async def scenario(): async def _run(): record = await FileCodes.create(code="d4", size=1) return record, await record.is_expired() return await _run() async def wrapper(): from tests.helpers import init_memory_db await init_memory_db() try: return await scenario() finally: from tests.helpers import close_db await close_db() record, expired = asyncio.run(wrapper()) self.assertEqual(record.expired_count, -1) self.assertFalse(expired, "未显式设置过期方式的记录不应立即过期")