{
    "info": {
        "author": "Daniil Minukhin",
        "author_email": "ddddsa@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Environment :: Console",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Operating System :: OS Independent",
            "Programming Language :: Python",
            "Topic :: Documentation",
            "Topic :: Utilities"
        ],
        "description": "# PostgreSQL Docs Generator for Foliant\n\nThis preprocessor generates simple documentation of a PostgreSQL database based on its structure. It uses [Jinja2](http://jinja.pocoo.org/) templating engine for customizing the layout and [PlantUML](http://plantuml.com/) for drawing the database scheme.\n\n## Installation\n\n```bash\n$ pip install foliantcontrib.pgsqldoc\n```\n\n## Config\n\nTo enable the preprocessor, add `pgsqldoc` to `preprocessors` section in the project config:\n\n```yaml\npreprocessors:\n    - pgsqldoc\n```\n\nThe preprocessor has a number of options:\n\n```yaml\npreprocessors:\n    - pgsqldoc:\n        host: localhost\n        port: 5432\n        dbname: postgres\n        user: postgres\n        password: ''\n        draw: false\n        filters:\n            ...\n        doc_template: pgsqldoc.j2\n        scheme_template: scheme.j2\n```\n\n`host`\n:   PostgreSQL database host address. Default: `localhost`\n\n`port`\n:   PostgreSQL database port. Default: `5432`\n\n`dbname`\n:   PostgreSQL database name. Default: `postgres`\n\n`user`\n:   PostgreSQL user name. Default: `postgres`\n\n`passwrod`\n:   PostgreSQL user password.\n\n`draw`\n:   If this parameter is `true` \u2014 preprocessor would generate scheme of the database and add it to the end of the document. Default: `false`\n\n`filters`\n:   SQL-like operators for filtering the results. More info in the **Filters** section.\n\n`doc_template`\n:   Path to jinja-template for documentation. Path is relative to the project directory. Default: `pgsqldoc.j2`\n\n`scheme_template`\n:   Path to jinja-template for scheme. Path is relative to the project directory. Default: `scheme.j2`\n\n## Usage\n\nAdd a `<<pgsqldoc></pgsqldoc>` tag at the position in the document where the generated documentation of a PostgreSQL database should be inserted:\n\n```markdown\n# Introduction\n\nThis document contains the most awesome automatically generated documentation of our marvellous database.\n\n<<pgsqldoc></pgsqldoc>\n```\n\nEach time the preprocessor encounters the tag `<<pgsqldoc></pgsqldoc>` it inserts the whole generated documentation text instead of it. The connection parameters are taken from the config-file.\n\nYou can also specify some parameters (or all of them) in the tag options:\n\n```markdown\n# Introduction\n\nIntroduction text for database documentation.\n\n<pgsqldoc draw=\"true\"\n          host=\"11.51.126.8\"\n          port=\"5432\"\n          dbname=\"mydb\"\n          user=\"scott\"\n          password=\"tiger\">\n</pgsqldoc>\n```\n\nTag parameters have the highest priority.\n\nThis way you can have documentation for several different databases in one foliant project (even in one md-file if you like it so).\n\n## Filters\n\nYou can add filters to exclude some tables from the documentation. Pgsqldocs supports several SQL-like filtering operators and a determined list of filtering fields.\n\nYou can switch on filters either in foliant.yml file like this:\n\n```yaml\npreprocessors:\n  - pgsqldoc:\n    filters:\n      eq:\n        schema: public\n      regex:\n        table_name: 'main_.+'\n```\n\nor in tag options using the same yaml-syntax:\n\n```markdown\n\n<pgsqldoc filters=\"\neq:\n    schema: public\n  regex:\n    table_name: 'main_.+'\">\n</pgsqldoc>\n\n```\n\nList of currently supported operators:\n\noperator | SQL equivalent | description | value\n-------- | -------------- | ----------- | -----\n`eq` | `=` | equals | literal\n`not_eq` | `!=` | does not equal | literal\n`in` | `IN` | contains | list\n`not_in` | `NOT IN` | does not contain | list\n`regex` | `~` | matches regular expression | literal\n`not_regex` | `!~` | does not match regular expression | literal\n\nList of currently supported filtering fields:\n\nfield | description\n----- | -----------\nschema | filter by PostgreSQL database schema\ntable_name | filter by database table names\n\nThe syntax for using filters in configuration files is following:\n\n```yaml\nfilters:\n  <operator>:\n    <field>: value\n```\n\nIf `value` should be list like for `in` operator, use YAML-lists instead:\n\n```yaml\nfilters:\n  in:\n    schema:\n      - public\n      - corp\n```\n\n## About Templates\n\nThe structure of generated documentation is defined by jinja-templates. You can choose what elements will appear in the documentation, change their positions, add constant text, change layouts and more. Check the [Jinja documentation](http://jinja.pocoo.org/docs/2.10/templates/) for info on all cool things you can do with templates.\n\nIf you don't specify path to templates in the config-file and tag-options pgsqldoc will use default paths:\n\n- `<Project_path>/pgsqldoc.j2` for documentation template;\n- `<Project_path>/scheme.j2` for database scheme source template.\n\nIf pgsqldoc can't find these templates in the project dir it will generate default templates and put them there.\n\nSo if you accidentally mess things up while experimenting with templates you can always delete your templates and run preprocessor \u2014 the default ones will appear in the project dir. (But only if the templates are not specified in config-file or their names are the same as defaults).\n\nOne more useful thing about default templates is that you can find a detailed description of the source data they get from pgsqldoc in the beginning of the template.\n\n\n",
        "description_content_type": "text/markdown",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "",
        "keywords": "",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "foliantcontrib.pgsqldoc",
        "package_url": "https://pypi.org/project/foliantcontrib.pgsqldoc/",
        "platform": "any",
        "project_url": "https://pypi.org/project/foliantcontrib.pgsqldoc/",
        "project_urls": null,
        "release_url": "https://pypi.org/project/foliantcontrib.pgsqldoc/1.1.5/",
        "requires_dist": [
            "foliant (>=1.0.5)",
            "foliantcontrib.utils.combined-options",
            "foliantcontrib.plantuml",
            "psycopg2-binary",
            "jinja2",
            "PyYAML"
        ],
        "requires_python": "",
        "summary": "Documentation generator for PostgreSQL DB",
        "version": "1.1.5"
    },
    "last_serial": 5790262,
    "releases": {
        "1.0.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b3f5199f0367862ca9abd37b4d23c065",
                    "sha256": "1bf58926c1879e53c040aaa20860da28d95cc1801f539e82c902d8d9bbbb415e"
                },
                "downloads": -1,
                "filename": "foliantcontrib.pgsqldoc-1.0.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "b3f5199f0367862ca9abd37b4d23c065",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 5511,
                "upload_time": "2018-08-23T07:19:45",
                "url": "https://files.pythonhosted.org/packages/58/e5/c3f1f04ac04523463254c945713167043c77f5efe1cc603d6b7f6ee41519/foliantcontrib.pgsqldoc-1.0.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "9f79bde865f3eec4c22bd95dfd3d0b93",
                    "sha256": "f7c7eaaba176d06f9f477d2065fcbdb0b5b5af954c0f8fd9c00f2f40544b65db"
                },
                "downloads": -1,
                "filename": "foliantcontrib.pgsqldoc-1.0.0.tar.gz",
                "has_sig": false,
                "md5_digest": "9f79bde865f3eec4c22bd95dfd3d0b93",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5378,
                "upload_time": "2018-08-23T07:19:46",
                "url": "https://files.pythonhosted.org/packages/f3/03/3bfdc2ccf57d9d6dceec1fd8f8e06cfd91fa3a0f9511c97e84f43dd68367/foliantcontrib.pgsqldoc-1.0.0.tar.gz"
            }
        ],
        "1.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "94472974b635ba33ef6fb021200e4169",
                    "sha256": "4d19e3d27b588215fd361f4f5058224b8656c409da70f0939f0fd24bc1651b9b"
                },
                "downloads": -1,
                "filename": "foliantcontrib.pgsqldoc-1.1.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "94472974b635ba33ef6fb021200e4169",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 11351,
                "upload_time": "2018-08-24T08:31:24",
                "url": "https://files.pythonhosted.org/packages/c2/57/cb82795f2078c63e4f18b1b8b7cc88f0ad37b1495eeee2db20167e15277e/foliantcontrib.pgsqldoc-1.1.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "b0d8965b7f70333a0da8eac02b3fca32",
                    "sha256": "77bba449858617ed27bf418cec947a329dcf63935a1ee6dd639e252fba0e28d5"
                },
                "downloads": -1,
                "filename": "foliantcontrib.pgsqldoc-1.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "b0d8965b7f70333a0da8eac02b3fca32",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 7452,
                "upload_time": "2018-08-24T08:31:25",
                "url": "https://files.pythonhosted.org/packages/44/1d/60317f38d623f31605baa8f05660ebce787a6c0ab45a5a4efca6a079b5f1/foliantcontrib.pgsqldoc-1.1.0.tar.gz"
            }
        ],
        "1.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "95c55766af31acd06c1d0677730f39e8",
                    "sha256": "90b470f751e6111660947ed4e0d6a19fc19b199860820b15eb470add49d5fcbe"
                },
                "downloads": -1,
                "filename": "foliantcontrib.pgsqldoc-1.1.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "95c55766af31acd06c1d0677730f39e8",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 11855,
                "upload_time": "2018-08-27T12:26:03",
                "url": "https://files.pythonhosted.org/packages/38/4a/b0f1dddafa05d60b00a0e82fb6ce98697ebff6bbe451348b011f98ce4be8/foliantcontrib.pgsqldoc-1.1.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "9a0ae3f3be452896e9bb0f352c970792",
                    "sha256": "67564427c800a7cfe305e46aadd091d2dd0f994feec68b3759c398ba7ffc5b4e"
                },
                "downloads": -1,
                "filename": "foliantcontrib.pgsqldoc-1.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "9a0ae3f3be452896e9bb0f352c970792",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 7680,
                "upload_time": "2018-08-27T12:26:04",
                "url": "https://files.pythonhosted.org/packages/96/bd/51a5e2fcc6eb3bc9be2651273ef918daa52972a7db9783edec74c2f299c1/foliantcontrib.pgsqldoc-1.1.1.tar.gz"
            }
        ],
        "1.1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "fa8413800a4203e64b18e153e76a2186",
                    "sha256": "85a94e1ee5664a2d8c531dd9b2aa119c87af346f1d453dfd132e55e89edcfec3"
                },
                "downloads": -1,
                "filename": "foliantcontrib.pgsqldoc-1.1.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "fa8413800a4203e64b18e153e76a2186",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 12624,
                "upload_time": "2018-08-29T10:48:46",
                "url": "https://files.pythonhosted.org/packages/c4/90/7a91d5ca8e89557006c49438d615c74e47a25cb441ad96ec7dcb4fc62953/foliantcontrib.pgsqldoc-1.1.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "4d293456ace406eb36b53f1c3c28d6eb",
                    "sha256": "24d47629a5328b43b490dca525b4ae9a613f566c1c521277d4afa239a6e23a0d"
                },
                "downloads": -1,
                "filename": "foliantcontrib.pgsqldoc-1.1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "4d293456ace406eb36b53f1c3c28d6eb",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9686,
                "upload_time": "2018-08-29T10:48:48",
                "url": "https://files.pythonhosted.org/packages/c2/fa/aadcf0a700f55e89868cf5f0f771843ff6756e99daa4650d0d22e00827a8/foliantcontrib.pgsqldoc-1.1.2.tar.gz"
            }
        ],
        "1.1.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9e3baa24c0e9d274c6c12db5b56f1a0b",
                    "sha256": "b659b3f5e13543d214ddaf65be452c0d5abf4926bd78125a034a5690d8774b26"
                },
                "downloads": -1,
                "filename": "foliantcontrib.pgsqldoc-1.1.3-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "9e3baa24c0e9d274c6c12db5b56f1a0b",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 12478,
                "upload_time": "2018-12-11T08:30:16",
                "url": "https://files.pythonhosted.org/packages/3e/20/ad91a25fdd597c790077e719bb4ab1538b02dbdc0d51521014a050caf355/foliantcontrib.pgsqldoc-1.1.3-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "c46b7b571a22f40182ad1c1e8a346703",
                    "sha256": "3b188927a34cdadb69cfab030a427b89bc858caa06ef4ee81d6f5f1eb0ebdcff"
                },
                "downloads": -1,
                "filename": "foliantcontrib.pgsqldoc-1.1.3.tar.gz",
                "has_sig": false,
                "md5_digest": "c46b7b571a22f40182ad1c1e8a346703",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11835,
                "upload_time": "2018-12-11T08:30:17",
                "url": "https://files.pythonhosted.org/packages/bc/08/d46b6c36fdeb8fa0da4b7475ee66aadee5af4a7432e92e62e41c60373675/foliantcontrib.pgsqldoc-1.1.3.tar.gz"
            }
        ],
        "1.1.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "19e6ffd0e097ff9f1c0c47837f919112",
                    "sha256": "3fe930afd775412e295199b3a5d5c18c5e90906ccc798de09e1bcfbfc3f57f4d"
                },
                "downloads": -1,
                "filename": "foliantcontrib.pgsqldoc-1.1.5-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "19e6ffd0e097ff9f1c0c47837f919112",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 11524,
                "upload_time": "2019-02-14T11:09:27",
                "url": "https://files.pythonhosted.org/packages/58/a6/4eb023ab33ded1b24684c35e01143efe3f1f9b89dfa9f3961b090f175ae5/foliantcontrib.pgsqldoc-1.1.5-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "0cedb776354b8140f09f872f85a7a807",
                    "sha256": "74b19ff460dcc541edd390dc61dffc2fd35647a61360e3462c56233f191f1428"
                },
                "downloads": -1,
                "filename": "foliantcontrib.pgsqldoc-1.1.5.tar.gz",
                "has_sig": false,
                "md5_digest": "0cedb776354b8140f09f872f85a7a807",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11167,
                "upload_time": "2019-02-14T11:09:29",
                "url": "https://files.pythonhosted.org/packages/37/99/8287f70f512dc83a1175254b15438b05fa5e4ac113078886cd17695e2f58/foliantcontrib.pgsqldoc-1.1.5.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "19e6ffd0e097ff9f1c0c47837f919112",
                "sha256": "3fe930afd775412e295199b3a5d5c18c5e90906ccc798de09e1bcfbfc3f57f4d"
            },
            "downloads": -1,
            "filename": "foliantcontrib.pgsqldoc-1.1.5-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "19e6ffd0e097ff9f1c0c47837f919112",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 11524,
            "upload_time": "2019-02-14T11:09:27",
            "url": "https://files.pythonhosted.org/packages/58/a6/4eb023ab33ded1b24684c35e01143efe3f1f9b89dfa9f3961b090f175ae5/foliantcontrib.pgsqldoc-1.1.5-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "0cedb776354b8140f09f872f85a7a807",
                "sha256": "74b19ff460dcc541edd390dc61dffc2fd35647a61360e3462c56233f191f1428"
            },
            "downloads": -1,
            "filename": "foliantcontrib.pgsqldoc-1.1.5.tar.gz",
            "has_sig": false,
            "md5_digest": "0cedb776354b8140f09f872f85a7a807",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 11167,
            "upload_time": "2019-02-14T11:09:29",
            "url": "https://files.pythonhosted.org/packages/37/99/8287f70f512dc83a1175254b15438b05fa5e4ac113078886cd17695e2f58/foliantcontrib.pgsqldoc-1.1.5.tar.gz"
        }
    ]
}