Class: Rails::Guarddog::Checkers::SqlInjectionChecker

Inherits:
BaseChecker
  • Object
show all
Defined in:
lib/rails/guarddog/checkers/sql_injection_checker.rb

Instance Attribute Summary

Attributes inherited from BaseChecker

#findings

Instance Method Summary collapse

Methods inherited from BaseChecker

#initialize

Constructor Details

This class inherits a constructor from Rails::Guarddog::Checkers::BaseChecker

Instance Method Details

#run ⇒ Object 



5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
# File 'lib/rails/guarddog/checkers/sql_injection_checker.rb', line 5

def run
  glob_files('app/**/*.rb').each do |file|
    content = File.read(file)
    content.each_line.with_index do |line, idx|
      if line.match?(/\.where\s*\(\s*['"].*#\{/) || line.match?(/\.find_by_sql\s*\(/)
        add_finding(
          severity: :high,
          message: "Potential SQL injection: using string interpolation in queries",
          file: file,
          line: idx + 1,
          snippet: line.strip,
          remediation: "Use parameterized queries: .where('column = ?', value)"
        )
      end
    end
  end
  findings
end