Location.ransack(locatable_of_House_type_number_eq: 100).result

# You can run this file directly using `ruby` command
# Given bundler and rspec 3 are installed globally
# It might be different if you are using rspec 2
require 'bundler/inline'
require 'rspec/autorun'
require 'rspec/core/formatters/progress_formatter'
require 'rspec/core/profiler'

# TODO: Define dependencies
gemfile true do
  source 'https://rubygems.org'
  gem 'sqlite3'
  gem 'rspec-expectations'

  gem 'activerecord', '~> 5.2', require: %w[active_record active_record/relation]
  gem 'activesupport', require: 'active_support/dependencies/autoload'
  gem 'ransack', github: 'activerecord-hackery/ransack', ref: '6434e3bedfbf4cc5d97d33c84d10682970a95083'
end

ActiveRecord::Base.establish_connection(adapter: 'sqlite3', database: ':memory:')

ActiveRecord::Schema.define do
  create_table :houses, force: true do |t|
  end

  create_table :locations, force: true do |t|
    t.references :locatable, polymorphic: true
  end
end

class House < ActiveRecord::Base
  has_one :location, as: :locatable
end

class Location < ActiveRecord::Base
  belongs_to :locatable, polymorphic: true
end

RSpec.describe Location, type: :model do
  it 'queries correctly' do
    expect(Location.ransack(locatable_of_House_type_id_eq: 123).result.to_sql).to eq(<<-SQL.squish)
      SELECT "locations".*
      FROM "locations"
      LEFT OUTER JOIN "houses" ON "houses"."id" = "locations"."locatable_id"
      WHERE "houses"."id" = 123
        AND "locations"."locatable_type" = 'House'
    SQL
end