--liquibase formatted cypher

--changeset jmarais:udpate_user_access:1 runAlways:true

MATCH (p:Profile)-[oldRel:HAS_ACCESS_TO]->(v:Vendor { id: 26664 })
WHERE p.uuid in [
    "08d35c14-73c3-4705-a011-e17006d34f7c",
    "850cea4c-6d6d-47a4-a002-12e08c0181cf",
    "4630152c-727a-4a88-99c3-06fddfde66af",
    "d954af34-4b9d-4550-bb61-ed155ad7bf11",
    "a41accaa-7415-4de1-9539-1c95cb5e6a60",
    "57ae4892-6eef-4f4d-9bd3-36fcf2b16860",
    "92896f45-782f-4ecb-94ba-96c1ba9bb7c3"
]
DELETE oldRel

WITH p, oldRel

MATCH (newV:Vendor { id: 792949 })
MERGE (p)-[newRel:HAS_ACCESS_TO]->(newV)
SET
    newRel.lastModifiedAt = datetime(),
    newRel.lastModifiedBy = 'database/PUB-1593_update_user_access'
RETURN p