Main
 |--- /nginx
 | |--- Dockerfile
 | |--- /logs    
 | |--- /ssl
 | |--- /sites-enabled
 | | |--- nginx_all
 | | |--- nginx_with_ssl
 | | |--- nginx_with_ssl_only
 | | |--- nginx_without_ssl     
 |--- /web
 | |--- Dockerfile
 | |--- manage.py
 | |--- requirements.txt
 | |--- tests
 | |--- /project
 | | |--- __init__.py
 | | |--- config.py
 | | |--- /templates 
 | | |--- /static
 | | |--- apps
 | | | |--- __init__.py
 | | | |--- models.py
 | | | |--- forms.py
 | | | |--- views.py
 | | | |--- /templates
 |--- .env
 |--- docker-compose.yml
 |--- README.md

$ curl -sSL https://get.docker.com/ | sh
$ pip install docker-compose

#sample .env file
DEBUG=False
SECRET_KEY=secret_key
DB_NAME=postgres
DB_USER=postgres
DB_PASS=postgres
DB_SERVICE=postgres
DB_PORT=5432
DEBUG_TB_ENABLED=False
THEME_VERSION=4.5.4  
APP_SETTINGS=project.config.ProductionConfig  
NOTEBOOK_PASSWORD='sha1:0c80a71d63da:a1ca534342f6cdbe8e71c80f06f1fcc0011bd55b'    

Soon

# Change postgres password (Security Reasons), Add User for the application
$ psql -h 127.0.0.1 -p 5432 -U postgres --password
postgres=# ALTER USER postgres WITH PASSWORD 'desired_password';
           CREATE DATABASE web;
           CREATE USER web WITH PASSWORD 'test';
           GRANT ALL PRIVILEGES ON DATABASE "web" to web;

$ docker-compose run web /usr/local/bin/python manage.py create_db

$ docker exec -it suite_postgres_1 \
  sh -c "pg_dump -U postgres_user postgres_dbname | gzip > /postgres/backup/dump_`date +%d-%m-%Y"_"%H_%M_%S`.gz"

$ docker exec -it suite_postgres_1 \
    sh -c "gunzip -c /postgres/backup/filename.gz | psql -U postgres_user postgres_dbname"

from project import db
db.engine.execute("ALTER SEQUENCE team_tasks_id_seq RESTART WITH 2001;")

DEBUG=False
SECRET_KEY=5(15ds+i2+%ik6z&!yer+ga9m=e%jcqiz_5wszg)r-z!2--b2d
DB_NAME=web
DB_USER=web
DB_PASS=test
DB_SERVICE=postgres
DB_PORT=5432

APP_SETTINGS=project.config.ProductionConfig

from project.models import User, UserGroup
import pandas as pd

from collections import defaultdict
from sqlalchemy.inspection import inspect

def query_to_dict(rset):
    result = defaultdict(list)
    for obj in rset:
        instance = inspect(obj)
        for key, x in instance.attrs.items():
            result[key].append(x.value)
    return result

user = User.query.join(UserGroup).filter(UserGroup.id == 1).all()
user_group = UserGroup.query.all()	

df_user	= pd.DataFrame(query_to_dict(user))
df_usergroup = pd.DataFrame(query_to_dict(user_group))

# pd.merge(left, right, left_on='group_id', right_on='id', how='inner', indicator=True)

# how must be inner if you want to filter and remove unrelated items
# how must be outer if you want to create rows even if no common in relational keys

merged = pd.merge(df_user, df_usergroup, left_on='group_id', right_on='id', how='inner', indicator='indicator_column')

git clone -b <branch> <repo> <foldername>
copy .env to the Host
copy SSL Certs
copy static files
update DB