#!/usr/bin/env python3
"""
根据标题查找adid
"""
import sqlite3

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

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

    # 搜索包含关键词的记录
    keywords = ["高晓松", "枪炮", "病菌与钢铁", "矮大紧", "文学"]
    search_terms = []
    for keyword in keywords:
        search_terms.append(f"name LIKE '%{keyword}%'")
    where_clause = " OR ".join(search_terms)

    query = f"SELECT rowid, name FROM ads WHERE {where_clause}"
    cursor.execute(query)
    results = cursor.fetchall()

    print(f"找到 {len(results)} 条匹配记录:")
    for rowid, name in results:
        print(f"  adid: {rowid}")
        print(f"  标题: {name}")
        print()

    conn.close()

except Exception as e:
    print(f"错误: {e}")