Function get_challenge

backend/app/main.py:337–388

(
    challenge_id: str,
    response: Response,
    participant=Cookie(default=None, alias=COOKIE_NAME),
)

@app.get("/api/challenges/{challenge_id}")
def get_challenge(
    challenge_id: str,
    response: Response,
    participant=Cookie(default=None, alias=COOKIE_NAME),
) -> dict:
    current = get_or_create_participant(response, participant)
    with connect() as conn:
        row = conn.execute(
            "SELECT * FROM challenges WHERE id = ?", (challenge_id,)
        ).fetchone()
        challenge = public_challenge(conn, row)
        cells = [
            row_to_dict(cell)
            for cell in conn.execute(
                """
                SELECT cell_id, lat, lng
                FROM challenge_cells
                WHERE challenge_id = ?
                ORDER BY cell_id
                """,
                (challenge_id,),
            ).fetchall()
        ]
        unlocked = [
            row_to_dict(cell)
            for cell in conn.execute(
                """
                SELECT DISTINCT cell_id
                FROM user_unlocked_cells
                WHERE challenge_id = ?
                """,
                (challenge_id,),
            ).fetchall()
        ]
        mine = [
            row_to_dict(cell)
            for cell in conn.execute(
                """
                SELECT cell_id
                FROM user_unlocked_cells
                WHERE challenge_id = ? AND participant_id = ?
                """,
                (challenge_id, current["id"]),
            ).fetchall()
        ]
        return {
            "challenge": challenge,
            "cells": cells,
            "unlocked": unlocked,
            "mine": mine,
            "participant": current,
        }


@app.get("/api/challenges/{challenge_id}/leaderboard")