TrainingExerciseTracking

The description of the coding challenge can be found here.

Setup

Setting up MSSQL with docker:

docker pull mcr.microsoft.com/mssql/server:2022-latest
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=Sml123456789" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-latest

The database migration will be applied automatically when the application starts.

Architecture

TypeDependency Diagram

Database EER Diagram

API

The api launches on port 5000 and has 2 POST endpoints:

• /movements
  example request body:

  {
    "longitude": 7.321437243553244,
    "latitude": 44.61757413013524,
    "participantNumber": 1337
  }

• /participants
  example request body:

  {
    "number": 1337,
    "rank": "Normal",
    "country": "USA",
    "information": "This is a normal participant."
  }

These endpoints can be used to inject data.