"""Queries for fetching network participant nodes."""

search_network_participant = """
CALL db.index.fulltext.queryNodes("networkParticipantNames", $wildcard_query)
YIELD node, score
WHERE node.networkId = $network_id
RETURN node
"""

create_network_participant = """
MERGE (i:IncrementId {nodeName: 'NetworkParticipant'})
    ON CREATE SET i.id = 1
    ON MATCH SET i.id = i.id + 1
CREATE (np:NetworkParticipant {
    id: i.id,
    name: $name,
    networkId: $network_id,
    createdAt: datetime(),
    modifiedAt: datetime()
})
RETURN np as node
"""

update_network_participant = """
MATCH (np:NetworkParticipant {
    id: $id,
    networkId: $network_id
})
SET
    np += $update_params,
    np.modifiedAt = datetime()
RETURN np as node
"""

get_network_participant_by_id = """
MATCH (np:NetworkParticipant)
    WHERE np.id = $id
RETURN np as node
LIMIT 1
"""