Skip to main content

build SQL database from version control repository

Project description

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.

Installation

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%).

Usage

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

License

Copyright (C) 2016 Thomas Aglassinger. Distributed under the GNU Lesser General Public License v3 or later (LGPLv3+).

History

v0.1, 2016-07-01

  • Initial public release.

Project details


Release history Release notifications | RSS feed

This version

0.1

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

vcdb-0.1-py3-none-any.whl (9.3 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page