Function get_practice_cards

backend/src/flashcards/services.py:282–325

Get practice cards for a session, optionally filtering, ordering, and limiting.

(
    session: Session,
    practice_session_id: uuid.UUID,
    status: Literal["pending", "completed", "all"] | None = None,
    limit: int | None = None,
    order: Literal["asc", "desc", "random"] | None = None,
)

def get_practice_cards(
    session: Session,
    practice_session_id: uuid.UUID,
    status: Literal["pending", "completed", "all"] | None = None,
    limit: int | None = None,
    order: Literal["asc", "desc", "random"] | None = None,
) -> tuple[list[PracticeCard], int]:
    """Get practice cards for a session, optionally filtering, ordering, and limiting."""
    base_statement = select(PracticeCard).where(
        PracticeCard.session_id == practice_session_id
    )

    if status == "pending":
        statement = base_statement.where(PracticeCard.is_practiced.is_not(True))
    elif status == "completed":
        statement = base_statement.where(PracticeCard.is_practiced.is_(True))
    else:
        statement = base_statement

    count_statement = select(func.count()).select_from(statement.subquery())
    count = session.exec(count_statement).one()

    if order == "asc":
        statement = statement.order_by(PracticeCard.created_at.asc())
    elif order == "desc":
        statement = statement.order_by(PracticeCard.created_at.desc())
    elif order != "random":
        if status == "pending":
            statement = statement.order_by(PracticeCard.created_at)
        else:
            statement = statement.order_by(PracticeCard.updated_at.desc())

    if order == "random":
        practice_cards = session.exec(statement).all()
        random.shuffle(practice_cards)

        if limit is not None:
            practice_cards = practice_cards[:limit]
    else:
        if limit is not None:
            statement = statement.limit(limit)
        practice_cards = session.exec(statement).all()

    return practice_cards, count


def get_practice_card(