Engineering Services Database

Final project for Introduction to Databases - CS340 @ OSU

Made with 💚 by Derek Greene & Nathan Schuler

Description

Application showcases web development & database knowledge. Users are able to view, add, edit, and remove records from various tables in the Engineering Services Database.

Three tier architecutre application built with:

• Flask/Python
• MySQL
• HTML/CSS
• Jinja2

See this app in action at https://www.derekrgreene.com/flask/

Citations

db_connector.py was adapted from: OSU-CS340-Ecampus Flask-Starter-App

Adapted to utilize pymysql instead of MySQLdb and removed unnecessary functions/sample query

Source URL: https://github.com/osu-cs340-ecampus/flask-starter-app/blob/master/database/db_connector.py

Getting started

Clone the repository

git clone https://github.com/derekgreene11/CS340.git

cd CS340/flask_proj

Install MySQL and create the database

CREATE DATABASE cs340_database;

Load the Engineering Services SQL and sample data into the database

source database/es_db.sql

Create a .env file in the CS340/flask_proj directory & enter credentials for the MySQL database

340DBHOST=localhost
340DBUSER=root
340DBPW="Enter the password you created during setup of MySQL Server"
340DB=cs340_database
340PORT="Enter open port of your choosing e.g. 5000"

Setup and Activate Python Virtual Enviornment

python3 -m venv venv

./venv/Scripts/activate

Install requirements.txt

pip install -r requirements.txt

Usage

Run python app.py to start application

Navigate to localhost at the port listed in the .env e.g. http://localhost:5000/