{
    "info": {
        "author": "Markus Englund",
        "author_email": "jan.markus.englund@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Intended Audience :: Developers",
            "Intended Audience :: System Administrators",
            "License :: OSI Approved :: GNU General Public License v3 (GPLv3)",
            "Operating System :: OS Independent",
            "Programming Language :: Python",
            "Programming Language :: Python :: 2",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.3",
            "Programming Language :: Python :: 3.4",
            "Programming Language :: Python :: 3.5",
            "Topic :: Database",
            "Topic :: Utilities"
        ],
        "description": "CountRecordRefs\n===============\n\n|License|\n\n``CountRecordRefs`` is a command-line tool for counting\nrelated records in a MySQL database. The program outputs\nthe number of records for each foreign key column.\n\nThe code is written in Python and should work with both\nPython 2 and 3.\n\nSource repository: `<https://github.com/jmenglund/CountRecordRefs>`_\n\n--------------------------------\n\n.. contents:: Table of contents\n   :depth: 2\n   :backlinks: none\n   :local:\n\n\nPrerequisites\n-------------\n\nApart from `MySQL <https://www.mysql.com>`_ itself, you only need\nto have the Python package `PyMySQL <https://github.com/PyMySQL/PyMySQL>`_\ninstalled. If you install ``CountRecordRefs`` following the instructions\nbelow, PyMySQL will be installed automatically for you.\n\n\nInstallation\n------------\n\nThe project is hosted at https://github.com/jmenglund/CountRecordRefs\nand can be installed using git:\n\n.. code-block::\n\n    $ git clone https://github.com/jmenglund/CountRecordRefs.git\n    $ cd CountRecordRefs\n    $ python setup.py install\n\nYou may consider installing ``CountRecordRefs`` within a virtual\nenvironment in order to avoid cluttering your system's Python path.\nSee for example the environment management system\n`conda <http://conda.pydata.org>`_ or the package\n`virtualenv <https://virtualenv.pypa.io/en/latest/>`_.\n\nThis project is centered around a self-contained single-module\n(single-file) executable script that can also be used as such.\n\n\nUsage\n-----\n\n.. code-block::\n\n    usage: CountRecordRefs.py [-h] [-V] [--user USER] [--password PASSWORD]\n                              [--host HOST] [-z]\n                              database_name table_name id\n\n    Command-line utility for counting related records in a MySQL database. Output\n    is written to <stdout>.\n\n    positional arguments:\n      database_name        MySQL database name\n      table_name           table name\n      id                   primary key value to look up\n\n    optional arguments:\n      -h, --help           show this help message and exit\n      -V, --version        show program's version number and exit\n      --user USER          MySQL user (default: \"root\")\n      --password PASSWORD  MySQL password\n      --host HOST          database host (default: \"localhost\")\n      -z, --zero-counts    include counts of zero in output\n\nLicense\n-------\n\n``CountRecordRefs`` is distributed under the\n`GNU General Public License, version 3 (GPL-3.0) <https://opensource.org/licenses/GPL-3.0>`_.\n\n\nAuthor\n------\n\nMarkus Englund, `orcid.org/0000-0003-1688-7112 <http://orcid.org/0000-0003-1688-7112>`_\n\n.. |License| image:: https://img.shields.io/badge/license-GNU%20GPL%20version%203-blue.svg\n   :target: https://raw.githubusercontent.com/jmenglund/CountRecordRefs/master/LICENSE.txt",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/jmenglund/CountRecordRefs",
        "keywords": "MySQL",
        "license": "GPLv3",
        "maintainer": "",
        "maintainer_email": "",
        "name": "CountRecordRefs",
        "package_url": "https://pypi.org/project/CountRecordRefs/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/CountRecordRefs/",
        "project_urls": {
            "Homepage": "https://github.com/jmenglund/CountRecordRefs"
        },
        "release_url": "https://pypi.org/project/CountRecordRefs/0.2.1/",
        "requires_dist": [
            "pymysql"
        ],
        "requires_python": "",
        "summary": "Command-line utility for counting records that refer to a database table in MySQL.",
        "version": "0.2.1"
    },
    "last_serial": 2496039,
    "releases": {
        "0.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b1534c477340eaf18cafa27f207b5012",
                    "sha256": "6901102fe692e2f44985b14a7d226d1bc3087d76938838a82288a54de7a8bf10"
                },
                "downloads": -1,
                "filename": "CountRecordRefs-0.2.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "b1534c477340eaf18cafa27f207b5012",
                "packagetype": "bdist_wheel",
                "python_version": "any",
                "requires_python": null,
                "size": 6456,
                "upload_time": "2016-12-02T15:25:45",
                "url": "https://files.pythonhosted.org/packages/cd/ac/a2088c56fb03fb4aff1a5a326c3684d2e602817ed12d09cbc46bd49253df/CountRecordRefs-0.2.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "e3c1ca9311b1bba4f7c7ba5756484981",
                    "sha256": "fd1b902d06ae0b1186a2a314e984702e08c7bb94bdfb3ec67be0a17ed4c0c482"
                },
                "downloads": -1,
                "filename": "CountRecordRefs-0.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "e3c1ca9311b1bba4f7c7ba5756484981",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 17774,
                "upload_time": "2016-12-02T15:24:18",
                "url": "https://files.pythonhosted.org/packages/36/fc/341e50c673f8fa32a65cf4194c9cb6ad8a569280ba4c5bad938cd1e90daa/CountRecordRefs-0.2.1.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "b1534c477340eaf18cafa27f207b5012",
                "sha256": "6901102fe692e2f44985b14a7d226d1bc3087d76938838a82288a54de7a8bf10"
            },
            "downloads": -1,
            "filename": "CountRecordRefs-0.2.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "b1534c477340eaf18cafa27f207b5012",
            "packagetype": "bdist_wheel",
            "python_version": "any",
            "requires_python": null,
            "size": 6456,
            "upload_time": "2016-12-02T15:25:45",
            "url": "https://files.pythonhosted.org/packages/cd/ac/a2088c56fb03fb4aff1a5a326c3684d2e602817ed12d09cbc46bd49253df/CountRecordRefs-0.2.1-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "e3c1ca9311b1bba4f7c7ba5756484981",
                "sha256": "fd1b902d06ae0b1186a2a314e984702e08c7bb94bdfb3ec67be0a17ed4c0c482"
            },
            "downloads": -1,
            "filename": "CountRecordRefs-0.2.1.tar.gz",
            "has_sig": false,
            "md5_digest": "e3c1ca9311b1bba4f7c7ba5756484981",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 17774,
            "upload_time": "2016-12-02T15:24:18",
            "url": "https://files.pythonhosted.org/packages/36/fc/341e50c673f8fa32a65cf4194c9cb6ad8a569280ba4c5bad938cd1e90daa/CountRecordRefs-0.2.1.tar.gz"
        }
    ]
}