--liquibase formatted cypher
--changeset dsalazar:1

MATCH (v:Vendor {id: "*"})
MATCH (i:Identity)
WHERE i.id = 'db2a0daf-f00d-4d2c-8c2f-45672c265536'
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-8655-grant-access-adrian-delarosa-sony-abacus-prod-qa/bf0bd455-0b22-4b77-9d22-6ace73c13a7a:1',
    lastModifiedBy: 'database/ACC-8655-grant-access-adrian-delarosa-sony-abacus-prod-qa/bf0bd455-0b22-4b77-9d22-6ace73c13a7a:1'
})
MERGE (i)-[:HAS_PROFILE]->(p)
MERGE (p)-[:HAS_ACCESS_TO]->(v)
RETURN i,p;