search

nmondal / cowj

[C]onfiguration [O]nly [Web] on [J]VM
Apache License 2.0
15 stars 11 forks source link

JDBC needs a parameterized query evaluator #90

Closed nmondal closed 6 months ago

nmondal commented 6 months ago

See the following cypher queries:

[1]

MATCH (a:Entity), (b:Entity) WHERE a.urn = '%s' AND b.urn = '%s'
CREATE (a)-[r:%s { startTime: datetime(), endTime: null } ]->(b)  
RETURN a,b

[2]

MATCH (a {urn:'%s'})-[r:%s]-(b {urn:'%s'})
SET r.endTime = datetime()

It takes 3 params. Entity1, Entity2, and a relation name. But now the ordering gets changed, that is shame.

nmondal commented 6 months ago

This solves it. https://github.com/nmondal/cowj/commit/670c91e64a8a936341eaf03d2cd72fd1222bf25b