Contents

require "spec_helper"

class Search < ActiveRecord::Base; end

describe Scenic::ActiveRecord::SchemaDumper, :db do
  it "dumps a create_view for a view in the database" do
    view_definition = "SELECT 'needle'::text AS haystack"
    Search.connection.create_view :searches, sql_definition: view_definition
    stream = StringIO.new

    ActiveRecord::SchemaDumper.dump(Search.connection, stream)

    output = stream.string
    expect(output).to include "create_view :searches"
    expect(output).to include view_definition

    Search.connection.drop_view :searches

    silence_stream(STDOUT) { eval(output) }

    expect(Search.first.haystack).to eq "needle"
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
scenic-0.1.0	spec/scenic/active_record/schema_dumper_spec.rb