Rails - May 2011 - Just wanted to say rails 3 active relation can be rather great!

Here''s a query I just built as I build my application and learn rails:

  def self.views
    sorted
      .select("help_categories.id, help_categories.name,
COUNT(help_documents.id) AS number_of_documents")
      .joins("left outer join help_documents on help_categories.id
help_documents.category_id")
      .group(:id)
      .group(:name)
  end

I just want to say that this query works and is so much more straight-
forward compared to using Hibernate. In the Hibernate world, you first
have to make a static class to store id, name and the
number_of_documents... and the query and boiler plate is immense:

    public List<HelpCategoryView> findAllViews() {
        return getHibernateTemplate().executeFind(new
HibernateCallback<List<HelpCategoryView>>() {
            @Override
            public List<HelpCategoryView> doInHibernate(Session
session) throws HibernateException, SQLException {
                Query query = session.createQuery(
                    "select new
trainingdividend.domain.sysadmin.HelpCategoryView(" +
                    "   helpCategory.id, helpCategory.name,
count(helpDocument)) " +
                    "from HelpCategory helpCategory " +
                    "   left join helpCategory.documents helpDocument
" +
                    "group by helpCategory.id, helpCategory.name " +
                    "order by helpCategory.name asc"
                );

                return query.list();
            }
        });
    }

So congrats!

-- 
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.