#!/usr/bin/env python3
"""
查询"像专家一样使用AI"的author字段
"""
import sqlite3

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

search_term = "像专家一样使用AI"
cursor.execute("SELECT name, author, signature FROM ads WHERE name LIKE ?", (f"%{search_term}%",))
results = cursor.fetchall()

if results:
    print(f"找到包含 '{search_term}' 的记录：")
    for name, author, signature in results:
        print(f"name: {name}")
        print(f"author: {author}")
        print(f"signature: {signature}")
        print("\n")
else:
    print(f"未找到包含 '{search_term}' 的记录")

conn.close()