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
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
This project is centered around a self-contained single-module (single-file) executable script that can also be used as such.
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
CountRecordRefs is distributed under the
GNU General Public License, version 3 (GPL-3.0).
Markus Englund, orcid.org/0000-0003-1688-7112