TASK: Implement Track and Category SQLModel entities #15

Open
opened 2026-05-15 17:32:38 -04:00 by darkhelm · 0 comments
Owner

Parent

#3

What to build

Create core entities for tracks and categories including one-genre-to-one-category mapping constraints.

Acceptance criteria

  • Track model includes Plex IDs, metadata, and timestamps
  • Category and genre mapping constraints are enforced
  • Required indexes exist for selector queries

Blocked by

Notes

  • Python backend code must be fully typed and async-safe.
  • Any blocking work must be wrapped through thread/process execution paths as appropriate.
  • Must pass lint, format, typing, docstring, and test quality gates.
## Parent #3 ## What to build Create core entities for tracks and categories including one-genre-to-one-category mapping constraints. ## Acceptance criteria - [ ] Track model includes Plex IDs, metadata, and timestamps - [ ] Category and genre mapping constraints are enforced - [ ] Required indexes exist for selector queries ## Blocked by - #12 ## Notes - Python backend code must be fully typed and async-safe. - Any blocking work must be wrapped through thread/process execution paths as appropriate. - Must pass lint, format, typing, docstring, and test quality gates.
darkhelm added this to the v1 Dynamic Realtime Playlist milestone 2026-05-15 17:32:38 -04:00
darkhelm added the databaseafkbackendtask labels 2026-05-15 17:32:38 -04:00
darkhelm added this to the Main Project Board project 2026-05-15 17:51:06 -04:00
darkhelm removed this from the Main Project Board project 2026-05-15 17:53:49 -04:00
darkhelm modified the milestone from v1 Dynamic Realtime Playlist to E2 - Domain Schema and Data Access Layer 2026-05-15 17:57:47 -04:00
Sign in to join this conversation.