Skip to content

Latest commit

 

History

History
35 lines (29 loc) · 1.15 KB

Frequently Used Query.md

File metadata and controls

35 lines (29 loc) · 1.15 KB

Frequently used Queries

  • Dates in AWS Graph notebook
%%gremlin -p v,inv
import java.time.LocalDateTime;
import java.time.ZoneId;
import java.util.Date;
// Creating a new Date object with the current date and time
Date currentDate = Date.from(LocalDateTime.now().atZone(ZoneId.systemDefault()).toInstant());
//g.V(549088).outE("has").inV().hasLabel("question").id().toList()
g.V(549088).outE("has").has('end_time', P.gte(currentDate)).inV().elementMap()
  • Update date using AWS graph notebook
%%gremlin -p v,e
import java.time.LocalDateTime;
import java.time.ZoneId;
import java.util.Date;
// Creating a new Date object with the current date and time
Date currentDate = Date.from(LocalDateTime.now().atZone(ZoneId.systemDefault()).toInstant());
// Creating a new Date object with a specific date and time
LocalDateTime customDateTime = LocalDateTime.of(2023, 5, 29, 10, 30, 0);
g.V(49360).property("end_time", Date.from(customDateTime.atZone(ZoneId.systemDefault()).toInstant()))
  • Convert Gremlin DSL/bytecode to groovy query
GroovyTranslator.of("g").
 translate(g.company(companyId).manager()).asAdmin().getBytecode())