--liquibase formatted cypher

--changeset rshield:NR-2586_vendor_changes:1 runAlways:true runOnChange:true
UNWIND [
    {UUID: "4bc1e45d-a301-4a86-b61b-8de4e415ea32", accId: 781860},
    {UUID: "24f63532-31e8-4508-9d2e-4d9b15e2deb9", accId: 790289},
    {UUID: "8d02f78f-07f2-4013-a945-60bb5216001b", accId: 790292},
    {UUID: "5a114f31-b142-4b6c-8512-f6d8947a88e5", accId: 790417},
    {UUID: "5f0fa64a-bb26-4ac5-a1c6-3539b7b86430", accId: 790550},
    {UUID: "4a0346c9-aab7-4909-b96d-3e63a2285298", accId: 790612},
    {UUID: "60340653-246e-4722-b6bd-720d625c7f41", accId: 790613},
    {UUID: "da0e13fc-c533-4ddb-9943-72d7abbdf589", accId: 790665},
    {UUID: "a3252b06-66f2-4e15-a6ab-a2554eda9d19", accId: 790689},
    {UUID: "f81167c2-b081-43f2-9235-866831ac3273", accId: 790776},
    {UUID: "3ebb2556-cebc-469b-936a-9d718bf76593", accId: 790777},
    {UUID: "7c6e4121-4d9d-4db2-87e2-cd5be6369cb3", accId: 790778},
    {UUID: "9eef298a-b964-45f8-a0b8-88a9286dd8ed", accId: 790783},
    {UUID: "0a04be67-ac5b-48f2-9c70-ebb6214879b0", accId: 790919},
    {UUID: "579305dd-f3ca-408d-a8a5-79dd41bcbd3f", accId: 790979},
    {UUID: "7a247727-5490-40b3-8cf8-6c4d7d47be48", accId: 790994},
    {UUID: "ff9cbdbb-8572-4157-ad0f-c3bb4b3d41c8", accId: 790995},
    {UUID: "3f45a02d-339e-484c-9190-3b4a521ba413", accId: 791127},
    {UUID: "d9ff691e-bc81-48c6-be7b-c6ae98767239", accId: 791193},
    {UUID: "39d61641-70a5-4e1f-ae06-a126c148e950", accId: 791168},
    {UUID: "699aa623-b2b1-475c-a38b-d8ec937ba1c4", accId: 791198}
] AS update
MATCH(c:NrContributor:NrPerformance {id: update.UUID})<-[r:HAS_NR_CONTRIBUTOR]-(v:Vendor)
MATCH(newVendor: Vendor {vendorId: update.accId})
DELETE r 
WITH c, newVendor
MERGE (newVendor)-[rr:HAS_NR_CONTRIBUTOR]->(c)
ON CREATE SET
    rr.createdAt = datetime(),
    rr.lastModifiedAt = datetime(),
    rr.lastModifiedBy = 'NR-2586_vendor_changes'
ON MATCH SET
    rr.lastModifiedAt = datetime(),
    rr.lastModifiedBy = 'NR-2586_vendor_changes'
RETURN rr