Method formatSQL

cmd/gosqlx/cmd/formatter.go:205–252

formatSQL formats a SQL string

(sql string)

// formatSQL formats a SQL string
func (f *Formatter) formatSQL(sql string) (string, error) {
	// Use pooled tokenizer for performance
	tkz := tokenizer.GetTokenizer()
	defer tokenizer.PutTokenizer(tkz)

	// Tokenize the SQL
	tokens, err := tkz.Tokenize([]byte(sql))
	if err != nil {
		return "", fmt.Errorf("tokenization failed: %w", err)
	}

	if len(tokens) == 0 {
		return "", nil
	}

	// Convert tokens for parser using centralized converter

	// Parse to AST with proper error handling for memory management
	p := parser.NewParser()
	parsedAST, err := p.ParseFromModelTokens(tokens)
	if err != nil {
		// Parser failed, no AST to release
		return "", fmt.Errorf("parsing failed: %w", err)
	}

	// CRITICAL: Always release AST, even on formatting errors
	defer func() {
		ast.ReleaseAST(parsedAST)
	}()

	// Configure formatter options
	indentStr := strings.Repeat(" ", f.Opts.IndentSize)
	formatterOpts := FormatterOptions{
		Indent:       indentStr,
		Compact:      f.Opts.Compact,
		UppercaseKw:  f.Opts.Uppercase,
		AlignColumns: !f.Opts.Compact, // Align columns unless in compact mode
	}

	// Create formatter and format the AST
	formatter := NewSQLFormatter(formatterOpts)
	formatted, err := formatter.Format(parsedAST)
	if err != nil {
		return "", fmt.Errorf("formatting failed: %w", err)
	}

	return formatted, nil
}

// FormatterFlags represents CLI flags for formatter command
type FormatterFlags struct {