Squeel breaks AR Hash conditions

[dnagir]

Before adding squeel I had this query:

Property.joins(:reservations).
  where(properties: {status: :reserved}).
  where(reservations: {status: :active, reservation_type: :online_payment, reservation_fee_received: false}).
  where("reservations.fee_due_at < ?", DateTime.now)

it breaks now with:

ActiveRecord::StatementInvalid:
       PG::Error: ERROR:  column properties.reserved does not exist
       LINE 1: ...= "properties"."id" WHERE "properties"."status" = "propertie...
                                                                    ^
       : SELECT properties.id FROM "properties" INNER JOIN "reservations" ON "reservations"."property_id" = "properties"."id" WHERE "properties"."status" = "properties"."reserved" AND (("reservations"."status" = "reservations"."active" AND "reservations"."reservation_type" = "reservations"."online_payment" AND "reservations"."reservation_fee_received" = 'f')) AND (reservations.fee_due_at < '2012-04-21 06:22:20')

Apparently, squeel seems to bea bit intrusive changing some of the AR behaviour.

I guess there's something to do with the nested Hash conditions.

But hey, apart from this it was a drop-in add-on for AR. I must have been lucky :)

[ernie]

It's not the hash conditions but the symbol values. If you change them
to strings you should be fine.

Sent from my iPhone

On Apr 19, 2012, at 1:25 AM, Dmytrii Nagirniak
reply@reply.github.com
wrote:

Before adding squeel I had this query:

Property.joins(:reservations).
 where(properties: {status: :reserved}).
 where(reservations: {status: :active, reservation_type: :online_payment, reservation_fee_received: false}).
 where("reservations.fee_due_at < ?", DateTime.now)

it breaks now with:

ActiveRecord::StatementInvalid:
      PG::Error: ERROR:  column properties.reserved does not exist
      LINE 1: ...= "properties"."id" WHERE "properties"."status" = "propertie...
                                                                   ^
      : SELECT properties.id FROM "properties" INNER JOIN "reservations" ON "reservations"."property_id" = "properties"."id" WHERE "properties"."status" = "properties"."reserved" AND (("reservations"."status" = "reservations"."active" AND "reservations"."reservation_type" = "reservations"."online_payment" AND "reservations"."reservation_fee_received" = 'f')) AND (reservations.fee_due_at < '2012-04-21 06:22:20')

Apparently, squeel seems to bea bit intrusive changing some of the AR behaviour.

I guess there's something to do with the nested Hash conditions.

But hey, apart from this it was a drop-in add-on for AR. I must have been lucky :)

---

Reply to this email directly or view it on GitHub:
#116

[dnagir]

Gosh. The same thing again :(
Those #67, #75 keep popping again and again.

Thanks and sorry for the "invalid" issue.

[ernie]

good call. I'm actually gonna get this on the common issues wiki.