Dynamic web application that allows users to view database of U.S. colleges and create a custom favorite colleges list to edit, delete, and update their colleges.
CollegeTracker is fully equipped with CRUD operations supported by the MySQL database.
CollegeTracker comes provided with a list of colleges with a variety of attributes: name, rank, type, price, location, and president. Every college is identified with a unique college id. The college database is read-only.
Each user has a custom favorites list in which they can add colleges from the database and add their own personalized comments.
A user can add a favorite, which contains a college id, rank, and review. Once a favorite is added, a user can choose to delete or edit the favorite at any point.
A user must login to an authentication page with their username and password in order to access the college database and their customized favorites list.
Once a user decides to edit a favorite, they are taken to the edit page where they can change the rank and review of the selected favorite.
- Flask - web app framework (Python)
- Werkzeug - WSGI web app library (Python)
- MySQL Connector - Driver for MySQL (Python)
- Flask-WTF - Extension that integrates WTForms and Flask (Python)
- Bootstrap - front-end component library (HTML/CSS/JS)
pip install Flask
pip install Werkzeug
pip install mysql-connector
pip install Flask-WTF
- Clone this repository:
git clone https://github.com/VKong6019/CollegeTracker.git - Once all dependencies have been installed, run CollegeTracker locally on a Flask server:
flask run - The server will run on http://127.0.0.1:5000/.
Download our local MySQL 'uscolleges' database dump and run the queries in CS3200 Project.
Vera Kong and Nicole Danuwidjaja
CS3200: Database Design, Professor Kathleen Durant, Northeastern University