DarkHelm.org/plex-playlist
Public Access
4
0
Fork 0
Code Issues 56 Pull Requests 1 Actions 9 Packages Projects 1 Releases Wiki Activity

EPIC: Domain Schema and Data Access Layer #3

New Issue
Open
opened 2026-05-15 17:30:50 -04:00 by darkhelm · 0 comments
darkhelm commented 2026-05-15 17:30:50 -04:00
Owner
Copy Link

Parent

#1

What to build

Implement SQLModel entities, constraints, and repository layer for tracks, categories, playlist sessions, and playback events.

Acceptance criteria

  • All core tables and relationships exist with proper indexes/constraints
  • Repository layer provides typed async query interfaces
  • Schema and repository tests validate integrity and edge cases

Blocked by

  • None - can start immediately

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 #1 ## What to build Implement SQLModel entities, constraints, and repository layer for tracks, categories, playlist sessions, and playback events. ## Acceptance criteria - [ ] All core tables and relationships exist with proper indexes/constraints - [ ] Repository layer provides typed async query interfaces - [ ] Schema and repository tests validate integrity and edge cases ## Blocked by - None - can start immediately ## 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:30:50 -04:00
darkhelm added the databasebackendepic labels 2026-05-15 17:30:52 -04:00
darkhelm added this to the Main Project Board project 2026-05-15 17:51:05 -04:00
darkhelm removed this from the Main Project Board project 2026-05-15 17:53:45 -04:00
darkhelm modified the milestone from v1 Dynamic Realtime Playlist to E2 - Domain Schema and Data Access Layer 2026-05-15 17:58:22 -04:00
darkhelm modified the milestone from E2 - Domain Schema and Data Access Layer to META: Plex Dynamic Realtime Playlist Generator v1 2026-05-15 18:00:12 -04:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
afk
Autonomous-friendly issue
 algorithm
Selection logic
 api
API contract
 backend
Backend related
 database
Database related
 devex
Developer experience
 docs
Documentation
 epic
Top-level planning item
 frontend
Frontend related
 hitl
Requires human-in-the-loop decision
 ingestion
Ingestion/sync
 ops
Operations
 performance
Performance
 realtime
Realtime/eventing
 release
Release readiness
 security
Security
 task
Implementation ticket
 testing
Testing
 ui
UI/UX
No Label backend database epic
Milestone
No items
No Milestone META: Plex Dynamic Realtime Playlist Generator v1
Projects
Clear projects
No project
Assignees
Clear assignees
copilotcoder darkhelm renovate-bot repository-bot
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: DarkHelm.org/plex-playlist#3
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?