--liquibase formatted cypher

--changeset anavalu:ACC-9505-create_abacus_profile runOnChange:true

MERGE (increment:IncrementId {nodeName: 'Profile'})
    ON CREATE SET increment.id = 2
    ON MATCH SET increment.id = increment.id + 1
CREATE (profile:Profile {
    profileId: (increment.id-1),
    profileType: 'AbacusProfile',
    profileName: 'Briana Garcia',
    uuid: apoc.create.uuid(),
    roles: ['administrator'],
    fullCatalogAccess: true,
    brand: 'orchard',
    createdAt: datetime(),
    lastModifiedAt: datetime(),
    createdBy: 'database/ACC-9505-create_abacus_profile/id: e7c2f7bd-e22d-4151-959f-a65767ccc473:1',
    lastModifiedBy: 'database/ACC-9505-create_abacus_profile/id: e7c2f7bd-e22d-4151-959f-a65767ccc473:1'
})
WITH profile
MATCH (v:Vendor { id: '*' })
MERGE (profile)-[:HAS_ACCESS_TO]->(v)
WITH profile
CREATE (identity:Identity {
    email: 'briana.garcia@theorchard.com',
    id: apoc.create.uuid(),
    firstName: 'Briana',
    lastName: 'Garcia',
    name: 'Briana Garcia',
    active: 'Y',
    createdAt: datetime(),
    defaultBrand: 'orchard',
    localization: 'en',
    numberFormat: 'us',
    userTypes: ['label']
})
CREATE (identity)-[:HAS_PROFILE]->(profile)
RETURN identity,profile;