Some Neo4j queries

query.sql

-- Create a simple node
MERGE (actor:test_article { aid:"112"})
ON CREATE SET actor.created = timestamp(), actor.api = "api", actor.type = "test_article"


-- Create activities

MERGE (actor:test_user { aid:"110"})
ON CREATE SET actor.created = timestamp(), actor.api = "api", actor.type = "test_user"
ON MATCH SET actor.updated = timestamp()
WITH actor
MERGE (object:test_comment { aid:"111"})
ON CREATE SET object.created = timestamp(), object.api = "api", object.type = "test_comment"
ON MATCH SET object.updated = timestamp()
WITH object, actor
MERGE (actor)-[verb:WROTE]->(object)
ON CREATE SET verb.created = timestamp()
ON CREATE SET verb.target = "112"
ON MATCH SET verb.updated = timestamp()
RETURN actor, verb, object;

-- Select an activity with his target

MATCH (u:test_user)-[r:WROTE]->(c:test_comment)
OPTIONAL MATCH (p:test_article)
where (has (r.target) and p.aid=r.target)
RETURN u, r, c, p;