HospitEase

HospitEase is a full stack hospital management system developed by gathering requirements from Mughal Labs.

Features

• Patient and doctor authentication.
• Ability to add new doctors to the system.
• Ability to add new nurses to the system.
• Retrieve patient and doctor data.
• Create and retrieve medical records for patients.
• Add appointment notes for patients.
• Discharge patient from hospital.
• Schedule an appointment with a doctor.
• Leave rating for a doctor.
• Billing mechanism.

The schema and the ER-diagram that depicts relationships within the entire system are available here.

Building

1. Start by cloning the repository:

git clone https://github.com/saadsheralam/HospitEase.git

2. If you do not have npm installed, install npm by following these instructions.

3. Navigate to the cloned directory.

4. Run the following command to install node modules.

cd client && npm i && cd ../server && npm i

5. Create an .env file in the server directory and set it up with the PORT and MONG_URI (MongoDB connection string). An example .env file might look like this:

PORT=3000
MONG_URI=mongodb+srv://<user>:<password>@<cluster0.example.mongodb.net>/?retryWrites=true&w=majority

6. Start the server

cd server 
node server.js

7. Start the client

cd client 
npm start

Testing

To test the schema and the relationships in the DB, automated Python scripts to create a MySQL database for the given schema are contained here.

1. Install MySQL Server and MySQL Workbench and set up and admin account for MySQL server.
2. Run MySQL Workbench.
3. Add user and password for SQL server in the following places: here, here, here, and here.
4. Navigate to the SQL-DB directory and install all dependencies:

cd db-info/SQL-DB/
pip3 install mysql-connector

4. Run the create-db.py file to create a HospitEase DB. Observe the newly created DB in MySQL Workbench.

cd db-info/SQL-DB/
python3 create-db.py

5. Run the create-tables.py file to create all tables in the HospitEase DB. Observe the newly created tables in MySQL Workbench.

python3 create-tables.py

6. Run the populate-tables.py file to add test data to all tables in the HospitEase DB. Observe data in MySQL Workbench. You can run queries in Workbench to verify all tables have been populated correctly.

python3 populate-tables.py

7. Finally, run the test-db.py file to test the database with an interactive prompt. MySQL Workbench will reflect any changes made by the python script.

python3 test_db.py