This project is a simple Flask application for managing employee data using SQLite as the database.
-
Clone the repository:
git clone https://github.com/kill3rstabs/EmployeeManagementSystem.git
-
Install dependencies:
pip install -r requirements.txt
-
Create the SQLite database:
python schema.py
flask run
Visit http://127.0.0.1:5000/ in your web browser to access the application.
- Endpoint: /
- Method: GET
- Endpoint: /retention_rate/<start_date>/<end_date>
- Method: GET
- Example: /retention_rate/2022-01-01/2023-01-01
- Endpoint: /filter_by_salary_range/int:min_salary/int:max_salary
- Method: GET
- Example: /filter_by_salary_range/50000/80000
- Endpoint: /top_earners/int:n
- Method: GET
- Example: /top_earners/5
- Endpoint: /filter_by_experience/int:min_experience/int:max_experience
- Method: GET
- Example: /filter_by_experience/1/3
- Endpoint: /average_salary_by_position
- Method: GET