summaryrefslogtreecommitdiff
path: root/routers/imports.py
diff options
context:
space:
mode:
authorTyler Hoang <tyler@tylerhoang.xyz>2026-05-06 18:05:07 -0700
committerTyler Hoang <tyler@tylerhoang.xyz>2026-05-06 18:05:07 -0700
commitead38fdb13abb406065cef0743d7e411cb27eaf3 (patch)
tree56f5bc31be37833505726ac61cec0cfd19a7be92 /routers/imports.py
parent2d298f982408f222ad344b2aa9c18bbe7dc70f12 (diff)
Add genre tracking and year-in-review improvements
Adds genre field to Film model with TMDB enrichment. Genres populate from TMDB detail fetch during add/edit and bulk enrichment. Genre metadata displays on film cards, detail page (Production section), stats page (top genres panel), and year-in-review (by decade and genre breakdowns). Auto-detects rewatches when adding films via TMDB autocomplete - if a film with the same TMDB ID already exists in diary, pre-fills rewatch checkbox and count. Rewatch count now displays on film cards as "Rewatch #N". Stats page now shows: - Top genres (most watched) - Film decades (sorted chronologically) - Already shows: directors, companions, star distribution, rewatch rate Year-in-review shows decades and genres alongside monthly activity and companions. Bulk enrichment endpoint (/data/enrich-posters) now fetches missing genre metadata along with posters and TMDB IDs. Co-Authored-By: Claude Haiku 4.5 <noreply@anthropic.com>
Diffstat (limited to 'routers/imports.py')
-rw-r--r--routers/imports.py10
1 files changed, 8 insertions, 2 deletions
diff --git a/routers/imports.py b/routers/imports.py
index f6a202d..10c0f49 100644
--- a/routers/imports.py
+++ b/routers/imports.py
@@ -202,7 +202,7 @@ async def _enrich_films_from_tmdb(films: list[Film]) -> int:
async with httpx.AsyncClient(timeout=10.0) as client:
for film in films:
- if film.poster_url and film.tmdb_id:
+ if film.poster_url and film.tmdb_id and film.genre:
continue
try:
metadata = await find_movie(film.title, year=film.year, client=client)
@@ -262,7 +262,13 @@ def clear_duplicates(db: Session = Depends(get_db)):
async def enrich_missing_posters(db: Session = Depends(get_db)):
films = (
db.query(Film)
- .filter(or_(Film.poster_url.is_(None), Film.poster_url == "", Film.tmdb_id.is_(None)))
+ .filter(or_(
+ Film.poster_url.is_(None),
+ Film.poster_url == "",
+ Film.tmdb_id.is_(None),
+ Film.genre.is_(None),
+ Film.genre == "",
+ ))
.order_by(Film.year.asc(), Film.title.asc())
.all()
)