#!/usr/bin/env python3
"""
查找"南海撞机烈士"在srts表中的字幕记录
"""
import sqlite3

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

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

# 搜索包含"南海撞机烈士"的字幕记录
cursor.execute("SELECT adid, adname, COUNT(*) FROM srts WHERE adname LIKE ? GROUP BY adid", ("%南海撞机烈士%",))
results = cursor.fetchall()

print(f"找到 {len(results)} 个匹配的字幕记录:\n")

for i, (adid, adname, count) in enumerate(results):
    print(f"记录 {i}:")
    print("-" * 80)
    print(f"adid: {adid}")
    print(f"adname: {adname}")
    print(f"字幕数量: {count}句")
    
    # 查看前3句字幕
    cursor.execute("SELECT idx, cn, en FROM srts WHERE adid = ? ORDER BY idx LIMIT 3", (adid,))
    subs = cursor.fetchall()
    if subs:
        print("\n前3句字幕:")
        for idx, cn, en in subs:
            print(f"  [{idx}] 中: {cn}")
            print(f"      英: {en}")
    
    print("-" * 80)
    print()

conn.close()