#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
获取韩寒创业简史 下集的author信息
"""

import sqlite3


def get_hanhan_bottom_author():
    """
    获取韩寒创业简史 下集的author信息
    """
    # 第一步：从srts表获取adname
    srts_db = r'\\ll\D\xtrssvjj\db\dpd.db'
    adid = 8434
    
    try:
        conn = sqlite3.connect(srts_db)
        cursor = conn.cursor()
        
        cursor.execute("SELECT adname FROM srts WHERE adid = ? LIMIT 1", (adid,))
        result = cursor.fetchone()
        
        if not result:
            print(f"未找到adid={adid}的adname")
            return
        
        adname = result[0]
        print(f"adid={adid}的adname: {adname}")
        
        # 第二步：从ads表查询author
        ads_db = r'\\ll\d\wxvddata\dpd.db'
        conn2 = sqlite3.connect(ads_db)
        cursor2 = conn2.cursor()
        
        # 使用adname的前60个字符进行模糊匹配
        search_term = adname[:60]
        print(f"搜索term: {search_term}")
        
        cursor2.execute("SELECT name, author FROM ads WHERE name LIKE ?", (f"%{search_term}%",))
        results = cursor2.fetchall()
        
        if results:
            print("找到的author信息:")
            for name, author in results:
                print(f"  name: {name[:100]}...")
                print(f"  author: {author}")
        else:
            print("未找到author信息")
            
    except Exception as e:
        print(f"错误: {e}")
    finally:
        if 'conn' in locals():
            conn.close()
        if 'conn2' in locals():
            conn2.close()


if __name__ == "__main__":
    get_hanhan_bottom_author()