Category Archives: Database

Create Vertex If Does Not Exist – Gremlin Query – Titan

Create Vertex If Does Not Exist - Gremlin Query - Titan

Create Vertex If Does Not Exist – Gremlin Query – Titan

Create Vertex If Does Not Exist - Gremlin Query - Titan

Create Vertex If Does Not Exist Return a vertex with given label and property. If the vertex does not exist, a new vertex is created and returned to vertexObject. vertexObject = g.V().hasLabel(‘VERTEX_LABEL’).has(‘property’,’value’).tryNext().orElseGet{ graph.addVertex(label, ‘VERTEX_LABEL’, ‘property’, ‘value’); }; Related Links:

Query/Access Root Level Properties and Nested Properties of Vertex in Single Query – Gremlin Query – Titan

Query/Access Root Level Properties and Nested Properties of Vertex in Single Query - Gremlin Query - Titan

Query/Access Root Level Properties and Nested Properties of Vertex in Single Query – Gremlin Query – Titan

Query/Access Root Level Properties and Nested Properties of Vertex in Single Query - Gremlin Query - Titan

Gremlin Query: g.V().hasLabel(‘TEST_LABEL’).has(‘_id’,’xxxxxxxxxxxxxx’).as(‘v’) .select(‘v’).valueMap(true).as(‘properties’) .select(‘v’).properties(‘nestedPropertiesKey’).valueMap().as(‘nestedProperties’) .select(‘properties’,’nestedProperties’) Sample Response: { “properties”:{ “attr1″:”value1” }, “nestedProperties”:{ “nestedAttr1″:”nestedValue1” } } Related Links:

Gremlin Query Language – Create Vertex/Node and Edge/Relationship

Gremlin Query Language - Create Vertex/Node and Edge/Relationship

Gremlin Query Language – Create Vertex/Node and Edge/Relationship

Gremlin Query Language - Create Vertex/Node and Edge/Relationship

Open Gremlin Console Initial command to work/test with inmemory storage graph = TitanFactory.build().set(‘storage.backend’,’inmemory’).open() g=graph.traversal(standard()) Example 1: Create Vertex. Label property is optional. The below queries will return vertex references. graph.addVertex(‘property1′,’value1′,’property2′,’value2′); OR graph.addVertex(label,’USER’,’property1′,’value1′,’property2′,’value2′); OR graph.addVertex(T.label,’USER’,’property1′,’value1′,’property2′,’value2′); OR graph.addVertex(T.label,’USER’).property(‘property1′,’value1’).property(‘property2′,’value2’); OR graph.addVertex(‘LABEL_NAME’); Example 2: Create Edge with/without properties using system generated unique ID g.V(123).next().addEdge(‘EDGE_LABEL’,g.V(456).next()) OR g.E(g.V(123).next().addEdge(‘EDGE_LABEL’,g.V(456).next())).property(‘property1′,’value1’).property(‘property2′,’value2’) Example 3: Create Edge with/without… Read More »

Neo4j Query Tutorial – MATCH and MERGE

Neo4j Query Tutorial - MATCH and MERGE

Neo4j Query Tutorial – MATCH and MERGE

Neo4j Query Tutorial - MATCH and MERGE

Example 1: Match two nodes and create a relationship between them. MATCH (person1:LABEL{id:’1234′}),(person2:LABEL{id:’5678′}) MERGE (person1)-[r:FRIEND]-(person2) Example 2: Match two nodes and create/update a relation between them. Optionally set properties to the nodes or relationships with ON CREATE SET or ON MATCH SET. Use r+={property:’value’} to add properties or update existing properties. MATCH (user1:USER{id:’123′}),(user2:USER{id:’456′}) MERGE (user1)-[r:FRIEND]-(user2) ON CREATE SET… Read More »