#!/usr/bin/env python3
"""
查询xtrssvjj数据库中"南海撞机烈士"的author和signature字段
"""
import sqlite3

db_path = r"\\ll\D\xtrssvjj\dpd.db"

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()