retrography
5/27/2015 - 3:45 AM

Useful functions for OrientDB

Useful functions for OrientDB

function getRID (className, property, condition, value) {
 
 var g = orient.getGraph();
 var qry = "SELECT FROM " + className + " WHERE " + property + " " + condition + " '" + value + "'";
 res = g.command("sql", qry);
 
 if (res.length == 0) {
  return;
 }
 else {
  rid = res[0].getId().toString(); 
  return rid;
 }
 
}

function dateDiff (from, to) {

 // The number of milliseconds in one day
 var ONE_DAY = 1000 * 60 * 60 * 24
 
 // Convert both dates to milliseconds
 var to_ms = to.getTime()
 var from_ms = from.getTime()
 
 // Calculate the difference in milliseconds
 var difference_ms = to_ms - from_ms
 
 // Convert back to days and return
 return Math.round(difference_ms / ONE_DAY)
 
}
function createEdge (from, to, type) {
 
 var g = orient.getGraph();
 var cmd = "CREATE EDGE " + type + " FROM " + from + " TO " + to;
 
 return g.command("sql", cmd);

}