Method validateFile

cmd/gosqlx/cmd/validator.go:222–291

validateFile validates a single SQL file or direct SQL input

(filename string)

// validateFile validates a single SQL file or direct SQL input
func (v *Validator) validateFile(filename string) output.FileValidationResult {
	result := output.FileValidationResult{
		Path: filename,
	}

	// Use robust input detection with security checks
	inputResult, err := DetectAndReadInput(filename)
	if err != nil {
		// Special handling for empty files - they're considered valid
		if strings.Contains(err.Error(), "file is empty") {
			result.Valid = true
			result.Size = 0
			return result
		}
		// Map file path errors to "file access validation failed" for consistency
		if strings.Contains(err.Error(), "invalid file path") || strings.Contains(err.Error(), "security validation failed") {
			result.Error = fmt.Errorf("file access validation failed: %w", err)
		} else {
			result.Error = fmt.Errorf("input processing failed: %w", err)
		}
		return result
	}

	data := inputResult.Content
	result.Size = int64(len(data))

	if len(data) == 0 {
		result.Valid = true
		return result // Empty inputs are considered valid
	}

	// Use pooled tokenizer for performance with dialect support
	tkz := tokenizer.GetTokenizer()
	defer tokenizer.PutTokenizer(tkz)

	// Configure dialect if specified
	if v.Opts.Dialect != "" {
		tkz.SetDialect(keywords.SQLDialect(v.Opts.Dialect))
	}

	// Tokenize
	tokens, err := tkz.Tokenize(data)
	if err != nil {
		result.Error = fmt.Errorf("tokenization failed: %w", err)
		return result
	}

	if len(tokens) == 0 {
		result.Valid = true
		return result
	}

	// Convert TokenWithSpan to Token using centralized converter

	// Parse to validate syntax with proper error handling for memory management
	p := parser.NewParser(parser.WithDialect(v.Opts.Dialect))
	astObj, err := p.ParseFromModelTokens(tokens)
	if err != nil {