I found a strange behavior in Rails 4 with scopes when I use postgres.
I have a Object with saleStartDate and saleEndDate attributes.
scope :active, -> { where(isActivate: true) }
> scope :activeDate, -> { active.where("? BETWEEN saleStartDate AND
> saleEndDate", Date.today)}
When I use sqlite, all works when I want to get the object with the
activeDate scope.
When I use postgres, I get an error "pg:error salestartdate column not
found"!
Postgres is case sensitive! So why does Rails convert saleStartDate to
salestartdate in a scope?
I changed saleStartDate to sale_start_date. Now it works.
Is it best practice to use _ and not CamelCase in scopes?
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rubyonrails-talk/162db918-b0f9-4765-bd4a-96eb4bcf5ec9%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
