--liquibase formatted cypher

--changeset mmoy:1

MATCH (i:Identity {id: 'e1729add-2b45-4ad2-98f0-508a3525a41f'})
WITH i
MATCH (i)-[:HAS_PROFILE]->(p:Profile {profileType: 'MoneyhubProfile'})-[r:DELETED_HAS_ACCESS_TO]->(v:Vendor {id: "*"})
SET r.updatedBy = "database/PLATFORM-4454", r.updatedAt = datetime()
WITH i, r
CALL apoc.refactor.setType(r, "HAS_ACCESS_TO")
YIELD input, output
WITH i
MATCH (i)-[:HAS_PROFILE]->(p:Profile {profileType: 'OrchAdminProfile'})-[r2:DELETED_HAS_ACCESS_TO]->(v:Vendor {id: "*"})
SET r2.updatedBy = "database/PLATFORM-4454", r2.updatedAt = datetime()
WITH i, r2
CALL apoc.refactor.setType(r2, "HAS_ACCESS_TO")
YIELD input, output
MATCH (i)-[:HAS_PROFILE]->(p:Profile {profileType: 'SettingsProfile'})-[r3:DELETED_HAS_ACCESS_TO]->(v:Vendor {id: "*"})
WITH r3
DELETE r3;