{
  "survey-core": "^2.3.11",
  "survey-react-ui": "^2.3.11",
  "recharts": "^2.15.3",
  "nayuki-qr-code-generator": "^1.8.0"
}

create table "public"."live_polls" (
    "id" uuid not null default gen_random_uuid(),
    "class_id" bigint not null,
    "created_by" uuid not null,
    "question" jsonb not null default '[]'::jsonb,
    "is_live" boolean not null default false,
    "created_at" timestamp with time zone not null default now(),
    "deactivates_at" timestamp with time zone,
    "require_login" boolean not null default false
);

create table "public"."live_poll_responses" (
    "id" uuid not null default gen_random_uuid(),
    "live_poll_id" uuid not null,
    "public_profile_id" uuid,
    "response" jsonb not null default '{}'::jsonb,
    "submitted_at" timestamp with time zone,
    "is_submitted" boolean not null default false,
    "created_at" timestamp with time zone not null default now()
);

{
  "elements": [
    {
      "type": "checkbox",
      "title": "Which topic should we review next?",
      "choices": ["Recursion", "Dynamic Programming", "Graphs"]
    }
  ]
}

{ "poll_question_0": "Dynamic Programming" }

CREATE OR REPLACE FUNCTION public.deactivate_expired_polls()
 RETURNS void
 LANGUAGE plpgsql
 SECURITY DEFINER
 SET search_path TO 'public'
AS $function$
BEGIN
  -- Deactivate polls where deactivates_at has passed
  UPDATE live_polls
  SET is_live = false
  WHERE is_live = true
    AND deactivates_at IS NOT NULL
    AND deactivates_at <= NOW();
END;
$function$

CREATE OR REPLACE FUNCTION public.can_access_poll_response(poll_id uuid, profile_id uuid)
 RETURNS boolean
 LANGUAGE sql
 STABLE SECURITY DEFINER
 SET search_path TO 'public'
AS $function$
  SELECT CASE
    -- Early exit: if require_login is false, anyone can access (no user_roles query needed)
    WHEN NOT lp.require_login THEN true
    -- If require_login is true, user must be authenticated
    WHEN lp.require_login AND auth.uid() IS NULL THEN false
    -- If require_login is true and user is authenticated, verify class membership and profile ownership
    WHEN lp.require_login AND auth.uid() IS NOT NULL THEN
      authorizeforclass(lp.class_id)
      AND profile_id IS NOT NULL
      AND authorizeforprofile(profile_id)
    ELSE false
  END
  FROM public.live_polls lp
  WHERE lp.id = poll_id;
$function$

// Staff. All polls in the course, live and not. Returns the array directly.
const polls = useLivePolls();                       // :2462-2475

// Students. Filtered to is_live === true.
const { polls, isLoading } = useActiveLivePolls();   // :2480-2490

// One poll by id, staff-side.
const poll = useLivePoll(pollId);                    // :2492-2496

// Live per-choice tallies for elements[0].
const { counts, isLoading } = usePollResponseCounts(pollId, pollQuestion); // :2552-2655

app/course/[course_id]/
├── polls/                                    # Student-facing
│   ├── page.tsx
│   └── StudentPollsTable.tsx
└── manage/polls/                             # Staff-facing
    ├── page.tsx                              # Poll list
    ├── PollsTable.tsx                        # Rows, live toggle, delete
    ├── PollsHeader.tsx
    ├── EmptyPollsState.tsx
    ├── new/page.tsx                          # Create only; there is no edit route
    └── [poll_id]/responses/
        ├── page.tsx
        ├── PollResponsesDynamicViewer.tsx    # Type dispatch, poll URL, fullscreen
        ├── MultipleChoiceDynamicViewer.tsx
        ├── PollResponsesHeader.tsx
        ├── PollBarChart.tsx                  # Recharts
        └── QrCode.tsx                        # Thumbnail plus modal

app/poll/[course_id]/page.tsx                 # Standalone respond page, anon-capable

components/
├── PollBuilder.tsx                           # QUESTION_TYPE_REGISTRY lives here
├── PollBuilderModal.tsx
├── PollPreviewModal.tsx
└── ui/polls/poll-question-form.tsx

hooks/
├── useCourseController.tsx                   # Poll hooks and count helpers
└── usePollQrCode.tsx

types/poll.ts

// types/poll.ts
export type PollQuestion = {
  id: string;
};

export type MultipleChoicePollQuestion = PollQuestion & {
  type: "multiple-choice";
  prompt: string;
  choices: { label: string }[];
  correct_choices: string[];
};

export type PollResponseData = Record<string, string | string[]>;

npx playwright test polls