Search code examples
orientdbupsertorientdb-2.1

Can we UPSERT an EDGE in orientdb?

Is it possible to get an example to upsert an edge in orientdb. IF it does not exist is there a way to check if the edge exist, if it does then just update the edge else create a new edge. I am using Orientdb 2.1.13 version. Thank you

Solution

  • via SQL you can use the basic UPDATE command

    update written_by SET out = #9:2, in = #16:43, prop="gianni" UPSERT WHERE out = #9:2 and in = #16:43

    http://orientdb.com/docs/last/SQL-Update.html