I have a database like in this question:
Neo4j - Finding the Shortest Path between two nodes based on relationship property
CREATE (some_point_1:Point {title:'Some Point 1'})
CREATE (some_point_2:Point {title:'Some Point 2'})
CREATE (some_point_3:Point {title:'Some Point 3'})
CREATE (some_point_4:Point {title:'Some Point 4'})
CREATE (some_point_5:Point {title:'Some Point 5'})
CREATE (some_point_6:Point {title:'Some Point 6'})
CREATE (some_point_1)-[:distance {value:100}]->(some_point_2)
CREATE (some_point_2)-[:distance {value:150}]->(some_point_4)
CREATE (some_point_1)-[:distance {value:200}]->(some_point_3)
CREATE (some_point_3)-[:distance {value:300}]->(some_point_4)
CREATE (some_point_2)-[:distance {value:500}]->(some_point_5)
CREATE (some_point_4)-[:distance {value:300}]->(some_point_5)
CREATE (some_point_5)-[:distance {value:300}]->(some_point_6)
CREATE (some_point_6)-[:distance {value:300}]->(some_point_1)
Now I'm trying to execute a query like this: (from a Rails app)
MATCH (start:Point {title: 'Some Point 1'}), (end:Point {title: 'Some Point 5'})
MATCH p=(start)-[:distance*]->(end)
WITH p,reduce(s = 0, r IN rels(p) | s + r.value) AS dist
RETURN p, dist ORDER BY dist DESC
I'm trying to do a similar query with the active model wrapper, but it's not working :(
Is there a way to execute a pure Cypher query from neo4jrb or neo4j-core?
Yes, you can easily do Cypher directly if you want via the neo4j-core gem (which you need anyways when using the neo4j gem).
For example: n = Neo4j::Session.query("MATCH (n) RETURN n").first (assuming you have configured you application to communicate with the Neo4j server).
If you are using the neo4j gem you need to have the corresponding ActiveNode (and possibly ActiveRel) models in your application so that you can do your queries. This gem is pretty much a nice wrapper of the standard ActiveModel for Neo4j :)
You have more information on how to: https://github.com/neo4jrb/neo4j-core/wiki/Queries
You can also move from a QueryProxy chain to a Neo4j::Core::Query. See https://github.com/neo4jrb/neo4j/wiki/Search-and-Match#detailed-querying