--liquibase formatted cypher
--changeset mcesonis:PLATFORM-4951_create_oa_profile_for_mcesonis.cypher
--comment: Give OA profile to user martynas.cesonis.ext@sonymusic-pde.com (already set up in AR)

MATCH (i:Identity {id: "8762838c-73f6-4e77-b8d8-0d57a3c8fb8a"})
MERGE (i)-[r:HAS_PROFILE]->(p:Profile {profileType: 'OrchAdminProfile'})
ON CREATE SET
    r.createdAt=datetime(),
    r.lastModifiedAt=datetime(),
    r.createdBy='database/PLATFORM-4951',
    r.lastModifiedBy='database/PLATFORM-4951',
    p.profileId=4003,
    p.profileName=i.name,
    p.uuid=randomUUID(),
    p.roles=['admin'],
    p.fullCatalogAccess=true,
    p.createdAt=datetime(),
    p.lastModifiedAt=datetime(),
    p.createdBy='database/PLATFORM-4951',
    p.lastModifiedBy='database/PLATFORM-4951'
WITH p
MATCH (v:Vendor {id: '*'})
MERGE (p)-[r2:HAS_ACCESS_TO]->(v)
ON CREATE SET
    r2.createdAt=datetime(),
    r2.lastModifiedAt=datetime(),
    r2.createdBy='database/PLATFORM-4951',
    r2.lastModifiedBy='database/PLATFORM-4951';

--rollback MATCH (i:Identity {id: "8762838c-73f6-4e77-b8d8-0d57a3c8fb8a"})-[r:HAS_PROFILE]->(p:Profile {profileType: 'OrchAdminProfile'}) DETACH DELETE p;