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

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

try:
    # 连接数据库
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 查询adid为8273的所有记录，按idx升序
    print("查询srts表中adid=8273的所有记录 (按idx升序):")
    cursor.execute("SELECT * FROM srts WHERE adid = 8273 ORDER BY idx ASC")
    results = cursor.fetchall()
    
    if results:
        print(f"找到 {len(results)} 条记录:")
        # 打印表头
        cursor.execute("PRAGMA table_info(srts)")
        columns = cursor.fetchall()
        headers = [col[1] for col in columns]
        print("  " + " | ".join(headers))
        print("  " + "-" * 120)
        
        # 打印记录
        for row in results:
            row_str = "  " + " | ".join(str(item) for item in row)
            print(row_str)
        
        # 显示idx范围
        min_idx = results[0][2]
        max_idx = results[-1][2]
        print(f"\nidx范围: {min_idx} - {max_idx}")
    else:
        print("  无匹配记录")
    
    # 关闭连接
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")