#!/usr/bin/env python3
"""
搜索整个srts表中包含"今天想聊聊金身不好玩"的记录
"""
import sqlite3

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

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

# 搜索包含关键词的记录
cursor.execute("SELECT adid, adname, idx, cn, en FROM srts WHERE cn LIKE ?", ("%今天想聊聊金身不好玩%",))
results = cursor.fetchall()

print(f"找到 {len(results)} 个匹配的记录:")
for i, (adid, adname, idx, cn, en) in enumerate(results):
    print(f"  {i}: adid={adid}")
    print(f"    标题: {adname}")
    print(f"    idx: {idx}")
    print(f"    中文: {cn}")
    print(f"    英文: {en}")
    print()

conn.close()