Files
silo-server/internal/scanner/extras_test.go
CoffeeKnyteandGitHub 021e54a03c fix(scanner): fix slow-scan regressions from #319 and #322 (#341)
* fix(scanner): stop classifying "other" content folders as extras

Regression from #322 (trailers and extras for movies and series), which
introduced the extrasDirKinds map.

The extras directory classifier mapped the generic labels "other" and
"others" to ExtraKindOther. These are not part of the Jellyfin/Plex extras
folder convention the map claims to mirror, and they collide with real
content-scope folder names.

A library organized as "movies/other/<Title (year) {ids}>/<file>" tripped
the depth-2 ancestor lookup in classifyExtraPath: every title two levels
under the scope folder "other" was classified as an "other"-kind extra. Such
files are partitioned out of primary root/group inference and matching, then
deferred in processExtraFiles because their parent cannot resolve (they are
the primary titles, not children of one). The result on one deployment was
~10k movies under a folder named "other" funneled through the slow extras
path every scan (parent-unresolved deferrals at ~9.5/s), stalling the scan
and freezing that scope for new/changed primary content.

Remove "other"/"others" from extrasDirKinds. The ExtraKindOther kind stays
reachable through genuine convention labels (extra/extras/interviews/
scenes/shorts). Add regression coverage asserting titles under a scope folder
named other/others stay primary.

* perf(scanner): rewrite identity-only changes without re-probing

