Method formatFile

cmd/gosqlx/cmd/formatter.go:168–202

formatFile formats a single SQL file

(filename string)

// formatFile formats a single SQL file
func (f *Formatter) formatFile(filename string) FileFormatterResult {
	result := FileFormatterResult{
		Path: filename,
	}

	// Use security validation first
	if err := ValidateFileAccess(filename); err != nil {
		result.Error = fmt.Errorf("file access validation failed: %w", err)
		return result
	}

	// G304: Path is validated by ValidateFileAccess above
	data, err := os.ReadFile(filename) // #nosec G304
	if err != nil {
		result.Error = fmt.Errorf("failed to read file: %w", err)
		return result
	}

	original := string(data)
	if len(data) == 0 {
		result.Formatted = original
		result.Changed = false
		return result
	}

	formatted, err := f.formatSQL(original)
	if err != nil {
		result.Error = err
		return result
	}

	result.Formatted = formatted
	result.Changed = (original != formatted)
	return result
}

// formatSQL formats a SQL string
func (f *Formatter) formatSQL(sql string) (string, error) {