Coding task for Elisa Data Engineer position.
Testing instructions:
- Set up containers
docker compose up
- Open following url with browser
http://0.0.0.0:8000/docs
- Updload test data to database
curl -X 'POST' \
'http://0.0.0.0:8000/upload/' \
-H 'accept: application/json' \
-H 'Content-Type: multipart/form-data' \
-F 'file=@data.json;type=application/json'
- Top 5 most utilized devices (on average) on a date
curl -X 'GET' \
'http://0.0.0.0:8000/devices' \
-H 'accept: application/json'
- Hourly rolling average of device utilization of a device between dates
curl -X 'GET' \
'http://0.0.0.0:8000/average/?id=6D3A2286' \
-H 'accept: application/json'
- Shut down containers
docker compose down