Rails find_by_sql with same field names in select

Question

I want to run next code in Rails:

boatData = Boat.find_by_sql(["SELECT bm.name as name1, bt.name as name2 
                                  FROM boat_models bm, boat_types bt, boats b
                                  WHERE b.id = ?
                                  AND bm.id = b.boat_model_id
                                  AND bt.id = bm.boat_type_id", boatId]).first
    puts "boatData=" + boatData.inspect
    description = "Booking: " + boatData[:name1] + "(" + boatData[:name2].to_s + ")"

The only problem is the fields in the select have the same name. When I try to add "as" the results are not right.

UPDATE:

This it the output of puts "boatData=" + boatData.inspect

boatData=#<BoatModel id: nil, name: "Velero">

what do you mean by "not right"?

Raj
– Raj

2014-03-11 13:14:47 +00:00
Commented Mar 11, 2014 at 13:14 — Raj
– Raj, Commented Mar 11, 2014 at 13:14
See my updated comment

Rober
– Rober

2014-03-11 13:30:51 +00:00
Commented Mar 11, 2014 at 13:30 — Rober
– Rober, Commented Mar 11, 2014 at 13:30

zwippie · Accepted Answer · 2014-03-11 14:03:56Z

1

I could be very wrong, but it looks like you just want to select a Boat and then get the model and type name for that boat.

If I understand your data model correctly, you can use:

boat = Boat.find(boatId)
modelName = boat.boat_model.name
typeName = boat.boat_model.boat_type.name

answered Mar 11, 2014 at 14:03

zwippie

15.6k3 gold badges44 silver badges58 bronze badges

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

Collectives™ on Stack Overflow

Rails find_by_sql with same field names in select

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