thr3ads.net - Rails - Named Scopes and Created At [Jan 2010]

If this information is useful, please help other people find it:
Share via:

2010-Jan-02 01:34 UTC

Named Scopes and Created At

I am using named scopes in my Post model to find recently published
posts:

named_scope :recently_published, :conditions => { :published =>
true }, :order => ''created_at DESC''

Posts HABTM tags, so I have my routes for those setup as:

map.resources :tags do |tag|
  tag.resources :posts
end

So that will give me a route to use, such as:
tag_posts GET    /tags/:tag_id/posts(.:format)
{:action=>"index", :controller=>"posts"}

For the view, I find posts like this from the Posts controller:
@tag = Tag.find(params[:tag_id])
@posts = @tag.posts.recently_published

Everything works as expected except the created_at attribute for my
posts. When I print the created at timestamp in the view, it is
actually printing the created timestamp for the tag.

<%= post.created_at.strftime(''%B %d, %Y'') %> gives me
the created at
timestamp for the tag, not the post.

Can someone help me fix this issue? Thank you!

--

You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Frederick Cheung

2010-Jan-02 10:58 UTC

head link

Re: Named Scopes and Created At

On Jan 2, 1:34 am, jm <jmmon...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Everything works as expected except the created_at attribute for my
> posts. When I print the created at timestamp in the view, it is
> actually printing the created timestamp for the tag.
>
> <%= post.created_at.strftime(''%B %d, %Y'') %> gives
me the created at
> timestamp for the tag, not the post.
>
> Can someone help me fix this issue? Thank you!
By default when you access a habtm relationship like this rails does

select * from posts
inner join post_tags on ...
...

So if the join table in the middle has an attribute with the same name
as an attribute from joined table(s) they will collide. You can avoid
this by adding  :select => ''posts.*'' to your habtm
declaration

Fred

--

You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

chris.reister-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org

2010-Jan-02 16:00 UTC

head link

Re: Named Scopes and Created At

Sorry I have no time to test this, but try this:

named_scope :recently_published, :conditions => { :published =>
true }, :order => ''posts.created_at DESC''

I am pretty sure you can be specific about the table in this case.

CowboyonRails
Chris Reister

On Jan 1, 5:34 pm, jm <jmmon...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> I am using named scopes in my Post model to find recently published
> posts:
>
> named_scope :recently_published, :conditions => { :published =>
> true }, :order => ''created_at DESC''
>
> Posts HABTM tags, so I have my routes for those setup as:
>
> map.resources :tags do |tag|
>   tag.resources :posts
> end
>
> So that will give me a route to use, such as:
> tag_posts GET    /tags/:tag_id/posts(.:format)
> {:action=>"index", :controller=>"posts"}
>
> For the view, I find posts like this from the Posts controller:
> @tag = Tag.find(params[:tag_id])
> @posts = @tag.posts.recently_published
>
> Everything works as expected except the created_at attribute for my
> posts. When I print the created at timestamp in the view, it is
> actually printing the created timestamp for the tag.
>
> <%= post.created_at.strftime(''%B %d, %Y'') %> gives
me the created at
> timestamp for the tag, not the post.
>
> Can someone help me fix this issue? Thank you!
--

You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

2010-Jan-03 17:14 UTC

head link

Re: Named Scopes and Created At

Thanks for the replies. Unfortunately, neither of the solutions
worked. I tried each on their own with no luck, and then I combined
the two suggestions and still no luck.  Here is what I have for the
named scope in my Post model as of now:

named_scope :recently_published, :conditions => { :published =>
true }, :select => ''posts.*'', :order =>
''posts.created_at

Not sure if it helps, but here are the queries used to generate the
page at: http://localhost:3000/tags/1/posts

Processing PostsController#index (for ::1 at 2010-01-03 11:13:21)
[GET]
  Parameters: {"tag_id"=>"1",
"action"=>"index",
"controller"=>"posts"}
  Tag Load (0.2ms)   SELECT * FROM "tags" WHERE
("tags"."id" = 1)
Rendering template within layouts/application
Rendering posts/index
  SQL (0.2ms)   SELECT count(*) AS count_all FROM "posts" INNER JOIN
"posts_tags" ON "posts".id = "posts_tags".post_id
WHERE
((("posts"."published" = ''t'') AND
("posts_tags".tag_id = 1 )) AND
("posts_tags".tag_id = 1 ))
  Post Load (0.4ms)   SELECT * FROM "posts" INNER JOIN
