How to query multiple tables with ActiveRecord?

Question

I am trying to figure out how to write the equivalent of this query in ActiveRecord:

SELECT id FROM projects, neighborhoods
WHERE ST_WITHIN(projects.lonlat, neighorhoods.the_geom);

I tried several approaches, including

Neighborhood.select(:id).from('projects').where("ST_WITHIN(projects.lonlat, neighorhoods.the_geom)")

But the resulting query always resolves to a single table. Can anyone help me out?

Dan Kohn · Accepted Answer · 2015-02-07 04:07:44Z

2

Make use of the amazing tool scuttle.io to covert SQL to Arel:

Neighborhood.select(:id).where(
  Arel::Nodes::NamedFunction.new(
    'ST_WITHIN', [
      Project.arel_table[:lonlat], Neighorhood.arel_table[:the_geom]
    ]
  )
)

answered Feb 7, 2015 at 4:07

Dan Kohn

34.4k9 gold badges91 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to query multiple tables with ActiveRecord?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related