Function challenge_stats

backend/app/main.py:142–168

(conn, challenge_id: str)

def challenge_stats(conn, challenge_id: str) -> dict:
    total_cells = conn.execute(
        "SELECT COUNT(*) AS c FROM challenge_cells WHERE challenge_id = ?",
        (challenge_id,),
    ).fetchone()["c"]
    unlocked_cells = conn.execute(
        """
        SELECT COUNT(DISTINCT cell_id) AS c
        FROM user_unlocked_cells
        WHERE challenge_id = ?
        """,
        (challenge_id,),
    ).fetchone()["c"]
    participant_count = conn.execute(
        """
        SELECT COUNT(DISTINCT participant_id) AS c
        FROM user_unlocked_cells
        WHERE challenge_id = ?
        """,
        (challenge_id,),
    ).fetchone()["c"]
    return {
        "total_cells": total_cells,
        "unlocked_cells": unlocked_cells,
        "participant_count": participant_count,
        "progress": round(unlocked_cells / total_cells, 4) if total_cells else 0,
    }


def public_challenge(conn, row) -> dict: