[Rails] Why does Rails convert scopes to downcase

Ruby on Rails Sunday, September 15, 2013

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 rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
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.

Ruby on Rails