OpenAtlas

• We have to do one super event at a time
• The super event must have sub events
• The super event is connected to an (moved) artifact which is connected to a source
• The sub events are connected to an (moved) artifact

In practice we can just try it out. Because code submitted in the backend SQL interface is in a transaction it will do everything (if it works ok) or nothing.

INSERT INTO model.link (domain_id, property_code, range_id)
SELECT domain.range_id, 'P67', range.range_id FROM

(SELECT event_artifact.range_id
FROM model.link sub_super
JOIN model.link event_artifact
  ON sub_super.domain_id = event_artifact.domain_id
  AND event_artifact.property_code = 'P25'
  AND sub_super.property_code = 'P117'
WHERE sub_super.range_id = xxx) domain
,
(SELECT artifact_source.range_id
FROM model.link artifact_source
JOIN model.link event_artifact 
    ON artifact_source.domain_id = event_artifact.range_id
    AND event_artifact.property_code = 'P25'
    AND artifact_source.property_code = 'P128'    
WHERE event_artifact.domain_id = xxx) range;

DELETE FROM model.link WHERE property_code = 'P117' AND range_id = xxx;

After showing how it works in today's meeting with decided:

• We will run the script on the test server so that we can take a look at the changes without risking unwanted changes in the productive system
• In cases where transformation isn't possible the "is sub event of" link will be kept and a list of them will be sent to check them
• Once we are satisfied with the result we can run the script on the productive data

I wrote a script which transforms super events where possible but leaves the one that couldn't be transformed.
The transformed database was uploaded to the test server and a list of the problematic ones (233 of 627) was sent to the CONNEC team.

Becca looked into the provided test instance and the script seems to work out ok.
But because of problems with different PostgreSQL server versions we decided to wait for the server move before running the script on the productive data.

Closing this issue because script was already executed for CONNEC data on new server.