django.md

Sports clubs: event registration using Django

Summary

A event registration blueprint for sports clubs built with Django on Ample. Domain schema: course_groups (team_or_class, season, age_group): teams and classes; memberships (course_group_id, member_reference, guardian_reference, role): players, guardians and coaches; sessions (course_group_id, starts_at, venue, type): training and fixtures; materials (course_group_id, title, object_key, visibility): schedules and coaching resources; events (seq, record_type, record_id, kind, at): application-owned history written in the same transaction. Public information: teams, seasons and fixtures, venues, membership fees. Kept out of scope until handling is reviewed: minor members and medical notes, safeguarding records. Medical and safeguarding records are sensitive; only schedules and coaching materials are modeled. Technical basis verified on Django: an optimistic version check and an event row written in the same transaction, a stale update rejected, and a history query over the application-owned events (history=2 conflict=rejected).

Infrastructure requirements

Prerequisites

Exact tested configuration

Steps

  1. Model the sports clubs domain. Create the tables course_groups, memberships, sessions, materials, events. Teams and classes lives in course_groups; keep the sensitive classes (minor members and medical notes, safeguarding records) out of this schema.

  2. Workflow step 1. Model sessions with capacity and registrations with status

  3. Workflow step 2. Register transactionally with a capacity check and an event per registration

  4. Workflow step 3. Reject stale concurrent updates

  5. Workflow step 4. Deploy and verify history and conflict handling

  6. Deploy. Run the synchronous deploy once and read the result. Re-running with no change is a no-op.

    ample deploy . --name <app-name> --public --start "python3 run.py" --env S3_ENDPOINT=... --env S3_REGION=... --env S3_BUCKET=... --env S3_ACCESS_KEY_ID=... --env S3_SECRET_ACCESS_KEY=...
    
  7. Verify. Run the pattern self-test(s) from the example (/p/transactional-workflows) and your own acceptance checks for the sports clubs workflow.

    ample logs <deployment_id> --kind build
    

Tested examples

Success checks

Limitations