Class ActiveRecord::ConnectionAdapters::PostgreSQLAdapter::QuotingTest < ActiveRecord::TestCase

# File activerecord/test/cases/adapters/postgresql/quoting_test.rb, line 8
def setup
  @conn = ActiveRecord::Base.connection
end

# File activerecord/test/cases/adapters/postgresql/quoting_test.rb, line 67
def test_quote_bit_string
  c = PostgreSQLColumn.new(nil, 1, OID::Bit.new)
  assert_equal nil, @conn.quote("'); SELECT * FROM users; /*\n01\n*/--", c)
end

# File activerecord/test/cases/adapters/postgresql/quoting_test.rb, line 48
def test_quote_cast_numeric
  fixnum = 666
  c = PostgreSQLColumn.new(nil, nil, Type::String.new, 'varchar')
  assert_equal "'666'", @conn.quote(fixnum, c)
  c = PostgreSQLColumn.new(nil, nil, Type::Text.new, 'text')
  assert_equal "'666'", @conn.quote(fixnum, c)
end

# File activerecord/test/cases/adapters/postgresql/quoting_test.rb, line 42
def test_quote_float_infinity
  infinity = 1.0/0
  c = PostgreSQLColumn.new(nil, 1, OID::Float.new, 'float')
  assert_equal "'Infinity'", @conn.quote(infinity, c)
end

# File activerecord/test/cases/adapters/postgresql/quoting_test.rb, line 36
def test_quote_float_nan
  nan = 0.0/0
  c = PostgreSQLColumn.new(nil, 1, OID::Float.new, 'float')
  assert_equal "'NaN'", @conn.quote(nan, c)
end

# File activerecord/test/cases/adapters/postgresql/quoting_test.rb, line 61
def test_quote_range
  range = "1,2]'; SELECT * FROM users; --".."a"
  c = PostgreSQLColumn.new(nil, nil, OID::Range.new(Type::Integer.new, :int8range))
  assert_equal "'[1,0]'", @conn.quote(range, c)
end

# File activerecord/test/cases/adapters/postgresql/quoting_test.rb, line 56
def test_quote_time_usec
  assert_equal "'1970-01-01 00:00:00.000000'", @conn.quote(Time.at(0))
  assert_equal "'1970-01-01 00:00:00.000000'", @conn.quote(Time.at(0).to_datetime)
end

# File activerecord/test/cases/adapters/postgresql/quoting_test.rb, line 24
def test_type_cast_cidr
  ip = IPAddr.new('255.0.0.0/8')
  c = PostgreSQLColumn.new(nil, ip, OID::Cidr.new, 'cidr')
  assert_equal ip, @conn.type_cast(ip, c)
end

# File activerecord/test/cases/adapters/postgresql/quoting_test.rb, line 18
def test_type_cast_false
  c = PostgreSQLColumn.new(nil, 1, Type::Boolean.new, 'boolean')
  assert_equal 'f', @conn.type_cast(false, nil)
  assert_equal 'f', @conn.type_cast(false, c)
end

# File activerecord/test/cases/adapters/postgresql/quoting_test.rb, line 30
def test_type_cast_inet
  ip = IPAddr.new('255.1.0.0/8')
  c = PostgreSQLColumn.new(nil, ip, OID::Cidr.new, 'inet')
  assert_equal ip, @conn.type_cast(ip, c)
end

# File activerecord/test/cases/adapters/postgresql/quoting_test.rb, line 12
def test_type_cast_true
  c = PostgreSQLColumn.new(nil, 1, Type::Boolean.new, 'boolean')
  assert_equal 't', @conn.type_cast(true, nil)
  assert_equal 't', @conn.type_cast(true, c)
end