#!/usr/bin/env python3
"""
查询srts表中adid=7992的所有记录，按idx排序
"""
import sqlite3

# 数据库路径
db_path = "\\\\ll\\D\\xtrssvjj\\dpd.db"

try:
    # 连接数据库
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 查询adid为7992的所有记录，按idx升序
    print("查询srts表中adid=7992的所有记录 (按idx升序):")
    cursor.execute("SELECT idx, start, end, en FROM srts WHERE adid = 7992 ORDER BY idx ASC")
    results = cursor.fetchall()
    
    if results:
        print(f"找到 {len(results)} 条记录:")
        print("  idx | start | end | en")
        print("  -" * 50)
        for idx, start, end, en in results:
            print(f"  {idx:3d} | {start:6d} | {end:6d} | {en}")
    else:
        print("  无匹配记录")
    
    # 关闭连接
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")