Function resolveRel

src/utils/migrations/diffToSQL.js:189–211

(diagram, rel)

}

function resolveRel(diagram, rel) {
  const tables = diagram?.tables || [];
  const startT = tables.find((t) => t.id === rel.startTableId);
  const endT = tables.find((t) => t.id === rel.endTableId);
  if (!startT || !endT) return null;
  const pairs = getRelationshipFields(rel);
  const startFieldNames = pairs.map(
    (p) => (startT.fields || []).find((f) => f.id === p.startFieldId)?.name,
  );
  const endFieldNames = pairs.map(
    (p) => (endT.fields || []).find((f) => f.id === p.endFieldId)?.name,
  );
  if (startFieldNames.some((n) => !n) || endFieldNames.some((n) => !n))
    return null;
  return {
    startTableName: startT.name,
    startFieldName: startFieldNames[0],
    endTableName: endT.name,
    endFieldName: endFieldNames[0],
    startFieldNames,
    endFieldNames,
  };
}

function fkCols(names, q) {
  return names.map((n) => q(n)).join(", ");