#!/usr/bin/env python3
"""
查询\\ll\d\wxvddata\dpd.db中"南海撞机烈士"的author和signature字段
"""
import sqlite3
import os

db_path = r"\\ll\d\wxvddata\dpd.db"

print(f"数据库路径: {db_path}")
print(f"路径是否存在: {os.path.exists(db_path)}")

try:
    conn = sqlite3.connect(db_path)
    cursor = conn.cursor()

    # 搜索包含"南海撞机烈士"的音频
    cursor.execute("SELECT name, author, signature FROM ads WHERE name LIKE ? LIMIT 10", ("%南海撞机烈士%",))
    results = cursor.fetchall()

    print(f"找到 {len(results)} 个匹配的音频文件:\n")

    for i, (name, author, signature) in enumerate(results):
        print(f"记录 {i}:")
        print("-" * 80)
        print(f"name: {name}")
        print(f"author: {author}")
        print(f"signature: {signature}")
        print("-" * 80)
        print()

    conn.close()
except Exception as e:
    print(f"错误: {e}")