LeagueSphere

Dev Documentation

Deploy

run

cd container
deploy.sh major|minor|patch

Django

Run server

To run server local under pycharm

1. create new python configuration (Alt + E)
2. set script path to manage.py
3. set parameters to: runserver
4. set environment variables to: league_manager=dev

Migration steps

Run new migration step in terminal

    python manage.py makemigrations
    python manage.py migrate

Access images and CSS

Run in Terminal

python manage.py collectstatic

MySQL

EXPORT MySQL from pythonanywhere

mysqldump -u 5erdffl -h 5erdffl.mysql.eu.pythonanywhere-services.com --set-gtid-purged=OFF --no-tablespaces '5erdffl$league_manager'  > db-backup.sql

IMPORT MySQL into pythonanywhere

mysql -u 5erdffl -h 5erdffl.mysql.eu.pythonanywhere-services.com '5erdffl$league_manager'  < db-backup.sql

IMPORT MySQL from local .sql file via mysql command

under windows: move terminal to mysql bin folder (cd C:\xampp\mysql\bin)

mysql -u root -p 5erdffl$league_manager < db-backup.sql

EXPORT MySQL to local .sql file via mysql command

mysqldump -u root -p --set-gtid-purged=OFF --no-tablespaces 5erdffl$league_manager  > db-backup.sql

Python

Reset virtual environment for pythonanywhere

Open terminal in pythonanywhere. While in home directory do the following steps:

rm -rf .virtualenvs/
mkvirtualenv venv --python=/usr/bin/python3.8