Skip to content

armgit / peach

Public Imported from GitHub
0

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

3.8 KB
Raw Blame
#!/usr/bin/env python3
"""只读审计全部带 code 的视频,核对 JAV 番号、标题清洁与版本徽章投影。"""
from __future__ import annotations

import argparse
import re
import sys
from pathlib import Path

PROJECT_ROOT = Path(__file__).resolve().parent.parent
SRC_DIR = PROJECT_ROOT / "src"
if str(SRC_DIR) not in sys.path:
    sys.path.insert(0, str(SRC_DIR))

from peach.catalog_rules import (
    is_jav_asset,
    is_jav_code,
    jav_display_metadata,
)
from peach.config import DATABASE_PATH, GENERATED_DIR
from peach.scripting import open_readonly
from peach.review_csv import write_rows


FIELDS = (
    "asset_id", "name", "raw_code", "display_code", "display_title",
    "edition_badges", "is_jav", "issues",
)
DOMAIN = re.compile(
    r"(?:www\.)?[a-z0-9][a-z0-9-]{1,30}\."
    r"(?:com|net|la|xyz|cc|me|top|vip|club|info|org|tv|app|co|pw|gg|cn)",
    re.I,
)


def audit(database: Path) -> list[dict[str, object]]:
    connection = open_readonly(database)
    try:
        rows = connection.execute(
            "SELECT a.id,a.name,a.code,a.studio,a.release_date,"
            "COALESCE((SELECT group_concat(DISTINCT e.kind) FROM asset_entity ae "
            "JOIN entity e ON e.id=ae.entity_id WHERE ae.asset_id=a.id),'') entity_kinds,"
            "COALESCE((SELECT group_concat(value,'|') FROM ("
            "SELECT DISTINCT t.tag value FROM asset_tag t WHERE t.asset_id=a.id UNION "
            "SELECT DISTINCT e.canonical_name value FROM asset_entity ae "
            "JOIN entity e ON e.id=ae.entity_id WHERE ae.asset_id=a.id AND e.kind='tag'"
            ")),'') tags FROM asset a WHERE a.medium='video' "
            "AND a.code IS NOT NULL AND trim(a.code)<>'' ORDER BY a.id"
        ).fetchall()
    finally:
        connection.close()

    output = []
    for row in rows:
        kinds = tuple(filter(None, str(row["entity_kinds"] or "").split(",")))
        tags = tuple(filter(None, str(row["tags"] or "").split("|")))
        jav = is_jav_asset(
            row["code"], row["studio"], row["release_date"], kinds,
        )
        display = jav_display_metadata(row["name"], row["code"], tags)
        issues = []
        if jav and not is_jav_code(row["code"]):
            issues.append("缺连字符但有发行证据")
        if jav and str(row["code"] or "").strip().upper() != display["display_code"]:
            issues.append("番号需规范显示")
        if DOMAIN.search(str(row["name"] or "")):
            issues.append("推广域名残留")
        if display["edition_badges"]:
            issues.append("版本语义改徽章")
        if not jav:
            issues.append("非JAV或缺发行证据")
        output.append({
            "asset_id": row["id"],
            "name": row["name"],
            "raw_code": row["code"],
            "display_code": display["display_code"] if jav else "",
            "display_title": display["display_title"] if jav else "",
            "edition_badges": " ".join(display["edition_badges"]) if jav else "",
            "is_jav": int(jav),
            "issues": ";".join(issues) if issues else "正常",
        })
    return output


def main(argv: list[str] | None = None) -> int:
    parser = argparse.ArgumentParser(description=__doc__)
    parser.add_argument("--db", type=Path, default=DATABASE_PATH)
    parser.add_argument(
        "--out", type=Path, default=GENERATED_DIR / "jav-display-audit.csv",
    )
    args = parser.parse_args(argv)
    rows = audit(args.db)
    write_rows(args.out, FIELDS, rows)
    issue_count = sum(row["issues"] != "正常" for row in rows)
    jav_count = sum(int(row["is_jav"]) for row in rows)
    print({
        "database_mode": "ro", "rows": len(rows), "jav": jav_count,
        "needs_attention": issue_count, "output": str(args.out),
    })
    return 0


if __name__ == "__main__":
    raise SystemExit(main())