#!/usr/bin/env python3
"""
查看小米音频的前10句字幕
"""
import sqlite3

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

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

# 查看前10句字幕
adid = 8343
cursor.execute("SELECT idx, start, end, cn, en FROM srts WHERE adid = ? ORDER BY idx LIMIT 10", (adid,))
subtitles = cursor.fetchall()

print(f"adid={adid} 前10句字幕:")
for sub in subtitles:
    idx, start, end, cn, en = sub
    print(f"  [{idx}] {start:>6}-{end:>6}ms | {cn}")
    print(f"        {en}")

# 查看总共有多少句
cursor.execute("SELECT COUNT(*) FROM srts WHERE adid = ?", (adid,))
total = cursor.fetchone()[0]
print(f"\n总共有 {total} 句字幕")

conn.close()