#!/usr/bin/env python3
"""
查询ads表中包含"致敬思迥异"或"做不同"的记录
"""
import sqlite3

# 数据库路径
db_path = "\\\\ll\\D\\wxvddata\\dpd.db"

try:
    # 连接数据库
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 查询包含"致敬思迥异"的记录
    print("查询ads表中包含'致敬思迥异'的记录:")
    cursor.execute("SELECT rowid, name, url FROM ads WHERE name LIKE '%致敬思迥异%'")
    results = cursor.fetchall()
    
    if results:
        for row in results:
            rowid, name, url = row
            print(f"  rowid: {rowid}")
            print(f"  name: {name}")
            print(f"  url: {url}")
            print()
    else:
        print("  无匹配记录")
    
    # 查询包含"做不同"的记录
    print("查询ads表中包含'做不同'的记录:")
    cursor.execute("SELECT rowid, name, url FROM ads WHERE name LIKE '%做不同%'")
    results = cursor.fetchall()
    
    if results:
        for row in results:
            rowid, name, url = row
            print(f"  rowid: {rowid}")
            print(f"  name: {name}")
            print(f"  url: {url}")
            print()
    else:
        print("  无匹配记录")
    
    # 关闭连接
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")