Function TestValidator_ValidateFile

cmd/gosqlx/cmd/validator_test.go:29–123

TestValidator_ValidateFile tests single file validation

(t *testing.T)

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

	tests := []struct {
		name          string
		filename      string
		content       string
		expectValid   bool
		expectError   bool
		errorContains string
	}{
		{
			name:        "valid SQL file",
			filename:    "valid.sql",
			content:     "SELECT * FROM users WHERE active = true",
			expectValid: true,
			expectError: false,
		},
		{
			name:        "valid empty file",
			filename:    "empty.sql",
			content:     "",
			expectValid: true,
			expectError: false,
		},
		{
			name:          "invalid SQL - missing table name",
			filename:      "invalid.sql",
			content:       "SELECT * FROM",
			expectValid:   false,
			expectError:   true,
			errorContains: "parsing failed",
		},
		{
			name:        "valid complex query with JOINs",
			filename:    "complex.sql",
			content:     "SELECT u.name, COUNT(o.id) FROM users u LEFT JOIN orders o ON u.id = o.user_id GROUP BY u.name",
			expectValid: true,
			expectError: false,
		},
		{
			name:        "valid window function",
			filename:    "window.sql",
			content:     "SELECT name, ROW_NUMBER() OVER (ORDER BY salary DESC) as rank FROM employees",
			expectValid: true,
			expectError: false,
		},
		{
			name:        "valid CTE",
			filename:    "cte.sql",
			content:     "WITH temp AS (SELECT id FROM users) SELECT * FROM temp",
			expectValid: true,
			expectError: false,
		},
	}

	for _, tt := range tests {
		t.Run(tt.name, func(t *testing.T) {