Skip to content

armgit / peach

Public Imported from GitHub
0

Peach: Local-first video metadata scraper and media manager.

5.2 KB
Raw Blame
"""数据管理页的孤儿记录:列出已消失的作品、接到某个文件、彻底删除(ADR-0087 决策三)。

账本路径都落在临时目录里:彻底删除那一支会顺手清空文件夹,路径指向真实的 `R:\\media`
就是在动这台机器上的目录。
"""
import sqlite3
import tempfile
import unittest
from contextlib import closing
from pathlib import Path
from unittest.mock import patch

from peach import record_rehome, web_batch
from peach import web_contract as rm_web
from peach.web_orphan_records import q_orphan_records, w_orphan_attach

from support.ledger import fresh_ledger


class OrphanRecordsTests(unittest.TestCase):
    def setUp(self):
        self.tmp = tempfile.TemporaryDirectory()
        self.addCleanup(self.tmp.cleanup)
        self.root = Path(self.tmp.name).resolve()
        self.enterContext(patch.object(web_batch, "LOCATION_ROOT_DECLARATIONS",
                                      {"local": (str(self.root),)}))
        self.db = fresh_ledger(self.root)
        gone, here = self.root / "gone", self.root / "here"
        rows = [
            # id, path, code, duration, disposal, feedback_at
            (7, gone / "ABC-123.mp4", "ABC-123", 3600, "vanished", 200),
            (9, here / "ABC-123.mkv", None, 3590, None, None),
            (10, here / "abc-123.mp4", None, 1800, None, None),
            (11, here / "XYZ-001.mp4", "XYZ-001", 3600, None, None),
            (12, gone / "海边.mp4", None, 600, "vanished", 100),
            (13, here / "海边.mkv", None, 601, None, None),
            # 回收站里的不当候选。
            (14, here / "ABC-123 old.mp4", None, 3600, "trash", 50),
        ]
        with closing(sqlite3.connect(self.db)) as connection:
            connection.executemany(
                "INSERT INTO asset(id,location,path,name,medium,size,code,duration,disposal,feedback_at) "
                "VALUES(?,'local',?,?,'video',10,?,?,?,?)",
                [(row[0], str(row[1]), row[1].name, *row[2:]) for row in rows])
            connection.execute("INSERT INTO asset_preference(profile_id,asset_id,liked,reason,updated_at) "
                               "VALUES('default',7,1,'','2026-01-01')")
            connection.execute("INSERT INTO watch_queue(profile_id,asset_id,added_at) VALUES('default',12,'2026-01-01')")
            connection.executemany(
                "INSERT INTO activity_event(asset_id,profile_id,kind,occurred_at,source) "
                "VALUES(7,'default','play',?,'web')", [("2026-01-01",), ("2026-01-02",)])
            connection.commit()
        self.contract = rm_web.WebContract(Path(self.db))

    def owners(self, table):
        with closing(sqlite3.connect(self.db)) as connection:
            return sorted({row[0] for row in connection.execute(f"SELECT asset_id FROM {table}")})

    def test_the_list_shows_each_vanished_row_with_its_records_and_candidates(self):
        listed = q_orphan_records(self.contract)
        self.assertEqual(listed["total"], 2)
        first, second = listed["items"]
        self.assertEqual((first["id"], second["id"]), (7, 12), "新标的在前")
        self.assertEqual(first["records"], {"asset_preference": 1, "activity_event": 2})
        self.assertEqual([item["id"] for item in first["candidates"]], [9, 10],
                         "番号对得上的在库文件,时长接近的在前;回收站里的不算")
        self.assertEqual(second["records"], {"watch_queue": 1})
        self.assertEqual([item["id"] for item in second["candidates"]], [13], "无番号按文件名主干对")

    def test_attaching_moves_the_records_and_records_a_revertible_batch(self):
        result = w_orphan_attach(self.contract, {"id": 7, "target": 10})
        self.assertEqual(result["batch"], f"{record_rehome.MANUAL_SOURCE}@1")
        self.assertEqual(self.owners("asset_preference"), [10])
        self.assertEqual(self.owners("activity_event"), [10])
        self.assertEqual([item["id"] for item in q_orphan_records(self.contract)["items"]], [12])
        with closing(sqlite3.connect(self.db)) as connection:
            self.assertEqual(connection.execute("SELECT count(*) FROM asset WHERE id=7").fetchone()[0], 0)
            self.assertEqual(len(record_rehome.planned_revert(connection, record_rehome.MANUAL_SOURCE)), 1)

    def test_attaching_refuses_a_target_outside_the_library(self):
        with self.assertRaisesRegex(ValueError, "在库"):
            w_orphan_attach(self.contract, {"id": 7, "target": 14})
        self.assertEqual(self.owners("asset_preference"), [7])

    def test_deleting_a_vanished_row_drops_it_and_its_records_but_keeps_a_file_that_came_back(self):
        back = self.root / "gone" / "海边.mp4"
        back.parent.mkdir()
        back.write_bytes(b"x")
        result = web_batch.w_batch(self.contract, {"ids": [7, 12], "operation": "delete"})
        self.assertEqual(result["purged"], 1)
        self.assertEqual([item["id"] for item in result["blocked"]], [12], "文件又回到盘上,只删数据库行的口径不删它")
        self.assertTrue(back.exists())
        self.assertEqual(self.owners("asset_preference"), [])
        self.assertEqual(self.owners("activity_event"), [])
        self.assertEqual(self.owners("watch_queue"), [12])


if __name__ == "__main__":
    unittest.main()