Files
FileCodeBox/tests/test_dashboard_quota_sql.py
Marrrrrrrrry c7b5eabe7c refactor: single canonical snake_case keys across admin/share APIs (D7)
Drop the message/msg envelope twin, all camel+snake dual-field response
pairs (file list/detail/policy/storage, dashboard counters, batch op
counts, status insights, presets, metadata), and camel request fields
(clearExpiredAt, downloadLimit, sortBy/sortOrder, maxChars). Stored
KeyValue JSON (metadata, presets, activities) keeps legacy-key read
fallbacks so existing deployments normalize transparently.
2026-09-11 03:10:04 +08:00

101 lines
3.6 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.
"""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, "未显式设置过期方式的记录不应立即过期")