#!/usr/bin/env python3
"""
查询oid=8237的所有字段
"""
import sqlite3

db_path = "\\\\ll\\d\\wxvddata\\dpd.db"
conn = sqlite3.connect(db_path)
cursor = conn.cursor()

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

oid = 8237
cursor.execute("SELECT * FROM ads WHERE oid = ?", (oid,))
result = cursor.fetchone()

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

conn.close()