Command-line utility for counting records that refer to a database table in MySQL.
Project description
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).
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for CountRecordRefs-0.2.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6901102fe692e2f44985b14a7d226d1bc3087d76938838a82288a54de7a8bf10 |
|
MD5 | b1534c477340eaf18cafa27f207b5012 |
|
BLAKE2b-256 | cdaca2088c56fb03fb4aff1a5a326c3684d2e602817ed12d09cbc46bd49253df |