@echo off
REM Windows batch script to generate DeFi_Collateral_Simulation.xlsx

REM Check if virtual environment exists
if not exist "venv" (
    echo Creating virtual environment...
    python -m venv venv
    if errorlevel 1 (
        echo.
        echo ERROR: Failed to create virtual environment
        echo Please install Python first
        pause
        exit /b 1
    )
)

REM Activate virtual environment
echo Activating virtual environment...
call venv\Scripts\activate.bat

REM Install xlsxwriter in virtual environment
echo Installing xlsxwriter...
python -m pip install --quiet --upgrade pip
python -m pip install --quiet xlsxwriter

if errorlevel 1 (
    echo.
    echo ERROR: Failed to install xlsxwriter
    echo Please install Python and pip first
    call venv\Scripts\deactivate.bat
    pause
    exit /b 1
)

echo.
echo Generating DeFi_Collateral_Simulation.xlsx...
python generate_defi_simulation.py

if errorlevel 1 (
    echo.
    echo ERROR: Failed to generate workbook
    call venv\Scripts\deactivate.bat
    pause
    exit /b 1
)

call venv\Scripts\deactivate.bat

echo.
echo SUCCESS: DeFi_Collateral_Simulation.xlsx has been generated!
echo.
pause