Skip to content

armgit / peach

Public Imported from GitHub
0

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

3.4 KB
Raw Blame
-- 下载任务:云下载(115 经 CloudDrive2、PikPak 直连)与本地下载共用的运行状态。
--
-- 两张表都是运行状态,不是真相字段:哪部作品在不在馆藏仍只由 `asset` 回答,这里只记
-- 「交给了谁、走到哪一步、为什么停下」。
--
-- `download_task` 一个 infohash 一行,`info_hash` 是小写 40 位十六进制,唯一索引就是幂等键:
-- 同一个磁力再提交一次,接管已有那一行,不在远端再建一个任务、不再扣一条配额。直链下载
-- 没有 infohash,那一列留空,部分唯一索引只管有值的行。
--
-- `state` 与 `failure` 的取值由 `peach.downloads` 定义(状态机与九类失败),这里不写
-- CHECK:第 42 条本地下载接进来时只加代码里的常量,不必为一个枚举值重建表。
-- `blocked_at` 是拉黑:115 对违规内容的离线拦截(`50038`)不重试,同一 infohash 以后
-- 提交直接拒收。
--
-- `download_submission` 每次提交追加一行,永不更新也不随任务删除:任务行会被「重新下载」
-- 覆盖成新的状态,而每一次提交都扣过一条配额,这笔账要留着。`task_id` 不挂外键,理由
-- 同 `record_rehome`。
--
-- 时间列一律 ISO-8601 UTC 文本。
CREATE TABLE download_task(
  id INTEGER PRIMARY KEY,
  info_hash TEXT,
  provider TEXT NOT NULL,
  source_uri TEXT NOT NULL,
  display_name TEXT NOT NULL DEFAULT '',
  target TEXT NOT NULL,
  code TEXT,
  title TEXT,
  origin TEXT,
  state TEXT NOT NULL,
  failure TEXT,
  failure_detail TEXT,
  remote_id TEXT,
  remote_name TEXT,
  progress REAL,
  ledger_path TEXT,
  asset_id INTEGER,
  checks INTEGER NOT NULL DEFAULT 0,
  submitted_at TEXT,
  remote_done_at TEXT,
  updated_at TEXT NOT NULL,
  finished_at TEXT,
  next_check_at TEXT,
  blocked_at TEXT
);

CREATE UNIQUE INDEX idx_download_task_info_hash ON download_task(info_hash)
  WHERE info_hash IS NOT NULL;
CREATE INDEX idx_download_task_due ON download_task(next_check_at) WHERE next_check_at IS NOT NULL;

CREATE TABLE download_submission(
  id INTEGER PRIMARY KEY,
  task_id INTEGER,
  info_hash TEXT,
  provider TEXT NOT NULL,
  source_uri TEXT NOT NULL,
  target TEXT NOT NULL,
  code TEXT,
  origin TEXT,
  outcome TEXT NOT NULL,
  failure TEXT,
  detail TEXT,
  created_at TEXT NOT NULL
);

CREATE INDEX idx_download_submission_task ON download_submission(task_id, id);

INSERT INTO ledger_revision(tbl) VALUES ('download_task');
INSERT INTO ledger_revision(tbl) VALUES ('download_submission');

CREATE TRIGGER rev_download_task_insert AFTER INSERT ON download_task BEGIN
  UPDATE ledger_revision SET n=n+1 WHERE tbl='download_task';
END;

CREATE TRIGGER rev_download_task_update AFTER UPDATE ON download_task BEGIN
  UPDATE ledger_revision SET n=n+1 WHERE tbl='download_task';
END;

CREATE TRIGGER rev_download_task_delete AFTER DELETE ON download_task BEGIN
  UPDATE ledger_revision SET n=n+1 WHERE tbl='download_task';
END;

CREATE TRIGGER rev_download_submission_insert AFTER INSERT ON download_submission BEGIN
  UPDATE ledger_revision SET n=n+1 WHERE tbl='download_submission';
END;

CREATE TRIGGER rev_download_submission_update AFTER UPDATE ON download_submission BEGIN
  UPDATE ledger_revision SET n=n+1 WHERE tbl='download_submission';
END;

CREATE TRIGGER rev_download_submission_delete AFTER DELETE ON download_submission BEGIN
  UPDATE ledger_revision SET n=n+1 WHERE tbl='download_submission';
END;