9 Commits
Author SHA1 Message Date
HousemannandClaude Sonnet 4.6 7a7a997f15 Add cover URL edit button and modal
Rows without a cover (cover_url NULL or N/A) show a + button.
Clicking it opens a modal to enter a URL which is saved via new
PATCH /api/records/{id}/cover_url endpoint. cover_image is cleared
so n8n picks it up on the next backfill run.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-07-17 21:19:58 +02:00
HousemannandClaude Sonnet 4.6 50548d44c4 Filter out N/A cover_url in backfill select query
Switch node from visual select to executeQuery to exclude
cover_url = 'N/A' entries which are not valid image URLs.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-07-17 20:44:32 +02:00
HousemannandClaude Sonnet 4.6 14c9bef002 Remove redundant FileBot_Main.json
FileBot_Cover_Backfill.json already contains the complete workflow
including webhook import, cover download and backfill logic.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-07-17 20:36:06 +02:00
HousemannandClaude Sonnet 4.6 3442659973 Add n8n workflows without credentials
Both workflows stripped of credential references for safe version control.
Import into n8n and assign 'Postgres n8n_filebot' credential to Postgres nodes.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-07-17 20:31:21 +02:00
HousemannandClaude Sonnet 4.6 edfd7105b7 README aktualisiert: Cover-DB, n8n-Workflows, aktuelle API-Endpunkte
- Port 8090 korrigiert
- Alle 4 Migrationen dokumentiert (inkl. cover_image/cover_mime_type)
- Neuen API-Endpunkt GET /records/{id}/cover ergänzt
- n8n-Workflows (Haupt + Backfill) mit Ablauf beschrieben
- Projektstruktur und deploy.sh aktualisiert
- Fehlerbehebungs-Tabelle erweitert

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-07-17 20:02:05 +02:00
HousemannandClaude Sonnet 4.6 b5366783b1 Cover-Bilder aus DB laden mit Fallback auf URL-Proxy
- API: neuer Endpunkt GET /api/records/{id}/cover liefert BYTEA direkt
  aus der DB; cover_mime_type in COLUMNS aufgenommen
- Frontend: CoverImage lädt primär aus DB (/api/records/{id}/cover),
  fällt bei 404 automatisch auf den URL-Proxy zurück
- types.ts: cover_mime_type zum MediaRecord-Interface hinzugefügt
- scripts/deploy.sh: einmaliges SSH-Passwort für alle scp-Transfers

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-07-17 19:51:23 +02:00
HousemannandClaude Sonnet 4.6 944ca9a308 Add migration for cover_image and cover_mime_type columns
Neue Spalten cover_image (BYTEA) und cover_mime_type (TEXT) in
n8n.movie_files, damit Cover-Bilder direkt in der DB gespeichert
werden können statt nur als externe URL.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-07-17 19:24:04 +02:00
Housemann 84b7529aa4 remote deployment 2026-07-17 18:54:54 +02:00
HousemannandClaude Sonnet 4.6 3f253ffe81 Initial commit: Filebot Media Browser
Vue 3 + FastAPI Webapp zur Anzeige von Filebot/n8n-Medienmetadaten aus PostgreSQL.
Enthält Frontend, API, Nginx-Config, SQL-Migrationen und Docker-Compose-Setup.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-07-11 05:38:37 +02:00