build SQL database from version control repository
Vcdb scans a version control repository and builds an SQL database that can be queried. This simplifies monitoring version control activity and obtaining numbers from it.
Vcdb is available from https://pypi.python.org/pypi/vcdb and can be installed running:
$ pip install vcdb
The minimum supported Python version is 3.4.
The Subversion command line client svn must be installed and located in the command search path ($PATH resp. %PATH%).
To build a database for vcdb’s own repository run:
$ vcdb https://github.com/roskakori/vcdb/trunk sqlite:////tmp/vcdb.db
Currently vcdb only supports Subversion. Because Github provides a Subversion interface for git repositories you can still analyze them using a call like the one above.
You can then query the database using e.g. the sqlite command line client, for example:
$ sqlite3 /tmp/vcdb.db "select count(1) from changes"
The data model is a work in progress, so their is no documentation yet. To see the SQL code used to create all available tables, columns and their relations, run:
$ sqlite3 /tmp/vcdb.db ".schema"
To see all available command line options, run:
$ vcdb --help
To see the current version number, run:
$ vcdb --version
Copyright (C) 2016 Thomas Aglassinger. Distributed under the GNU Lesser General Public License v3 or later (LGPLv3+).