saved_querys

Per database:
maak user aan:
CREATE OR REPLACE USER neo4jPython SET PASSWORD "python" SET PASSWORD CHANGE NOT REQUIRED
geef user admin privileges:
GRANT ROLE admin to neo4jPython

delete all:
MATCH (n)
DETACH DELETE n

delete all (2):
CALL apoc.periodic.iterate('MATCH (n) RETURN n', 'DETACH DELETE n', {batchSize:1000})

show all
Match (n)-[r]->(m)
Return n,r,m

RETURN apoc.version() AS output;

dump
cd bin
neo4j-admin.bat dump --database=neo4j --to=C:/resources/dumps/neo4j/neo4j-20220419.dump
load
bin/neo4j-admin load --from=/dumps/neo4j/neo4j-<timestamp>.dump --database=neo4j --force

drop and create constraints
DROP constraint ON (n:Asset) ASSERT n.uuid is UNIQUE
CREATE CONSTRAINT Asset_uuid IF NOT EXISTS FOR (n:Asset) REQUIRE n.uuid IS UNIQUE
CREATE CONSTRAINT Agent_uuid IF NOT EXISTS FOR (n:Agent) REQUIRE n.uuid IS UNIQUE


MATCH (a:Asset)-[:HoortBij]->(l) WHERE a.eanNummer IS NOT NULL AND not a.typeURI CONTAINS 'lgc'
RETURN a.eanNummer as EAN, l.uuid as uuid, 'otl' as cat UNION ALL
MATCH (a:Asset) WHERE a.eanNummer IS NOT NULL AND a.typeURI CONTAINS 'lgc'
return a.eanNummer as EAN, a.uuid as uuid, 'lgc' as cat