Graphing lines of code over time

generate_sql.sh

cd /path/to/your/code
mkdir ../counts
git log --format=format:"git reset --hard %H&&cloc --skip-uniqueness --force-lang=HTML,twig --sql-project=\"%ai\" --sql=../counts/%H.sql ." --no-merges > ../runme.sh
bash ../runme.sh
mysql -u root -p stats < grep -h ../counts/* insert

report.sql

SELECT * FROM (
	SELECT Project as Date, Language, SUM(nBlank) AS Blank, SUM(nComment) AS Comment, SUM(nCode) AS Code, SUM(nBlank) + SUM(nComment) + SUM(nCode) AS Total
	FROM t
	GROUP BY Project, Language
	UNION
	SELECT Project as Date, 'Total' AS Language, SUM(nBlank) AS Blank, SUM(nComment) AS Comment, SUM(nCode) AS Code, SUM(nBlank) + SUM(nComment) + SUM(nCode) AS Total
	FROM t
	GROUP BY Project
) AS x
ORDER BY Date, Language = 'Total', Language