#!/usr/bin/env python3
"""
查询所有字幕句数量
"""
import sqlite3

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

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

    cursor.execute("SELECT COUNT(*) FROM srts WHERE adid = 8281")
    count = cursor.fetchone()[0]

    cursor.execute("SELECT idx, start, end, cn, en FROM srts WHERE adid = 8281 ORDER BY idx ASC")
    subtitles = cursor.fetchall()

    print(f"总字幕句数: {count}")
    print(f"\n首句: {subtitles[0]}")
    print(f"末句: {subtitles[-1]}")

    # 计算总时长
    first_start = subtitles[0][1]
    last_end = subtitles[-1][2]
    total_duration = (last_end - first_start) / 1000
    print(f"\n字幕时间范围: {first_start}ms - {last_end}ms")
    print(f"总时长: {total_duration:.2f}s ({total_duration/60:.2f}分钟)")

    conn.close()

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