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

import sqlite3

def get_hanhan_author(adid):
    """
    获取author信息
    """
    # 第一步：从srts表获取adname
    db_path = r"\\ll\\d\\xtrssvjj\\dpd.db"
    conn = sqlite3.connect(db_path)
    cur = conn.cursor()
    
    cur.execute("SELECT adname FROM srts WHERE adid=? LIMIT 1", (adid,))
    result = cur.fetchone()
    conn.close()
    
    if not result:
        print("未找到adname")
        return None
    
    adname = result[0]
    print(f"adname: {adname}")
    
    # 第二步：从ads表查询author
    author_db_path = r"\\ll\\d\\wxvddata\\dpd.db"
    conn = sqlite3.connect(author_db_path)
    cur = conn.cursor()
    
    # 使用adname的前60个字符进行模糊匹配
    search_term = adname[:60]
    cur.execute("SELECT author FROM ads WHERE name LIKE ? LIMIT 1", (f"%{search_term}%",))
    result = cur.fetchone()
    conn.close()
    
    if result:
        author = result[0]
        print(f"author: {author}")
        return author
    else:
        print("未找到author，使用'未知'")
        return "未知"


if __name__ == "__main__":
    adid = 8428  # 韩寒创业简史 上
    get_hanhan_author(adid)