Coverage for downtify/db/migrations/versions/0004_slskd_misses.py: 100%

6 statements  

« prev     ^ index     » next       coverage.py v7.17.4, created at 2026-11-21 22:18 +0000

1"""Why slskd wasn't used: the reasons downloads fell through to another 

2source. 

3 

4Mirrors :class:`downtify.slskd_misses.SlskdMisses`. 

5""" 

6 

7from __future__ import annotations 

8 

9from downtify.db.core import Connection 

10 

11DDL: list[str] = [ 

12 """ 

13 CREATE TABLE IF NOT EXISTS slskd_misses ( 

14 id BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, 

15 at TEXT NOT NULL, 

16 reason TEXT NOT NULL, 

17 detail TEXT NOT NULL DEFAULT '', 

18 fallback TEXT NOT NULL DEFAULT '', 

19 title TEXT NOT NULL DEFAULT '', 

20 artist TEXT NOT NULL DEFAULT '' 

21 ) 

22 """, 

23 """ 

24 CREATE INDEX IF NOT EXISTS idx_slskd_misses_at ON slskd_misses (at) 

25 """, 

26] 

27 

28 

29def up(conn: Connection) -> None: 

30 for stmt in DDL: 

31 conn.execute(stmt)