--liquibase formatted cypher
--changeset dsalazar:1
MATCH (v:Vendor {id: "*"})
MATCH (i:Identity)
WHERE i.id = '4dac5780-6cdd-451a-877f-90285270b6a0'
MERGE (increment:IncrementId {nodeName: 'Profile'})
    ON CREATE SET increment.id = 2
    ON MATCH SET increment.id = increment.id + 1
CREATE (p:Profile {
    profileId: (increment.id-1),
    profileType: 'AbacusProfile',
    profileName: i.name,
    uuid: apoc.create.uuid(),
    roles: ['administrator'],
    fullCatalogAccess: true,
    brand: 'orchard',
    createdAt: datetime(),
    lastModifiedAt: datetime(),
    createdBy: 'database/ACC-8656-grant-access-fran-fajardo-abacus-prod-qa/bf0bd455-0b22-4b77-9d22-6ace73c13a7a:1',
    lastModifiedBy: 'database/ACC-8656-grant-access-fran-fajardo-abacus-prod-qa/bf0bd455-0b22-4b77-9d22-6ace73c13a7a:1'
})
MERGE (i)-[:HAS_PROFILE]->(p)
MERGE (p)-[:HAS_ACCESS_TO]->(v)
RETURN i,p;