Function boardColumns

packages/shared-domain/src/database-transforms.ts:144–161

(
  rows: DbRow[],
  groupField: DbField,
  optionOrder: string[]
)

 * references a removed option.
 */
export function boardColumns(
  rows: DbRow[],
  groupField: DbField,
  optionOrder: string[]
): BoardColumn[] {
  const buckets = new Map<string, DbRow[]>()
  const known = new Set(optionOrder)
  for (const value of optionOrder) buckets.set(value, [])
  buckets.set(EMPTY_GROUP, [])
  for (const row of rows) {
    const v = cell(row, groupField.id).trim()
    const key = v.length > 0 && known.has(v) ? v : EMPTY_GROUP
    buckets.get(key)!.push(row)
  }
  const columns = optionOrder.map((value) => ({ key: value, rows: buckets.get(value)! }))
  columns.push({ key: EMPTY_GROUP, rows: buckets.get(EMPTY_GROUP)! })
  return columns
}