Get properties of node using java embedded cypher query

Question

currently have a cypher query method

public static void RunQuery(String _query)
{
    Properties prop = new Properties();
    final String DB_PATH = "path/to/db"
    GraphDatabaseService graphDb = new GraphDatabaseFactory().newEmbeddedDatabase(DB_PATH);
    ExecutionEngine engine = new ExecutionEngine(graphDb);
    ExecutionResult result = engine.execute(_query);
    for(Map<String,Object> map : result)
    {
        System.out.println(map.toString());
    }
    graphDb.shutdown();


}

However this only allows me to get results like this:

{a=Node[11303]}
{a=Node[11341]}
{a=Node[11343]}
{a=Node[11347]}
{a=Node[11349]}
{a=Node[11378]}

How can I augment it to spit out the entire query results like the cypher shell does?

Nicholas · Accepted Answer · 2013-07-02 14:47:33Z

3

What does your query look like. The Map<String, Object> that is returned will have a key of the variable you return. The Object can be a Path, Node, or Relationship, and this will just call the native toString() on them, which in Java code just returns the Node ID. You have to build your own printer, something that will get the property keys and iterate through each of them.

for (String key : node.getPropertyKeys()) {
    System.out.println("Key: " + key + ", Value: " +  node.getProperty(key));
}

edited Jul 2, 2013 at 14:47

answered Jul 1, 2013 at 20:13

Nicholas

7,53111 gold badges51 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Badmiral Over a year ago

yes, I am looking for if the object is a node for it to print out the properties and values and if it is a value (such as a count) for it not to. Essentially I want to recreate the console in the web interface or the neo4j-shell.

Nicholas Over a year ago

It's up to you to print out the properties, I don't believe Neo4j provides any convenience method for doing this, but you can do it in Java, I have modified my answer to include code for doing this.

Badmiral Over a year ago

Thanks Nicholas! In your code, what is r and what is relationshipDto?

Nicholas Over a year ago

I have updated to code to make the object more have verbose names

Mohamed Ismail Mansour · Accepted Answer · 2013-07-01 20:43:19Z

-1

It depends on the RETURN of your query..

For example, if you have a query like this:

_query="Start x= node(someIndex) Match x-[rel:SOMETHING]-n Return n";

So, your code can be

    ExecutionResult result = engine.execute(_query);
    Iterator<Node> n_column = result.columnAs("n");
            for (Node outputNode: IteratorUtil.asIterable(n_column)) {
                System.out.println(outputNode.getProperty("yourKey","defaultValueIfNull"));
            }

answered Jul 1, 2013 at 20:43

Mohamed Ismail Mansour

1,05111 silver badges22 bronze badges

1 Comment

Badmiral Over a year ago

this assumes that you know apriori that n is being returned. I just want to return the string results of the query in order to replicate the neo4j-shell

Collectives™ on Stack Overflow

Get properties of node using java embedded cypher query

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related