connect.py

# Connect to database
import os

import pandas as pd
from sqlalchemy import create_engine

hostname = "127.0.0.1"
username = os.environ['DB_USERNAME']
db_name = os.environ['DB_NAME']
password = os.environ['MYSQL_PWD']
port = os.environ['DB_PORT']

url = "mysql://{}:{}@{}:{}/{}".format(username, password, hostname, port, db_name)
engine = create_engine(url)

# Load data
student_assessments = pd.read_sql_query(
    'select * from student_assessments', engine, index_col='id')