Transect Section History

As an Admin or Project lead, I want to be able to see the history of assigned sections to transects.

Jira ticket: https://ufz-jira.scolution.de/browse/MWB-278

Data model: https://confluence.digitalearth-hgf.de/pages/viewpage.action?pageId=16716827

AC

• Entity TransectSectionHistory is created
• Relation TransectSectionHistory - Transect (many to one) and TransectSectionHistory - Section are created (many to one)
• Event listener is created, to fire event on section and transect (create and update). Event handler checks if there is Transect - section assignment and creates a record in TransectSection table accordingly:
  • Active assignments of sections to transect have allocated_end set to null. When new assignment happens, active assignments are closed and new ones are inserted
• Creation of TransectSectionHistory is possible only through event handler. No manual creation is possible via GraphQl
• Admin and project lead can read TransectSectionHistory
• Tests

Review

• Entity TransectSectionHistory is created
• Relation TransectSectionHistory - Transect (many to one) and TransectSectionHistory - Section are created (many to one)
• Event listener is created, to fire event on section and transect (create and update). Event handler checks if there is Transect - section assignment and creates a record in TransectSection table accordingly:
  • Active assignments of sections to transect have allocated_end set to null. When new assignment happens, active assignments are closed and new ones are inserted
• Creation of TransectSectionHistory is possible only through event handler. No manual creation is possible via GraphQl
• Admin and project lead can read TransectSectionHistory
• Tests