[Teammetrics-discuss] Commit statistics

[Sukhbir Singh]

Hello!

> You are trying to aggregate commits of commiters in one single line.
> That's just wrong!  The script should just gather information of SINGLE

Err, though I am calculating the lines changed _per_ each revision, I
seem to be pushing a single revision only. Not cool! I am going to fix
this now. FYI, here is the flowchart:

1. Create a mapping of author to revisions.
2. Iterate over each revision and fetch the lines changed and added.

I seem to be doing (1) and (2) correctly but as you know my old habit
of collecting stuff and then waiting for the end to push it (!). But
as you have pointed out this mistake many times now, it's time to
change this for good!

>  2. changes: REMOVED! We want to record *every* single commit, so
>     changes should be ==1 for every record in the database
>     --> in case I missinterpreted this field just reintroduce, but
>         if I understood it correctly we just get it via
>
>           SELECT name, count(*) AS changes FROM commitstat GROUP BY name

In my case, SUM(changes) :D

>  3. commit_date: For the graphs we need the commit date
>     --> just needed for the final graphs
>  4. today_date: not so important, but we have it in the mails table
>     as well so it might not harm
>     --> simple housekeeping and perhaps helpful for debugging

Ok, (3) and (4) will be added.