Method formatAlterTableOperation

cmd/gosqlx/cmd/sql_formatter.go:498–545

formatAlterTableOperation formats a single ALTER TABLE operation

(op *ast.AlterTableOperation)

// formatAlterTableOperation formats a single ALTER TABLE operation
func (f *SQLFormatter) formatAlterTableOperation(op *ast.AlterTableOperation) {
	switch op.Type {
	case ast.AddColumn:
		f.writeKeyword("ADD")
		if op.ColumnKeyword {
			f.builder.WriteString(" ")
			f.writeKeyword("COLUMN")
		}
		if op.ColumnDef != nil {
			f.builder.WriteString(" " + op.ColumnDef.Name)
			if op.ColumnDef.Type != "" {
				f.builder.WriteString(" " + op.ColumnDef.Type)
			}
		}
	case ast.DropColumn:
		f.writeKeyword("DROP")
		if op.ColumnKeyword {
			f.builder.WriteString(" ")
			f.writeKeyword("COLUMN")
		}
		if op.ColumnDef != nil {
			f.builder.WriteString(" " + op.ColumnDef.Name)
		}
	case ast.AddConstraint:
		f.writeKeyword("ADD CONSTRAINT")
		if op.Constraint != nil && op.Constraint.Name != "" {
			f.builder.WriteString(" " + op.Constraint.Name)
		}
	case ast.DropConstraint:
		f.writeKeyword("DROP CONSTRAINT")
		if op.ConstraintName != nil {
			f.builder.WriteString(" " + op.ConstraintName.String())
		}
	case ast.RenameColumn:
		f.writeKeyword("RENAME COLUMN")
		if op.OldColumnName != nil {
			f.builder.WriteString(" " + op.OldColumnName.String())
		}
		f.builder.WriteString(" ")
		f.writeKeyword("TO")
		if op.NewColumnName != nil {
			f.builder.WriteString(" " + op.NewColumnName.String())
		}
	default:
		// Fallback for unsupported operations
		f.builder.WriteString("...")
	}
}

// formatWithClause formats WITH (CTE) clauses
func (f *SQLFormatter) formatWithClause(with *ast.WithClause) error {