#!/usr/bin/env python3
"""
查询ads表中adid=7992的记录
"""
import sqlite3

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

try:
    # 连接数据库
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 查询adid为7992的记录
    print("查询ads表中adid=7992的记录:")
    cursor.execute("SELECT rowid, name, url FROM ads WHERE rowid = 7992")
    result = cursor.fetchone()
    
    if result:
        rowid, name, url = result
        print(f"  rowid: {rowid}")
        print(f"  name: {name}")
        print(f"  url: {url}")
        
        # 检查是否包含"晓松故事会"
        if "晓松故事会" in name:
            print("\n  ✓ 包含'晓松故事会'")
        else:
            print("\n  ✗ 不包含'晓松故事会'")
    else:
        print("  无匹配记录")
    
    # 关闭连接
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")