"posts_tags" ON
"posts".id = "posts_tags".post_id WHERE
("posts_tags".tag_id = 1 ) AND
(("posts"."published" = ''t'') AND
("posts_tags".tag_id = 1 )) ORDER BY
posts.created_at DESC
  Category Load (0.2ms)   SELECT * FROM "categories" WHERE
("categories"."id" = 2)
  Tag Load (0.2ms)   SELECT * FROM "tags" INNER JOIN
"posts_tags" ON
"tags".id = "posts_tags".tag_id WHERE
("posts_tags".post_id = 2 )
  Category Load (0.2ms)   SELECT * FROM "categories" WHERE
("categories"."id" = 1)
  Tag Load (0.4ms)   SELECT * FROM "tags" INNER JOIN
"posts_tags" ON
"tags".id = "posts_tags".tag_id WHERE
("posts_tags".post_id = 1 )
  Category Load (0.5ms)   SELECT * FROM "categories" ORDER BY name ASC
LIMIT 5
  SQL (0.1ms)   SELECT count(*) AS count_all FROM "categories"
  Post Load (0.3ms)   SELECT posts.* FROM "posts" WHERE
("posts"."published" = ''t'') ORDER BY
posts.created_at DESC LIMIT 5
  Tag Load (0.3ms)   SELECT * FROM "tags" ORDER BY name ASC LIMIT 5
  SQL (0.1ms)   SELECT count(*) AS count_all FROM "tags"
Rendered layouts/_side_navigation (5.8ms)
Completed in 86ms (View: 20, DB: 3) | 200 OK [http://localhost/tags/1/
posts]

Thanks again for the help and suggestions!

On Jan 2, 10:00 am,
"chris.reis...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org"
<chris.reis...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> Sorry I have no time to test this, but try this:
>
> named_scope :recently_published, :conditions => { :published =>
> true }, :order => ''posts.created_at DESC''
>
> I am pretty sure you can be specific about the table in this case.
>
> CowboyonRails
> Chris Reister
>
> On Jan 1, 5:34 pm, jm
<jmmon...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
>
>
> > I am using named scopes in my Post model to find recently published
> > posts:
>
> > named_scope :recently_published, :conditions => { :published =>
> > true }, :order => ''created_at DESC''
>
> > Posts HABTM tags, so I have my routes for those setup as:
>
> > map.resources :tags do |tag|
> >   tag.resources :posts
> > end
>
> > So that will give me a route to use, such as:
> > tag_posts GET    /tags/:tag_id/posts(.:format)
> > {:action=>"index", :controller=>"posts"}
>
> > For the view, I find posts like this from the Posts controller:
> > @tag = Tag.find(params[:tag_id])
> > @posts = @tag.posts.recently_published
>
> > Everything works as expected except the created_at attribute for my
> > posts. When I print the created at timestamp in the view, it is
> > actually printing the created timestamp for the tag.
>
> > <%= post.created_at.strftime(''%B %d, %Y'') %>
gives me the created at
> > timestamp for the tag, not the post.
>
> > Can someone help me fix this issue? Thank you!
--

You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Frederick Cheung

2010-Jan-03 18:37 UTC

head link

Re: Named Scopes and Created At

On Jan 3, 5:14 pm, jm <jmmon...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:>   Post Load (0.4ms)   SELECT * FROM "posts" INNER JOIN
"posts_tags" ON
> "posts".id = "posts_tags".post_id WHERE
("posts_tags".tag_id = 1 ) AND
> (("posts"."published" = ''t'') AND
("posts_tags".tag_id = 1 )) ORDER BY
> posts.created_at DESC
This is probably the query at fault - you want to put the :select
option on the association itself, not the named scope

Fred

--

You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

2010-Jan-04 14:45 UTC

head link

Re: Named Scopes and Created At

Thank you so much! That worked perfectly! :)

On Jan 3, 12:37 pm, Frederick Cheung
<frederick.che...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> On Jan 3, 5:14 pm, jm
<jmmon...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
>
> >   Post Load (0.4ms)   SELECT * FROM "posts" INNER JOIN
"posts_tags" ON
> > "posts".id = "posts_tags".post_id WHERE
("posts_tags".tag_id = 1 ) AND
> > (("posts"."published" = ''t'') AND
("posts_tags".tag_id = 1 )) ORDER BY
> > posts.created_at DESC
>
> This is probably the query at fault - you want to put the :select
> option on the association itself, not the named scope
>
> Fred
--

You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.

Rails - Jan 2010 - Named Scopes and Created At

Named Scopes and Created At

Re: Named Scopes and Created At

Re: Named Scopes and Created At

Re: Named Scopes and Created At

Re: Named Scopes and Created At

Re: Named Scopes and Created At