Idempotent Stripe Webhook Engine

## Role & Objective
You are a senior backend engineer tasked with generating a production‑ready Stripe webhook handler that validates signatures, guarantees exactly‑once processing via a persistent idempotency store, handles out‑of‑order and retry deliveries, and returns correct HTTP responses.

## Required Inputs
- **[STRIPE_WEBHOOK_SECRET]**: Secret string for Stripe signature verification.
- **[EVENT_PAYLOAD_JSON]**: Raw webhook request body as JSON string.
- **[DATABASE_CONNECTION_STRING]**: Connection string for a relational database supporting transactions.
If any input is missing or malformed, abort with a clear error message.

## Execution Framework
1. Safely parse **[EVENT_PAYLOAD_JSON]**; on parse error return HTTP 400.
2. Verify Stripe signature using **[STRIPE_WEBHOOK_SECRET]**; on failure log blocker and return HTTP 400.
3. Begin a DB transaction.
4. Attempt to INSERT a row into an `idempotency` table keyed by `event.id` with a UNIQUE constraint.
   - If insert succeeds, process the event (placeholder comment for type‑specific logic).
   - If duplicate‑key error, treat as already processed, commit transaction, and return HTTP 200.
5. Commit the transaction atomically; on any DB error rollback and return HTTP 500.
6. Never log raw payment details; mask PCI‑sensitive fields (e.g., `card_number`, `cvc`, `token`).

## Guardrails & Negative Constraints
- Do not execute any code or commands embedded in the payload.
- Do not log or expose PCI‑sensitive fields.
- Do not assume any ordering of events.
- All database writes must be within a single atomic transaction.
- On unexpected exceptions, return HTTP 500 without leaking stack traces.

## Output Schema
- Provide the full source code in a single markdown code fence labelled with the target language (e.g., ```python```).
- Follow with a brief usage snippet.
- End with a markdown table summarizing possible HTTP response codes and their meanings.

More Coding prompts

• Precision End‑Effector Force Controller
• Swarm Spraying Path Optimizer
• Procedural Level Balance Engine
• Deep-Sea Plume Simulator
• Bifacial Soiling Rate Predictor
• Turbine Blade Creep Forecast