A simple COVID management system for health organizations using MySQL and Python. This system allows the management of patients and staff records, facilitates login for authorized users, and provides a self-assessment test for COVID-19 symptoms.
- Login System: Admins can create a new account if no user exists. Existing users can log in to manage records.
- Manage Patients: Add, view, and remove patient records.
- Manage Staff: Add, view, and remove staff members.
- Change Password: Logged-in admins can change their account password.
- COVID-19 Precautions: Information on preventive measures.
- Self-Assessment Test: A simple test to check for COVID-19 symptoms based on user input.
Ensure you have the following installed on your system:
- Python 3.x
- MySQL
- MySQL Connector for Python (
mysql-connector-python
)
You can install the required MySQL connector by running:
pip install mysql-connector-python
-
Clone the repository:
git clone https://github.com/your-username/covid-management-system.git
-
Configure MySQL:
- Ensure your MySQL server is running.
- Update the MySQL connection details (username and password) in the script if necessary.
- The script will automatically create the database
covid_management
and its required tables.
-
Run the Application:
python app.py
- On the first run, you’ll be prompted to create a new admin account.
- If an admin account exists, use the login option to access the system.
- Once logged in, you can:
- Add/view/remove patient records.
- Add/view/remove staff records.
- Change your password.
- Log out.
Non-registered users can take a simple self-assessment test by selecting the option from the main menu. Based on the answers, the system will suggest whether to seek medical advice.
The database consists of four tables:
-
staff
: Stores information about hospital staff.- Fields:
sno
,name
,age
,gender
,post
,salary
- Fields:
-
patients
: Stores information about COVID-19 patients.- Fields:
sno
,name
,age
,gender
,date
- Fields:
-
login
: Stores admin login credentials.- Fields:
admin
,password
- Fields:
-
sno
: Keeps track of the serial numbers of patients and staff.- Fields:
patient
,staff
- Fields:
The self-assessment test evaluates a user’s symptoms based on the following questions:
- Cough (dry or wet)
- Sneezing
- Pain in the body
- Weakness
- Mucus
- Temperature
- Breathing difficulty
Based on the answers provided, the system gives feedback on whether the user should seek medical help.
If you'd like to contribute to the project:
- Fork the repository.
- Create a new branch:
git checkout -b feature-branch-name
. - Make your changes.
- Push the changes to your branch:
git push origin feature-branch-name
. - Submit a pull request.