#!/usr/bin/env python3
"""
查找adid=8096的音频文件位置
"""
import sqlite3
import os

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

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

    # 查询adid=8096的所有字段
    cursor.execute("SELECT * FROM ads WHERE rowid = 8096")
    columns = [description[0] for description in cursor.description]
    result = cursor.fetchone()

    if result:
        print("adid=8096 的所有字段:")
        for col, val in zip(columns, result):
            print(f"  {col}: {val}")
    else:
        print("未找到adid=8096的记录")

    conn.close()

except Exception as e:
    print(f"错误: {e}")