#!/usr/bin/env python3
"""
查找"南海撞机烈士"在ads表中的记录行（全部字段）
"""
import sqlite3

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

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

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

# 获取表结构
cursor.execute("PRAGMA table_info(ads)")
columns = cursor.fetchall()

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

for i, result in enumerate(results):
    print(f"记录 {i}:")
    print("-" * 80)
    
    for j, (col_id, col_name, col_type, *_) in enumerate(columns):
        if j < len(result):
            value = result[j]
            print(f"{col_name:<20} ({col_type}): {value}")
    
    print("-" * 80)
    print()

conn.close()