Skip to main content
Help us improve Python packaging – donate today!

Command-line utility for counting records that refer to a database table in MySQL.

Project Description

License

CountRecordRefs is a command-line tool for counting related records in a MySQL database. The program outputs the number of records for each foreign key column.

The code is written in Python and should work with both Python 2 and 3.

Source repository: https://github.com/jmenglund/CountRecordRefs


Prerequisites

Apart from MySQL itself, you only need to have the Python package PyMySQL installed. If you install CountRecordRefs following the instructions below, PyMySQL will be installed automatically for you.

Installation

The project is hosted at https://github.com/jmenglund/CountRecordRefs and can be installed using git:

$ git clone https://github.com/jmenglund/CountRecordRefs.git
$ cd CountRecordRefs
$ python setup.py install

You may consider installing CountRecordRefs within a virtual environment in order to avoid cluttering your system’s Python path. See for example the environment management system conda or the package virtualenv.

This project is centered around a self-contained single-module (single-file) executable script that can also be used as such.

Usage

usage: CountRecordRefs.py [-h] [-V] [--user USER] [--password PASSWORD]
                          [--host HOST] [-z]
                          database_name table_name id

Command-line utility for counting related records in a MySQL database. Output
is written to <stdout>.

positional arguments:
  database_name        MySQL database name
  table_name           table name
  id                   primary key value to look up

optional arguments:
  -h, --help           show this help message and exit
  -V, --version        show program's version number and exit
  --user USER          MySQL user (default: "root")
  --password PASSWORD  MySQL password
  --host HOST          database host (default: "localhost")
  -z, --zero-counts    include counts of zero in output

License

CountRecordRefs is distributed under the GNU General Public License, version 3 (GPL-3.0).

Author

Markus Englund, orcid.org/0000-0003-1688-7112

Release history Release notifications

This version
History Node

0.2.1

Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
CountRecordRefs-0.2.1-py3-none-any.whl (6.5 kB) Copy SHA256 hash SHA256 Wheel any Dec 2, 2016
CountRecordRefs-0.2.1.tar.gz (17.8 kB) Copy SHA256 hash SHA256 Source None Dec 2, 2016

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page