cskardon / cosmostoneo4j Goto Github PK

Including options to ignore...

{
 "Nodes" : [
   { 
      "Neo4j" : "Person",
      "Cosmos": "Person",
      "PropertiesMap" : [
           { 
               "Cosmos" : "Id",
               "Neo4j" : "Id",
               "Indexed": "true" //If not supplied = false
               "Ignored": "false" //If not supplied = false
            }
      ]
  }]
}

At the moment the Guid Paginator can only cope with 36 pages (0-9, a-z) by only looking for the first character.
If the paginator can be extended to handle multiple characters - so:

0 -> 01
01 -> 02

2 characters would give up to 1,296 pages
3 characters up to 46,656 pages!

At the moment the Cypher generated is:

UNWIND $relationships AS rel
MATCH (inN {CosmosId: rel.inV})
MATCH (outN {CosmosId: rel.outV})
MERGE (inN)-[r:ACTED_IN]->(outN)
SET r += rel.properties

But this would be more efficient if the inN and outN nodes had their labels attached.

UNWIND $relationships AS rel
MATCH (inN:Person {CosmosId: rel.inV})
MATCH (outN:Movie {CosmosId: rel.outV})
MERGE (inN)-[r:ACTED_IN]->(outN)
SET r += rel.properties

So you can generate a base template version

As the relationships are created using the InVertexLabel etc - which is still on the Cosmos setting, not the Neo4j one

The following message is thrown when CosmosRelationship Properties property is null.

"Expected Property(ReferenceFromSlot(0,rel),PropertyKeyName(properties)) to be a map, but it was :`NO_VALUE`"

Using unwind or similar

You lose context as - in its current state - the MERGE will cause multiples of the same relationship to be merged into one - which is unintended.

Following a couple of test migrations, it appears that the direction of edges is inverted in Neo4J, from the direction they had in CosmosDB.

For example, in our Cosmos DB, we have an edge/rel labelled 'Themes' that goes out from Client node in to Theme nodes in Comsos, but, one imported into Neo4J, the relation Themes direction goes from Theme to Client.

This seems consistent across the migration from what I can see.