Method formatMergeAction

cmd/gosqlx/cmd/sql_formatter.go:1351–1411

formatMergeAction formats the action part of a WHEN clause (UPDATE/INSERT/DELETE)

(action *ast.MergeAction)

// formatMergeAction formats the action part of a WHEN clause (UPDATE/INSERT/DELETE)
func (f *SQLFormatter) formatMergeAction(action *ast.MergeAction) error {
	if action == nil {
		return nil
	}

	switch action.ActionType {
	case "UPDATE":
		f.writeKeyword("UPDATE SET")
		if len(action.SetClauses) > 0 {
			f.builder.WriteString(" ")
			for i, setClause := range action.SetClauses {
				if i > 0 {
					f.builder.WriteString(", ")
				}
				f.builder.WriteString(setClause.Column)
				f.builder.WriteString(" = ")
				if err := f.formatExpression(setClause.Value); err != nil {
					return fmt.Errorf("failed to format SET clause value: %w", err)
				}
			}
		}

	case "INSERT":
		f.writeKeyword("INSERT")
		if action.DefaultValues {
			f.builder.WriteString(" ")
			f.writeKeyword("DEFAULT VALUES")
		} else if len(action.Columns) > 0 {
			f.builder.WriteString(" (")
			for i, col := range action.Columns {
				if i > 0 {
					f.builder.WriteString(", ")
				}
				f.builder.WriteString(col)
			}
			f.builder.WriteString(")")
			if len(action.Values) > 0 {
				f.writeNewline()
				f.builder.WriteString(f.currentIndent())
				f.writeKeyword("VALUES")
				f.builder.WriteString(" (")
				f.formatExpressionList(action.Values, ", ")
				f.builder.WriteString(")")
			}
		} else if len(action.Values) > 0 {
			f.builder.WriteString(" ")
			f.writeKeyword("VALUES")
			f.builder.WriteString(" (")
			f.formatExpressionList(action.Values, ", ")
			f.builder.WriteString(")")
		}

	case "DELETE":
		f.writeKeyword("DELETE")

	default:
		return fmt.Errorf("unsupported merge action type: %s", action.ActionType)
	}