Skip to main content

A git query language

Project description

https://travis-ci.org/mackong/gitql.svg?branch=master

Gitql is a Git query language.

Gitql is written in Golang by cloudson originally, I reimplemented by python language, and with some enhancements.

Installation

pip install gitql

or

pip install git+https://github.com/mackong/gitql.git#egg=gitql

or

python setup.py install

Usage

usage: gitql [-h] [-i] [-p PATH] [-s] [-t {table,json}] [-f] [-v] [SQL]

Git query language

positional arguments:
  SQL                   A query to run

optional arguments:
  -h, --help            show this help message and exit
  -i, --interactive     Enter to interactive mode
  -p PATH, --path PATH  The path to run gitql (default ".")
  -s, --show-tables     Show all tables
  -t {table,json}, --type {table,json}
                        The output type format (default "table")
  -f, --format-json     Format the json output
  -v, --version         Show the version of gitql

Compare to Gitql

  • tables, fields, keywords case-insensitive

    Select * From COMMITS wherE author='bob';
    
  • field message -> summary, full_message -> message changed in commits table

  • * can combined with other fields

    select *, name, full_name from tags;
    
  • a table footer added similar to mysql

  • keyword NOT added

    select * from tags where not 'RC' in name;
    
  • limit -1 for all records

    select * from tags limit -1;
    
  • offset added to limit

    select * from tags limit 5, 5;
    

    or

    select * from tags limit 5 offset 5;
    
  • tailing ; is optional

    select * from tags
    

    or

    select * from tags;
    
  • value type limitation in where clause removed

    select summary, date from commits where '2016-12-28' < date;
    

    or

    select * from commits where 1 and 2;
    

Project details


Download files

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

Source Distribution

gitql-1.0.5.tar.gz (21.5 kB view hashes)

Uploaded source

Built Distribution

gitql-1.0.5-py2.py3-none-any.whl (23.7 kB view hashes)

Uploaded py2 py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page