AnormCypher/AnormCypher

Neo4j Scala library based on Anorm in the Play Framework

Kai Chen

@Kai-Chen

The relationships are mapped using NeoRelationship. You'd use Cypher to return all the relationships. If you want them in a list, you'd run

match (n:criteria)-[r]-() return n, collect(r) as links;

or if you want one row for each relationship, simply

match (n:criteria)-[r]-() return n,r

then use (NeoNode, NeoRelationship) to map the rows. HTH.

Kamaldeep Singh

@kamaldsingh

thanks

Kamaldeep Singh

@kamaldsingh

anyone know the java process doesnt terminate after it returns the results from the cypher query

Kai Chen

@Kai-Chen

@kamaldsingh you need to call close() on the WS client. If you are doing it in the console, take a look at build.sbt's console set up in the AnormCypher project.

AnormCypher 0.9.0 just released with support for transaction, details here https://github.com/AnormCypher/AnormCypher/releases/tag/0.9.0

Kai Chen

@Kai-Chen

Anything else anyone would like to add before we can do a formal 1.0 release? I've got pretty much all the features I need for myself.

Swayam Narain

@swayam18

The repo host, http://repo.anormcypher.org/org/anormcypher/ is down.

[error] Server access Error: Operation timed out url=http://repo.anormcypher.org/org/anormcypher/anormcypher_2.11/0.9.0/anormcypher_2.11-0.9.0.pom

this is what I get

Is there an alternate source that one could use?

Eve Freeman

@freeeve

works for me

Swayam Narain

@swayam18

hi @freeve, thanks for your response... can you try accessing: http://repo.anormcypher.org/org/anormcypher/anormcypher_2.11/0.9.0/anormcypher_2.11-0.9.0.pom please?

Eve Freeman

@freeeve

works fine

uptime on host is 155 days

Swayam Narain

@swayam18

oh, not sure why its timing out here

Eve Freeman

@freeeve

wonder if it's a dns thing, what IP is resolving

should be 50.116.56.111

eve-macbook.local:~ dig repo.anormcypher.org

; <<>> DiG 9.8.3-P1 <<>> repo.anormcypher.org
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 48673
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0

;; QUESTION SECTION:
;repo.anormcypher.org.        IN    A

;; ANSWER SECTION:
repo.anormcypher.org.    86400    IN    A    50.116.56.111

;; Query time: 63 msec
;; SERVER: 68.105.28.11#53(68.105.28.11)
;; WHEN: Tue May 17 05:59:14 2016
;; MSG SIZE  rcvd: 54

Swayam Narain

@swayam18

Hmm I doubt its a dns issue, as I can navigate to the repository. I can get as far as choosing the scala version and anormcypher version, but it does not initiate the download of the actual jar / pom

Ill try using a proxy and see what happens

Eve Freeman

@freeeve

huh

does your browser use a proxy?

Swayam Narain

@swayam18

no, it doesn't .... I can reach http://repo.anormcypher.org/org/anormcypher/anormcypher_2.11/0.9.0/ but any other links timeout

I just used a proxy server to download successfully though o_o

Eve Freeman

@freeeve

ok good

Swayam Narain

@swayam18

Thank you!

Eve Freeman

@freeeve

no problem, have a good day :sparkles:

Swayam Narain

@swayam18

you too!

Kai Chen

@Kai-Chen

0.9.1 released with support for neo4j 3.0 (not posting in the mailing list since nobody is there :))

Darren Gibson

@zarthross

Does it use the new API or the rest API?

Eve Freeman

@freeeve

it's using the transactional endpoint

would be pretty cool to implement the socket stuff, or at least wrap the java impl

Kai Chen

@Kai-Chen

yes, still REST; the java native driver is not async yet, much less streaming, so that's at least what's unique in anormcypher. But if you use transaction, async or streaming is not really meaningful, especially when one part of the tx depends on the successful result of a previous stmt

Swayam Narain

@swayam18

Is it possible to use the parser api directly on any nodes that were returned? i.e., can I do something like this:

Cypher("MATCH (u: User) RETURN u").single(str("u.id"))

The query above results in an exception: "u.id not found, available columns : u"

I tried using "RETURN u.*" but received a cypher syntax exception "Invalid input '*' "

Kai Chen

@Kai-Chen

With anormcypher-0.8.1 the node mapping should still work. The 0.9 series switched to the transactional endpoint, and Neo4j 2.x doesn't return node and relationships. Neo4j 3.x does return the information again through the transactional endpoint, and we do plan to add node mapping back. HTH.

Kai Chen

@Kai-Chen

Hi, guys, I can't find Eve, and was about to ask github to switch Anormcypher into a top-level project (instead of a fork from Eve's original) before I realized that I should probably check with people here fist. Give me a shout if you don't like the idea.

bastien

@protheusfr

Hello, Did you know if it is possible to get the number of created node(s) from a Cypher().execute() (on another call) ?
I would like to know how many node (or relationship) is create with a cypher request like MERGE (n {name:"something"})-[:REL]->(p {name:"otherthing"}) ?

Kai Chen

@Kai-Chen

Right now there isn't any stats such as 'number of nodes created' etc exposed through the AnormCypher api. And that's because we're supporting both Neo4j 2.x and 3.x, and in 2.x only the legacy REST endpoint returns stats -- though I haven't checked whether it returns the nodes created stats specifically. The 3.x series does return these numbers, but we're not asking for it in the REST query.

NickBlow

@NickBlow

I'm really struggling to get data out of my cypher query - I'm collecting paths .

Here is the query match p=(n:node)-[r:PERMISSION]->(t:node), (o:node{id:$id})-[:PARENT*0..]-(t) return COLLECT(p). This returns [[{id: 3}, {}, {id: 1}], [{id:6}, {}, {id: 2}]] - I got a seq of cypher results row, but I cannot for the life of me get the data out because it keeps failing the typecheck.

i always get Error:(24, 33) could not find implicit value for parameter c: org.anormcypher.Column[_]

im trying to cast it to a List[List[_]]

Printing out the CypherResultRow gives

CypherResultRow('COLLECT(p)':List(List(Map(id -> 3), Map(), Map(id -> 1)), List(Map(id -> 6), Map(), Map(id -> 2))) as String)

Kai Chen

@Kai-Chen

What about row.asList?

memoizr

@memoizr

Hi everyone, quick question: Why do the examples in the readme show the CypherRow syntax, but it says it's not yet supported? As a user, this has me confused a bit.

It would be nice to have a more direct example which we can actually use. Is there something I'm missing?

gendin

@gendin

Hi everyone. I have a question(most likely a stupid one but never the less...) In previous releases NeoNode used to be defined as 'case class NeoNode(id:Int, props:Map[String,Any])', but now it has lost its id parameter. So, I wonder, if there is still a way to obtain node id without explicitly adding it to Cypher query?

arkady69

@arkady69

@gendin -- i am having the same problem. Is there a way to get an id without adding to the query?

Michael Merz

@dermicha

Hi, currently my build fails because http://repo.anormcypher.org ist down?

amantuer

@amantuer

Hi everyone, I want to know how to write a parser for data which has type of Map[string,Map[string,string]] like below:

val parser: Map[string,Map[string,string]] =...
val result: List[Map[string,Map[string,string]] ] = SQL"SELECT * FROM table".as(parser.*)
//for three item has relation like: ( item1 -> (item2 -> item3))

thanks.

Where communities thrive

People

Repo info

Activity