#!/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[0]}: {col[1]} ({col[2]})")

# 查看前10条数据
print("\n前10条数据:")
cursor.execute("SELECT * FROM ads LIMIT 10")
rows = cursor.fetchall()
for i, row in enumerate(rows):
    print(f"  {i}: {row}")
    print()

conn.close()