search

VirtualFlyBrain / VFB_neo4j

A python package for writing schema-compliant content to VFB neo4J DBs
Apache License 2.0
0 stars 1 forks source link

edit merge statement #281

Closed Clare72 closed 7 months ago

Clare72 commented 7 months ago

Previous statement was not matching develops_from relationships to obsolete neuroblasts - new statement does match (from testing in KB).

Clare72 commented 7 months ago

/home/runner/work/VFB_neo4j/VFB_neo4j/src/uk/ac/ebi/vfb/neo4j/neo4j_tools.py:148: UserWarning: {'code': 'Neo.ClientError.Statement.SyntaxError', 'message': 'Exactly one relationship type must be specified for MERGE. Did you forget to prefix your relationship type with a \':\'? (line 1, column 153 (offset: 152))\n"MATCH (c:Class {iri: \'http://purl.obolibrary.org/obo/FBbt_00100234\'})<-[r {type:\'Related\'}]-(i:Individual), (c2:Class {short_form: \'FBbt_9\'}) MERGE (c2)<-[r2 {type:\'Related\'}]-(i) SET r2=properties(r) DELETE r"\n ^'}

So a relationship type needs to be specified with ':', but ':Related' doesn't match (at least not develops_from relationships), so do we need a different statement for every different relationship type?!

dosumis commented 7 months ago

No time to look at details now, but perhaps worth reviewing what this means for schema. Can we add to agenda next call?