How to write upsert query for edge ?

[Suyog Kale]

How to write upsert query for edge that if it exist then update else insert, Please give me sample examples. few forums observed that developers has issues that it adds multiple edges.

[user.w...@gmail.com]

Hi,

try this:

update link SET out = #22:0, in = #21:0 UPSERT WHERE out = #22:0 and in = #21:0

Hope it helps

Regards,

Michela

[Suyog Kale]

Hi Michela,
I got following error:
error com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error parsing query:\nUPDATE LINK

I am using graph DB, I am not sure if we can use Update EDGE with Upsert.  OR update Link is right syntax.

[Suyog Kale]

I am able to upsert for edge class with following syntax:

UPDATE LikeComment SET out = #21:21, in = #20:20 UPSERT WHERE out = #21:21 and in = #20:20

But When I select source vertex like SELECT FROM #21:21 it does not show me that out edge in result.

[user.w...@gmail.com]

Hi,

link is the name of my edge so, you have to do:

UPDATE LikeComment SET out = #21:21, in = #20:20 UPSERT WHERE out = #21:21 and in = #20:20

Hope it helps

Regards,

Miichela

[Suyog Kale]

I am able to upsert for edge class with following syntax:

UPDATE LikeComment SET out = #21:21, in = #20:20 UPSERT WHERE out = #21:21 and in = #20:20

But When I select source vertex like SELECT FROM #21:21 it does not show me that out edge in result.

[user.w...@gmail.com]

Hi,

can you open an issue?

Thx.

Regards,

Michela

[Oleksandr Gubchenko]

You can also ask for updates here: https://github.com/orientechnologies/orientdb/issues/4436

[Suyog Kale]

Ya, logged the issue.