The repository contains a CRUD (Create, Read, Update, Delete) dentist/ patient management web application Dental Clinic. It is built using Flask, a microframework for Python, and MySQL, a database management system.
The project has the following features:
- A Flask server with a REST API
- Interaction with a third party API using jQuery
- MySQL database with two table accessible with authorization
- Web interface using AJAX calls
- Online hosted on PythonAnywhere
Submitted by: Olga Rozhdestvina (Student No: G00387844)
Lecturer: Andrew Beatty
Programming Languages used: Python, HTML, JavaScript, MySQL
Applications used for completion of the tasks are
Distribution of Python is Anaconda Python distribution.
Packages and modules used to complete the project:
- On remote.
To view the project on remove please follow the link http://olgarozhdestvina.pythonanywhere.com/ on PythonAnywhere.
- Locally.
To run on your local machine follow the instructions below.
-
Get into directory "Data-Representation-Project" in your Command Interpreter
-
Run createDatabase.py and then createTables.py to initialize a database "dentalclinic" or follow instructions in initdb.sql in MySQL command line client.
-
Run python -m venv venv to make a virtual environment.
-
Activate venv by running:
- Windows:
.\venv\Scripts\activate.bat
- Linux:
source venv/bin/activate -
Install packages by running pip install -r requirements.txt
-
Set Flask app to flask_server and run it:
- Windows:
set FLASK_APP=flask_server flask run- Linux:
export FLASK_APP=flask_server flask run -
Follow the flask URL to perform CRUD operations on the database or do it through another instance of Command Interpreter with CURL.
-
Run deactivate to exit venv.
This project is licensed under the MIT License - see the LICENSE.md file for details
