Function getExistingValuesForTableColumn

src/DBClone.ts:1224–1252

(tableName: string, columnName: string)

    const tableColumnValuesCache = new Map<string, Set<string>>();
    const getExistingValuesForTableColumn = async (tableName: string, columnName: string) => {
      const cacheKey = `${tableName}|${columnName}`;
      const existingCache = tableColumnValuesCache.get(cacheKey);
      if (existingCache) return existingCache;

      const existingValues = new Set<string>();
      for (const targetPackPath of packPathsForCollisionChecks) {
        if (isCanceled()) {
          report("canceled", "Canceled");
          return existingValues;
        }

        const tableFiles = await getTableFilesForPackAndTable(targetPackPath, tableName);
        for (const tableFile of tableFiles) {
          const columnIndex = getColumnIndexForPackedFile(tableFile, columnName);
          if (columnIndex < 0) continue;

          const rows = getRowsForPackedFile(tableFile);
          for (const row of rows) {
            const cell = row[columnIndex];
            if (!cell) continue;
            existingValues.add(cell.resolvedKeyValue);
          }
        }
      }

      tableColumnValuesCache.set(cacheKey, existingValues);
      return existingValues;
    };

    interface SavePackedFileDataWithSchema {
      name: string;