--liquibase formatted cypher
--changeset gmaroulis:NR-2684_update_ownership_rule_end_date:1 runAlways:true runOnChange:true
MATCH (sr:NrSoundRecording:NrOwnership {id:"62ac9e49-1b41-40e8-92a1-0d9aa38211ac"})
WITH sr as soundRecording1

MATCH (sr:NrSoundRecording:NrOwnership {id:"f2969c4b-9d8f-4300-8acf-ab4fe6c07560"})
WITH sr as soundRecording2, soundRecording1

MATCH (service:NrOwnershipService)
WHERE service.territory in [
  "AT", "BE", "BG", "CH", "CY", "CZ", "DE", "DK", "EE", "ES", "FI", "FR", "GB", "GR", "HR", "HU", "IE", "IT", "LT", "LU", "LV", "MT", "NL", "NO", "PL", "PT", "RO", "SE", "SI", "SK"
]
WITH service as services, soundRecording1, soundRecording2

UNWIND services as service
MERGE(soundRecording1)-[r1:HAS_OWNERSHIP_RULE_CARVEOUT]->(service)
ON MATCH SET
  r1.lastModifiedAt = datetime(),
  r1.startDate = date('2019-05-19'),
  r1.lastModifiedBy = "NR-2684/createCarveoutRules/db-pr"
ON CREATE SET
  r1.id = apoc.create.uuid(),
  r1.createdAt = datetime(),
  r1.createdBy = "NR-2684/createCarveoutRules/db-pr",
  r1.lastModifiedAt = datetime(),
  r1.startDate = date('2019-05-19'),
  r1.lastModifiedBy = "NR-2684/createCarveoutRules/db-pr"
WITH service, soundRecording2

MERGE(soundRecording2)-[r2:HAS_OWNERSHIP_RULE_CARVEOUT]->(service)
ON MATCH SET
  r2.lastModifiedAt = datetime(),
  r2.startDate = date('2019-05-19'),
  r2.lastModifiedBy = "NR-2684/createCarveoutRules/db-pr"
ON CREATE SET
  r2.id = apoc.create.uuid(),
  r2.createdAt = datetime(),
  r2.createdBy = "NR-2684/createCarveoutRules/db-pr",
  r2.lastModifiedAt = datetime(),
  r2.startDate = date('2019-05-19'),
  r2.lastModifiedBy = "NR-2684/createCarveoutRules/db-pr"