#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
查看srts表结构
"""

import sqlite3

db_path = r'\\ll\D\xtrssvjj\db\dpd.db'
adid = 8434

try:
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    print("srts表结构:")
    cursor.execute("PRAGMA table_info(srts)")
    columns = cursor.fetchall()
    for col in columns:
        print(f"  {col[1]} ({col[2]}")
    
    print("\n前5句字幕数据:")
    print("-" * 80)
    cursor.execute("SELECT * FROM srts WHERE adid = ? AND idx < 5 ORDER BY idx", (adid,))
    subtitles = cursor.fetchall()
    
    # 获取列名
    cursor.execute("PRAGMA table_info(srts)")
    col_names = [col[1] for col in cursor.fetchall()]
    
    for row in subtitles:
        for i, (col_name, value) in enumerate(zip(col_names, row)):
            print(f"  {col_name}: {value}")
        print()
    
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")