#!/usr/bin/env python3
"""
列出adid=8096的所有字幕句时间和中文
"""
import sqlite3

db_path = "\\\\ll\\D\\xtrssvjj\\dpd.db"

try:
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()

    # 查询adid=8096的所有字幕句，按idx排序
    cursor.execute("SELECT idx, start, end, cn FROM srts WHERE adid = 8096 ORDER BY idx ASC")
    subtitles = cursor.fetchall()

    print(f"adid=8096 共 {len(subtitles)} 句字幕:")
    print("=" * 100)
    print(f"{'idx':>4} | {'start(ms)':>10} | {'end(ms)':>10} | {'中文':<60}")
    print("=" * 100)

    for idx, start, end, cn in subtitles:
        # 限制中文显示长度
        cn_display = cn[:60] + "..." if len(cn) > 60 else cn
        print(f"{idx:>4} | {start:>10} | {end:>10} | {cn_display:<60}")

    print("=" * 100)
    conn.close()

except Exception as e:
    print(f"错误: {e}")