Add a function to count the total number of new issues/issue comments in a week [#889920]

One of the metrics we want for Project metrics for drupal.org redesign is a count of the total number of issue comments for a project in a given week.

This is a bit wonky when you look at comments that move an issue from one queue to another. ;) For simplicity, I think we just count that as a comment in the *new* project's tally. So, my proposal is the rule is whatever project an issue is in after your comment is the project we increment the counter for...

Comment	File	Size	Author
#2	889920-2-pi-new-issues-comments-metric.patch	4.02 KB	hunmonk
#1	pi-new-issues-comments-metric.patch	4.03 KB	hunmonk

Comments

Comment #1

hunmonk commented 1 October 2010 at 18:24

Assigned:	Unassigned	» hunmonk
Status:	Active	» Needs review

Status	File	Size
new	pi-new-issues-comments-metric.patch	4.03 KB

first stab at this.

couple of problems:

the query that pulls all the projects + new issue counts doesn't seem to actually pull all of the projects. i get somewhere in the neighborhood of 2200 rows with that query, but the {project_projects} table says there's closer to 7800
both queries are ridiculously expensive -- on my laptop, 30 seconds for the issue query, and a minute and a half for the comments :( i *think* the comments query can by improved dramatically by added an index on {project_issue_comments}.timestamp

otherwise, it seems to do what it's supposed to.

Comment #2

hunmonk commented 11 March 2011 at 20:34

Status	File	Size
new	889920-2-pi-new-issues-comments-metric.patch	4.02 KB

latest patch, adds batch support.

Comment #3

hunmonk commented 12 March 2011 at 18:02

Title:	Add a function to count the total number of issue comments in a week	» Add a function to count the total number of new issues/issue comments in a week
Status:	Needs review	» Fixed

commited in merge http://drupalcode.org/project/project_issue.git/commit/a29ed52