Function TestValidator_Validate

cmd/gosqlx/cmd/validator_test.go:126–291

TestValidator_Validate tests multi-file validation

(t *testing.T)

// TestValidator_Validate tests multi-file validation
func TestValidator_Validate(t *testing.T) {
	tmpDir := t.TempDir()

	tests := []struct {
		name               string
		files              map[string]string // filename -> content
		args               []string
		opts               ValidatorOptions
		expectTotalFiles   int
		expectValidFiles   int
		expectInvalidFiles int
		expectError        bool
		expectOutContains  []string
		expectErrContains  []string
	}{
		{
			name: "single valid file",
			files: map[string]string{
				"query1.sql": "SELECT * FROM users",
			},
			args:               []string{filepath.Join(tmpDir, "query1.sql")},
			opts:               ValidatorOptions{},
			expectTotalFiles:   1,
			expectValidFiles:   1,
			expectInvalidFiles: 0,
			expectOutContains:  []string{"✅", "query1.sql", "Valid SQL"},
		},
		{
			name: "multiple valid files",
			files: map[string]string{
				"query1.sql": "SELECT * FROM users",
				"query2.sql": "INSERT INTO users (name) VALUES ('John')",
				"query3.sql": "UPDATE users SET active = true WHERE id = 1",
			},
			args: []string{
				filepath.Join(tmpDir, "query1.sql"),
				filepath.Join(tmpDir, "query2.sql"),
				filepath.Join(tmpDir, "query3.sql"),
			},
			opts:               ValidatorOptions{},
			expectTotalFiles:   3,
			expectValidFiles:   3,
			expectInvalidFiles: 0,
			expectOutContains:  []string{"✅", "query1.sql", "query2.sql", "query3.sql"},
		},
		{
			name: "mix of valid and invalid files",
			files: map[string]string{
				"valid.sql":   "SELECT * FROM users",
				"invalid.sql": "SELECT * FROM",
			},
			args: []string{
				filepath.Join(tmpDir, "valid.sql"),
				filepath.Join(tmpDir, "invalid.sql"),
			},
			opts:               ValidatorOptions{},
			expectTotalFiles:   2,
			expectValidFiles:   1,