neode icon indicating copy to clipboard operation
neode copied to clipboard

Incorrect Constraints Query Generated

Open ColtraneNadler opened this issue 10 months ago • 2 comments

Incorrect Constraints Query Generated

Versions

  • Neo4j Version 5.18.1
  • Neode Version 0.4.9

Problem

Incorrect constraints query being generated by

instance.model('MyNode', {
    customKey: {
        type: 'string',
        unique: true
    },
    mappings: 'string'
 });

instance.schema.install()

Runs the following cypher query

CREATE CONSTRAINT ON (model:MyNode) ASSERT model.customKey IS UNIQUE

which returns the following error ->

  error: Neo4jError: Invalid constraint syntax, ON and ASSERT should not be used. Replace ON with FOR and ASSERT with REQUIRE. (line 1, column 1 (offset: 0))
  "CREATE CONSTRAINT ON (model:MyNode) ASSERT model.customKey IS UNIQUE"
   ^

ColtraneNadler avatar Apr 24 '24 14:04 ColtraneNadler

Bumping this

ColtraneNadler avatar May 02 '24 17:05 ColtraneNadler

I created a PR for this issue here https://github.com/adam-cowley/neode/pull/184

ColtraneNadler avatar May 02 '24 17:05 ColtraneNadler