Contents

require 'spec_helper'

describe 'CITEXT migrations' do
  let!(:connection) { ActiveRecord::Base.connection }
  before(:all) { ActiveRecord::Base.connection.add_extension('citext') if ActiveRecord::Base.connection.supports_extensions? }
  after { connection.drop_table :data_types }
  it 'creates an citext column' do
    lambda do
      connection.create_table :data_types do |t|
        t.citext :citext_1
        t.citext :citext_2, :citext_3
        t.column :citext_4, :citext
      end
    end.should_not raise_exception

    columns = connection.columns(:data_types)
    citext_1 = columns.detect { |c| c.name == 'citext_1'}
    citext_2 = columns.detect { |c| c.name == 'citext_2'}
    citext_3 = columns.detect { |c| c.name == 'citext_3'}
    citext_4 = columns.detect { |c| c.name == 'citext_4'}

    citext_1.sql_type.should eq 'citext'
    citext_2.sql_type.should eq 'citext'
    citext_3.sql_type.should eq 'citext'
    citext_4.sql_type.should eq 'citext'
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
postgres_ext-0.2.0	spec/migrations/citext_spec.rb