Contents

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

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

  describe ".copy_to_string" do
    context "with no options" do
      subject{ TestModel.copy_to_string }
      it{ should == File.open('spec/fixtures/comma_with_header.csv', 'r').read }
    end

    context "with tab as delimiter" do
      subject{ TestModel.copy_to_string :delimiter => "\t" }
      it{ should == File.open('spec/fixtures/tab_with_header.csv', 'r').read }
    end
  end

  describe ".copy_to" do
    it "should copy and pass data to block if block is given and no path is passed" do
      File.open('spec/fixtures/comma_with_header.csv', 'r') do |f|
        TestModel.copy_to do |row|
          row.should == f.readline
        end
      end
    end

    it "should copy to disk if block is not given and a path is passed" do
      TestModel.copy_to '/tmp/export.csv'
      File.open('spec/fixtures/comma_with_header.csv', 'r') do |fixture|
        File.open('/tmp/export.csv', 'r') do |result|
          result.read.should == fixture.read
        end
      end
    end

    it "should raise exception if I pass a path and a block simultaneously" do
      lambda do
        TestModel.copy_to('/tmp/bogus_path') do |row|
        end
      end.should raise_error
    end
  end
end

Version data entries

10 entries across 10 versions & 1 rubygems

Version	Path
postgres-copy-1.1.2	spec/copy_to_spec.rb
postgres-copy-1.1.1	spec/copy_to_spec.rb
postgres-copy-1.1.0	spec/copy_to_spec.rb
postgres-copy-1.0.0	spec/copy_to_spec.rb
postgres-copy-0.9.3	spec/copy_to_spec.rb
postgres-copy-0.9.2	spec/copy_to_spec.rb
postgres-copy-0.9.1	spec/copy_to_spec.rb
postgres-copy-0.9.0	spec/copy_to_spec.rb
postgres-copy-0.8.1	spec/copy_to_spec.rb
postgres-copy-0.8.0	spec/copy_to_spec.rb