Function transformSheet

src/transformers/index.ts:12–47

(
  sheetDefinition: SheetDefinition,
  sheetData: SheetState
)

import { Transformer } from './transformer_definitions/base';

function transformSheet(
  sheetDefinition: SheetDefinition,
  sheetData: SheetState
) {
  const pipelineByColumnId = eachWithObject<SheetColumnDefinition, Pipeline>(
    sheetDefinition.columns,
    (columnDefinition, obj) => {
      obj[columnDefinition.id] = new Pipeline();
      if (!columnDefinition.transformers) return;
      columnDefinition.transformers.forEach((transformerDefinition) => {
        obj[columnDefinition.id].push(
          buildTransformerFromDefinition(transformerDefinition)
        );
      });
    }
  );

  sheetDefinition.columns.forEach((columnDefinition) => {
    const columnId = columnDefinition.id;
    const pipeline = pipelineByColumnId[columnId];

    sheetData.rows.forEach((row) => {
      if (!hasData(row)) {
        return;
      }

      const cellValue = row[columnId];

      if (!isEmptyCell(cellValue)) {
        row[columnId] = pipeline.transform(cellValue);
      }
    });
  });

  return sheetData.rows;
}

export function applyTransformations(
  sheetDefinitions: SheetDefinition[],