Contents

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

describe "COPY TO BINARY" do
  before(:all) do
    ActiveRecord::Base.connection.execute %{
      TRUNCATE TABLE test_models;
      SELECT setval('test_models_id_seq', 1, false);
}
    TestModel.create :data => 'text'
  end

  describe "should allow binary output to string" do
    context "with only binary option" do
      subject{ TestModel.copy_to_string(:format => :binary) }
      it{ should == File.open('spec/fixtures/2_col_binary_data.dat', 'r:ASCII-8BIT').read }
    end
    context "with custom select" do
      subject{ TestModel.select("id, data").copy_to_string(:format => :binary) }
      it{ should == File.open('spec/fixtures/2_col_binary_data.dat', 'r:ASCII-8BIT').read }
    end
  end

  describe "should allow binary output to file" do
    it "should copy to disk if block is not given and a path is passed" do
      TestModel.copy_to '/tmp/export.dat', :format => :binary
      str = File.open('/tmp/export.dat', 'r:ASCII-8BIT').read

      str.should == File.open('spec/fixtures/2_col_binary_data.dat', 'r:ASCII-8BIT').read
      
    end
  end

end

Version data entries

14 entries across 14 versions & 1 rubygems

Version	Path
postgres-copy-1.4.1	spec/copy_to_binary_spec.rb
postgres-copy-1.4.0	spec/copy_to_binary_spec.rb
postgres-copy-1.3.0	spec/copy_to_binary_spec.rb
postgres-copy-1.2.0	spec/copy_to_binary_spec.rb
postgres-copy-1.1.2	spec/copy_to_binary_spec.rb
postgres-copy-1.1.1	spec/copy_to_binary_spec.rb
postgres-copy-1.1.0	spec/copy_to_binary_spec.rb
postgres-copy-1.0.0	spec/copy_to_binary_spec.rb
postgres-copy-0.9.3	spec/copy_to_binary_spec.rb
postgres-copy-0.9.2	spec/copy_to_binary_spec.rb
postgres-copy-0.9.1	spec/copy_to_binary_spec.rb
postgres-copy-0.9.0	spec/copy_to_binary_spec.rb
postgres-copy-0.8.1	spec/copy_to_binary_spec.rb
postgres-copy-0.8.0	spec/copy_to_binary_spec.rb