Create unique node

Neo4j Graph Platform
1

hello

im trying create node with 1 unique property called name so i try create something like this

CREATE CONSTRAINT ON (n:words) assert n.name is unique

and after that

create (n:words{name:"test"})

so my problem is i dont want to be case sensitive i mean for example if we send word and Word it doesn't create the second one

and next thing i wanna ask is when i use above query it says this feature is deprecated so is there any new way? and because i wanna use this on node js is it problem to repeat the first query?

2

Hello @hoseinmorshedy :blush:

If you are on the latest version of Neo4j (4.4.x):

CREATE CONSTRAINT constraint_Word IF NOT EXISTS FOR (n:Word) REQUIRE n.name IS UNIQUE;

If you create a unique constraint, then you should use MERGE clause instead of CREATE:

MERGE (n:Word {name: toLower($your_string)})

Regards,

Cobra

3

but how we make it uncase sensitive?

i dont want to create 2 node called A and a

4

You can't do it directly, that's why I used the toLower() function to make sure it creates only one node.

5

one more thing in node js im trying to get all index of array with foreach and then merge it into neo4j the problem i have is it just merge 1 item into database my code is:

words.forEach((res, index) => {

session.run(`merge (words{name:'${res}'})`)

}

6

You should pass the whole list to your query and UNWIND it like this:

UNWIND $words AS item
MERGE (n:Word {name: toLower(item)})