Function TestFormatter_FormatFile

cmd/gosqlx/cmd/formatter_test.go:26–106

TestFormatter_FormatFile tests single file formatting

(t *testing.T)

// TestFormatter_FormatFile tests single file formatting
func TestFormatter_FormatFile(t *testing.T) {
	tmpDir := t.TempDir()

	tests := []struct {
		name          string
		filename      string
		content       string
		expectChanged bool
		expectError   bool
		errorContains string
	}{
		{
			name:          "valid SQL file - basic SELECT",
			filename:      "query.sql",
			content:       "SELECT * FROM users WHERE active = true",
			expectChanged: true, // Formatter adds indentation and newlines
			expectError:   false,
		},
		{
			name:          "valid empty file",
			filename:      "empty.sql",
			content:       "",
			expectChanged: false,
			expectError:   false,
		},
		{
			name:          "SQL needing formatting",
			filename:      "unformatted.sql",
			content:       "select*from users",
			expectChanged: true,
			expectError:   false,
		},
		{
			name:          "invalid SQL",
			filename:      "invalid.sql",
			content:       "SELECT * FROM",
			expectChanged: false,
			expectError:   true,
			errorContains: "parsing failed",
		},
	}

	for _, tt := range tests {
		t.Run(tt.name, func(t *testing.T) {
			// Create test file
			filepath := filepath.Join(tmpDir, tt.filename)
			if err := os.WriteFile(filepath, []byte(tt.content), 0644); err != nil {
				t.Fatalf("Failed to create test file: %v", err)
			}

			// Create formatter
			var outBuf, errBuf bytes.Buffer
			formatter := NewFormatter(&outBuf, &errBuf, CLIFormatterOptions{
				IndentSize: 2,
				Uppercase:  true,
				Compact:    false,
			})