Function executeReferenceLookupNode

src/nodeExecutor.ts:1297–1537

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

}

async function executeReferenceLookupNode(
  nodeId: string,
  textValue: string,
  inputData: DBTablesNodeData,
  config?: unknown,
  executionContext?: FlowExecutionContext,
): Promise<NodeExecutionResult> {
  console.log(`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 reference table and includeBaseGame from textValue
  const parsed = getNodeConfig<{ selectedReferenceTable?: string; includeBaseGame?: boolean }>(config, textValue);
  if (!parsed) {
    return { success: false, error: "Invalid node configuration" };
  }
  const selectedReferenceTable = parsed.selectedReferenceTable || "";
  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(`Reference Lookup Node ${nodeId}: Added base game pack from ${baseGamePackPath}`);
          }
        }
      }
    }
  }

  if (!selectedReferenceTable || selectedReferenceTable.trim() === "") {
    console.log(`Reference Lookup Node ${nodeId}: No reference table selected, returning empty result`);
    return {
      success: true,
      data: {
        type: "TableSelection",
        tables: [],
        sourceFiles: sourceFiles,
        tableCount: 0,
      } as DBTablesNodeData,