Function executeReverseReferenceLookupNode

src/nodeExecutor.ts:1539–1888

(
  nodeId: string,
  textValue: string,
  inputData: DBTablesNodeData,
  config?: unknown,
  executionContext?: FlowExecutionContext,
)

}

async function executeReverseReferenceLookupNode(
  nodeId: string,
  textValue: string,
  inputData: DBTablesNodeData,
  config?: unknown,
  executionContext?: FlowExecutionContext,
): Promise<NodeExecutionResult> {
  console.log(`Reverse Reference Lookup Node ${nodeId}: Processing with input tables:`, {
    tableCount: inputData?.tables?.length,
    tableNames: inputData?.tables?.map((t) => t.name),
  });

  if (!inputData || inputData.type !== "TableSelection") {
    return { success: false, error: "Invalid input: Expected TableSelection data" };
  }

  // Parse selected reverse table and includeBaseGame from textValue
  const parsed = getNodeConfig<{ selectedReverseTable?: string; includeBaseGame?: boolean }>(config, textValue);
  if (!parsed) {
    return { success: false, error: "Invalid node configuration" };
  }
  let selectedReverseTable = parsed.selectedReverseTable || "";
  const includeBaseGame = parsed.includeBaseGame !== false;

  // Build source files list, potentially including base game
  const sourceFiles = [...(inputData.sourceFiles || [])];

  if (includeBaseGame) {
    const baseGamePackName = gameToPackWithDBTablesName[appData.currentGame];
    if (baseGamePackName) {
      const baseGameFolder = appData.gamesToGameFolderPaths[appData.currentGame].dataFolder;
      if (baseGameFolder) {
        const baseGamePackPath = path.join(baseGameFolder, baseGamePackName);
        // Check if base game pack is not already in sourceFiles
        if (!sourceFiles.some((sf) => sf.path === baseGamePackPath)) {
          if (fs.existsSync(baseGamePackPath)) {
            sourceFiles.push({
              name: baseGamePackName,
              path: baseGamePackPath,
              loaded: true,
            });
            console.log(
              `Reverse Reference Lookup Node ${nodeId}: Added base game pack from ${baseGamePackPath}`,
            );
          }
        }
      }
    }
  }

  // Get the input table name to find reverse references
  let inputTableName = "";
  if (inputData.tables.length > 0) {
    inputTableName = inputData.tables[0].name.replace(/^db\\/, "").replace(/\\.*$/, "");
  }

  // If no reverse table is selected, try to auto-select if there's only one option
  if ((!selectedReverseTable || selectedReverseTable.trim() === "") && inputTableName) {