[fossil-users] Repo activity stats over time

2013-05-04 Thread Stephan Beal
Hi, all, i just updated my www hoster's copy of fossil, which was last updated in June 2012, and as the "pull" was chugging away it got me thinking about some type of repo activity reporting. Have any of you created any sort of reporting scripts/tools for getting an overview of repo activity, e.g

Re: [fossil-users] Repo activity stats over time

2013-05-04 Thread Richard Hipp
On Sat, May 4, 2013 at 9:19 AM, Stephan Beal wrote: > > Have any of you created any sort of reporting scripts/tools for getting an > overview of repo activity, e.g. number of commits per day over a period of > time? > I think the following query (run using "fossil sql") gives a monthly summary o

Re: [fossil-users] Repo activity stats over time

2013-05-04 Thread Stephan Beal
On Sat, May 4, 2013 at 8:40 PM, Richard Hipp wrote: > I think the following query (run using "fossil sql") gives a monthly > summary of comments: > > SELECT substr(date(mtime),1,7) AS m, count(*) AS c > FROM event > WHERE type='ci' > GROUP BY m > ORDER BY m; That's exactly the type of thin

Re: [fossil-users] Repo activity stats over time

2013-05-04 Thread Doug Franklin
On 2013-05-04 14:55, Stephan Beal wrote: SELECT substr(date(mtime),1,7) AS Month, count(*) AS Commits Is there a way to embed the counts in the reports themselves? For example, could I have a report that lists tickets ordered by their status and gives a count for each status value? -- Tha

Re: [fossil-users] Repo activity stats over time

2013-05-04 Thread Richard Hipp
On Sat, May 4, 2013 at 2:55 PM, Stephan Beal wrote: > > Maybe fossil should have a facility to allow people to install such > general-purposes reporting queries and show them on some public page (e.g. > /reports). > Why don't you add a page that draws a graph based on the output of that query?

Re: [fossil-users] Repo activity stats over time

2013-05-04 Thread Stephan Beal
On Sat, May 4, 2013 at 8:58 PM, Doug Franklin wrote: > On 2013-05-04 14:55, Stephan Beal wrote: > > SELECT substr(date(mtime),1,7) AS Month, count(*) AS Commits >> > > Is there a way to embed the counts in the reports themselves? For > example, could I have a report that lists tickets ordered by

Re: [fossil-users] Repo activity stats over time

2013-05-04 Thread Stephan Beal
On Sat, May 4, 2013 at 9:07 PM, Richard Hipp wrote: > On Sat, May 4, 2013 at 2:55 PM, Stephan Beal wrote: > >> >> Maybe fossil should have a facility to allow people to install such >> general-purposes reporting queries and show them on some public page (e.g. >> /reports). >> > > Why don't you ad

Re: [fossil-users] Repo activity stats over time

2013-05-04 Thread Stephan Beal
On Sat, May 4, 2013 at 9:09 PM, Stephan Beal wrote: > On Sat, May 4, 2013 at 9:07 PM, Richard Hipp wrote: > >> On Sat, May 4, 2013 at 2:55 PM, Stephan Beal wrote: >> >>> >>> Maybe fossil should have a facility to allow people to install such >>> general-purposes reporting queries and show them o

Re: [fossil-users] Repo activity stats over time

2013-05-04 Thread Stephan Beal
On Sat, May 4, 2013 at 9:41 PM, Stephan Beal wrote: > But i couldn't resist adding this quick hack: > > http://fossil-scm.org/index.html/info/c5ea75133a > Okay, okay, Richard, you convinced me to take a break from work and do something more interesting... Screenshot: http://wanderinghorse.net/t

Re: [fossil-users] Repo activity stats over time

2013-05-04 Thread Stephan Beal
On Sat, May 4, 2013 at 10:41 PM, Stephan Beal wrote: > Commit: http://fossil-scm.org/index.html/info/495bf1ea8d > Here are a couple of live demos: http://fossil.wanderinghorse.net/repos/cson/index.cgi/activity http://fossil.wanderinghorse.net/repos/whio/index.cgi/activity -- - stephan bea