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

import sqlite3

def check_subtitle_index(adid):
    """
    检查字幕索引
    """
    db_path = r"\\ll\\d\\xtrssvjj\\dpd.db"
    conn = sqlite3.connect(db_path)
    cur = conn.cursor()
    
    # 查询前10句字幕
    cur.execute("SELECT idx, cn FROM srts WHERE adid=? ORDER BY idx LIMIT 10", (adid,))
    results = cur.fetchall()
    conn.close()
    
    print("前10句字幕索引:")
    for idx, cn in results:
        print(f"idx: {idx}, cn: {cn}")


if __name__ == "__main__":
    adid = 8407
    check_subtitle_index(adid)