Contents

require 'spec_helper'

describe 'Index schema dumper' 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 'handles index type parameters' do
    connection.add_index(:index_types, :col1, :index_type => :gin)

    stream = StringIO.new
    ActiveRecord::SchemaDumper.dump(connection, stream)
    output = stream.string

    output.should match /:index_type => :gin/
    output.should_not match /:index_type => :btree/
    output.should_not match /:index_opclass =>/
  end

  it 'handles index where clauses' do
    connection.add_index(:index_types, :col2, :where => '(col2 > 50)')

    stream = StringIO.new
    ActiveRecord::SchemaDumper.dump(connection, stream)
    output = stream.string

    output.should match /:where => "\(col2 > 50\)"/
  end

  it 'dumps index operator classes', :if => ActiveRecord::Base.connection.supports_extensions? do
    connection.add_index(:index_types, :col3, :index_type => :gin, :index_opclass => :gin_trgm_ops)

    stream = StringIO.new
    ActiveRecord::SchemaDumper.dump(connection, stream)
    output = stream.string

    output.should match /:index_type => :gin,\s+:index_opclass => :gin_trgm_ops/
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

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