CODEWITHSUNDEEP
graph-databasestinkerpopamazon-neptunegremlinpython
Thirumal
Thirumal

Reputation: 9676

Get or Create vertex/edge in Apache TinkerPop Gremlin in one query

How to get or create vertex/edge in Apache TinkerPop Gremlin in one query?

Currently I am doing,

id = None
if g.V().has('employee', 'name', 'thirumal').hasNext():
  id = g.V().has('employee', 'name', 'thirumal').values('id')
else:
  id = uuid4()
  g.addV('employee').property(T.id, id).property('name', 'Thirumal').iterate()
logging.debug("Id is {}".format(id))

Upvotes: 0

Views: 434

Answers (1)

Kelvin Lawrence
Kelvin Lawrence

Reputation: 14391

The currently recommended way to do this in Gremlin is to use the fold/coalesce/unfold pattern. In the case of your example it becomes something like:

g.V().has('employee', 'name', 'thirumal').fold().
  coalesce(unfold(),
           addV('employee').property(T.id, id).property('name', 'Thirumal')).
  id().next()

Within the Apache TinkerPop community we are looking at adding additional ways to do this kind of upsert more declaratively, but for now, this is the recommended pattern to use.

This query pattern is discussed more here and here.

Upvotes: 1

Related Questions