A pure identity/grouping change on an already-probed file — a
root_assignment_changed or group_assignment_changed reason with nothing
else — used to fall into the full update branch, which unconditionally ran
ffprobe (probeFile) and then upserted every column, including probe columns,
from the freshly built row. When a group-key or root scheme changes across
the library (see #319), this reprobed nearly every file on the next scan:
an incremental scan that normally takes ~1h ran 7h+ as a full-library
ffprobe storm, even though the media bytes were untouched.

Add a metadata-only update path in processFile: when identityOnlyUpdateReasons
reports every reason is a root/group reassignment, rewrite just the derived
identity columns via the new FileRepository.UpdateIdentity and skip ffprobe,
OSHash, and marker fetch entirely. UpdateIdentity issues a targeted UPDATE of
the root/group/identity and edition/presentation columns only, mirroring
Upsert's column handling, and leaves probe data, file bytes/mtime/hash,
subtitles, chapters, markers, and content/episode/extra linkage intact. The
stored group key converges to the recomputed value on the next scan, so the
file takes the unchanged fast-path thereafter — without a probe storm.

The shared identity-column population is extracted into populateScanIdentity
so the full path and the metadata-only path stay in lockstep.

Verification: unit test for the identityOnlyUpdateReasons classifier; a
DB-backed test (skipped without SILO_TEST_DATABASE_URL) asserting UpdateIdentity
rewrites grouping while preserving probe/linkage columns; the UPDATE statement
was also exercised against the live schema inside a rolled-back transaction.

* fix(scanner): harden identity fast path and extras scope classification

Review follow-ups for the two scan-regression fixes on this branch,
addressing both Codex review comments on PR #341 plus adversarial-review
findings.

Identity fast path (processFile/UpdateIdentity):

- Gate the metadata-only path on existing.ExtraID == "": a row still
  linked as an extra reaching processFile is being reclassified as
  primary, and only the full upsert clears extra linkage; UpdateIdentity
  would have frozen it out of matching forever (match backlog filters
  extra_id IS NULL).
- Gate on existing.FileHash != "": the full path backfills the OSHash
  and fetches hash-keyed S3 intro/credits markers, which no later scan
  reason would repair; hash-less legacy rows now take the full path once
  instead of silently losing that repair channel. file_hash is added to
  the scan-state row shape to support the gate.
- Clear match_suppressed_at like every other scan write, so files with
  fresh identity re-enter the match backlog (suppression is documented
  as lasting "until retried or seen by a new scan").
- Write media_folder_id, mirroring Upsert's ON CONFLICT reassignment.
- Return ErrFileNotFound when the row vanished mid-scan (concurrent
  delete) and fall through to the full upsert path instead of surfacing
  a per-file scan error.
- Return only the row id instead of RETURNING all ~75 columns: the fast
  path fires once per file during library-wide grouping migrations, and
  dragging the track/chapter JSONB payloads along for a million rows
  dominated the cost of the path built to be cheap.
- Extract identityColumnDefaults shared by Upsert and UpdateIdentity so
  the defaulting rules cannot drift, and drop the no-op editionConfidence
  indirection copied between them.
- Use populateScanIdentity in the new-file insert path too; it still
  carried a verbatim copy of the extracted block (with a provably dead
  existingByPath lookup).

Extras classification:

- Restore "other" to extrasDirKinds: it is part of both the documented
  Jellyfin and Plex extras-folder conventions (the removed-label fix
  overshot and broke "movies/<Title>/Other/<file>" libraries, ingesting
  their extras as bogus primary titles). "others" stays removed - it is
  in neither convention.
- Replace label removal with the structural guard the PR had deferred:
  classifyExtraPath now rejects a supplemental-named directory sitting
  at library-scope depth (the dir, any supplemental ancestor, or the
  first non-supplemental ancestor is a configured library root). This
  fixes the original "movies/other/<Title>" defer-storm generically,
  covering every convention label (shorts, scenes, extras, ...) used as
  a content-scope folder.
- Scope extras parent binding by folder.Paths instead of the walk roots,
  so a subtree scan targeting a single movie folder still binds that
  movie's own extras instead of deferring them.

Tests: eligibility-gate unit tests, scope-guard classifier cases
(convention Other/ inside a title binds; scope-level other/shorts stay
primary), and the DB-backed UpdateIdentity test now also covers folder
moves, suppression clearing, and ErrFileNotFound. Full scanner suite ran
green against a migrated scratch PostgreSQL 17 container.

* refactor(scanner): simplify extras scope guard to title-folder rule

Replace the ancestor-walking supplementalDirAtScopeDepth loop with the
plain rule it was approximating: a convention-named directory counts as
an extras dir only when it sits inside a title folder — it must not be a
configured library root or directly under one. Same outcome for the
layouts that matter (movies/other/<Title> stays primary, <Title>/Other
classifies), less machinery.

* test(scanner): assert all rewritten identity columns in UpdateIdentity test

* fix(scanner): make extras scope classification structure-aware

The title-folder rule from 53632022 anchored on library roots, so it
missed both directions: chained convention dirs at the root
("movies/extras/behind the scenes/clip.mkv") classified as extras with
an unresolvable parent (deferred forever), and category folders nested
below the root ("movies/4K/other/<Title>/") still misclassified their
titles.

Replace the root-distance heuristic with the structural property that
actually distinguishes the two cases: a convention-named directory only
counts as an extras dir when its owner (first non-supplemental
ancestor) is a title folder — a directory that holds media of its own.
The new extrasClassifier derives that from the scan's walked path list
(no extra I/O): movie folders must hold a file directly beside the
extras dir; series folders may hold episodes one level down in season
folders (media hiding inside a folder's own extras dirs doesn't count).
Library roots never qualify. Watch-event scans, which have no walked
list, probe ownership with bounded os.ReadDir instead.

This handles title folders at any depth below the root and keeps
scope/category folders primary at any depth, with two known edges: a
title folder holding only extras (its media file missing) stays primary
until the file appears, and a mixed dir holding both loose media and a
category folder degrades to deferral, never wrong linkage.

resolveExtraParent's inline supplemental-chain walk is extracted into
the shared firstNonSupplementalAncestor.
2026-07-08 11:18:07 -04:00

160 lines
6.6 KiB
Go

package scanner
import (
"os"
"path/filepath"
"testing"
"github.com/Silo-Server/silo-server/internal/models"
)
func TestClassifyExtraPathMovieLibrary(t *testing.T) {
cases := []struct {
path string
wantKind models.ExtraKind
wantDir string
wantOK bool
}{
{"/movies/Heat (1995)/Trailers/teaser.mkv", models.ExtraKindTrailer, "/movies/Heat (1995)/Trailers", true},
{"/movies/Heat (1995)/Behind The Scenes/doc.mkv", models.ExtraKindBehindTheScenes, "/movies/Heat (1995)/Behind The Scenes", true},
{"/movies/Heat (1995)/Extras/Making Of.mkv", models.ExtraKindOther, "/movies/Heat (1995)/Extras", true},
// "Other" is part of the Jellyfin/Plex extras convention.
{"/movies/Heat (1995)/Other/making-of.mkv", models.ExtraKindOther, "/movies/Heat (1995)/Other", true},
// Nested one level below a supplemental dir still classifies.
{"/movies/Heat (1995)/Extras/Sub/clip.mkv", models.ExtraKindOther, "/movies/Heat (1995)/Extras", true},
// Title folders own their extras at any depth below the root.
{"/movies/Collection/Ronin (1998)/Other/interview.mkv", models.ExtraKindOther, "/movies/Collection/Ronin (1998)/Other", true},
// Suffix classification with no supplemental dir.
{"/movies/Heat (1995)/Heat (1995)-trailer.mkv", models.ExtraKindTrailer, "", true},
// Plain movie files are not extras.
{"/movies/Heat (1995)/Heat (1995).mkv", "", "", false},
{"/movies/Collection/Ronin (1998)/Ronin (1998).mkv", "", "", false},
// Ancestor lookup is depth-bounded: a library living under a dir
// named "Extras" must not classify everything.
{"/data/Extras/Movies/Heat (1995)/Heat (1995).mkv", "", "", false},
// A content-scope folder carrying a convention label ("other",
// "shorts", "extras", ...) owns no media of its own, so titles
// beneath it stay primary and must not be misclassified as extras
// (regression for the /movies/other re-probe/defer storm) — at the
// library root or nested any depth below it. "others" is additionally
// absent from the convention vocabulary entirely.
{"/movies/other/Heat (1995)/Heat (1995).mkv", "", "", false},
{"/movies/others/Heat (1995)/Heat (1995).mkv", "", "", false},
{"/movies/shorts/Heat (1995)/Heat (1995).mkv", "", "", false},
{"/movies/4K/other/Alien (1979)/Alien (1979).mkv", "", "", false},
// Chained convention names at library scope hold no title either:
// loose clips there stay primary instead of deferring forever.
{"/movies/extras/behind the scenes/clip.mkv", "", "", false},
// Loose files directly under a scope-level convention dir are primary
// too — unless the filename itself carries a convention suffix.
{"/movies/other/stray file.mkv", "", "", false},
}
paths := make([]string, 0, len(cases))
for _, tc := range cases {
paths = append(paths, tc.path)
}
classifier := newExtrasClassifier("movies", []string{"/movies"}, paths)
for _, tc := range cases {
candidate, ok := classifier.classify(tc.path)
if ok != tc.wantOK {
t.Errorf("classify(%q) ok = %v, want %v", tc.path, ok, tc.wantOK)
continue
}
if !ok {
continue
}
if candidate.Kind != tc.wantKind || candidate.SupplementalDir != tc.wantDir {
t.Errorf("classify(%q) = (%q, %q), want (%q, %q)",
tc.path, candidate.Kind, candidate.SupplementalDir, tc.wantKind, tc.wantDir)
}
}
}
func TestClassifyExtraPathSeriesLibrary(t *testing.T) {
paths := []string{
"/tv/Show/Season 01/Show S01E01.mkv",
"/tv/Show/Extras/Show S00E01 Special.mkv",
"/tv/Show/Trailers/season-preview.mkv",
"/tv/other/Flat Show/pilot.mkv",
}
classifier := newExtrasClassifier("series", []string{"/tv"}, paths)
// Documented behavior: an episode-tokened file under Extras/ in a series
// library maps to season 0, so it must NOT classify as an extra.
if _, ok := classifier.classify("/tv/Show/Extras/Show S00E01 Special.mkv"); ok {
t.Fatal("SxxExx file under Extras/ must remain a season-0 episode, not an extra")
}
// A non-tokened file under a show-level supplemental dir IS an extra;
// the show folder owns it through its season-level episodes.
candidate, ok := classifier.classify("/tv/Show/Trailers/season-preview.mkv")
if !ok || candidate.Kind != models.ExtraKindTrailer {
t.Fatalf("show trailer dir should classify, got ok=%v kind=%q", ok, candidate.Kind)
}
// A scope folder named "other" holding show folders stays primary.
if _, ok := classifier.classify("/tv/other/Flat Show/pilot.mkv"); ok {
t.Fatal("show under a scope-level other/ must remain primary")
}
}
func TestClassifyExtraPathWatchMode(t *testing.T) {
// Watch-event scans have no walked path list; title ownership is probed
// from the filesystem.
root := t.TempDir()
title := filepath.Join(root, "Heat (1995)")
other := filepath.Join(title, "Other")
scopeOther := filepath.Join(root, "other", "Alien (1979)")
for _, dir := range []string{other, scopeOther} {
if err := os.MkdirAll(dir, 0o755); err != nil {
t.Fatal(err)
}
}
for _, file := range []string{
filepath.Join(title, "Heat (1995).mkv"),
filepath.Join(other, "making-of.mkv"),
filepath.Join(scopeOther, "Alien (1979).mkv"),
} {
if err := os.WriteFile(file, nil, 0o644); err != nil {
t.Fatal(err)
}
}
classifier := newWatchExtrasClassifier("movies", []string{root})
candidate, ok := classifier.classify(filepath.Join(other, "making-of.mkv"))
if !ok || candidate.Kind != models.ExtraKindOther {
t.Fatalf("convention dir beside the movie file should classify, got ok=%v kind=%q", ok, candidate.Kind)
}
if _, ok := classifier.classify(filepath.Join(scopeOther, "Alien (1979).mkv")); ok {
t.Fatal("title under a scope-level other/ must remain primary in watch mode")
}
}
func TestPartitionExtraPaths(t *testing.T) {
paths := []string{
"/movies/Heat (1995)/Heat (1995).mkv",
"/movies/Heat (1995)/Trailers/tease.mkv",
"/movies/Heat (1995)/Heat (1995)-featurette.mkv",
}
primary, extras := partitionExtraPaths(paths, "movies", []string{"/movies"})
if len(primary) != 1 || primary[0] != paths[0] {
t.Fatalf("primary = %v, want just the main feature", primary)
}
if len(extras) != 2 {
t.Fatalf("extras = %d entries, want 2", len(extras))
}
}
func TestMovieSupplementalDirsNoLongerSkipExtras(t *testing.T) {
// The walk must still hard-skip noise dirs...
for _, dir := range []string{"/m/Movie/Sample", "/m/Movie/Subs"} {
if !shouldSkipMovieSupplementalDir(dir) {
t.Errorf("expected %q to remain skipped", dir)
}
}
// ...but extras-shaped dirs are walked now (classified downstream).
for _, dir := range []string{"/m/Movie/Trailers", "/m/Movie/Extras", "/m/Movie/Behind The Scenes"} {
if shouldSkipMovieSupplementalDir(dir) {
t.Errorf("expected %q to be walked for extras classification", dir)
}
}
}