#!/usr/bin/env python3
"""
查询"金身不好玩"（adid=8370）第一行的所有字段
"""
import sqlite3

db_path = "\\\\ll\\D\\xtrssvjj\\dpd.db"

conn = sqlite3.connect(db_path)
cursor = conn.cursor()

adid = 8370
idx = 0

# 查询第一行的所有字段
cursor.execute("SELECT * FROM srts WHERE adid = ? AND idx = ?", (adid, idx))
result = cursor.fetchone()

if result:
    # 查看表结构获取字段名
    cursor.execute("PRAGMA table_info(srts)")
    columns = cursor.fetchall()
    
    print('"金身不好玩" 第一行所有字段：')
    print('-' * 80)
    
    for i, (col_id, col_name, col_type, *_) in enumerate(columns):
        if i < len(result):
            value = result[i]
            print(f"{col_name:<20} ({col_type}): {value}")
    
    print('-' * 80)
else:
    print('未找到第一行记录')

conn.close()