Function parseSheetsTableColumnsJSON

internal/cmd/sheets_table_columns.go:21–71

(spec string, input io.Reader)

}

func parseSheetsTableColumnsJSON(spec string, input io.Reader) ([]*sheets.TableColumnProperties, error) {
	b, err := resolveInlineOrFileBytes(spec, input)
	if err != nil {
		return nil, usagef("read --columns-json: %v", err)
	}

	var raw []sheetsTableColumnInput
	dec := json.NewDecoder(bytes.NewReader(b))
	dec.DisallowUnknownFields()
	if err := dec.Decode(&raw); err != nil {
		return nil, usagef("invalid columns JSON: %v", err)
	}
	var extra any
	if err := dec.Decode(&extra); err != io.EOF {
		if err == nil {
			return nil, usage("invalid columns JSON: multiple JSON values")
		}
		return nil, usagef("invalid columns JSON: %v", err)
	}
	if len(raw) == 0 {
		return nil, usage("provide at least one table column")
	}

	cols := make([]*sheets.TableColumnProperties, 0, len(raw))
	for i, in := range raw {
		name := strings.TrimSpace(in.ColumnName)
		if name == "" {
			return nil, usagef("columns[%d].columnName is required", i)
		}
		colType, err := normalizeSheetsTableColumnType(in.ColumnType)
		if err != nil {
			return nil, usagef("columns[%d].columnType: %v", i, err)
		}
		validation := in.DataValidationRule
		if validation == nil {
			validation = in.DataValidation
		}
		if validation != nil && colType != sheetsTypeDropdown {
			return nil, usagef("columns[%d].dataValidationRule requires columnType DROPDOWN", i)
		}
		col := &sheets.TableColumnProperties{
			ColumnIndex:        int64(i),
			ColumnName:         name,
			ColumnType:         colType,
			DataValidationRule: validation,
		}
		col.ForceSendFields = []string{"ColumnIndex"}
		cols = append(cols, col)
	}
	return cols, nil
}

func normalizeSheetsTableColumnType(input string) (string, error) {
	t := strings.ToUpper(strings.TrimSpace(input))