[Gitstat-devel] [bug 1785778] sql query to get the maximum commits

[Paul V. <pau...@gm...>]

Hi,

(This relates to bug 1785578 'ybase is set fixed for "number of changesets" graph')

I've figured out the sql statement to get the maximum number of commits in the 
changeset:

mysql> select max(maxcommits) from (select
count(DATE_FORMAT(FROM_UNIXTIME(commitdate),'%Y%m%d')) as maxcommits
from ChangeLog group by
DATE_FORMAT(FROM_UNIXTIME(commitdate),'%Y%m%d')) as t1;
+-----------------+
| max(maxcommits) |
+-----------------+
|             733 |
+-----------------+
1 row in set (0.22 sec)

You see even the '700' that is currently set for the linux kernel is not enough ;-)

Apart from that if you browse to the current gitstat page 
(http://tree.celinuxforum.org/gitstat/chart.php?chart_parameter1=1&submit=1&setybase=700&prevperiod=16) 
you'll also see that 700 is not correct.

One thing we could do is use the outcome from the above sql query, round that up 
to a nice number and set that as ybase? The downside is that we have to execute 
the query for every page (chart.php?chart_parameter1=1) as it's not 'globally' used.

Cheers,

Paul.