#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
查找包含"下"的韩寒相关adid
"""

import sqlite3


def find_hanhan_bottom():
    """
    查找包含"下"的韩寒相关adid
    """
    db_path = r'\\ll\D\xtrssvjj\db\dpd.db'
    
    try:
        conn = sqlite3.connect(db_path)
        cursor = conn.cursor()
        
        # 搜索包含"韩寒"和"下"的adname
        cursor.execute("""
            SELECT adid, adname 
            FROM srts 
            WHERE adname LIKE '%韩寒%' AND adname LIKE '%下%' 
            GROUP BY adid, adname
            ORDER BY adid
        """)
        
        results = cursor.fetchall()
        
        if results:
            print("找到包含'下'的韩寒相关adid:")
            for adid, adname in results:
                print(f"adid: {adid}, adname: {adname}")
        else:
            print("未找到包含'下'的韩寒相关adid")
        
        # 再搜索所有包含"下"的adname
        print("\n所有包含'下'的adname:")
        cursor.execute("""
            SELECT adid, adname 
            FROM srts 
            WHERE adname LIKE '%下%' 
            GROUP BY adid, adname
            ORDER BY adid
            LIMIT 20
        """)
        
        results2 = cursor.fetchall()
        for adid, adname in results2:
            print(f"adid: {adid}, adname: {adname}")
            
    except Exception as e:
        print(f"错误: {e}")
    finally:
        if 'conn' in locals():
            conn.close()


if __name__ == "__main__":
    find_hanhan_bottom()