--liquibase formatted cypher

--changeset gmaroulis:NR-3071_remove_isrcs_for_awal:1 runOnChange: true
UNWIND [
  "USN2F2300114",
  "USN2F2300094",
  "USN2F2300051",
  "USN2F2300057",
  "USN2F2300111",
  "USN2F2300113",
  "USN2F2300110"
] as isrc
MATCH (sr:NrSoundRecording:NrOwnership {isrc: isrc})-[r:HAS_OWNERSHIP_RULE_MONETIZE|HAS_OWNERSHIP_RULE_CARVEOUT]-(s)
WHERE r.vendorId = 38631
SET r.vendorId = 67215;

--changeset gmaroulis:NR-3071_remove_isrcs_for_awal:2 runOnChange: true
UNWIND [
  "USN2F2300114",
  "USN2F2300094",
  "USN2F2300051",
  "USN2F2300057",
  "USN2F2300111",
  "USN2F2300113",
  "USN2F2300110"
] as isrc
MATCH (t:NrTrack:NrOwnership {submittedByVendorId: 67215})-[:IS_PLACEMENT_OF]->(s:NrSoundRecording:NrOwnership {isrc: isrc})
WITH t LIMIT 1
SET t.reference = true;

--changeset gmaroulis:NR-3071_remove_isrcs_for_awal:3 runOnChange: true
UNWIND [
  "USN2F2300114",
  "USN2F2300094",
  "USN2F2300051",
  "USN2F2300057",
  "USN2F2300111",
  "USN2F2300113",
  "USN2F2300110"
] as isrc
MATCH (t:NrTrack:NrOwnership {submittedByVendorId: 38631})-[:IS_PLACEMENT_OF]->(s:NrSoundRecording:NrOwnership {isrc: isrc})
DETACH DELETE t;