#!/usr/bin/env python3
"""
查找小米相关的音频文件
"""
import sqlite3

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

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

# 查找包含"小米"和"雷军"的音频
cursor.execute("SELECT rowid, name FROM ads WHERE name LIKE '%小米%' AND name LIKE '%雷军%' ORDER BY rowid")
results = cursor.fetchall()

print(f"找到 {len(results)} 条结果:")
for row in results:
    print(f"  rowid={row[0]}: {row[1]}")

conn.close()