Author: pawelz
Date: Thu Apr 1 01:03:36 2010
New Revision: 11292
Modified:
toys/cvsstats/count.sql
Log:
- drop separators
Modified: toys/cvsstats/count.sql
==============================================================================
--- toys/cvsstats/count.sql (original)
+++ toys/cvsstats/count.sql Thu Apr 1 01:03:36 2010
@@ -27,59 +27,45 @@
INSERT INTO commi...@y@_...@m@ SELECT * FROM commits WHERE date LIKE
'@y...@-@m...@-%';
-SELECT('----');
SELECT('Total number of commits:');
SELECT count(*) FROM commi...@y@_...@m@;
-SELECT('----');
SELECT('Number of touched files:');
SELECT count(distinct filename) FROM fil...@y@_...@m@;
-SELECT('----');
SELECT('Number of authors that commited at least once:');
SELECT count(distinct author) FROM commi...@y@_...@m@;
-SELECT('----');
SELECT('Number of hunks:');
SELECT sum(hunks) FROM commi...@y@_...@m@;
-SELECT('----');
SELECT('Number of added lines:');
SELECT sum(added) FROM commi...@y@_...@m@;
-SELECT('----');
SELECT('Number of removed lines:');
SELECT sum(removed) FROM commi...@y@_...@m@;
-SELECT('----');
SELECT('Number of commits per author:');
SELECT author, count(*) AS `Number of commits` FROM commi...@y@_...@m@ GROUP
BY author ORDER BY `Number of commits` DESC LIMIT 3;
-SELECT('----');
SELECT('Most hard-working developers (in terms of numbers of changed lines in
their commits) were:');
SELECT author, sum(added)+sum(removed) AS `Number of changed lines`,
sum(added), sum(removed) FROM commi...@y@_...@m@ GROUP BY author ORDER BY
`Number of changed lines` DESC LIMIT 3;
-SELECT('----');
SELECT('Most creative developers (numbers of added lines/number of removed
lines) were:');
SELECT author, sum(added)/sum(removed) AS `Points`, sum(added), sum(removed)
FROM commi...@y@_...@m@ GROUP BY author ORDER BY `Points` DESC LIMIT 3;
-SELECT('----');
SELECT('Most destructive developers (same as above, but bottom three) were:');
SELECT author, sum(added)/sum(removed) AS `Points`, sum(added), sum(removed)
FROM commi...@y@_...@m@ GROUP BY author ORDER BY `Points` ASC LIMIT 3;
-SELECT('----');
SELECT('Most actively developed files (in terms of number of commits) were:');
SELECT filename, count(*) AS `Number of commits` FROM fil...@y@_...@m@ GROUP
BY filename ORDER BY `Number of commits` DESC LIMIT 20;
-SELECT('----');
SELECT('Most changed files (in terms of modified lines) were:');
SELECT filename, sum(added) + sum(removed) AS `Changed lines` FROM
fil...@y@_...@m@ GROUP BY filename ORDER BY `Changed lines` DESC LIMIT 20;
-SELECT('----');
SELECT('Number of commits per author (full table):');
SELECT author, count(*) AS `Number of commits` FROM commi...@y@_...@m@ GROUP
BY author ORDER BY `Number of commits` DESC;
-SELECT('----');
SELECT('Most hard-working developers (full table):');
SELECT author, sum(added)+sum(removed) AS `Number of changed lines`,
sum(added), sum(removed) FROM commi...@y@_...@m@ GROUP BY author ORDER BY
`Number of changed lines` DESC;
_______________________________________________
pld-cvs-commit mailing list
[email protected]
http://lists.pld-linux.org/mailman/listinfo/pld-cvs-commit
