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 ".pg_copy_to_string" do
    context "with no options" do
      subject{ TestModel.pg_copy_to_string }
      it{ should == File.open('spec/fixtures/comma_with_header.csv', 'r').read }
    end

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

  describe ".pg_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.pg_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.pg_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.pg_copy_to('/tmp/bogus_path') do |row|
        end
      end.should raise_error
    end
  end
end

Version data entries

11 entries across 11 versions & 1 rubygems

Version	Path
postgres-copy-0.7.0	spec/pg_copy_to_spec.rb
postgres-copy-0.6.0	spec/pg_copy_to_spec.rb
postgres-copy-0.5.8	spec/pg_copy_to_spec.rb
postgres-copy-0.5.7	spec/pg_copy_to_spec.rb
postgres-copy-0.5.5	spec/pg_copy_to_spec.rb
postgres-copy-0.5.4	spec/pg_copy_to_spec.rb
postgres-copy-0.5.3	spec/pg_copy_to_spec.rb
postgres-copy-0.5.2	spec/pg_copy_to_spec.rb
postgres-copy-0.5.0	spec/pg_copy_to_spec.rb
postgres-copy-0.4.0	spec/pg_copy_to_spec.rb
postgres-copy-0.3.6	spec/pg_copy_to_spec.rb