#!/usr/bin/env python3
"""
检查字幕idx=70的数据
"""
import sqlite3

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

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

# 检查idx=70的字幕
cursor.execute("SELECT idx, start, end, cn FROM srts WHERE adid = 8096 AND idx = 70")
result = cursor.fetchone()
print(f"idx=70的字幕: {result}")

# 检查idx=69和idx=71的字幕
cursor.execute("SELECT idx, start, end, cn FROM srts WHERE adid = 8096 AND idx IN (69, 70, 71) ORDER BY idx")
results = cursor.fetchall()
print(f"\nidx=69,70,71的字幕:")
for row in results:
    print(f"  {row}")

# 检查字幕列表的第70个元素
cursor.execute("SELECT idx, start, end, cn FROM srts WHERE adid = 8096 ORDER BY idx ASC")
subtitles = cursor.fetchall()
print(f"\n字幕列表的第70个元素 (subtitles[70]):")
print(f"  {subtitles[70]}")

conn.close()