SQL Injection in Filter example
evan-duncan opened this issue · 1 comments
evan-duncan commented
The wiki page for filters includes examples that will open up users to SQL injection.
# easy use case:
filter(:name, :string) { |value| where("name ilike '%#{value}%'") }
You should update all example queries that are not properly sanitizing inputs so users less familiar with active record won't do bad things.
# easy use case:
filter(:name, :string) { |value| where("name ilike ?", "%#{value}%") }
bogdan commented
Good suggestion, btw, you can update that too.