Function validateRowAgainstSchema

apps/sim/lib/table/validation.ts:214–264

(data: RowData, schema: TableSchema)

/** Validates row data matches schema column types and required fields. */
export function validateRowAgainstSchema(data: RowData, schema: TableSchema): ValidationResult {
  const errors: string[] = []

  for (const column of schema.columns) {
    const value = data[getColumnId(column)]

    if (column.required && (value === undefined || value === null)) {
      errors.push(`Missing required field: ${column.name}`)
      continue
    }

    if (value === null || value === undefined) continue

    switch (column.type) {
      case 'string':
        if (typeof value !== 'string') {
          errors.push(`${column.name} must be string, got ${typeof value}`)
        } else if (value.length > TABLE_LIMITS.MAX_STRING_VALUE_LENGTH) {
          errors.push(`${column.name} exceeds max string length`)
        }
        break
      case 'number':
        if (typeof value !== 'number' || Number.isNaN(value)) {
          errors.push(`${column.name} must be number`)
        }
        break
      case 'boolean':
        if (typeof value !== 'boolean') {
          errors.push(`${column.name} must be boolean`)
        }
        break
      case 'date':
        if (
          !(value instanceof Date) &&
          (typeof value !== 'string' || Number.isNaN(Date.parse(value)))
        ) {
          errors.push(`${column.name} must be valid date`)
        }
        break
      case 'json':
        try {
          JSON.stringify(value)
        } catch {
          errors.push(`${column.name} must be valid JSON`)
        }
        break
    }
  }

  return { valid: errors.length === 0, errors }
}

/**
 * Attempts to coerce a non-null value to a column's declared type. Returns the