@echo off
REM 定时推送脚本 - 配合 Windows 任务计划程序使用
REM 创建定时任务：schtasks /create /tn "XiaozhiPush" /tr "C:\path\to\schedule_push.bat" /sc daily /st 10:00
REM 每天早上 10:00 自动推送最新生成的书到小智音箱

cd /d "%~dp0"
call .venv\Scripts\activate.bat

REM 查最新生成的书
for /f %%i in ('mysql -u root -p123456 -h localhost -P 3306 audio_book -N -e "SELECT id FROM Book WHERE genStage='audio_completed' ORDER BY createdAt DESC LIMIT 1;" 2^>nul') do set BOOK_ID=%%i

if "%BOOK_ID%"=="" (
    echo [%date% %time%] 没有可推送的书
    exit /b 0
)

echo [%date% %time%] 推送 book %BOOK_ID%
python push_book.py %BOOK_ID%