Function _get_recent_sessions

backend/src/stats/services.py:42–67

Get recent practice sessions using an optimized query.

(
    session: Session, collection_id: uuid.UUID, limit: int = 10
)

def _get_recent_sessions(
    session: Session, collection_id: uuid.UUID, limit: int = 10
) -> list[PracticeSessionStats]:
    """Get recent practice sessions using an optimized query."""
    statement = (
        select(PracticeSession)
        .where(
            PracticeSession.collection_id == collection_id,
            PracticeSession.is_completed,
        )
        .order_by(PracticeSession.created_at.asc())
        .limit(limit)
    )

    sessions = session.exec(statement).all()
    return [
        PracticeSessionStats(
            id=s.id,
            created_at=s.created_at,
            cards_practiced=s.cards_practiced,
            correct_answers=s.correct_answers,
            total_cards=s.total_cards,
            is_completed=s.is_completed,
        )
        for s in sessions
    ]


def _get_difficult_cards(