Command-line utility for counting records that refer to a database table in MySQL.
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 virtualenv.
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).
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Hashes for CountRecordRefs-0.2.1-py3-none-any.whl