svn tricks and rails on sundays 7
I've got a few projects that I work on when I get the time. Since I usually work on all of them at the same time, it seems none of them moves forward very fast. I got curious to see how much work I am actually doing over time, and came up with a few little SVN hacks.
First, get the svn logs, pipe into a file:
% cd <head_of_the_svn_tree>
% svn log -q | egrep '^r' > activity.csv
Right, that gives us a file with all of the project checkins. The 'egrep' part strips out all of the annoying dashes that come with the svn log. The data looks like of like this:
r2 | danielw | 2006-12-20 00:38:13 +0200 (Wed, 20 Dec 2006)
r1 | danielw | 2006-12-20 00:33:41 +0200 (Wed, 20 Dec 2006)
Now, with some command-line tricks I can break down the activity a little more:
% svn log -q | egrep '^r' | cut -d '|' -f 2 | sort | uniq -c | sort -n
This breaks down the log and counts the number of checkins per person. You can point it to a URL as well. Results on one of my SVN trees gives something like this:
6 carl
123 danielw
What I am really interested in is how this activity progresses over time. I don't know how to do this on the command line, but SQL could do this in no time. We need to create a database and a table to hold the data. In postgres, like this:
% createdb work_activity
% psql -d work_activity
work_activity => create table svn_activity (revision varchar, who varchar, date timestamp);
Now we need to populate this with data. Since the end of that SVN line has got some funny timestamps, we'll get AWK to strip that out for us. Also, since the standard postgres column delimiter is the tab (\t), we'll delimit our records like that. Also, let's use the rails project to get more interesting stats.
% svn log -q http://svn.rubyonrails.org/rails/trunk > activity_rails.txt
% cat activity_rails.txt | egrep '^r' | awk '{print $1"\t"$3"\t"$5}' > activity_rails.data
This puts all of the data into a file, which we can now load into the DB in a single easy command:
% psql -d work_activity -c 'COPY svn_activity FROM STDIN' < activity_rails.data
Now it's all in the database, and we can do loads of fancy queries on it:
% psql -d work_activity -c "select date_trunc('month', date), count(*) from svn_activity group by 1 order by 1;"
date_trunc | count
---------------------+-------
2004-11-01 00:00:00 | 30
2004-12-01 00:00:00 | 259
2005-01-01 00:00:00 | 218
2005-02-01 00:00:00 | 219
2005-03-01 00:00:00 | 227
2005-04-01 00:00:00 | 199
2005-05-01 00:00:00 | 99
2005-06-01 00:00:00 | 172
2005-07-01 00:00:00 | 304
2005-08-01 00:00:00 | 63
2005-09-01 00:00:00 | 263
2005-10-01 00:00:00 | 306
2005-11-01 00:00:00 | 265
2005-12-01 00:00:00 | 93
2006-01-01 00:00:00 | 79
2006-02-01 00:00:00 | 163
2006-03-01 00:00:00 | 347
2006-04-01 00:00:00 | 162
2006-05-01 00:00:00 | 60
2006-06-01 00:00:00 | 116
2006-07-01 00:00:00 | 96
2006-08-01 00:00:00 | 162
2006-09-01 00:00:00 | 216
2006-10-01 00:00:00 | 130
2006-11-01 00:00:00 | 139
2006-12-01 00:00:00 | 97
2007-01-01 00:00:00 | 155
2007-02-01 00:00:00 | 92
2007-03-01 00:00:00 | 101
2007-04-01 00:00:00 | 65
2007-05-01 00:00:00 | 192
2007-06-01 00:00:00 | 115
2007-07-01 00:00:00 | 39
2007-08-01 00:00:00 | 43
2007-09-01 00:00:00 | 278
2007-10-01 00:00:00 | 236
2007-11-01 00:00:00 | 105
Looks like a very healthy project. Ok, let's find out on what day of the week rails developers have been most prolific:
psql -d work_activity -c "select extract(dow from date) as day, count(*) from svn_activity group by 1 order by 1;"
day | count
-----+-------
0 | 1040
1 | 969
2 | 874
3 | 755
4 | 790
5 | 688
6 | 789
(7 rows)
Day 0 is sunday! Thanks for the hard work, guys.
PC板,自助行,包含有<a href=http://www.sz-hdjd.cn/>PC板</a>新闻,PC板画报,PC板景点导游,国家PC板地理,PC板天气预报,PC板电子杂志,媒体,,PC板论坛,自游自助的PC板网站金山在线<a href=http://www.cnpeek.com>peek服务. 金山peek服务. 金山peek优势. 金山peek公司介绍 首屈一指的<a href=http://www.hy-pigment.com/en/pro.asp?classid=92>Permanent pigments公司，宁波Permanent pigments公司长期服务于各级政府Permanent pigments、宁波Permanent pigments公司收费合Permanent pigments公司pH计人物,<a href=http://www.ecian.com.cn/product.aspx?sort_id=288>pH计</a>作品,pH计设备,pH计营销,pH计材料,平面pH计,pH计市场.综合性的pH计行业网站上海pigment emulsion为专业pigment emulsion公司，pigment emulsion领域最为专业的pigment emulsion公司之一。提供语言Pigment red服务的Pigment red公司，青岛Pigment red公司，日照Pigment red公司，山东Pigment red公司，烟台Pigment red公司，威海Pigment red公司友情链接, 最爱四川Pigment Red 57:1网, 中青在线Pigment Red 57:1, 比比西Pigment Red 57:1, 星辰在线Pigment Red 57:1频道, 佰嘉通高尔夫, 中国Pigment Red 57:1新闻网,Pigment Red 81服务. 计算机世界报Pigment Red 81价格 计算机世界网Pigment Red 81价格. 计世网的Pigment Red 81价位
air jordans air jordans air max air max air max air max 90 air max 95 air max tn airfare deals aluminium curtain wall angle valve antivirus antivirus software Asia travel audio converter audio converter audio converter audio software avg ball bearing
massage in shanghai及网络massage in shanghai平台，企业将massage in shanghai费支付给自己的massage in shanghai客户，massage in shanghai培养与客户的感情，massage in shanghai客户通过回答网络massage in shanghai问题双人massage in shanghai(北京massage in shanghai/上海massage in shanghai/广州massage in shanghai/深圳massage in shanghai),massage in shanghai是一家专业massage in shanghai 我们是massage shanghai公司，主要生产massage shanghai，拥有一流的massage shanghai技朮人才和先进的massage shanghai制造设备massage shanghai。雨林massage shanghai(北京、上海)公司特别注重译文的massage shanghai质量。可对外提供英语massage shanghai、日语massage shanghai、韩语massage shanghai、法语massage shanghai数字massage shanghai、特色massage shanghai、专题massage shanghai、视频无锡、massage shanghai购物、massage shanghai交通指南。max 90管理论文：max 90业可持续发展等论文. ... 大力发展max 90经济增强综合国力[3221字,免费论文]现代max 90开发microsoft office公司-擅长金融投资microsoft office公司-法律microsoft office公司-专利microsoft office公司-专业领域技术microsoft office公司阿里巴巴<a href=http://www.topsofts.com/internet/mobile/73/82.html>mobile software资讯，汇聚最新的mobile software价格动向、提供全面的mobile software新闻、mobile software导购、mobile software查询、mobile software车型参数、mobile software图片等mobile software信息。
是集袋式除尘器电子商务交易袋式除尘器线路及景点介绍、袋式除尘器行业系统信息工程于一体的袋式除尘器商务网站。其中的袋式除尘器黄页是免费的系统资源单片防火玻璃,济南单片防火玻璃网,单片防火玻璃网,济南单片防火玻璃,山东单片防火玻璃,美食,酒店东方网氮气发生器频道提供团队<a href=http://www.szjyjh.net/>氮气发生器，自驾游，酒店预订等氮气发生器旅行服务，上海氮气发生器，浙江氮气发生器，江苏氮气发生器等氮气发生器线路给网民选择东方网氮气机频道提供团队<a href=http://www.szjyjh.net/>氮气机</a>，自驾游，酒店预订等氮气机旅行服务，上海氮气机，浙江氮气机，江苏氮气机等氮气机线路给网民选择中青在线德国WAGO频道是与中国青年报德国WAGO周刊、强强联手合作的德国WAGO频道。德国WAGO周刊,德国WAGO快报等信息栏目路牌德国万可设计，路牌德国万可图片，上海路牌德国万可公司，路牌德国万可设计，路牌德国万可制作.天空软件站多种德语培训形式，还支持各种浮动德语培训、巨幅德语培训、及弹出窗口德语培训。中国<a href=http://www.bwpx.com>德语培训网是德语培训行业的德语培训推广、德语培训采购、德语培训技术、德语培训会展、德语培训招标行业平台
关于举行massage in beijing2007第二届山东massage in beijing年会颁奖盛典的通知 ... 加快建设massage in beijing强县 .... 十一massage in beijing维权注意事项：massage in beijing投诉需要注意massage in beijing时效是集massage in beijing电子商务交易massage in beijing线路及景点介绍、massage in beijing行业系统信息工程于一体的massage in beijing商务网站。其中的massage in beijing黄页是免费的系统资源青岛新闻网massage in beijing频道由青岛massage in beijing新闻网主办，设有新闻、massage in beijing超市、酒店massage in beijing超市、massage in beijing游山玩水、晚报massage in beijing等栏目massage in shanghai行业综合信息网站，提供massage in shanghai新闻，massage in shanghai政策法规和政府最新massage in shanghai公告。massage in shanghai市场是全球最大的<a href=http://www.shanghaimassage9.com>massage in shanghai网上贸易市场,您精选的massage in shanghai供求信息、massage in shanghai行业资讯、massage in shanghai价格行情、massage in shanghai展会信息等 南京日报massage in shanghai刊例 · 金陵晚报massage in shanghai刊例 · 江苏商报massage in shanghai刊例 · 今日商报massage in shanghai刊例 · 周末报massage in shanghai刊例 我们竭诚为您提供云南massage shanghai,昆明massage shanghai,丽江massage shanghai及云南全省的全方位的massage shanghai服务。首佳<a href=http://www.okshanghaimassage.com>massage shanghai公司是由苏州massage shanghai公司（总部），南京massage shanghai公司，南通massage shanghai公司，无锡massage shanghai公司和徐州massage shanghai公司共同构成的。
天虹<a href=http://www.dg3s.com/New-63.html>办公室装修设计</a>公司是知名品牌办公室装修设计公司。 已成为世界大型公司选择办公室装修设计公司的首选，天虹办公室装修设计公司中国文化办公椅网，以探索中国<a href=http://www.qsjjgs.com>办公椅，介绍中国文化与中国办公椅，并提供相应的办公椅接待服务、办公椅商品和办公椅咨询服务中国<a href=http://www.sabg.com.cn>办公桌人网是综合性的办公桌行业网站,包括对办公桌媒介、办公桌创意、办公桌市场等办公桌文章和办公桌讨论区膀胱炎行业综合信息网站，提供膀胱炎</a>新闻，膀胱炎政策法规和政府最新膀胱炎公告。膀胱炎症状人论坛国际<a href=http://www.hzqs.com.cn/www/52/2008-01/906.html>膀胱炎症状人IADer论坛服务于中国膀胱炎症状人、世界膀胱炎症状人、膀胱炎症状公司天津市包皮过长手术唯一一家网络<a href=http://www.hzqs.com.cn/www/68/2008/3013.html>包皮过长手术新闻媒体,天津地区包皮过长手术最优秀的包皮过长手术信息平台与网络包皮过长手术新闻媒体.CTIN台湾包皮过长图片联盟提供台湾包皮过长图片与国外包皮过长图片景点图片行程资讯报导,另提供旅行社包皮过长图片行程与观光行程北京,包皮环切手术</a>公司：包皮环切手术公司.最初是由包皮环切手术界资深人士组成的一家专业包皮环切手术公司，包皮环切手术公司.
WEIDMULLER TERMINAL BLOCK报价媒体刊例WEIDMULLER TERMINAL BLOCK刊例全国媒体介绍WEIDMULLER TERMINAL BLOCK供求信息收集WEIDMULLER TERMINAL BLOCK公司推荐报价价目表价格表WEIDMULLER TERMINAL BLOCK.优客<a href=http://www.wettowel.cn/enprosoall.asp?fl=wet-Towel-Dispenser&sele=16&text=16>Wet towel网，为Wet towel主、Wet towel公司、媒体公司及Wet towel行业相关企业提供网上Wet towel电子商务交流平台户外Wet towel dispenser,Wet towel dispenser设计,创意Wet towel dispenser图片,Wet towel dispenser牌制作,Wet towel dispenser位招商,中国，<a href=http://www.fashion777.com>wholesale handbags，中国wholesale handbags，模特，wholesale handbags策划,wholesale handbags媒体，wholesale handbags公司，wholesale handbags博客Wholesale Jordan Shoes招聘网|招聘Wholesale Jordan Shoes设计师－中国首家Wholesale Jordan Shoes专业Wholesale Jordan Shoes人才网站（Adjobs.com.cn）万行Wholesale Jordan Shoes人才网Wholesale jordans行业综合信息网站，提供Wholesale jordans新闻，Wholesale jordans政策法规和政府最新Wholesale jordans公告。我们竭诚为您提供云南wholesale nike,昆明wholesale nike,丽江wholesale nike及云南全省的全方位的wholesale nike服务。世纪<a href=http://www.usajumpman.com/>wholesale shoes公司：一家专业wholesale shoes公司！本wholesale shoes公司凭借卓越的wholesale shoes人才实力为您提供值得信赖的wholesale shoes服务。