Displaying 20 results from an estimated 8000 matches similar to: "counter_cache is making a redundant SELECT before UPDATE"
2006 Jul 11
1
counter_cache, has_many and belongs_to
I am a bit confused about counter_cache here. The API docs
http://api.rubyonrails.org/classes/ActiveRecord/Associations/ClassMethods.html
say that only the belongs_to association can take the :counter_cache
option. When I try to use it on a has_many I get an "unknown key(s):
counter_cache" error.
Why would this be the case? belongs_to means that this model has a
field with an id
2006 Apr 18
1
what happened to my increment_counter method?
this used to work for me. i started re-writing my little app and now
it doesn''t work.
here''s my models:
class Company < ActiveRecord::Base
has_many :people
end
class Person < ActiveRecord::Base
belongs_to :Company, :counter_cache => true
end
then i go into my console and say:
c = Company.find(:first)
c.increment_counter
and its all like "waaaaaaH"
2007 Jun 01
2
Ferret FileNotFound error after adding counter_cache to mode
I have a model that I''ve been indexing and searching with ferret with no
problems.
I just added a counter_cache for some voting functionality to the same
model and now when I perform the voting fxn on an object from that
model, I get the FileNotFound error as it looks for a file named
"_1c_1.del" ...which breaks my voting function.
I tried killing the server and my index
2006 Jun 08
2
counter_cache is not looking for children_count with acts_as_tree
Hi there, the acts_as_tree API says that I can set a counter cache and
that it will automatically increment the "children_count" column. I
did that but when I create a new page it asks for a "pages_count"
column instead.
Here is the relevant part of page.rb model:
class Page < ActiveRecord::Base
acts_as_tree :order => :position, :counter_cache => true
2006 Feb 03
2
acts_as_tree counter_cache behavior is different than API docs
Before I file a ticket, I''ll query ya''ll about this:
The API docs for acts_as_tree''s counter_cache is to create a database column
called "children_count" to hold the counter_cache. I have enabled this
option in my model. While writing tests I wrote a test for creating children
from the a parent:
message = @forum_message["parent"].find
child =
2006 Mar 12
2
counter_cache reference/tutorial
I''m trying to use counter_cache, but I''m not doing something right.
It is unreliable and I keep having to correct it manually. Is there a
good tutorial or reference on how to use it on-line? I have the AWDR
book, but I need something more complete.
TIA,
Jeffrey
2006 Mar 24
6
Should counter_cache fields be saved in the database?
As far as I can tell, the counter_cache option on a belongs_to model
doesn''t actually save anything in the database. For example, I have
the following models:
class Parent < ActiveRecord::Base
has_many :children,
:conditions => "deleted_at IS NULL"
end
class Child < ActiveRecord::Base
belongs_to :parent, :counter_cache => true
end
With the following
2006 May 22
3
STI, HABTM & counter_cache
Hello world...
I have an interesting issue that the online docs aren''t helping me with.
In my app I have 4 models
Item < ActiveRecord
Deal < Item
Product < Item
Category < ActiveRecord
Item has_and_belongs_to_many :categories...
On each category record I''d like to maintain a product_count and deal_count
to increase performance. This doesn''t appear
2006 Aug 12
2
Very weird counter_cache behavior
Hi All,
I''m using a counter_cache, which I believe I''m doing correctly because I
can see this SQL query being executed in the development.log file:
UPDATE gifts SET bookmarks_count = bookmarks_count + 1 WHERE (id = 276)
However, in the gifts table, the bookmarks_count field isn''t incremented
(it''s zero). If I literally copy and paste that query into the
2007 May 14
3
Counter Problem
Hi. I have a problem with counters in Rails. The situation looks like
this:
-3 simple models
class Forum < ActiveRecord::Base
has_many :posts
end
class Topic < ActiveRecord::Base
has_many :posts
end
class Post < ActiveRecord::Base
belongs_to :topic, :counter_cache => true
belongs_to :forum, :counter_cache => true
end
- In migrations i have declared
t.column :posts_count,
2005 Mar 01
0
acts_as_tree counter_cache
Hi List,
I''m new to and hot on RoR.
And I have a question regarding acts_as_tree and counter_cache.
What methods actually update the counter_cache column?
I''ve only really started the app so i''ve just got it set up so that I
can select the parent node (from a list of nodes that exclude all
descendants of the current node) with a radio buttoned list named and
valued
2006 Feb 27
0
Better counter_caches
Hey everybody,
Rails currently offers ''belongs_to :counter_cache'', which is a very
basic replacement for count triggers:
":counter_cache - caches the number of belonging objects on the
associate class through use of increment_counter and decrement_counter.
The counter cache is incremented when an object of this class is created
and decremented when it?s destroyed. This
2006 Apr 12
0
counter_cache and updates
I''m trying to figure out how to use counter_cache.
I''ve got Clients that have many Profiles. And I got things working so that
when I add a new Profile, the profiles_count gets updated.
profile = client.profiles.new(params[:profile])
profile.save
However, I''m stuck trying to figure out how to deal with UPDATING a profile
(moving it to a different Client). If I change
2006 Mar 08
0
How to add something similar to :counter_cache - :avg_cache
Hi,
I was thinking of doing this with a stored procedure, but I thought it
could be better implemented in Rails.
I have several tables that hold a counter cache for other tables,
which aren''t directly related. For example:
Table ''schools'' has records that belong_to table ''counties'', and that
table has records that belong_to table
2005 Dec 14
0
counter_cache not updating
Hi
I'm using those 2 models:
class Topic < ActiveRecord::Base
has_many :articles, :order => :rank
end
class Article < ActiveRecord::Base
belongs_to :topic, :counter_cache => true
end
The "counter_cache" column in the "topics" table does increase when
adding a new article, but it does not update when updating article's
topic or when deleting the
2006 Apr 16
2
conditional updated_on update
Hi list,
I''ve got some counter_caches in a model. When these get incremented - say on
a page view - my updated_on column also gets updated. How can I
conditionally not update updated_on if just these counter_cache columns
change?
The problem with that is that I am using acts_as_versioned which clones the
record each time updated_on changes. I am successfully ignoring the
counter_cache
2006 Apr 07
2
errors.add_to_base
What are the limitations on using:
errors.add_to_base
to display errors in views?
I have tried for days to add errors from my object.rb and they never get
displayed.
class Keyword < ActiveRecord::Base
validates_presence_of(:name, :message => "Name is required.")
validates_uniqueness_of(:name, :message => "This name is already in
use. Please try
2008 Oct 31
0
Loading fixtures and counter_cache
Hi everyone,
Does anybody know who is responsible for updating *_count columns
(via :counter_cache) when creating the db and loading fixtures? In my
case, the *_count elements remain zero!
Thanks,
Omid
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send
2006 Mar 18
4
Accessing overridden method
I have two model classes:
class Item < ActiveRecord::Base
belongs_to :channel, :counter_cache => true
validates_presence_of :channel
end
class Channel < ActiveRecord::Base
has_many :items, :dependent => true
end
In the Channel controller I have variable channel.items, an Array of
Items. I would like to use the Array find method. However,
channel.items.find() is a Rails
2007 Sep 12
1
Counter cache like plugin for sum
Hi list,
Is there a plugin similar to counter_cache except for caching sums
instead of counts? The reason I ask is for performance and convenience
for reporting.
--~--~---------~--~----~------------~-------~--~----~
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