Skip to content

Latest commit

 

History

History
128 lines (99 loc) · 5.03 KB

CHANGELOG.md

File metadata and controls

128 lines (99 loc) · 5.03 KB
Raw

Changes between cypher_kernel 0.2.2 and 0.2.3

  • Fixed handling of queries, which do not return anything, such as the following. Earilier they crashed the kernel, now they should work.
MERGE (nAlice:User {id:'Alice'})
MERGE (nBridget:User {id:'Bridget'})
MERGE (nCharles:User {id:'Charles'})
MERGE (nDoug:User {id:'Doug'})
MERGE (nMark:User {id:'Mark'})
MERGE (nMichael:User {id:'Michael'})
MERGE (nAlice)-[:FOLLOWS]->(nDoug)
MERGE (nAlice)-[:FOLLOWS]->(nBridget)
MERGE (nAlice)-[:FOLLOWS]->(nCharles)
MERGE (nMark)-[:FOLLOWS]->(nDoug)
MERGE (nMark)-[:FOLLOWS]->(nMichael)
MERGE (nBridget)-[:FOLLOWS]->(nDoug)
MERGE (nCharles)-[:FOLLOWS]->(nDoug)
MERGE (nMichael)-[:FOLLOWS]->(nDoug)

Changes between cypher_kernel 0.2.1 and 0.2.2

  • Added handling for EXPLAIN and parsing for PROFILE queries.

Changes between cypher_kernel 0.2.0 and 0.2.1

  • Fixed parsing of queries, such as CALL apoc.meta.graph();, which may return lists containing only single elements, as in the following:
+-----------------------+
| nodes | relationships |
+-----------------------+
| [(:Person {name: "Person", count: 737000, _id_: -12})] | [[:FOLLOWS {count: 36733633, _id_: -12, type: "FOLLOWS", in: 36733633, out: 36733633}[-12>-12]]] |
+-----------------------+
  • Fixed parsing of relations, which was broken due to a mistake in parsing lists.
  • Added keywords for EXPLAIN and PROFILE, however their results currently crash the parser.

Changes between cypher_kernel 0.1.1 and 0.2.0

Added parsing of lists

Cypher queries, may return lists. Examples are:

CALL apoc.meta.graph();
MATCH (n) 
RETURN labels(n) AS labels, COUNT(*) AS count
ORDER BY count DESC

Such lists should now be parsed correctly.

Added support for %%python magic

Now, there are standard code cells, which contains Cypher code and code cells for %%bash and %%python code.

Noteable about %%python code cells is, that a Pandas DataFrame is accessible under the name df. It contains the results of the last Cypher query. That is, the DataFrame may be empty of the query did not return anything. Otherwise, it contains the data as returned by the query. Note, all contents are strings and have to be manually casted correspondingly.

For example, if a query returns:

+------------------------------------------------------+
| juris            | num   | officer_country           |
+------------------------------------------------------+
| "Bermuda"        | 67025 | "United States"           |
| "Aruba"          | 36191 | "Netherlands Antilles"    |
| "Bermuda"        | 12846 | "United Kingdom"          |
| "Bermuda"        | 12180 | "Hong Kong"               |
| "Cayman Islands" | 9563  | "United States"           |
| "Bermuda"        | 7818  | "Switzerland"             |
| "Aruba"          | 7168  | "Curaçao"                 |
| "Aruba"          | 5344  | "Virgin Islands, British" |
| "Bermuda"        | 4089  | "China"                   |
| "Bermuda"        | 3794  | "Canada"                  |
| "Aruba"          | 3627  | "Saint Kitts and Nevis"   |
| "Bermuda"        | 3123  | "Singapore"               |
| "Cayman Islands" | 2585  | "China"                   |
| "Bermuda"        | 2556  | "Australia"               |
| "Bermuda"        | 2219  | "British Virgin Islands"  |
| "Isle of Man"    | 2032  | "United Kingdom"          |
| "Bermuda"        | 1912  | "Cayman Islands"          |
| "Cayman Islands" | 1739  | "United Kingdom"          |
| "Bermuda"        | 1629  | "France"                  |
| "Cayman Islands" | 1596  | "Hong Kong"               |
+------------------------------------------------------+

The corresponding DataFrame looks as:

               juris    num            officer_country
0          "Bermuda"  67025            "United States"
1            "Aruba"  36191     "Netherlands Antilles"
2          "Bermuda"  12846           "United Kingdom"
3          "Bermuda"  12180                "Hong Kong"
4   "Cayman Islands"   9563            "United States"
5          "Bermuda"   7818              "Switzerland"
6            "Aruba"   7168                  "Curaçao"
7            "Aruba"   5344  "Virgin Islands, British"
8          "Bermuda"   4089                    "China"
9          "Bermuda"   3794                   "Canada"
10           "Aruba"   3627    "Saint Kitts and Nevis"
11         "Bermuda"   3123                "Singapore"
12  "Cayman Islands"   2585                    "China"
13         "Bermuda"   2556                "Australia"
14         "Bermuda"   2219   "British Virgin Islands"
15     "Isle of Man"   2032           "United Kingdom"
16         "Bermuda"   1912           "Cayman Islands"
17  "Cayman Islands"   1739           "United Kingdom"
18         "Bermuda"   1629                   "France"
19  "Cayman Islands"   1596                "Hong Kong"

Syntax highlighting

Cypher code is now highligthed correctly. Thanks to Thomas' answer to my question on the Jupyter Help repository, see jupyter/help#301