开脑洞：用sql语句操作git仓库
原创开脑洞：用sql语句操作git仓库
原创
mariolu
发布于 2020-07-05 11:17:38
发布于 2020-07-05 11:17:38
代码可运行
运行总次数：0
代码可运行
一、gitqlite能做些什么
用过git，也用过sql。两者结合起来用有试过吗？github上开源了gitqlite项目
github地址：https://github.com/augmentable-dev/gitqlite。该项目使用sql语法可以做以下事情：
- 列出所有的commit：
gitqlite “SELECT * FROM commits”- 列出所有作者的提交数量并排序：
SELECT author_email, count(*) FROM commits GROUP BY author_email ORDER BY count(*) DESC- 除开合并提交，再按所有作者的提交数量排序：
SELECT author_email, count(*) FROM commits WHERE parent_count < 2 GROUP BY author_email ORDER BY count(*) DESC- 某个提交id所变更的文件：
SELECT * FROM files WHERE commit_id='some_commit_id'- 按照短id查看变更文件：
SELECT * FROM files WHERE commit_id LIKE 'shortened_commit_id%'- 查看每位作者的变更行数，
SELECT count(*) AS commits, SUM(additions) AS additions, SUM(deletions) AS deletions, author_email FROM commits GROUP BY author_email ORDER BY commits- 查看作者每天的提交量：
SELECT count(*) AS commits, count(case when strftime('%w',author_when)='0' then 1 end) as sunday, count(case when strftime('%w',author_when)='1' then 1 end) as monday, count(case when strftime('%w',author_when)='2' then 1 end) as tuesday, count(case when strftime('%w',author_when)='3' then 1 end) as wednesday, count(case when strftime('%w',author_when)='4' then 1 end) as thursday, count(case when strftime('%w',author_when)='5' then 1 end) as friday, count(case when strftime('%w',author_when)='6' then 1 end) as saturday, author_email FROM commits GROUP BY author_email ORDER BY commits二、gitqlite怎么安装
那么怎么安装呢？首先该项目是个go程序，需要先安装go环境，并设置GOPATH变量
- 在centos7安装go，
yum install go- 设置GOPATH变量，
export GOPATH=/data/mariolu/gopath（这里是填你的个人目录）- 下载gitqlite，使用go get命令可以顺带下载依赖库，
go get -v github.com/augmentable-dev/gitqlite- 安装gitqlite，
go install -v -tags=sqlite_vtable github.com/augmentable-dev/gitqlite- 安装好的程序在$GOPATH/bin/gitqlite。并把$GOPATH/bin设置到二进制路径$PATH下
以后就可以愉快的使用gitqlite “sql语句”在git仓库目录下做历史提交的探索了。
原创声明：本文系作者授权腾讯云开发者社区发表，未经许可，不得转载。
如有侵权，请联系 cloudcommunity@tencent.com 删除。
原创声明：本文系作者授权腾讯云开发者社区发表，未经许可，不得转载。
如有侵权，请联系 cloudcommunity@tencent.com 删除。
评论
登录后参与评论
推荐阅读
目录
腾讯云开发者
