knowstory-refresh-db.bat

set "OLD_SQL_ALCHEMY_ECHO=%SQL_ALCHEMY_ECHO%"
set "SQL_ALCHEMY_ECHO=False"
set "OLD_CURRENT_ENV=%CURRENT_ENV%"

set "CURRENT_ENV=DEV"
mysqladmin -uroot -f drop knowstory && mysqladmin -uroot create knowstory
alembic upgrade head
python fake_data_db_generator\main.py

set "CURRENT_ENV=UNIT-TEST"
mysqladmin -uroot -f drop knowstory_test && mysqladmin -uroot create knowstory_test
alembic upgrade head

set "CURRENT_ENV=%OLD_CURRENT_ENV%"
set "SQL_ALCHEMY_ECHO=%OLD_SQL_ALCHEMY_ECHO%"