create .env file and add:
POSTGRES_USER=<your_username> # str type
POSTGRES_PASSWORD=<your_password> # str type
POSTGRES_DB='<db_name>' # str type
POSTGRES_HOST='your_postgres_host>' # for example 'localhost'
SQLALCHEMY_DATABASE_URI='postgresql://<your_username>:<your_password>@<your_postgres_host>/<db_name>'
SECRET_KEY=<your_secret_key>
To install all the packages activate your virtualenv and run the following command in your terminal:
pip install -r requirements.txt
To create DB - type in your terminal:
createdb -h <your_postgres_host> -p <your_postgres_port> -U <your_username> <db_name>
# for example: createdb -h localhost -p 5432 -U postgres VocabularyTask
To create a table in your DB just run a run.py file and the table automatically will be created if it did not exist