KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Rails gurus: I've just discovered named_scope thanks to another SO user. :) I'd like to get the count of a set of rows - i.e. a SELECT COUNT(*) . Additionally, I want to still be able to chain named scopes in the call. Is this a legitimate (albeit weird) usage of named scope? named_scope :count, :select => "COUNT(*) as count_all" So then I can do (for example): @foobar = Foobar.count.scope.scope.scope The count is accessed via @foobar.first.count_all . (Edited to address Allan's comments) You could do: @foobar = Foobar.scope.scope.scope.size But this would cause a result query and not the faster SELECT COUNT(*) query. I have a large amount of rows in the database I am querying. Is there a better way to do this?
Tags (comma-separated)
Save Edits
Cancel