music_library/backlog/completed/ml-107 - Regular-job-to-cleanup-asset-cache.md

id, title, status, assignee, created_date, labels, dependencies, references, priority

id	title	status	assignee	created_date	labels	dependencies	references	priority
ML-107	Regular job to cleanup asset cache	Done		2026-04-20 08:59			https://github.com/cloud8421/music_library/issues/59	medium

Description

GitHub: created 2025-11-07 · updated 2025-11-07 · closed 2025-11-07

This query returns the hash of all orphan assets

SELECT hash
FROM assets
LEFT JOIN records on records.cover_hash == assets.hash
LEFT JOIN artist_infos on artist_infos.image_data_hash == assets.hash
WHERE records.id IS NULL AND artist_infos.id IS NULL;