Contents

require File.dirname(__FILE__) + '/spec_helper.rb'

include RR

require File.dirname(__FILE__) + "/../config/test_config.rb"

describe "PostgreSQL support" do
  before(:each) do
    Initializer.configuration = standard_config
  end

  after(:each) do
  end

  if Initializer.configuration.left[:adapter] == 'postgresql'

    it "should read & write microsecond times" do
      session = nil
      begin
        session = Session.new
        session.left.begin_db_transaction
        session.left.insert_record('extender_type_check',
          {'id' => 2, 'timestamp' => Time.local(2009, "feb", 16, 20, 48, 1, 543)}
        )

        org_cursor = session.left.select_cursor(
          :query => "select id, timestamp from extender_type_check where id = 2",
          :type_cast => false
        )
        cursor = TypeCastingCursor.new session.left, 'extender_type_check', org_cursor

        row = cursor.next_row
        row['timestamp'].usec.should == 543
        cursor.clear
      ensure
        session.left.rollback_db_transaction if session
      end
    end

    it "should not round microsecond times to incorrect value" do
      session = nil
      begin
        session = Session.new
        session.left.begin_db_transaction
        session.left.insert_record('extender_type_check',
          {'id' => 2, 'timestamp' => Time.local(2009, "feb", 16, 13, 37, 11, 126291)}
        )

        org_cursor = session.left.select_cursor(
          :query => "select id, timestamp from extender_type_check where id = 2",
          :type_cast => false
        )
        cursor = TypeCastingCursor.new session.left, 'extender_type_check', org_cursor

        row = cursor.next_row
        row['timestamp'].usec.should == 126291
        cursor.clear
      ensure
        session.left.rollback_db_transaction if session
      end
    end
  end
end

Version data entries

5 entries across 5 versions & 2 rubygems

Version	Path
andyjeffries-rubyrep-1.2.1	spec/postgresql_support_spec.rb
rubyrep-1.2.0	spec/postgresql_support_spec.rb
rubyrep-1.1.2	spec/postgresql_support_spec.rb
rubyrep-1.1.1	spec/postgresql_support_spec.rb
rubyrep-1.1.0	spec/postgresql_support_spec.rb