#!/usr/bin/env python3
"""
搜索"金身不好玩"音频文件并查询其字幕信息
"""
import sqlite3

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

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

# 搜索包含"金身不好玩"的音频（使用正确的字段名）
cursor.execute("SELECT * FROM ads WHERE name LIKE ? LIMIT 5", ("%金身不好玩%",))
results = cursor.fetchall()

print(f"找到 {len(results)} 个匹配的音频文件:")
for i, result in enumerate(results):
    adid = result[0]  # 第一列是adid
    name = result[9]   # 第十列是name
    print(f"  {i}: adid={adid} - {name}")
    
    # 查询对应的字幕
    cursor.execute("SELECT idx, cn, en, tts FROM srts WHERE adid = ? ORDER BY idx", (adid,))
    subs = cursor.fetchall()
    
    print(f"    字幕数量: {len(subs)}句")
    print("    字幕列表 (idx, cn, en, tts):")
    for idx, cn, en, tts in subs:
        print(f"    [{idx}] 中: {cn}")
        print(f"        英: {en}")
        print(f"        tts: {tts}")
        print()

conn.close()