--liquibase formatted cypher

--changeset mstead:1 runOnChange:true
MATCH (v:Vendor {id: "*"})
MATCH (i:Identity)
WHERE i.id = '68670549-6927-46be-82a0-52580a65909e'
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-9073_create_abacus_readonly_profile/e904d95b-9955-4011-8ec2-32dcf7543f8a:1',
    lastModifiedBy: 'database/ACC-9073_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 = '2ccffd8c-a338-49a3-9a6b-a58296643f6f'
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-9073_create_abacus_readonly_profile/e904d95b-9955-4011-8ec2-32dcf7543f8a:1',
    lastModifiedBy: 'database/ACC-9073_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:3 runOnChange:true
MATCH (v:Vendor {id: "*"})
MATCH (i:Identity)
WHERE i.id = '51b3c053-4df4-41b9-ba28-22f63e599710'
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-9073_create_abacus_readonly_profile/e904d95b-9955-4011-8ec2-32dcf7543f8a:1',
    lastModifiedBy: 'database/ACC-9073_create_abacus_readonly_profile/e904d95b-9955-4011-8ec2-32dcf7543f8a:1'
})
MERGE (i)-[:HAS_PROFILE]->(p)
MERGE (p)-[:HAS_ACCESS_TO]->(v)
RETURN i,p;