Loading repository data…
dattaaaaa / repository
A Complete Web based Vaccination Database Management System with AI features built with Python(Flask) and MySQL
A transparent discovery signal based on current public GitHub metadata.
This score does not audit code, security, maintainers, documentation quality, or suitability. Verify the repository and its current documentation before adoption.
A comprehensive web-based vaccination management system built with Flask, allowing users to schedule vaccinations, manage profiles, and generate digital certificates. The system includes user, admin, and vaccine administrator roles with different privileges.
View the latest deployment of this flask web application here (Note: The site may take around 50 seconds to load.)
Install MySQL
Ensure MySQL is installed on your system. You can download it from MySQL's official website or use a package manager like apt (Linux) or brew (Mac).
Create a Database and User
Log into MySQL and create a database for the application. Also, create a dedicated user with the necessary privileges.
Enable SSL (If you are using an online instance of MySQL from providers like Aiven.io)
(Ignore this step if you are using a local MySQL database)
If using an online database or requiring encrypted connections, configure SSL and obtain the CA certificate.
[Convert]::ToBase64String((Get-Content -Path "ca.pem" -Raw -Encoding Byte)) | Set-Content -Path "ca_base64.txt"
[Convert]::ToBase64String((Get-Content -Path "client-cert.pem" -Raw -Encoding Byte)) | Set-Content -Path "cert_base64.txt"
[Convert]::ToBase64String((Get-Content -Path "client-key.pem" -Raw -Encoding Byte)) | Set-Content -Path "key_base64.txt"
Update .env Configuration
Add your MySQL connection details to the .env file, including the DATABASE_URL and SSL certificate (that can be done by).
Initialize the Database
Run migrations to set up the required tables and relationships.
Verify Connection
Ensure the Flask application connects successfully to the MySQL database before running the server.
git clone https://github.com/dattaaaa/vaxcare.git
cd vaxcare
python -m venv myenv
source myenv/bin/activate # On Windows: myenv\Scripts\activate
pip install -r requirements.txt
.env file in the project root with the following variables:DATABASE_URL=mysql://username:password@host:port/database_name
SECRET_KEY=your_secret_key
GROQ_API_KEY=your_groq_api_key
CA_PEM=your_ssl_certificate_in_base64
flask db upgrade
python app.py
gunicorn -c gunicorn_config.py app:app
vaxcare/
| .env
| .gitignore
| app.py
| Create_tables.sql
| Entity-Relationship(ER)-diagram.png
| guincorn_config.py
| LICENSE
| Populate_all.sql
| project_structure.txt
| README.md
| Relational_Schema.png
| requirements.txt
|
+---Documents
| Report.pdf
|
+---static
| android-chrome-192x192.png
| android-chrome-512x512.png
| apple-touch-icon.png
| favicon-16x16.png
| favicon-32x32.png
| favicon.ico
|
\---templates
| admin_dashboard.html
| base.html
| book_appointment.html
| certificates.html
| chat.html
| create_profile.html
| edit_centre.html
| edit_profile.html
| edit_schedule.html
| edit_vaccine.html
| home.html
| index.html
| login.html
| register.html
| reschedule_appointment.html
| temp.html
| user_dashboard.html
| vaccine_admin_dashboard.html
|
+---admin
| appointments_overview.html
| edit_inventory.html
| manage_centres.html
| manage_inventory.html
| manage_schedules.html
| manage_vaccines.html
|
\---errors
404.html
500.html
The application uses MySQL with SSL encryption. Make sure your database server supports SSL connections and provide the CA certificate in the .env file.
If you want an online MySQL database, login to Aiven Console to get your credentials and CA certificate.
You can as well remove the CA certificate part from the app if you are using a local MySQL database instance.
The application includes a gunicorn_config.py with the following settings:
The application provides several API endpoints for:
git checkout -b feature/AmazingFeature)git commit -m 'Add some AmazingFeature')git push origin feature/AmazingFeature)This project is licensed under the MIT License - see the LICENSE file for details.
Vishnu Datta - kvishnudatta.ai22@rvce.edu.in Project Link: https://github.com/dattaaaaa/vaxcare
Selected from shared topics, language and repository description—not editorial ratings.
MinLouisCyber /
About A Complete Web based Vaccination Database Management System with AI features built with Python(Flask) and MySQL
59/100 health