--liquibase formatted cypher

--changeset mstead:1 runOnChange:true
MATCH (v:Vendor {id: "*"})
MATCH (i:Identity)
WHERE i.id = 'a3016c1e-4e2f-4773-854e-9233c7fb63f1'
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: 'Account360Profile',
    profileName: i.name,
    uuid: apoc.create.uuid(),
    roles: ['account360'],
    fullCatalogAccess: true,
    createdAt: datetime(),
    lastModifiedAt: datetime(),
    createdBy: 'database/ACC-9108_create_abacus_readonly_profile/e904d95b-9955-4011-8ec2-32dcf7543f8a:1',
    lastModifiedBy: 'database/ACC-9108_create_abacus_readonly_profile/e904d95b-9955-4011-8ec2-32dcf7543f8a:1'
})
MERGE (i)-[:HAS_PROFILE]->(p)
MERGE (p)-[:HAS_ACCESS_TO]->(v)
RETURN i,p;

--changeset mstead:2 runOnChange:true
MATCH (v:Vendor {id: "*"})
MATCH (i:Identity)
WHERE i.id = '0e557cd3-1356-426e-9636-5bec0ffbfad6'
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: 'Account360Profile',
    profileName: i.name,
    uuid: apoc.create.uuid(),
    roles: ['account360'],
    fullCatalogAccess: true,
    createdAt: datetime(),
    lastModifiedAt: datetime(),
    createdBy: 'database/ACC-9108_create_abacus_readonly_profile/e904d95b-9955-4011-8ec2-32dcf7543f8a:1',
    lastModifiedBy: 'database/ACC-9108_create_abacus_readonly_profile/e904d95b-9955-4011-8ec2-32dcf7543f8a:1'
})
MERGE (i)-[:HAS_PROFILE]->(p)
MERGE (p)-[:HAS_ACCESS_TO]->(v)
RETURN i,p;