app.py

import os
import psycopg2
from flask import Flask, render_template, request, url_for, redirect
from flask_cors import CORS


app = Flask(__name__)
CORS(app)

def get_db_connection():
    conn = psycopg2.connect(host='localhost',
                            database='flask_db',
                            user=os.environ['DB_USERNAME'],
                            password=os.environ['DB_PASSWORD'])
    return conn


# @app.route('/teams')
# def teams():
#     conn = get_db_connection()
#     cur = conn.cursor()
#     cur.execute('SELECT * FROM teams;')
#     teams = cur.fetchall()
#     cur.close()
#     conn.close()
#     return render_template('teams.html', teams=teams)

# @app.route('/games')
# def games():
#     conn = get_db_connection()
#     cur = conn.cursor()
#     cur.execute('SELECT * FROM games;')
#     teams = cur.fetchall()
#     cur.close()
#     conn.close()
#     return render_template('games.html', teams=teams)