OrientDB SQL：如何找到顶点并在它们之间创建边？

这就是我最终要做的事情：

createEdges使用三个参数定义函数：createEdges(from, to, type)

// Check whether "from" is invalid or empty
if (from instanceof java.util.Collection) {
  if (from.isEmpty()) {
    return [];
  } else {
    var it = from.iterator();
    var obj = it.next();
    if (!(obj instanceof com.orientechnologies.orient.core.id.ORecordId)) {
      throw "Bad Input: createdEdges() only accepts ORecordIds or Collections of ORecordIds";
    }
  } 
} else if (!(from instanceof com.orientechnologies.orient.core.id.ORecordId)) {
  throw "Bad Input: createdEdges() only accepts ORecordIds or Collections of ORecordIds";
}

// Check whether "to" is invalid or empty
if (to instanceof java.util.Collection) {
  if (to.isEmpty()) {
    return [];
  } else {
    var it = to.iterator();
    var obj = it.next();
    if (!(obj instanceof com.orientechnologies.orient.core.id.ORecordId)) {
      throw "Bad Input: createdEdges() only accepts ORecordIds or Collections of ORecordIds";
    }
  } 
} else if (!(to instanceof com.orientechnologies.orient.core.id.ORecordId)) {
  throw "Bad Input: createdEdges() only accepts ORecordIds or Collections of ORecordIds";
}

var g = orient.getGraph();
var cmd = "CREATE EDGE " + type + " FROM " + from + " TO " + to;

return g.command("sql", cmd);

uniq使用一个参数定义函数：uniq(collection)

if (collection instanceof java.util.Collection) {
  if (collection.isEmpty()) {
    return collection
  } else {
    return new java.util.HashSet(collection)
  }
} else {
  throw "Bad Input: uniq() only accepts Java collections as input"
}

现在，我可以运行以下SQL命令：

SELECT createEdges(src, dst, 'RELIES_ON') FROM
(SELECT @rid AS src, uniq(out('USES').out('BELONGS_TO').@rid) AS dst FROM Modules)

这将在模块和它们依赖的项目之间创建独特的优势，而且速度非常快。

感谢@vitorenesduarte，他提供了最初的回应和主要灵感...