Function coerceValueToColumnType

apps/sim/lib/table/validation.ts:272–314

* Attempts to coerce a non-null value to a column's declared type. Returns the * coerced value when the value already matches or can be converted without * ambiguity (e.g. the string `"1999"` to the number `1999`), and `ok: false` * when no safe conversion exists.

(
  value: JsonValue,
  type: ColumnDefinition['type']
)

 * when no safe conversion exists.
 */
function coerceValueToColumnType(
  value: JsonValue,
  type: ColumnDefinition['type']
): { ok: true; value: JsonValue } | { ok: false } {
  switch (type) {
    case 'string':
      if (typeof value === 'string') return { ok: true, value }
      if (typeof value === 'number' || typeof value === 'boolean') {
        return { ok: true, value: String(value) }
      }
      return { ok: false }
    case 'number':
      if (typeof value === 'number') {
        return Number.isFinite(value) ? { ok: true, value } : { ok: false }
      }
      if (typeof value === 'string' && value.trim() !== '') {
        const parsed = Number(value)
        return Number.isFinite(parsed) ? { ok: true, value: parsed } : { ok: false }
      }
      return { ok: false }
    case 'boolean':
      if (typeof value === 'boolean') return { ok: true, value }
      if (typeof value === 'string') {
        const normalized = value.trim().toLowerCase()
        if (normalized === 'true') return { ok: true, value: true }
        if (normalized === 'false') return { ok: true, value: false }
      }
      return { ok: false }
    case 'date': {
      if (typeof value === 'string' && !Number.isNaN(Date.parse(value))) return { ok: true, value }
      // Date instances and epoch numbers may still be out of the representable
      // range (>±8.64e15ms) — guard `toISOString()`, which throws RangeError on
      // an Invalid Date, so an over-range value degrades to `{ ok: false }`
      // rather than crashing the write.
      const date =
        value instanceof Date ? value : typeof value === 'number' ? new Date(value) : null
      if (date && !Number.isNaN(date.getTime())) return { ok: true, value: date.toISOString() }
      return { ok: false }
    }
    default:
      return { ok: true, value }
  }
}

/**
 * Coerces each present value in `data` toward its column's declared type **in