Python-SQL Package

This package is to be used for locally storing client information on a MySQL database using python front end.

Python and environment setup:

• Setup conda enviroment using given requirements.txt file

List of Tasks:

• [x] Develop an example connecting to an existing MySQL database (DB) using SQL-python connector
• [x] Improve components of DB by adding additional fields
• [x] Enable addition of data to DB using inputs written in excel or csv file
• [x] Enable data query through python API
• [x] Use SQLAlchemy instead of Python-SQL Connector to access database (to enable use with Flask-SQLAlchemy)
• [] Convert API to a python package before proceeding to app development
• [] Use a FLASK web app to add GUI functionality