#!/usr/bin/env python3
"""
查看ads表的完整字段名
"""
import sqlite3

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

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

# 查看表结构
cursor.execute("PRAGMA table_info(ads)")
columns = cursor.fetchall()

print("ads表字段名:")
for col in columns:
    print(f"  {col[1]}")

# 查看前3条数据的所有字段
print("\n前3条数据:")
cursor.execute("SELECT * FROM ads LIMIT 3")
rows = cursor.fetchall()

for i, row in enumerate(rows):
    print(f"\n  第{i}条:")
    for j, col in enumerate(columns):
        print(f"    {col[1]}: {row[j]}")

conn.close()