EPIC: As a project manager I want to enhance the ODH Mobility core so to efficiently integrate traffic events

[rcavaliere]

Deadline: 28 February 2022

@bertolla (with support by @Piiit for the DB modeling)

• Design DB model
• Create DB model
• Writer API enhancement

@Piiit

• Fix the writer to use Postgres rangetypes and not bytea for intervals
• include a provenance into events
• Modernize the writer code to use spring boot and .env files
  • writer
  • dto
  • dal (merge into writer)
  • dc-interface
  • remove: ws-interface
  • remove: tools
  • remove: api v1
• Fix the log4j shell vulnerability
• Decide if we want to use timezones @rcavaliere

  We use timezones, but we should do that in all time related fields... this is another user story Introduce time zones in all time related columns #213 for the future therefore

• Use half-open intervals for events
• Introduce flyway and schema migrations
• improve local development with docker, that is, start a local postgres and fill it with the initial schema from the migrations
• fix measurementjsonhistory duplicates and unique constraint
  • clean testing DB
  • clean production DB
• Should we use category,name and not only uuid as unique compound key

  We decided to create some new unique constraints for this... the exact design must still be done

• Ninja API enhancement

[rcavaliere]

Basic concept of DB structure:

“events”

• Id
• categoy
• subcategory
• created_on
• descripton

events_metadata”

• id
• json

“events_interval”

• id
• data_inizio
• data_fine
• description

“events_geometry”

• id
• location (geometry)
• description

[bertolla]

For the location I propose to use geojson in the dto, to have a valid geometry that can accommodate everything

[rcavaliere]

@bertolla ok, does this have an impact on the DB table structure above?

[bertolla]

I deployed the writer with the changes on the testserver.
The version of the dc-interface to use is 5.3.0-SNAPSHOT
The new added call is addEvents(List<EventDto>). Maybe Davide could already test it out in the test environment
It's important to change the repository release to http://it.bz.opendatahub.s3-website-eu-west-1.amazonaws.com/snapshot to be able to use snapshot releases

[Piiit]

@rcavaliere I move this to TODO, because it is a prerequisite of noi-techpark/bdp-commons#263

[Piiit]

@rcavaliere Done, please test... https://mobility.api.opendatahub.testingmachine.eu

The README has some minimal examples too --> https://github.com/noi-techpark/it.bz.opendatahub.api.mobility-ninja#events