A Wedding Website: RSVPs, Dinner Choices, and One Database

flowchart TD
    subgraph GuestClient [Guest Client Experience]
        A[Guest Arrives via Unique Invite Code / QR] --> B[Zod Invite Code Authentication]
        B --> C[Dynamic Multi-Event RSVP Form]
        C --> D1[Attending Status & Meal Selection]
        C --> D2[Dietary Restrictions & Allergies]
        C --> D3[Song Requests & Hotel Lodging Info]
    end

    subgraph ServerLayer [Next.js Server Actions & API]
        D1 & D2 & D3 --> E[Server Action: submitRsvpAction]
        E --> F[Zod Payload Validation]
        F --> G[Prisma Database Transaction]
    end

    subgraph StorageComms [Data Store & Notification Engine]
        G --> H[(PostgreSQL Database)]
        G --> I[Transactional Confirmation Email Dispatch]
        I --> J[Guest Inbox]
        H --> K[Admin Live Dashboard & CSV Export]
    end

// Next.js Server Action for atomic multi-guest RSVP submission
"use server";

import { prisma } from "@/lib/prisma";
import { RsvpPayloadSchema, type RsvpPayload } from "@/lib/schemas/rsvp";
import { revalidatePath } from "next/cache";

async function submitRsvpAction(rawPayload: RsvpPayload) {
  const validated = RsvpPayloadSchema.safeParse(rawPayload);
  if (!validated.success) {
    return { success: false, errors: validated.error.flatten().fieldErrors };
  }

  const { householdId, responses } = validated.data;

  try {
    const updated = await prisma.$transaction(
      responses.map((guest) =>
        prisma.guest.update({
          where: { id: guest.guestId, householdId },
          data: {
            isAttending: guest.isAttending,
            mealPreference: guest.mealPreference,
            dietaryNotes: guest.dietaryNotes,
            respondedAt: new Date(),
          },
        })
      )
    );

    revalidatePath("/rsvp");
    return { success: true, count: updated.length };
  } catch (error) {
    console.error("RSVP transaction failed:", error);
    return { success: false, error: "Failed to persist RSVP. Please try again." };
  }
}

// Strict runtime schema validation for multi-event RSVP submissions
import { z } from "zod";

const GuestResponseSchema = z.object({
  guestId: z.string().cuid(),
  isAttending: z.boolean(),
  mealPreference: z.enum(["BEEF", "FISH", "VEGETARIAN", "VEGAN", "KIDS"]),
  dietaryNotes: z.string().max(500).optional(),
});

const RsvpPayloadSchema = z.object({
  householdId: z.string().cuid(),
  inviteCode: z.string().min(4).max(12),
  responses: z.array(GuestResponseSchema).min(1),
  contactEmail: z.string().email(),
  songRequest: z.string().max(200).optional(),
});

type RsvpPayload = z.infer;