HEADERS = [
    "OA User Id",
    "First Name",
    "Last Name",
    "Owner",
    "Active",
    "Email",
    "Group",
    "Existing ABACUS Access",
]

CYPHER_QUERY = """
MATCH (i:Identity {email: $email})
MATCH (v:Vendor { id: '*' })
MATCH (inc:IncrementId {nodeName: 'Profile'})
CALL apoc.atomic.add(inc, 'id', 1, 3) YIELD newValue AS increment
WITH i, v, increment
MERGE (i)-[:HAS_PROFILE]->(p:Profile {profileType: 'Account360Profile'})
ON CREATE SET 
    p.profileId = increment,
    p.profileName = 'Account360Profile',
    p.roles = ['account360'],
    p.uuid = randomUUID(),
    p.createdAt = datetime(),
    p.createdBy = 'lambda/attachA360Profile',
    p.lastModifiedAt = datetime(),
    p.lastModifiedBy = 'lambda/attachA360Profile',
    p.fullCatalogAccess = true
MERGE (p)-[r:HAS_ACCESS_TO]->(v)
SET
    r.createdBy = 'lambda/attachA360Profile',
    r.lastModifiedBy = 'lambda/attachA360Profile',
    r.lastModifiedAt = datetime(),
    r.createdAt = datetime()
RETURN i.id AS identityId
"""

PARENT_COMPANIES = [
    {"name": "theorchard", "uuid": "955a1bbd-b623-4ea1-ab5f-8d6620c442fb"},
    {"name": "sme", "uuid": "f1594122-7f99-4916-b103-08b0444c7b46"},
]