#!/usr/bin/env python3
"""
查询srts表中adid=8237的完整记录
"""
import sqlite3

db_path = "\\\\ll\\D\\xtrssvjj\\dpd.db"
conn = sqlite3.connect(db_path)
cursor = conn.cursor()

cursor.execute("PRAGMA table_info(srts)")
columns = cursor.fetchall()
column_names = [col[1] for col in columns]

adid = 8237
cursor.execute("SELECT * FROM srts WHERE adid = ? LIMIT 1", (adid,))
result = cursor.fetchone()

if result:
    print(f"找到adid={adid}的记录：")
    for i, col_name in enumerate(column_names):
        print(f"{col_name}: {result[i]}")
else:
    print(f"未找到adid={adid}的记录")

conn.close()