"""Neo4j cypher queries."""

FULL_RESET = """
MATCH (e:Employee),(ug:UserGroup),(af:AppFamily)
DETACH DELETE e,ug,af;"""

EMPLOYEE_NODE = """(:Employee:{role} {{username: "{username}", name: "{name}", company: "{company}"}})"""  # noqa:E501
APP_FAMILY_NODE = """(:AppFamily {{name: "{name}"}})"""
GROUP_NODE = """(:UserGroup {{name: "{name}"}})"""

CONNECT_MANAGERS = """
MATCH (e1:Employee), (e2:Employee)
WHERE e1.username = "{employee_username}"
AND e2.name = "{manager_name}"
MERGE (e1)<-[:MANAGES]-(e2);"""

CONNECT_GROUP_TO_FAMILY = """
MATCH (af:AppFamily), (ug:UserGroup)
WHERE af.name = "{app_family_name}"
AND ug.name = "{group_name}"
MERGE (ug)-[:HAS_ACCESS_TO]->(af);
"""

CONNECT_GROUP_TO_EMPLOYEE = """
MATCH (e:Employee), (ug:UserGroup)
WHERE e.username = "{username}"
AND ug.name = "{group_name}"
MERGE (e)-[:MEMBER_OF]->(ug);
"""