how to write Rails 4 scope for SQL statement?

Question

Currently I am upgrading my application to rails 4.i know there are some syntax changes made for writing scopes in rails4 for SQL statement. below is the scope in rails 3:

scope :current_active_leases,     group("leases.id").where("leases.commencement <= ? and (leases.expiration >= ? or leases.mtm=?) and leases.is_executed= ? ", Time.now.strftime("%Y-%m-%d"), Time.now.strftime("%Y-%m-%d"), true, true)

how to rewrite this in rails 4

You have error in your scope. It should be placed in lambda - otherwise your dates are evaluated once, at class code execution. This addresses to Rails 3 also. — Marek Lipka
– Marek Lipka, Commented Nov 26, 2013 at 9:45

Sabyasachi Ghosh · Accepted Answer · 2013-11-26 09:45:02Z

1

I guess what ever you have written should work but in rails 4 you should write like

scope :current_active_leases,  -> {group("leases.id").where("leases.commencement <= ? and (leases.expiration >= ? or leases.mtm=?) and leases.is_executed= ? ", Time.now.strftime("%Y-%m-%d"), Time.now.strftime("%Y-%m-%d"), true, true) }

Check the documentation http://api.rubyonrails.org/classes/ActiveRecord/Scoping/Named/ClassMethods.html#method-i-scope

answered Nov 26, 2013 at 9:45

Sabyasachi Ghosh

2,78524 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

how to write Rails 4 scope for SQL statement?

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