#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
检查adid=8407的详细信息
"""

import sqlite3

def check_adid_info(adid):
    """
    检查adid的详细信息
    """
    db_path = r"\\ll\\d\\xtrssvjj\\dpd.db"
    conn = sqlite3.connect(db_path)
    cur = conn.cursor()
    
    # 查询adname
    cur.execute("SELECT adname FROM srts WHERE adid=? LIMIT 1", (adid,))
    adname_result = cur.fetchone()
    
    if adname_result:
        adname = adname_result[0]
        print(f"adid: {adid}")
        print(f"adname: {adname}")
        
        # 查询字幕数量
        cur.execute("SELECT COUNT(*) FROM srts WHERE adid=?", (adid,))
        count_result = cur.fetchone()
        print(f"字幕数量: {count_result[0]}")
        
        # 查询前5句字幕
        cur.execute("SELECT idx, cn, en FROM srts WHERE adid=? ORDER BY idx LIMIT 5", (adid,))
        print("\n前5句字幕:")
        for row in cur.fetchall():
            idx, cn, en = row
            print(f"{idx}: {cn} | {en}")
    else:
        print("未找到adid信息")
    
    conn.close()


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