收藏夹内容

(async () => {
  const mediaId = "";   // 你的收藏夹 media_id
  const pageSize = 20;
  let page = 1;
  let hasMore = true;
  const results = [];

  function sleep(ms) {
    return new Promise(r => setTimeout(r, ms));
  }

  function formatHour(ts) {
    const d = new Date(ts * 1000);
    const yy = String(d.getFullYear()).slice(2);
    const mm = String(d.getMonth() + 1).padStart(2, "0");
    const dd = String(d.getDate()).padStart(2, "0");
    const hh = String(d.getHours()).padStart(2, "0");
    return `${yy}-${mm}-${dd}-${hh}`;
  }

  while (hasMore) {
    const url = `https://api.bilibili.com/x/v3/fav/resource/list?media_id=${mediaId}&pn=${page}&ps=${pageSize}`;
    console.log("Fetching page", page);

    const resp = await fetch(url, { credentials: "include" });
    const json = await resp.json();

    const medias = json?.data?.medias || [];
    hasMore = json?.data?.has_more;

    for (const m of medias) {
      if (!m.bvid || !m.fav_time) continue;

      results.push({
        bv: m.bvid,
        collect_hour: formatHour(m.fav_time),
        title: m.title.replace(/[\r\n,]+/g, " ") // 去掉换行和逗号，避免 CSV 出错
      });
    }

    page++;
    await sleep(300);
  }

  // 按时间排序（最老在前）
  results.sort((a, b) => a.collect_hour.localeCompare(b.collect_hour));

  console.table(results);

  // 导出 CSV（Excel UTF-8 BOM 兼容）
  const header = "bv,collect_hour,title\n";
  const rows = results.map(r => `${r.bv},${r.collect_hour},${r.title}`).join("\n");

  const blob = new Blob(
    ["\ufeff" + header + rows],
    { type: "text/csv;charset=utf-8;" }
  );

  const downloadUrl = URL.createObjectURL(blob);
  const a = document.createElement("a");
  a.href = downloadUrl;
  a.download = "bilibili_fav.csv";
  a.click();
  URL.revokeObjectURL(downloadUrl);

  console.log("Export done, total:", results.length);
})();

import csv
import os
import re

# ======================
# 配置区
# ======================
VIDEO_DIR = r"C:\Archive"           # 视频所在目录
CSV_PATH  = r"C:\Archive\bilibili_fav.csv"  # CSV 文件
LOG_PATH  = os.path.join(VIDEO_DIR, "rename_miss.log")
# ======================

# Windows 文件名非法字符
INVALID_CHARS = r'\/:*?"<>|'

def clean_title(title):
    for c in INVALID_CHARS:
        title = title.replace(c, "_")
    return title.strip()

# 清空日志文件
with open(LOG_PATH, "w", encoding="utf-8") as f:
    f.write("=== 缺失文件日志 ===\n")

# 读取 CSV → 建立 BV -> (时间, 标题) 映射
bv_list = []

with open(CSV_PATH, "r", encoding="utf-8-sig", newline="") as f:
    reader = csv.DictReader(f)
    for row in reader:
        bv = row["bv"].strip()
        time_prefix = row["collect_hour"].strip()
        title = clean_title(row.get("title", "").strip())
        bv_list.append((bv, time_prefix, title))

print(f"[INFO] 从 CSV 读取到 {len(bv_list)} 条记录")

# 扫描目录 → BV 文件
files_in_dir = os.listdir(VIDEO_DIR)
bv_to_file = {}

for filename in files_in_dir:
    file_path = os.path.join(VIDEO_DIR, filename)
    if not os.path.isfile(file_path):
        continue

    m = re.search(r"(BV[0-9A-Za-z]+)", filename)
    if not m:
        print(f"[SKIP] 未识别 BV: {filename}")
        continue

    bv_to_file[m.group(1)] = filename

# 批量重命名（全量，自动防覆盖）
for idx, (bv, time_prefix, title) in enumerate(bv_list, start=1):
    old_filename = bv_to_file.get(bv)
    if not old_filename:
        print(f"[MISS] 目录中找不到 BV: {bv}")
        with open(LOG_PATH, "a", encoding="utf-8") as logf:
            logf.write(f"{bv} 未找到对应文件\n")
        continue

    old_path = os.path.join(VIDEO_DIR, old_filename)
    ext = os.path.splitext(old_filename)[1]

    # 文件名格式：编号-时间-BV-标题.扩展名
    new_name = f"{idx:04d}-{time_prefix}-{bv}-{title}{ext}"
    new_path = os.path.join(VIDEO_DIR, new_name)

    # 防止意外覆盖，自动加 _1/_2 ...
    counter = 1
    base_new_name = new_name
    while os.path.exists(new_path):
        new_name = f"{os.path.splitext(base_new_name)[0]}_{counter}{ext}"
        new_path = os.path.join(VIDEO_DIR, new_name)
        counter += 1

    # 执行重命名
    try:
        os.rename(old_path, new_path)
        print(f"[{idx}/{len(bv_list)}] {old_filename} → {new_name}")
    except Exception as e:
        print(f"[ERROR] 重命名失败: {old_filename} → {new_name} ({e})")
        with open(LOG_PATH, "a", encoding="utf-8") as logf:
            logf.write(f"[ERROR] {old_filename} → {new_name} ({e})\n")

print("🎉 全量重命名完成")