Add attendance tracking

[jontyms]

/attendance Endpoint

• Method: GET
  • URL Arguments: event_id (optional)
  • Description: If event_id is provided, show a confirmation for the event. If event_id is not provided, show a form to enter the event code.
• Method: POST
  • Request Body: event_code (required if event_id is not provided)
  • Description: Validate the event code or event_id. If valid, create a row in the attendance table for the user and event.

/admin/events Endpoint

• Method: GET
  • Description: Show a UI listing all current events with a button to create a new event.
• Method: POST
  • Request Body: Details for the new event (e.g., name, date, etc.)
  • Description: Create a new event.

/admin/event/{id} Endpoint

• Method: GET
  • Description: Show event details and settings. Allow setting event code, opening/closing attendance, setting counts toward total, setting event type, viewing members in the event, and removing members from the event.
• Method: PATCH
  • URL Parameters: id (event ID)
  • Request Body: Partial update data (e.g., event_code, attendance_status, counts_toward_total, event_type)
  • Description: Update event settings.
• Method: DELETE
  • URL Parameters: id (event ID)
  • Request Body: member_id
  • Description: Remove a member from the event.
  • Method: POST
    • URL Parameters: id (event ID)
    • Request Body: member_id
    • Description: add a member to the event.

Database

class Event(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    name: str
    date: datetime
    event_code: Optional[str] = None
    attendance_open: bool = False
    counts_toward_total: bool = False
    event_type: Optional[str] = None
    comment: Optional[str] = None

  class Attendance(SQLModel, table=True):
    id: Optional[int] = Field(default=None, primary_key=True)
    user_id: uuid = Field(foreign_key="user.id")
    event_id: int = Field(foreign_key="event.id")
    user: Optional["User"] = Relationship(back_populates="attendances")
    event: Optional["Event"] = Relationship(back_populates="attendances")
  # update user  
  class User(SQLModel, table=True):
    id: Optional[uuid] = Field(default=None, primary_key=True)
    attendances: list["Attendance"] = Relationship(back_populates="user")