{
    "info": {
        "author": "Datapunt Amsterdam",
        "author_email": "datapunt@amsterdam.nl",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 3 - Alpha",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: Mozilla Public License 2.0 (MPL 2.0)",
            "Natural Language :: English",
            "Programming Language :: Python",
            "Programming Language :: Python :: 3.6"
        ],
        "description": "# pg_partition\nUtility to partition new/existing PostgreSql database tables. Data can be migrated. Only date range partition type is supported.\n\nRequired environment variables:\n```\nDATABASE_HOST : hostname/ip of the PostgreSql server\nDATABASE_NAME : database to operate on\nDATABASE_USER : PostgreSql login\nDATABASE_PASSWORD : PostgreSql password\n```\n\n#### Install ####\n```\npip install -r requirements.txt\n```\n\n#### Usage ####\n```\nusage: pg_partition.py [-h] {create,add} ...\n\npositional arguments:\n  {create,add}\n\noptional arguments:\n  -h, --help    show this help message and exit\n```\n\n#### Create Usage ####\n```\nusage: pg_partition.py create [-h] [--type {day,week,month}] table column\n\npositional arguments:\n  table                 table to be partitioned\n  column                column to be used for range\n\noptional arguments:\n  -h, --help            show this help message and exit\n  --type {day,week,month}\n```\n\n#### Add Usage ####\n```\nusage: pg_partition.py add [-h] [--num NUM] [--date DATE]\n                           table {day,week,month}\n\npositional arguments:\n  table             table to be partitioned\n  {day,week,month}\n\noptional arguments:\n  -h, --help        show this help message and exit\n  --num NUM         partitions to create\n  --date DATE       start date (yyyymmdd)\n```\n\n#### Creating partitions ####\n```\n# Convert 'table' to a range partitioned table by 'column'\n# No data is migrated\npython pg_partition.py create table column\n\n# Convert 'table' to a range partitioned table by 'column'\n# Data is migrated in week partitions \npython pg_partition.py create table column --type week\n```\n\n#### Adding partitions ####\n```\n# Adds 10 day partitions starting from 20180101 to 'table'\npython pg_partition.py add table day --num 10 --date 20180101\n\n```\n\n\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/amsterdam/pg_partition",
        "keywords": "",
        "license": "Mozilla Public License Version 2.0",
        "maintainer": "",
        "maintainer_email": "",
        "name": "datapunt-pg-partitioning",
        "package_url": "https://pypi.org/project/datapunt-pg-partitioning/",
        "platform": "",
        "project_url": "https://pypi.org/project/datapunt-pg-partitioning/",
        "project_urls": {
            "Homepage": "https://github.com/amsterdam/pg_partition"
        },
        "release_url": "https://pypi.org/project/datapunt-pg-partitioning/2019.2.27.3/",
        "requires_dist": [
            "psycopg2-binary",
            "python-dateutil",
            "pytest ; extra == 'dev'",
            "pytest-cov ; extra == 'dev'",
            "pylint ; extra == 'dev'",
            "twine ; extra == 'dev'",
            "sphinx ; extra == 'docs'",
            "sphinx-autobuild ; extra == 'docs'",
            "sphinx-rtd-theme ; extra == 'docs'"
        ],
        "requires_python": "",
        "summary": "Datapunt Amsterdam postgres table partitioning module",
        "version": "2019.2.27.3"
    },
    "last_serial": 4875059,
    "releases": {
        "2019.2.27": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "bd92b700d2724c520b6faea8fbb952b5",
                    "sha256": "bd432b7aa18ba95eca9bede3a149ba9e1354f81b214366f1b3c02b17f6d29fd7"
                },
                "downloads": -1,
                "filename": "datapunt_pg_partitioning-2019.2.27-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "bd92b700d2724c520b6faea8fbb952b5",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5743,
                "upload_time": "2019-02-27T12:52:57",
                "url": "https://files.pythonhosted.org/packages/6f/d2/9c33cbf90ca01c531b05d05e7aa25436c1f60b560d8b46e641c044a64677/datapunt_pg_partitioning-2019.2.27-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "1f4aa19039ed8db5e35c3f269807f51d",
                    "sha256": "d6a72546a7446681d95226c2c9bba47a794f372aa4923a1be2a5d1e785403484"
                },
                "downloads": -1,
                "filename": "datapunt-pg-partitioning-2019.2.27.tar.gz",
                "has_sig": false,
                "md5_digest": "1f4aa19039ed8db5e35c3f269807f51d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5242,
                "upload_time": "2019-02-27T12:52:59",
                "url": "https://files.pythonhosted.org/packages/82/ba/f29f2b30d095556664ab8b79b51bce55271f831fc6b29aa8f45470f3c5bb/datapunt-pg-partitioning-2019.2.27.tar.gz"
            }
        ],
        "2019.2.27.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "289c1805c7221593271da4b763659623",
                    "sha256": "7a61c0469217dc40b31ca32e0f54e7b45daefc9cf426508fe9720dc88e2a0432"
                },
                "downloads": -1,
                "filename": "datapunt_pg_partitioning-2019.2.27.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "289c1805c7221593271da4b763659623",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 15082,
                "upload_time": "2019-02-27T13:03:57",
                "url": "https://files.pythonhosted.org/packages/21/2e/64b67e8e2dc4ecd176218662519e338598ae910800343ac08968be660ded/datapunt_pg_partitioning-2019.2.27.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "1b4a23783d30cf875767e4b9bcca6feb",
                    "sha256": "54f029859bff77fb0fe68da835817e260bc4c5098f5503fb17a15147fe603abc"
                },
                "downloads": -1,
                "filename": "datapunt-pg-partitioning-2019.2.27.2.tar.gz",
                "has_sig": false,
                "md5_digest": "1b4a23783d30cf875767e4b9bcca6feb",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5278,
                "upload_time": "2019-02-27T13:03:58",
                "url": "https://files.pythonhosted.org/packages/fe/c5/e1636862af926326fae1f10438850262f184d83f241b8c47e48f97737fdf/datapunt-pg-partitioning-2019.2.27.2.tar.gz"
            }
        ],
        "2019.2.27.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5fe1fe8e3c286ca7612b5d5d844f06ab",
                    "sha256": "0db846da5ea39163c888e8dda4c59cc234545fd1cc0e817bc50fb91d8399a6c6"
                },
                "downloads": -1,
                "filename": "datapunt_pg_partitioning-2019.2.27.3-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "5fe1fe8e3c286ca7612b5d5d844f06ab",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 15496,
                "upload_time": "2019-02-27T16:21:04",
                "url": "https://files.pythonhosted.org/packages/9d/60/706a64de884a5cba0e60572feac1b2e91480eccb144f31afa66bcd04bc39/datapunt_pg_partitioning-2019.2.27.3-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "608ceccfe9afcae699e06c4fbd714729",
                    "sha256": "7e0c5e2ea58768e06a95485153544b94f1d1c4c380d840b327873789f7db788d"
                },
                "downloads": -1,
                "filename": "datapunt-pg-partitioning-2019.2.27.3.tar.gz",
                "has_sig": false,
                "md5_digest": "608ceccfe9afcae699e06c4fbd714729",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5504,
                "upload_time": "2019-02-27T16:21:05",
                "url": "https://files.pythonhosted.org/packages/05/0c/9cd7cd4f491850e0bc448a5664eba440d05fa94c3793782ac9f943378f9e/datapunt-pg-partitioning-2019.2.27.3.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "5fe1fe8e3c286ca7612b5d5d844f06ab",
                "sha256": "0db846da5ea39163c888e8dda4c59cc234545fd1cc0e817bc50fb91d8399a6c6"
            },
            "downloads": -1,
            "filename": "datapunt_pg_partitioning-2019.2.27.3-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "5fe1fe8e3c286ca7612b5d5d844f06ab",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 15496,
            "upload_time": "2019-02-27T16:21:04",
            "url": "https://files.pythonhosted.org/packages/9d/60/706a64de884a5cba0e60572feac1b2e91480eccb144f31afa66bcd04bc39/datapunt_pg_partitioning-2019.2.27.3-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "608ceccfe9afcae699e06c4fbd714729",
                "sha256": "7e0c5e2ea58768e06a95485153544b94f1d1c4c380d840b327873789f7db788d"
            },
            "downloads": -1,
            "filename": "datapunt-pg-partitioning-2019.2.27.3.tar.gz",
            "has_sig": false,
            "md5_digest": "608ceccfe9afcae699e06c4fbd714729",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 5504,
            "upload_time": "2019-02-27T16:21:05",
            "url": "https://files.pythonhosted.org/packages/05/0c/9cd7cd4f491850e0bc448a5664eba440d05fa94c3793782ac9f943378f9e/datapunt-pg-partitioning-2019.2.27.3.tar.gz"
        }
    ]
}