#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
查找"韩寒创业简史 中"的adid
"""

import sqlite3


def find_hanhan_middle_adid():
    """
    查找"韩寒创业简史 中"的adid
    """
    db_path = r"\\ll\D\xtrssvjj\db\dpd.db"
    try:
        conn = sqlite3.connect(db_path)
        cur = conn.cursor()
        
        # 查询包含"韩寒创业简史"和"中"的记录
        cur.execute("SELECT adid, adname FROM srts WHERE adname LIKE '%韩寒创业简史%' AND adname LIKE '%中%' LIMIT 1")
        result = cur.fetchone()
        conn.close()
        
        if result:
            adid, adname = result
            print(f"找到adid: {adid}")
            print(f"adname: {adname}")
            return adid, adname
        else:
            print("未找到韩寒创业简史 中")
            return None, None
    except Exception as e:
        print(f"数据库查询错误: {e}")
        return None, None


if __name__ == "__main__":
    find_hanhan_middle_adid()