--liquibase formatted cypher

--changeset gmaroulis:NR-3068_update_vendor_for_tracks:1 runOnChange: true
UNWIND [
  "NL33X1400005",
  "NL33X1400006",
  "NL33X1400004",
  "NL33X1400001"
] as isrc
MATCH (sr:NrSoundRecording:NrOwnership {isrc: isrc})-[r:HAS_OWNERSHIP_RULE_MONETIZE|HAS_OWNERSHIP_RULE_CARVEOUT]-(s)
  WHERE r.vendorId = 68189
DELETE r

WITH sr, isrc
MATCH (t:NrTrack:NrOwnership {submittedByVendorId: 68250})-[:IS_PLACEMENT_OF]->(s:NrSoundRecording:NrOwnership {isrc: isrc})
SET t.reference = true

WITH sr, isrc
MATCH (t:NrTrack:NrOwnership {submittedByVendorId: 68189})-[:IS_PLACEMENT_OF]->(s:NrSoundRecording:NrOwnership {isrc: isrc})
DETACH DELETE t;

--changeset gmaroulis:NR-3068_update_vendor_for_tracks::2 runOnChange: true
UNWIND [
  "NL1281300030",
  "NL33X1400013",
  "NL33X1400007",
  "NL33X1400008",
  "NL33X1400003",
  "NL33X1400009",
  "NL33X1400012",
  "NL33X1400010",
  "NL33X1400011",
  "NL33X1400002"
] as isrcSecondBatch
MATCH (sr2:NrSoundRecording:NrOwnership {isrc: isrcSecondBatch})-[r:HAS_OWNERSHIP_RULE_MONETIZE|HAS_OWNERSHIP_RULE_CARVEOUT]-(s)
SET r.vendorId=68250

WITH sr2, isrcSecondBatch
MATCH (t2:NrTrack:NrOwnership {submittedByVendorId: 68250})-[:IS_PLACEMENT_OF]->(s:NrSoundRecording:NrOwnership {isrc: isrcSecondBatch})
SET t2.reference = true

WITH isrcSecondBatch
MATCH (t3:NrTrack:NrOwnership {submittedByVendorId: 68189})-[:IS_PLACEMENT_OF]->(s:NrSoundRecording:NrOwnership {isrc: isrcSecondBatch})
DETACH DELETE t3;