Re: How to find comment count for each post?

2007-11-11 Thread Adam Royle 

I would keep the comment count in a field of its own in the posts
table (eg. comments_count), and update the value automatically
whenever a comment is saved or deleted. The beauty of this code is
that you don't need to change your controller code in any way (unless
you are updating the table using raw queries or using deleteAll(),
which doesn't use callbacks during the operation (yet)).

Please note this code is off-the-cuff and untested, but I do a similar
thing in one of my projects.


class Comment extends AppModel {

var $name = 'Comment';
var $belongsTo = array('Post');

var $_tempPostId;

function afterSave($created) {
$this-updateCommentCount($this-data['Comment']['post_id']);
}

function beforeDelete() {
$this-_tempPostId = $this-field('post_id');
return true;
}

function afterDelete() {
if ($this-_tempPostId) {
$this-updateCommentCount($this-_tempPostId);
$this-_tempPostId = null;
}
}

function updateCommentCount($post_id) {
$count = $this-findCount(array('post_id' = $post_id));
$this-Post-save( array('id' = $post_id, 'comments_count' =
$count) );
}

}


Cheers,
Adam

On Nov 10, 1:55 pm, Action [EMAIL PROTECTED] wrote:
 I want to be able to retrieve multiple blog posts as well as the
 comment count for each post. I do not want to retrieve the comments
 themselves, just the comment count.

 This is what I have so far:

 $this-Post-unbindModel(array('hasMany' = array('Comment')));

 $this-set('data', $this-Post-find('all', array('order' = 'created
 DESC')));

 I unbound the model association so it wouldn't pull the comments in
 the query. How can I make it so the find() as also grabs the comment
 count for each post it is grabbing?

 If I kept the association it would work, but I would have to also pull
 all of the comment data as well, which is something I don't want to
 do.

 Thanks.


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake 
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---

Re: How to find comment count for each post?

2007-11-10 Thread R. Rajesh Jeba Anbiah 

On Nov 10, 8:55 am, Action [EMAIL PROTECTED] wrote:
 I want to be able to retrieve multiple blog posts as well as the
 comment count for each post. I do not want to retrieve the comments
 themselves, just the comment count.
   snip

1. http://bin.cakephp.org/saved/2247
2. http://groups.google.com/group/cake-php/web/frequent-discussions

--
  ?php echo 'Just another PHP saint'; ?
Email: rrjanbiah-at-Y!comBlog: http://rajeshanbiah.blogspot.com/


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake 
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---

Re: How to find comment count for each post?

2007-11-10 Thread Action 

Here's what I have:

$this-Post-unbindModel(array('hasMany' = array('Comment')));
$this-Post-bindModel(array('hasMany' = array('Comment' =
array('className' = 'Comment', 'fields' = array('count');

$this-set('data', $this-Post-find('all', array('order' =
'created DESC')));

I get the following error: Unknown column 'Comment.count' in 'field
list'.

Where do I specify that I'm looking for just the count? I think in the
way I currently have it, it's trying to find a column called count
which doesn't exist.


On Nov 10, 1:57 am, francky06l [EMAIL PROTECTED] wrote:
 You bind your model again, using 'fields' option to set the fields you
 want :

 $this-Post-bindModel(array('hasMany' = array('Comment' =
 array('className' = 'Comment',
  'fields' = array('field you
 want';

 On Nov 10, 4:55 am, Action [EMAIL PROTECTED] wrote:

  I want to be able to retrieve multiple blog posts as well as the
  comment count for each post. I do not want to retrieve the comments
  themselves, just the comment count.

  This is what I have so far:

  $this-Post-unbindModel(array('hasMany' = array('Comment')));

  $this-set('data', $this-Post-find('all', array('order' = 'created
  DESC')));

  I unbound the model association so it wouldn't pull the comments in
  the query. How can I make it so the find() as also grabs the comment
  count for each post it is grabbing?

  If I kept the association it would work, but I would have to also pull
  all of the comment data as well, which is something I don't want to
  do.

  Thanks.


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake 
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---

Re: How to find comment count for each post?

2007-11-10 Thread Action 

I currently have it so the association just pulls in the post_id for
each comment then I just count() that array in the view for the
comment count:

$this-Post-bindModel(array('hasMany' = array('Comment' =
array('fields' = array('post_id');
$this-set('data', $this-Post-find('all', array('order' =
'created DESC')));

Is there a better way to do this?

On Nov 10, 1:57 am, francky06l [EMAIL PROTECTED] wrote:
 You bind your model again, using 'fields' option to set the fields you
 want :

 $this-Post-bindModel(array('hasMany' = array('Comment' =
 array('className' = 'Comment',
  'fields' = array('field you
 want';

 On Nov 10, 4:55 am, Action [EMAIL PROTECTED] wrote:

  I want to be able to retrieve multiple blog posts as well as the
  comment count for each post. I do not want to retrieve the comments
  themselves, just the comment count.

  This is what I have so far:

  $this-Post-unbindModel(array('hasMany' = array('Comment')));

  $this-set('data', $this-Post-find('all', array('order' = 'created
  DESC')));

  I unbound the model association so it wouldn't pull the comments in
  the query. How can I make it so the find() as also grabs the comment
  count for each post it is grabbing?

  If I kept the association it would work, but I would have to also pull
  all of the comment data as well, which is something I don't want to
  do.

  Thanks.


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake 
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---

Re: How to find comment count for each post?

2007-11-10 Thread Marcin Jaworski 

I didn't try this but you can give it a try. Put count(post_id) as a
field name. I'm 90% sure that this won't work (when using aggregation
functions in the query, SQL requires that every other non-aggregation
field you select to be present in group by clause). But still you can
try it anyway.

On 10 Lis, 17:38, Action [EMAIL PROTECTED] wrote:
 I currently have it so the association just pulls in the post_id for
 each comment then I just count() that array in the view for the
 comment count:

 $this-Post-bindModel(array('hasMany' = array('Comment' =
 array('fields' = array('post_id');
 $this-set('data', $this-Post-find('all', array('order' =
 'created DESC')));

 Is there a better way to do this?

 On Nov 10, 1:57 am, francky06l [EMAIL PROTECTED] wrote:

  You bind your model again, using 'fields' option to set the fields you
  want :

  $this-Post-bindModel(array('hasMany' = array('Comment' =
  array('className' = 'Comment',
   'fields' = array('field you
  want';

  On Nov 10, 4:55 am, Action [EMAIL PROTECTED] wrote:

   I want to be able to retrieve multiple blog posts as well as the
   comment count for each post. I do not want to retrieve the comments
   themselves, just the comment count.

   This is what I have so far:

   $this-Post-unbindModel(array('hasMany' = array('Comment')));

   $this-set('data', $this-Post-find('all', array('order' = 'created
   DESC')));

   I unbound the model association so it wouldn't pull the comments in
   the query. How can I make it so the find() as also grabs the comment
   count for each post it is grabbing?

   If I kept the association it would work, but I would have to also pull
   all of the comment data as well, which is something I don't want to
   do.

   Thanks.


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake 
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---

How to find comment count for each post?

2007-11-09 Thread Action 

I want to be able to retrieve multiple blog posts as well as the
comment count for each post. I do not want to retrieve the comments
themselves, just the comment count.

This is what I have so far:

$this-Post-unbindModel(array('hasMany' = array('Comment')));

$this-set('data', $this-Post-find('all', array('order' = 'created
DESC')));

I unbound the model association so it wouldn't pull the comments in
the query. How can I make it so the find() as also grabs the comment
count for each post it is grabbing?

If I kept the association it would work, but I would have to also pull
all of the comment data as well, which is something I don't want to
do.

Thanks.


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake 
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---

Re: How to find comment count for each post?

2007-11-09 Thread francky06l 

You bind your model again, using 'fields' option to set the fields you
want :

$this-Post-bindModel(array('hasMany' = array('Comment' =
array('className' = 'Comment',
 'fields' = array('field you
want';

On Nov 10, 4:55 am, Action [EMAIL PROTECTED] wrote:
 I want to be able to retrieve multiple blog posts as well as the
 comment count for each post. I do not want to retrieve the comments
 themselves, just the comment count.

 This is what I have so far:

 $this-Post-unbindModel(array('hasMany' = array('Comment')));

 $this-set('data', $this-Post-find('all', array('order' = 'created
 DESC')));

 I unbound the model association so it wouldn't pull the comments in
 the query. How can I make it so the find() as also grabs the comment
 count for each post it is grabbing?

 If I kept the association it would work, but I would have to also pull
 all of the comment data as well, which is something I don't want to
 do.

 Thanks.


--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake 
PHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en
-~--~~~~--~~--~--~---