#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
检查"我们需要知识分子吗_思考"的音频文件是否存在
"""

import os
import sqlite3

def check_audio_file(adid):
    """
    检查音频文件是否存在
    """
    db_path = r"\\ll\\d\\xtrssvjj\\dpd.db"
    conn = sqlite3.connect(db_path)
    cur = conn.cursor()
    
    # 查询adname
    cur.execute("SELECT adname FROM srts WHERE adid=? LIMIT 1", (adid,))
    result = cur.fetchone()
    conn.close()
    
    if result:
        adname = result[0]
        audio_file = f"\\ll\\d\\xtrssvjj\\{adname}.mp3"
        print(f"检查音频文件: {audio_file}")
        print(f"文件存在: {os.path.exists(audio_file)}")
        return audio_file
    else:
        print("未找到adname")
        return None


if __name__ == "__main__":
    adid = 8407
    check_audio_file(adid)