Missing cleanup when creating random templates

[chevalleyc]

Configuration information

"ehrbase_version": "0.19.0-SNAPSHOT",
"openehr_sdk_version": "1.7.0-SNAPSHOT",
"archie_version": "1.0.4",
"jvm_version": "Oracle Corporation 11.0.13+10-LTS-370",
"os_version": "Linux amd64 5.4.0-91-generic",
"postgres_version": "PostgreSQL 12.9 (Ubuntu 12.9-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit"

Steps to reproduce

Integration test DefaultRestTemplateEndpointIT creates several templates with random version ids which causes issues with other tests when run locally (AqlTestIT). In particular, translated SQL is bloated with unnecessary UNIONs. One of the side effect is that checked cardinality of results doesn't match since UNION is present causing duplicated values to be eliminated (similarly to an explicit DISTINCT).

Actual result

The created templates remain in the DB after running the tests

Expected result (Acceptance Criteria)

The created templates are deleted from the DB

Definition of Done

• The defect is checked by an unit or an integration test (Robot)
• Merge Request approved
• Unit tests passed
• Build without errors
• Release notes prepared
• No additional runtime warnings