Neo4j-来自ruby的Cypher查询翻译

Question

我有一个小neo4j，有两个节点类型Author和Book。authored_book从作者到图书的单一关系。我知道如何找到一位作者的名字，以及他从Ruby那里写的所有书。但我不知道如何用Cypher写同样的东西。这是Ruby代码：

2.1.5 :183 > a = Author.find_by(name: 'Albert Camus')
 => #<Author name: "Albert Camus">
2.1.5 :184 > a.books.count
 => 24
2.1.5 :185 > a.books.first
 => #<Book title: "LA Peste (Folio Series: No. 42)">
2.1.5 :186 > a.books.last
 => #<Book title: "La Chute">
2.1.5 :187 >

需要知道如何用Cypher写这篇文章。

Answer 1

开始吧。查找并编写所有由书籍编写的内容。返回书籍的计数、书籍的收藏、收藏中的第一本书、收藏中书籍的尾部和收藏中的最后一本书。

match (a:Author {name: 'Albert Camus'})-[:AUTHORED_BOOK]->(b:Book)
return count(b) as Num
, collect(b.title) as Books
, head(collect(b.title)) as Head
, tail(collect(b.title)) as Tail
, last(collect(b.title)) as Last
, collect(b.title)[length(collect(b))-1] as Last2