#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
检查字幕数据
"""

import sqlite3

# 数据库路径
dbfile = r'\\ll\d\xtrssvjj\dpd.db'

try:
    # 连接数据库
    conn = sqlite3.connect(dbfile)
    cursor = conn.cursor()
    
    print("检查adid=8243的字幕数据...")
    
    # 查询该视频的字幕
    cursor.execute("SELECT start, end, cn FROM srts WHERE adid = 8243 ORDER BY start")
    rows = cursor.fetchall()
    
    print(f"\n找到 {len(rows)} 条字幕\n")
    
    for i, row in enumerate(rows[:10], 1):  # 只显示前10条
        start_time = row[0] / 1000.0
        end_time = row[1] / 1000.0
        duration = end_time - start_time
        text = row[2]
        
        print(f"{i}. 时间: {start_time:.2f}s - {end_time:.2f}s (时长: {duration:.2f}s)")
        print(f"   文本: {text}")
        print()
    
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")