@REM Generate Django ERD v2
@REM 11/27/2023

@echo off
For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%c-%%a-%%b)
For /f "tokens=1-2 delims=/:" %%a in ("%TIME%") do (set mytime=%%a%%b)

REM Trim leading and trailing spaces from mydate and mytime
call :TrimSpaces mydate
call :TrimSpaces mytime

echo Writing models for %mydate% %mytime%

set DateStr=%mydate%_%mytime%

echo File name will be %DateStr%

@REM Specify which models to exclude from the ERD, i.e. Django default models.
set Exclude=User,Session,AbstractUser,ContentType,Permission,LogEntry,AbstractBaseSession,Group

@REM pip install graphviz pydotplus

python manage.py graph_models -a -g -X %Exclude% -o database/models_%DateStr%.png
python manage.py graph_models -a -g -X %Exclude% > database/models_%DateStr%.dot

exit /b

:TrimSpaces
set "var=%1"
set "var=%var: =%"
goto :eof