sandheepg/rails-construct-finder-sql.md

Last active March 8, 2017 08:09

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/sandheepg/662150f43587ed078874d7cad6cc32cb.js"></script>
Save sandheepg/662150f43587ed078874d7cad6cc32cb to your computer and use it in GitHub Desktop.

Retrieve SQL query in Rails 2.x

Raw

The method is construct_finder_sql(options) (lib/active_record/base.rb:1681) You will have to use send because it is private.

sql = Item.send :construct_finder_sql, :select => :all, :include => [:categories, :prices], :conditions => conditions

sql = ActionType.send :construct_finder_sql, :select => 'hosted, top_action_type, count(*) as count', :group => 'hosted, top_action_type'