#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
查找"我们需要知识分子吗_思考"的正确adid
"""

import sqlite3

def find_adid():
    """
    查找包含"知识分子"的adid
    """
    db_path = r"\\ll\\d\\xtrssvjj\\dpd.db"
    conn = sqlite3.connect(db_path)
    cur = conn.cursor()
    
    # 查询包含"知识分子"的adname
    cur.execute("SELECT adid, adname FROM srts WHERE adname LIKE ? GROUP BY adid, adname", ("%知识分子%",))
    results = cur.fetchall()
    conn.close()
    
    print("包含'知识分子'的内容:")
    for adid, adname in results:
        print(f"adid: {adid}, adname: {adname}")


if __name__ == "__main__":
    find_adid()