---
id: ML-105
title: Refactor MusicLibrary.ScrobbleRules
status: Done
assignee: []
created_date: '2026-04-20 08:59'
labels: []
dependencies: []
references:
  - 'https://github.com/cloud8421/music_library/issues/65'
priority: medium
---

## Description

<!-- SECTION:DESCRIPTION:BEGIN -->
_GitHub: created 2025-11-16 · updated 2026-02-10 · closed 2026-02-10_

- Extract sql macro for `CASE...WHEN...ELSE` update
- Extract sql macro for `json_extract`
- Extract sql macro for `json_set`
- Remove extended duplication
<!-- SECTION:DESCRIPTION:END -->
