#!/usr/bin/env python3
"""
查询数据库中对应视频文件的记录
"""
import sqlite3

# 视频文件名
target_name = "别用井底之蛙的视角，去丈量人类40万公里的征途。月薪多少决定你今晚吃什么，但不能限制你仰望星空。#阿尔忒弥斯计划 #重返月球 #NASA #认知觉醒 #太空探索 #航天技术 #科技改"

# 数据库路径
db_path = "\\\\ll\\D\\wxvddata\\dpd.db"

try:
    # 连接数据库
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()
    
    # 尝试查询可能的字段
    possible_fields = ['name', 'tit', 'txt']
    
    for field in possible_fields:
        print(f"\n尝试字段: {field}")
        query = f"SELECT * FROM ads WHERE {field} LIKE ? LIMIT 5"
        cursor.execute(query, ('%' + target_name + '%',))
        results = cursor.fetchall()
        
        if results:
            print(f"找到 {len(results)} 条记录:")
            for i, row in enumerate(results):
                print(f"  记录 {i+1}: {row}")
        else:
            print("  无匹配记录")
    
    # 尝试模糊匹配关键词
    print("\n尝试模糊匹配关键词:")
    keywords = ['井底之蛙', '阿尔忒弥斯', 'NASA', '太空探索']
    
    for keyword in keywords:
        print(f"  关键词: {keyword}")
        cursor.execute("SELECT * FROM ads WHERE name LIKE ? OR tit LIKE ? OR txt LIKE ? LIMIT 3", 
                       ('%' + keyword + '%', '%' + keyword + '%', '%' + keyword + '%'))
        results = cursor.fetchall()
        
        if results:
            print(f"    找到 {len(results)} 条记录:")
            for i, row in enumerate(results):
                print(f"      {i+1}: {row[0]}")  # 只显示name字段
        else:
            print("    无匹配记录")
    
    # 关闭连接
    conn.close()
    
except Exception as e:
    print(f"错误: {e}")