#!/usr/bin/env python3
"""
查看ads表结构并查找"师徒一场"相关广告
"""
import sqlite3

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

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

# 查看ads表结构
cursor.execute("PRAGMA table_info(ads)")
columns = cursor.fetchall()
print("ads表结构:")
for col in columns:
    print(f"  {col}")

print(f"\n查找包含'师徒一场'的广告:")
cursor.execute("SELECT id, name FROM ads WHERE name LIKE '%师徒一场%' ORDER BY id")
results = cursor.fetchall()
print(f"找到 {len(results)} 条结果:")
for row in results:
    print(f"  id={row[0]}: {row[1]}")

conn.close()