diff options
| author | Tarmo Tänav <tarmo@itech.ee> | 2008-05-12 17:58:03 +0300 |
|---|---|---|
| committer | Jeremy Kemper <jeremy@bitsweat.net> | 2008-06-22 16:16:06 -0700 |
| commit | 509374ebe2dba0dc2ea7e44d67a6f8d530d12fac (patch) | |
| tree | 6ee9f77d5f0d21c3921d0de8cf5c23bc4e0fe133 /activerecord/test/cases/finder_test.rb | |
| parent | 2e1b56c93745bf0513e449e95830edd390abfaf2 (diff) | |
| download | rails-509374ebe2dba0dc2ea7e44d67a6f8d530d12fac.tar.gz rails-509374ebe2dba0dc2ea7e44d67a6f8d530d12fac.tar.bz2 rails-509374ebe2dba0dc2ea7e44d67a6f8d530d12fac.zip | |
Named bind variables can now be used with postgresql-style typecasts
For example :conditions => ['stringcol::integer = :var', { :var => 10 }]
will no longer raise an exception about ':integer' having a missing value.
Diffstat (limited to 'activerecord/test/cases/finder_test.rb')
| -rw-r--r-- | activerecord/test/cases/finder_test.rb | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/activerecord/test/cases/finder_test.rb b/activerecord/test/cases/finder_test.rb index 80936d51f3..f48b62ba6b 100644 --- a/activerecord/test/cases/finder_test.rb +++ b/activerecord/test/cases/finder_test.rb @@ -1,5 +1,6 @@ require "cases/helper" require 'models/author' +require 'models/categorization' require 'models/comment' require 'models/company' require 'models/topic' @@ -394,6 +395,12 @@ class FinderTest < ActiveRecord::TestCase assert_equal '1,1,1', bind('?', os) end + def test_named_bind_with_postgresql_type_casts + l = Proc.new { bind(":a::integer '2009-01-01'::date", :a => '10') } + assert_nothing_raised(&l) + assert_equal "#{ActiveRecord::Base.quote_value('10')}::integer '2009-01-01'::date", l.call + end + def test_string_sanitation assert_not_equal "#{ActiveRecord::Base.connection.quoted_string_prefix}'something ' 1=1'", ActiveRecord::Base.sanitize("something ' 1=1") assert_equal "#{ActiveRecord::Base.connection.quoted_string_prefix}'something; select table'", ActiveRecord::Base.sanitize("something; select table") |