Database Management - CPSC 408, Fall 2021
Tarek El-Hajjaoui, Erin Lee, Connor Lydon
This is a payment processing console app for magazine subscriptions. The database runs on a cloud instance. Instructions for interacting with the app below.
- Install pip packages.
pip3 install -r requirements.txt
- Run the application.
python3 app.py
- app.py
- main program
- controllers/db_helper.py
- database functions
- controllers/ui_helper.py
- user interface functions
- data/
- a directory containing a flat file with individual CSV tables & randomly generated data
- generateReport.py
- exports data to a CSV depending on what the user selects
- meta_info/
- directory containing outline & rubric for the project
- models/parser.py
- contains the parser for reading through flat files & reading them into the object types
- models/db_model.py
- the main database interface that works with the MYSQL database
- models/record_types.py
- the object types that are read into before putting them into the database
- queries/
- directory containing all of the queries that are used in the program
- requirements.txt
- contains all of the required packages
- test.py
- contains a function that prints the .env contents
- views/
- directory containing the ui & how each user is treated differently