vendor/rails/activerecord/test/cases/sanitize_test.rb

   1 require "cases/helper"
   2 require 'models/binary'
   3
   4 class SanitizeTest < ActiveRecord::TestCase
   5   def setup
   6   end
   7
   8   def test_sanitize_sql_array_handles_string_interpolation
   9     quoted_bambi = ActiveRecord::Base.connection.quote_string("Bambi")
  10     assert_equal "name=#{quoted_bambi}", Binary.send(:sanitize_sql_array, ["name=%s", "Bambi"])
  11     assert_equal "name=#{quoted_bambi}", Binary.send(:sanitize_sql_array, ["name=%s", "Bambi".mb_chars])
  12     quoted_bambi_and_thumper = ActiveRecord::Base.connection.quote_string("Bambi\nand\nThumper")
  13     assert_equal "name=#{quoted_bambi_and_thumper}",Binary.send(:sanitize_sql_array, ["name=%s", "Bambi\nand\nThumper"])
  14     assert_equal "name=#{quoted_bambi_and_thumper}",Binary.send(:sanitize_sql_array, ["name=%s", "Bambi\nand\nThumper".mb_chars])
  15   end
  16
  17   def test_sanitize_sql_array_handles_bind_variables
  18     quoted_bambi = ActiveRecord::Base.connection.quote("Bambi")
  19     assert_equal "name=#{quoted_bambi}", Binary.send(:sanitize_sql_array, ["name=?", "Bambi"])
  20     assert_equal "name=#{quoted_bambi}", Binary.send(:sanitize_sql_array, ["name=?", "Bambi".mb_chars])
  21     quoted_bambi_and_thumper = ActiveRecord::Base.connection.quote("Bambi\nand\nThumper")
  22     assert_equal "name=#{quoted_bambi_and_thumper}", Binary.send(:sanitize_sql_array, ["name=?", "Bambi\nand\nThumper"])
  23     assert_equal "name=#{quoted_bambi_and_thumper}", Binary.send(:sanitize_sql_array, ["name=?", "Bambi\nand\nThumper".mb_chars])
  24   end
  25 end