Contents

require 'spec_helper'

describe 'Index migrations' do
  let!(:connection) { ActiveRecord::Base.connection }

  before do
    connection.create_table :index_types do |t|
      t.integer :col1, :array => true
      t.integer :col2
      t.text    :col3
    end
  end

  after { connection.drop_table :index_types }

  it 'creates special index' do
    lambda do
      connection.add_index(:index_types, :col1, :index_type => :gin)
    end.should_not raise_exception

    indexes = connection.indexes(:index_types)
    index_1 = indexes.detect { |c| c.columns.map(&:to_s) == ['col1']}

    index_1.index_type.to_s.should  eq    'gin'
  end

  it 'creates indexes with where clauses' do
    lambda do
      connection.add_index(:index_types, :col2, :where => '(col2 > 50)')
    end.should_not raise_exception

    indexes = connection.indexes(:index_types)
    index_2 = indexes.detect { |c| c.columns.map(&:to_s) == ['col2']}

    index_2.where.should            match /col2 > 50/
  end

  it 'creates indexes with operator classes', :if => ActiveRecord::Base.connection.supports_extensions? do
    lambda do
      connection.add_index(:index_types, :col3, :index_type => :gin, :index_opclass => :gin_trgm_ops)
    end.should_not raise_exception

    indexes = connection.indexes(:index_types)
    index_3 = indexes.detect { |c| c.columns.map(&:to_s) == ['col3']}

    index_3.index_type.should       eq    :gin
    index_3.index_opclass.should    eq    :gin_trgm_ops
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
postgres_ext-0.2.2	spec/migrations/index_spec.rb
postgres_ext-0.2.1	spec/migrations/index_spec.rb
postgres_ext-0.2.0	spec/migrations/index_spec.rb
postgres_ext-0.1.0	spec/migrations/index_spec.rb