Function validateSheet

src/validators/index.ts:77–139

(
  sheetDefinition: SheetDefinition,
  sheetData: SheetState,
  allData: SheetState[]
)

}

async function validateSheet(
  sheetDefinition: SheetDefinition,
  sheetData: SheetState,
  allData: SheetState[]
) {
  const validationErrors: ImporterValidationError[] = [];
  const validationPromises: Promise<void>[] = [];

  const validatorsByColumnId = eachWithObject<
    SheetColumnDefinition,
    Validator[]
  >(sheetDefinition.columns, (columnDefinition, obj) => {
    obj[columnDefinition.id] = [];

    const validatorDefinitions = [
      ...(columnDefinition.validators ?? []),
      ...automaticFieldValidators(columnDefinition, allData),
    ];

    validatorDefinitions.forEach((validatorDefinition) => {
      obj[columnDefinition.id].push(
        buildValidatorFromDefinition(validatorDefinition)
      );
    });
  });

  sheetDefinition.columns.forEach((columnDefinition) => {
    sheetData.rows.forEach((row, rowIndex) => {
      if (!hasData(row)) {
        return;
      }

      if (
        !(columnDefinition.id in row) &&
        !fieldIsRequired(columnDefinition, { skipConditionCheck: true })
      ) {
        return;
      }

      const value = row[columnDefinition.id];
      const validators = validatorsByColumnId[columnDefinition.id];

      validators.forEach((v) => {
        const promise = Promise.resolve(v.isValid(value, row)).then(
          (result) => {
            if (result != null) {
              validationErrors.push({
                sheetId: sheetDefinition.id,
                columnId: columnDefinition.id,
                rowIndex,
                message: result,
              });
            }
          }
        );
        validationPromises.push(promise);
      });
    });