#!/usr/bin/env python3
"""
调试脚本：查询并显示 srts 表数据
"""
import sqlite3

dbfile = 'dpd.db'
adid = 8397

conn = sqlite3.connect(dbfile)
conn.row_factory = sqlite3.Row  # 使用Row对象，方便通过列名访问
cur = conn.cursor()

try:
    # 查询adid=8397的数据
    sqlstr = '''select rowid,* from srts where adid=? order by idx'''  
    re = cur.execute(sqlstr, (adid,))
    srtsdata = re.fetchall()
    
    print(f'srts表 adid={adid} 的数据:')
    print(f'总数据量: {len(srtsdata)}')
    print('-' * 120)
    
    # 显示字段名
    fields = [description[0] for description in cur.description]
    print('字段名:', fields)
    print('-' * 120)
    
    # 显示前5条数据
    for i, row in enumerate(srtsdata[:5]):
        print(f'[{i+1}] rowid: {row[0]}')
        print(f'  adid: {row[1]}')
        print(f'  adname: {row[2]}')
        print(f'  idx: {row[3]}')
        print(f'  cn: {row[6]}')
        print(f'  en: {row[7]}')
        print(f'  start: {row[9]}')
        print(f'  end: {row[10]}')
        print(f'  tts: {row[11]}')
        print(f'  ttsdur: {row[27]}')
        print('-' * 120)
        
finally:
    cur.close()
    conn.close()

print('查询完成！')