Sha256: 176608ac0a2bb5dc1d0d775d6a3f6605905f71f8efd3fd4181fcfaaeb9765fdd

Contents?: true

Size: 1.02 KB

Versions: 2

Compression:

Stored size: 1.02 KB

Contents

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

require 'models/user'

describe "views" do

  let(:migration) { ::ActiveRecord::Migration }

  let(:dump) do
    stream = StringIO.new
    ActiveRecord::SchemaDumper.ignore_tables = %w[users comments]
    ActiveRecord::SchemaDumper.dump(ActiveRecord::Base.connection, stream)
    stream.string
  end

  let(:view_statement) { "SELECT * FROM users where deleted_at IS NULL" }

  it "should return views" do
    with_view "active_users", view_statement do
      migration.connection.views.should have(1).view
    end
  end

  it "should be included in schema dump" do
    with_view "active_users", view_statement do
      dump.should match /active_users/
       # I don't test view definition as it is transformed to different form
       # comparing to original statement
    end
  end

  protected
  def with_view(name, definition)
    migration.suppress_messages do
      migration.create_view name, definition
      yield
      migration.drop_view name
    end
  end

end

Version data entries

2 entries across 2 versions & 1 rubygems

Version Path
redhillonrails_core-2.0.0.pre spec/view_spec.rb
redhillonrails_core-1.2.0 spec/view_spec.rb