#!/usr/bin/env python3
"""
搜索包含"失去对流量的掌控"的音频文件
"""
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()

print(f"找到 {len(results)} 个匹配的音频文件:")
for i, result in enumerate(results):
    print(f"  {i}: {result[0]} - {result[9]}")
    print()

conn.close()