Contents

require 'postgres'
require 'test/unit'

class PostgresTestCase < Test::Unit::TestCase

  def setup
    @conn = PGconn.new('dbname' => 'template1')
  end

  def teardown
    @conn.close
  end

  def test_conversion
    query = <<-EOT
select true as true_value,
       false as false_value,
       $1::bytea as bytea_value,
       '2005-11-30'::date as date_value,
       '12:00:00'::time as time_value,
       '2005-11-30 12:00:00'::timestamp as date_time_value,
       1.5::float as float_value,
       12345.5678::numeric as numeric_value,
       1234.56::numeric(10) as numeric_10_value,
       12345.12345::numeric(10,5) as numeric_10_5_value
EOT
    res = @conn.exec(query, '12345\111\000\111TEST')
    assert_equal(res.num_tuples, 1)
    assert_equal(res.num_fields, 10)
    tuple = res.result.first
    assert_equal(true, tuple['true_value'])
    assert_equal(false, tuple['false_value'])
    assert_equal("12345I\000ITEST", tuple['bytea_value'])
    assert_equal(Date.parse('2005-11-30'), tuple['date_value'])
    assert_equal(Time.parse('12:00:00'), tuple['time_value'])
    assert_equal(DateTime.parse('2005-11-30 12:00:00'), tuple['date_time_value'])
    assert_equal(1.5, tuple['float_value'])
    assert_equal(BigDecimal("12345.5678"), tuple['numeric_value'])
    assert_equal(1235, tuple['numeric_10_value'])
    assert_kind_of(Integer, tuple['numeric_10_value'])
    assert_equal(BigDecimal("12345.12345"), tuple['numeric_10_5_value'])
  end

end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
ruby-postgres-0.7.1.2005.12.19-mswin32	tests/tc_postgres.rb
ruby-postgres-0.7.1.2005.12.19	tests/tc_postgres.rb