#668 Dynamic scopes and dynamic finders for belongs_to - Ruby on Rails

Type	To find
responsible:me	tickets assigned to you
tagged:"@high"	tickets tagged @high
milestone:next	tickets in the upcoming milestone
state:invalid	tickets with the state invalid
created:"last week"	tickets created last week
sort:number, importance, updated	tickets sorted by #, importance or updated
Combine keywords for powerful searching.
Use advanced searching »

This project is archived and is in readonly mode.

#668 ✓stale

Dynamic scopes and dynamic finders for belongs_to

Reported by Lawrence Pit | July 21st, 2008 @ 09:43 AM | in 2.x

This patch consists of two changes:

1. the dynamic finders now accept belongs_to attributes.

2. attributes that can be used via a dynamic finder can also be directly accessed as scopes.

Example usages include:

  comments = Comment.find_by_creator(current_user)

  comments = Comment.creator(current_user).commentable(post).all

  posts = Post.creator(current_user).published.my_named_scope.last

  cases = Case.status("OPEN").priority("HIGH").my_named_scope.all

The main advantage of this patch is that it allows easy formation of dynamic queries based on input, without needing to explicitly define named scoped in your models. For example:

  scope = Comment.scoped({:include => [:creator, :commentable]})
  scope = scope.commentable(post) if post
  scope = scope.university(params[:uni]) if params[:uni]
  scope = scope.creator(current_user) if params[:created_by_me] == "1"
  scope = scope.country(params[:country]) if params[:country]
  @comments = scope.all

scope.diff 38.3 KB

Comments and changes to this ticket

Pratik July 21st, 2008 @ 02:37 PM
- Assigned user set to “Michael Koziarski”
You flagged this item as spam.
Ryan Bates July 21st, 2008 @ 03:47 PM
I think it's preferable to go through the has_many association whenever possible. So you could do this in the first example.
```
comments = current_user.comments
```
But for cases where you need to search on multiple belongs_to associations then I could see this being really useful.
You flagged this item as spam.
Tom Locke July 21st, 2008 @ 06:12 PM
This seems to be a bit at risk of name clashes, the following slight change might help and is perhaps more readable:
```
Comment.creator_is(current_user)
```
Then you can also have the negative form, e.g.:
```
my_post.comments.creator_is_not(some_user)
```
I also have an implementation of these and many more which I'm intending to release as a plugin.
josh October 28th, 2008 @ 04:29 PM
- State changed from “new” to “stale”
Staling out, please reopen if this is still a problem.
Ryan Bigg October 9th, 2010 @ 10:04 PM
- Tag cleared.
- Importance changed from “” to “Low”
Automatic cleanup of spam.
Ryan Bigg October 21st, 2010 @ 03:36 AM
Automatic cleanup of spam.
You flagged this item as spam.
bingbing March 26th, 2011 @ 01:24 AM
gucci watches
You flagged this item as spam.
klkk May 23rd, 2011 @ 02:53 AM
louisvuittonwarehouse.com
You flagged this item as spam.
klkk May 23rd, 2011 @ 02:55 AM
www.louisvuittonwarehouse.com