#!/usr/bin/env python3
"""
查询前几句字幕的时间信息
"""
import sqlite3

# 数据库路径
db_path = "\\\\ll\\D\\xtrssvjj\\dpd.db"

try:
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 查询前5句字幕
    print("查询前5句字幕:")
    cursor.execute("SELECT idx, start, end, cn, en FROM srts WHERE adid = 8281 ORDER BY idx ASC LIMIT 5")
    results = cursor.fetchall()
    
    for idx, start, end, cn, en in results:
        duration = (end - start) / 1000
        print(f"  idx: {idx}")
        print(f"  start: {start}ms ({start/1000:.2f}s)")
        print(f"  end: {end}ms ({end/1000:.2f}s)")
        print(f"  duration: {duration:.2f}s")
        print(f"  cn: {cn}")
        print(f"  en: {en}")
        print()
    
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")