#!/usr/bin/env python3
"""
查询师徒一场的第一句字幕
"""
import sqlite3

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

try:
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 查询adid=8281的第一条字幕 (idx=0)
    print("查询adid=8281的第一条字幕:")
    cursor.execute("SELECT idx, start, end, cn, en FROM srts WHERE adid = 8281 AND idx = 0")
    result = cursor.fetchone()
    
    if result:
        idx, start, end, cn, en = result
        print(f"  idx: {idx}")
        print(f"  start: {start}")
        print(f"  end: {end}")
        print(f"  cn: {cn}")
        print(f"  en: {en}")
    else:
        print("  无记录")
    
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")