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

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

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

# 检查字幕idx是否连续
cursor.execute("SELECT idx FROM srts WHERE adid = 8096 ORDER BY idx ASC")
all_idx = [row[0] for row in cursor.fetchall()]

print(f"字幕总数: {len(all_idx)}")
print(f"idx范围: {min(all_idx)} - {max(all_idx)}")
print(f"idx是否连续: {all_idx == list(range(min(all_idx), max(all_idx)+1))}")

# 检查是否有重复的idx
if len(all_idx) != len(set(all_idx)):
    print("警告: 有重复的idx!")
    from collections import Counter
    idx_count = Counter(all_idx)
    for idx, count in idx_count.items():
        if count > 1:
            print(f"  idx={idx} 出现了{count}次")

# 检查时间是否递增
cursor.execute("SELECT idx, start, end FROM srts WHERE adid = 8096 ORDER BY idx ASC")
subtitles = cursor.fetchall()

print("\n检查时间递增:")
prev_end = 0
for idx, start, end in subtitles:
    if start < prev_end:
        print(f"  idx={idx}: start={start} < prev_end={prev_end}")
    if end < start:
        print(f"  idx={idx}: end={end} < start={start}")
    prev_end = end

conn.close()