@echo off
set "ROOT=%~dp0"
set "ROOT=%ROOT:~0,-1%"
set "PYTHON_EXE=C:\venv_ICR\Scripts\python.exe"
set "LOG=C:\PYTHON_LOCAL\ParquetToAccessDaily\run_TEST.log"

echo ParquetToAccess — test run (log: %LOG%)
if exist "C:\PYTHON_LOCAL\ParquetToAccessDaily\DB_DAY.laccdb" del "C:\PYTHON_LOCAL\ParquetToAccessDaily\DB_DAY.laccdb"
"%PYTHON_EXE%" -u "%ROOT%\main.py" --no-publish --no-enrich > "%LOG%" 2>&1
echo Exit code: %ERRORLEVEL% >> "%LOG%"
echo Fatto. Vedi %LOG%