[Teammetrics-discuss] Commit statistics

[Andreas Tille]

Hi Sukhbir,

I had some look at the commit stats.  Besides the fact that it does not
yet regard the commit_id (and I failed to fix in
0111567217cdc0924cafec0dc426340ba053ce7a - but I hope you got the idea
behind my change to just fetch the ID) I noticed in the SVN commits
which ended up in the database that there is some missunderstanding.
You are trying to aggregate commits of commiters in one single line.
That's just wrong!  The script should just gather information of SINGLE
commits and write this straight into the database.  Databases are cool
for aggregation so let's do it there.  Moreover your aggregation step
makes it impossible to do the analysis over time which we finally want
to do.

So I did the following changes to commit table:

  1. Commit_id moved to different position (in analogy to message_id)
     --> just cosmetics
  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

  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 

Kind regards

     Andreas.

-- 
http://fam-tille.de