{
    "info": {
        "author": "Alfred Blokland",
        "author_email": "alfred.blokland@hendrikx-itc.nl",
        "bugtrack_url": null,
        "classifiers": [],
        "description": "PostgreSQL Database Tools\n=========================\n\n|Crates.io|\n\n.. |Crates.io| image:: https://img.shields.io/pypi/v/pg-db-tools.svg\n   :target: https://pypi.org/project/pg-db-tools/\n\nDesign, create, maintain and document a PostgreSQL databases using a yaml based\ndescriptions.\n\nRead the `documentation on readthedocs.io <https://pg-db-tools.readthedocs.io/en/latest/>`_.\n\nInstallation\n------------\n\nInstall from PyPi::\n\n    $ pip3 install pg-db-tools\n\n\nInstall from GitHub::\n\n    $ git clone https://github.com/hendrikx-itc/pg-db-tools\n    $ sudo pip3 install pg-db-tools\n\nUsage\n-----\n\nCommand usage::\n\n    db-schema <command> [options]\n\n    commands:\n        compile       compile output from schema definition\n        extract       extract schema definition from source\n        doc           documentation generation command\n        --help,-h     display help information\n\n\ncompile\n~~~~~~~\n\nSub-command compile::\n\n    db-schema compile <output-type> <schema-filename>\n\n    output-types:\n        dot   Generate Graphviz DOT\n        sql   Generate SQL\n        md    Generate Markdown documentation\n        rst   Generate reStructuresText documentation\n\n\nextract\n~~~~~~~\n\nSub-command extract::\n\n    db-schema extract <source>\n\n    sources:\n        from-db   Extract from postgres database\n\nSub-sub-command from-db::\n\n    db-schema extract from-db --format {yaml.json} [--owner OWNER] [schemas]\n\nschemas:\n* Multiple schemas can be supplied\n* If no schema is supplied, all schemas are returned\n\nExample::\n\n    PGHOST=localhost \\\n    PGPORT=5432 \\\n    PGUSER=postgres \\\n    PGDATABASE=postgres \\\n    db-schema extract from-db --format yaml\n\n\ndoc\n~~~\n\n\nExamples\n--------\n\nCreate sql from the example webshop.yaml::\n\n    $ db-schema compile sql example/webshop.yaml\n\nCreate rst documentation from the example webshop.yaml::\n\n    $ db-schema compile rst example/webshop.yaml\n\n\nresult::\n\n    Schema ``shop``\n    ===============\n\n\n    Tables\n    ------\n\n    Order\n    ^^^^^\n\n    Contains all orders\n\n    +---------+--------------------------+----------+-------------+\n    | Column  | Type                     | Nullable | Description |\n    +=========+==========================+==========+=============+\n    | id      | integer                  | \u2714        | Primary key |\n    +---------+--------------------------+----------+-------------+\n    | created | timestamp with time zone | \u2714        |             |\n    +---------+--------------------------+----------+-------------+\n\n    OrderLine\n    ^^^^^^^^^\n\n    Contains all order lines for all orders\n\n    +------------+---------+----------+-------------+\n    | Column     | Type    | Nullable | Description |\n    +============+=========+==========+=============+\n    | id         | integer | \u2714        | Primary key |\n    +------------+---------+----------+-------------+\n    | order_id   | integer | \u2714        |             |\n    +------------+---------+----------+-------------+\n    | line_nr    | integer | \u2714        |             |\n    +------------+---------+----------+-------------+\n    | product_id | integer | \u2714        |             |\n    +------------+---------+----------+-------------+\n    | amount     | integer | \u2714        |             |\n    +------------+---------+----------+-------------+\n\n    Schema ``public``\n    =================\n\n\nDescription Format\n------------------\n\nOne of the main components of the toolset is a database schema description\nformat. The description format is based on YAML, because it is easy to read and\nwrite for humans.\n\nSee an example [here](https://github.com/hendrikx-itc/pg-db-tools/blob/master/example/webshop.yaml)\n\nSee the schema file [here](https://github.com/hendrikx-itc/pg-db-tools/blob/master/src/pg_db_tools/spec.schema)\n\nNote\n----\n\nThis tool is specifically not meant as a cross database toolset, because\nthat usually causes compatibility headaches and multiple partially supported\ndatabase engines.",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "http://www.hendrikx-itc.nl",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "pg-db-tools",
        "package_url": "https://pypi.org/project/pg-db-tools/",
        "platform": "",
        "project_url": "https://pypi.org/project/pg-db-tools/",
        "project_urls": {
            "Homepage": "http://www.hendrikx-itc.nl"
        },
        "release_url": "https://pypi.org/project/pg-db-tools/1.0.5/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "PostgreSQL database schema design and maintenance tools",
        "version": "1.0.5"
    },
    "last_serial": 5878900,
    "releases": {
        "1.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "da7f6d5218788a81ef209c43150a5c0d",
                    "sha256": "a2db06a963e4b0ef8c5d7f17462ea8c2944ca86e670adc04ef035ad38fd559e2"
                },
                "downloads": -1,
                "filename": "pg_db_tools-1.0.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "da7f6d5218788a81ef209c43150a5c0d",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 37471,
                "upload_time": "2019-03-15T15:25:24",
                "url": "https://files.pythonhosted.org/packages/79/98/27ab5ba8784962bbe896bd0dc208e49ed7d1a13420b564c4851e851fdadd/pg_db_tools-1.0.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "c9023805ea83ab58e52ac294631bbbab",
                    "sha256": "ba841522790e36a399f98698b8e15de15d49c5a9ccde6496bb240d0d8e6503f6"
                },
                "downloads": -1,
                "filename": "pg-db-tools-1.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "c9023805ea83ab58e52ac294631bbbab",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 27282,
                "upload_time": "2019-03-15T15:21:59",
                "url": "https://files.pythonhosted.org/packages/6e/07/91d4ccba3b217f9e574917976739ce322020ed5de9ac01f31f57f62dcf74/pg-db-tools-1.0.1.tar.gz"
            }
        ],
        "1.0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "82ee418a10df7e543be2a37d9e0f4e6e",
                    "sha256": "ba17d4c118a7a4ab534b02a29af6bafa036ce13d557d834aa1e25b13a54637f3"
                },
                "downloads": -1,
                "filename": "pg_db_tools-1.0.2-py2-none-any.whl",
                "has_sig": false,
                "md5_digest": "82ee418a10df7e543be2a37d9e0f4e6e",
                "packagetype": "bdist_wheel",
                "python_version": "py2",
                "requires_python": null,
                "size": 37636,
                "upload_time": "2019-03-25T14:04:23",
                "url": "https://files.pythonhosted.org/packages/78/fe/101f2df3670c4e6758d8836b55778fe8b0055e3274992599f7e107b5a6e1/pg_db_tools-1.0.2-py2-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "35b190b5acfaa5466f83c85eca1416ff",
                    "sha256": "2c76223b3d23979c88f877c69518c0eeb672bc6be13aa3d18f8db9c166db8313"
                },
                "downloads": -1,
                "filename": "pg_db_tools-1.0.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "35b190b5acfaa5466f83c85eca1416ff",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 37471,
                "upload_time": "2019-03-15T15:26:00",
                "url": "https://files.pythonhosted.org/packages/59/10/9f9fb7a09ddc65d01610a4cf64c51055b7276dcdfc4a4b55d8c3a6b66084/pg_db_tools-1.0.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "82fde89fe24d50a63625119c694e1cb3",
                    "sha256": "f052008a70bfa55b9ba206541496d06b2d145ede2a7b7d9de4b41b0b42a95ca0"
                },
                "downloads": -1,
                "filename": "pg-db-tools-1.0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "82fde89fe24d50a63625119c694e1cb3",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 30801,
                "upload_time": "2019-03-25T14:04:24",
                "url": "https://files.pythonhosted.org/packages/6a/2b/886790d922e7babd9cdb2cb05ee153a133ad9690025d19e47c2431820c96/pg-db-tools-1.0.2.tar.gz"
            }
        ],
        "1.0.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "57cfaf3db5cafc070dbc355e9f28963b",
                    "sha256": "f4c3b0759c0e015dbec6e270a446d7e4637f138d9c7e569c1a77462ac08aa16e"
                },
                "downloads": -1,
                "filename": "pg_db_tools-1.0.3-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "57cfaf3db5cafc070dbc355e9f28963b",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 60152,
                "upload_time": "2019-03-25T14:05:39",
                "url": "https://files.pythonhosted.org/packages/50/17/ee2fab689155a28e2b9b265ec96eba753d888fad2efed3aedc9fa19f20ce/pg_db_tools-1.0.3-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "ff2b85b64d68e766215405b1c93e17df",
                    "sha256": "f35c9b063b791abf7bbc053fd49bb92e6d76ea0cc2307e6a66eb3564c5c3ab3a"
                },
                "downloads": -1,
                "filename": "pg-db-tools-1.0.3.tar.gz",
                "has_sig": false,
                "md5_digest": "ff2b85b64d68e766215405b1c93e17df",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 30801,
                "upload_time": "2019-03-25T14:05:40",
                "url": "https://files.pythonhosted.org/packages/c8/61/a6a30b0f83293d51586e2a62c1b846ab1d06ea1cdfd0947b1f593efcd807/pg-db-tools-1.0.3.tar.gz"
            }
        ],
        "1.0.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "69d0f356526d527de5db99dbbacf0930",
                    "sha256": "07165ba6a32142327c1caaa6553fbda44ab8ae9dce62654ca5f2c9cea9d82a21"
                },
                "downloads": -1,
                "filename": "pg_db_tools-1.0.4-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "69d0f356526d527de5db99dbbacf0930",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 60147,
                "upload_time": "2019-03-25T15:21:08",
                "url": "https://files.pythonhosted.org/packages/d1/8d/bde75db66e5b1f60c34803e4f037145637958662a6f6c0a8951963303fa6/pg_db_tools-1.0.4-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "8c2674f794ca15be33eace07c266ecb4",
                    "sha256": "6340279ab8c1452f035374f972709cf462f070c0421ba8be1bd54e340c10c3c2"
                },
                "downloads": -1,
                "filename": "pg-db-tools-1.0.4.tar.gz",
                "has_sig": false,
                "md5_digest": "8c2674f794ca15be33eace07c266ecb4",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 30811,
                "upload_time": "2019-03-25T15:21:09",
                "url": "https://files.pythonhosted.org/packages/41/76/9ad7d5b72590bc45a632006d05f909653228f351279ee7fad1ba04b684b2/pg-db-tools-1.0.4.tar.gz"
            }
        ],
        "1.0.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "395ba30e342426fe6f5a1f438a12c2a1",
                    "sha256": "9d7402a774c81e515e8358e7136e5f2f653ca8b592eb0e89d8a636d568c558b1"
                },
                "downloads": -1,
                "filename": "pg-db-tools-1.0.5.tar.gz",
                "has_sig": false,
                "md5_digest": "395ba30e342426fe6f5a1f438a12c2a1",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 31290,
                "upload_time": "2019-09-24T10:30:33",
                "url": "https://files.pythonhosted.org/packages/13/5a/c7fb661467008ee7abea30f425d1484162afcc10b24c6bcb06e3678ab1bb/pg-db-tools-1.0.5.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "395ba30e342426fe6f5a1f438a12c2a1",
                "sha256": "9d7402a774c81e515e8358e7136e5f2f653ca8b592eb0e89d8a636d568c558b1"
            },
            "downloads": -1,
            "filename": "pg-db-tools-1.0.5.tar.gz",
            "has_sig": false,
            "md5_digest": "395ba30e342426fe6f5a1f438a12c2a1",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 31290,
            "upload_time": "2019-09-24T10:30:33",
            "url": "https://files.pythonhosted.org/packages/13/5a/c7fb661467008ee7abea30f425d1484162afcc10b24c6bcb06e3678ab1bb/pg-db-tools-1.0.5.tar.gz"
        }
    ]
}