Skip to content

PRINTFILM: AI short-video marketing and AI short-drama creation platform

2.9 KB
Raw Blame
"""项目列表活动任务必须批量读取,并保持用户隔离和新任务优先。"""

from types import SimpleNamespace
from unittest.mock import AsyncMock

from sqlalchemy.dialects import postgresql

from app.services.tasks.service import (
    ACTIVE_TASK_STATUSES,
    list_active_tasks_for_owner,
    list_active_tasks_for_projects,
)


# 模拟 SQLAlchemy 结果链;保留任务顺序供批量分组断言。
def _result(tasks):
    rows = SimpleNamespace(all=lambda: tasks)
    rows.unique = lambda: rows
    return SimpleNamespace(scalars=lambda: rows)


async def test_empty_projects_skip_database():
    """空列表无需发出 IN 查询。"""
    db = SimpleNamespace(execute=AsyncMock())
    assert await list_active_tasks_for_projects(db, 7, []) == {}
    db.execute.assert_not_awaited()


async def test_projects_use_one_scoped_query_and_keep_task_order():
    """一页项目只查一次任务,且无任务的项目仍返回空列表。"""
    newest = SimpleNamespace(project_id=12, id=3)
    older = SimpleNamespace(project_id=12, id=1)
    other = SimpleNamespace(project_id=20, id=2)
    db = SimpleNamespace(execute=AsyncMock(return_value=_result([newest, other, older])))

    grouped = await list_active_tasks_for_projects(db, 7, [12, 20, 30, 12])

    assert grouped == {12: [newest, older], 20: [other], 30: []}
    db.execute.assert_awaited_once()
    statement = db.execute.await_args.args[0].compile(dialect=postgresql.dialect())
    sql = str(statement)
    assert "task_runs.requested_by =" in sql
    assert "task_runs.project_id IN" in sql
    assert "task_runs.status IN" in sql
    assert "ORDER BY task_runs.created_at DESC" in sql
    assert 7 in statement.params.values()
    assert [12, 20, 30] in statement.params.values()
    assert any(set(value) == ACTIVE_TASK_STATUSES for value in statement.params.values() if isinstance(value, (list, tuple)))


async def test_projects_without_tasks_return_empty_groups():
    """整页都没有任务时,仍保留所有项目供列表直接索引。"""
    db = SimpleNamespace(execute=AsyncMock(return_value=_result([])))
    assert await list_active_tasks_for_projects(db, 7, [12, 20]) == {12: [], 20: []}
    db.execute.assert_awaited_once()


async def test_owner_without_scope_skips_database():
    """原单项目查询未传范围时不扩大到用户全部任务。"""
    db = SimpleNamespace(execute=AsyncMock())
    assert await list_active_tasks_for_owner(db, 7) == []
    db.execute.assert_not_awaited()


async def test_owner_keeps_project_and_drama_union_scope():
    """共享查询构造后仍兼容两个项目范围的或条件。"""
    db = SimpleNamespace(execute=AsyncMock(return_value=_result([])))
    assert await list_active_tasks_for_owner(db, 7, project_id=12, drama_project_id=20) == []
    statement = db.execute.await_args.args[0].compile(dialect=postgresql.dialect())
    assert "(task_runs.project_id =" in str(statement)
    assert " OR task_runs.drama_project_id =" in str(statement)