#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
详细检查韩寒创业简史的所有相关内容
"""

import sqlite3


def check_hanhan_series():
    """
    详细检查韩寒创业简史的所有相关内容
    """
    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 '%创业简史%' 
            GROUP BY adid, adname
            ORDER BY adid
        """)
        
        results = cursor.fetchall()
        
        print("=== 韩寒创业简史系列 ===")
        if results:
            for adid, adname in results:
                print(f"adid: {adid}")
                print(f"adname: {adname}")
                print()
        else:
            print("未找到创业简史相关内容")
        
        # 检查是否有其他可能的"下"相关内容
        print("=== 可能的'下'相关内容 ===")
        cursor.execute("""
            SELECT adid, adname 
            FROM srts 
            WHERE adname LIKE '%韩寒%' 
            GROUP BY adid, adname
            ORDER BY adid
        """)
        
        all_hanhan = cursor.fetchall()
        for adid, adname in all_hanhan:
            print(f"adid: {adid}, adname: {adname}")
            
    except Exception as e:
        print(f"错误: {e}")
    finally:
        if 'conn' in locals():
            conn.close()


if __name__ == "__main__":
    check_hanhan_series()