{ "info": { "author": "HIROSE Masaaki", "author_email": "hirose31@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Topic :: Database" ], "description": "[![Build Status](https://travis-ci.org/hirose31/mysql-grantparser-python.svg?branch=master)](https://travis-ci.org/hirose31/mysql-grantparser-python)\n\n# NAME\n\nmysql_grantparser - parse MySQL SHOW GRANTS\n\n# SYNOPSIS\n\n``` python\nimport mysql_grantparser\n\ngrants = mysql_grantparser.Exporter(\n host='127.0.0.1',\n port=3306,\n user='root',\n password='pa55w0rd',\n).export()\n\n```\n\n# DESCRIPTION\n\nmysql_grantparser is SHOW GRANTS parser for MySQL, inspired by Ruby's [Gratan](https://github.com/codenize-tools/gratan).\n\nThis module returns privileges for all users as following dict.\n\n``` python\n{\n 'USER@HOST': {\n 'user': USER,\n 'host': HOST,\n 'objects': {\n 'DB_NAME.TABLE_NAME': {\n 'privs': [ PRIV_TYPE, PRIV_TYPE, ... ],\n 'with': 'GRANT OPTION',\n },\n ...\n },\n 'options': {\n 'identified': '...',\n 'required': '...',\n },\n },\n ...\n}\n```\n\nFor example, this GRANT statement\n\n``` sql\nGRANT SELECT, INSERT, UPDATE, DELETE ON orcl.* TO 'scott'@'%' IDENTIFIED BY 'tiger' WITH GRANT OPTION;\n```\n\nis represented as following.\n\n``` python\n{\n 'scott@%': {\n 'user': 'scott',\n 'host': '%',\n 'objects': {\n '*.*': {\n privs: [\n 'USAGE'\n ],\n },\n 'orcl.*': {\n 'privs': [\n 'SELECT',\n 'INSERT',\n 'UPDATE',\n 'DELETE',\n ],\n 'with': 'GRANT OPTION',\n }\n },\n 'options': {\n 'identified': \"PASSWORD XXX\",\n },\n },\n}\n```\n\n# SEE ALSO\n\n- Documentation: https://github.com/hirose31/mysql-grantparser-python/blob/master/README.md\n- Changelog: https://github.com/hirose31/mysql-grantparser-python/blob/master/CHANGELOG.md\n- Repository: https://github.com/hirose31/mysql-grantparser-python\n- Test status: https://travis-ci.org/hirose31/mysql-grantparser-python\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": "https://github.com/hirose31/mysql-grantparser-python", "keywords": "MySQL", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "mysql-grantparser", "package_url": "https://pypi.org/project/mysql-grantparser/", "platform": "", "project_url": "https://pypi.org/project/mysql-grantparser/", "project_urls": { "Homepage": "https://github.com/hirose31/mysql-grantparser-python" }, "release_url": "https://pypi.org/project/mysql-grantparser/1.0.3/", "requires_dist": [ "setuptools (>=30.3.0)", "mysql-connector-python", "pytest (>=3); extra == 'dev'", "coverage; extra == 'dev'", "tox; extra == 'dev'" ], "requires_python": ">=3.5", "summary": "parse MySQL SHOW GRANTS.", "version": "1.0.3" }, "last_serial": 4735158, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "f00602624ac41a7c60b4dc7af77bb3bb", "sha256": "b76ac9024a42bdec12bdf2c066829f015aa4278b7043e3b47cb9335b8298036c" }, "downloads": -1, "filename": "mysql_grantparser-1.0.0-py3-none-any.whl", "has_sig": false, "md5_digest": "f00602624ac41a7c60b4dc7af77bb3bb", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 5935, "upload_time": "2019-01-21T09:08:44", "url": "https://files.pythonhosted.org/packages/4d/5e/4d156fe8ecaac7183366cbcbadde81eea75a30a7856e230b177ea33e27f7/mysql_grantparser-1.0.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "bd2330dc4fd2a00763a3a121a856caf3", "sha256": "b699d17393a18b3d7508a6dfbca132c4d4ecb7025136b80862d46f95ed4f99cd" }, "downloads": -1, "filename": "mysql-grantparser-1.0.0.tar.gz", "has_sig": false, "md5_digest": "bd2330dc4fd2a00763a3a121a856caf3", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 4905, "upload_time": "2019-01-21T09:08:46", "url": "https://files.pythonhosted.org/packages/a9/19/ee22ac5f6ac0844a9df55e33ea6df28e9f9ed19137bfb5a5745cb630220c/mysql-grantparser-1.0.0.tar.gz" } ], "1.0.1": [ { "comment_text": "", "digests": { "md5": "d8a6368a1e65b9163d993334dd2505a9", "sha256": "1ce7435d2ea87116147ac1a33d241027996e5334470eecd012b667f9695e0875" }, "downloads": -1, "filename": "mysql_grantparser-1.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "d8a6368a1e65b9163d993334dd2505a9", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 5796, "upload_time": "2019-01-22T07:35:09", "url": "https://files.pythonhosted.org/packages/af/57/32f645818f51177b0951ad757c436c9b57b2bf6d32808b9f71d2d2a0a278/mysql_grantparser-1.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "3f2839c8d26123bc29fc549f7fddccd1", "sha256": "c5df3921c190b21380f86670257c0d41ca6bb193c136dbadc1786bdd3d18394e" }, "downloads": -1, "filename": "mysql-grantparser-1.0.1.tar.gz", "has_sig": false, "md5_digest": "3f2839c8d26123bc29fc549f7fddccd1", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 5044, "upload_time": "2019-01-22T07:35:10", "url": "https://files.pythonhosted.org/packages/18/4d/8174fadb152f67971856d3df54f840816cd8ecc3c97b960396cbfe94b5e8/mysql-grantparser-1.0.1.tar.gz" } ], "1.0.2": [ { "comment_text": "", "digests": { "md5": "889e96eca67ecce10a894a0270d27ce5", "sha256": "c1622b9feb479f5f2404bce9e2202144aa52b06bd1724fea90c461879c9cf1ed" }, "downloads": -1, "filename": "mysql_grantparser-1.0.2-py3-none-any.whl", "has_sig": false, "md5_digest": "889e96eca67ecce10a894a0270d27ce5", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 5982, "upload_time": "2019-01-23T12:06:08", "url": "https://files.pythonhosted.org/packages/e0/36/917f52b4fd050051a4f5da27627d3238206d6b27004903da0982b36b8567/mysql_grantparser-1.0.2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "10fde99bca8b260732b87bb5d0a6ef2d", "sha256": "997997ee405c1c76467bd0bb45ae716c88a0a2fb1b451a5424e52dccd9e3c777" }, "downloads": -1, "filename": "mysql-grantparser-1.0.2.tar.gz", "has_sig": false, "md5_digest": "10fde99bca8b260732b87bb5d0a6ef2d", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 5201, "upload_time": "2019-01-23T12:06:09", "url": "https://files.pythonhosted.org/packages/64/49/11f38d671a36e36f59d6f18ca80a270d684c13402de93006821dffe42865/mysql-grantparser-1.0.2.tar.gz" } ], "1.0.3": [ { "comment_text": "", "digests": { "md5": "9e82235c41d98f3d4c6623cf956a9512", "sha256": "d6cc35cbced766cc24815f5af1c45cd51ba039c9a451af42cb974a0a3f6d0754" }, "downloads": -1, "filename": "mysql_grantparser-1.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "9e82235c41d98f3d4c6623cf956a9512", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 5979, "upload_time": "2019-01-24T10:48:06", "url": "https://files.pythonhosted.org/packages/61/07/c7a70efed7177d4e51014304c6fe26f5d4f756af7161d031920969f637f0/mysql_grantparser-1.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "ce923869c0595b68892130355d4d21d4", "sha256": "04d1f708a432a35edca0d2812a9e1fab554d2dfc6553f955c0e193e3e528c594" }, "downloads": -1, "filename": "mysql-grantparser-1.0.3.tar.gz", "has_sig": false, "md5_digest": "ce923869c0595b68892130355d4d21d4", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 5242, "upload_time": "2019-01-24T10:48:08", "url": "https://files.pythonhosted.org/packages/20/de/2e563ca5f19aae4938f98d534e8336f44f1b90afe374fea2c453341ca956/mysql-grantparser-1.0.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "9e82235c41d98f3d4c6623cf956a9512", "sha256": "d6cc35cbced766cc24815f5af1c45cd51ba039c9a451af42cb974a0a3f6d0754" }, "downloads": -1, "filename": "mysql_grantparser-1.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "9e82235c41d98f3d4c6623cf956a9512", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.5", "size": 5979, "upload_time": "2019-01-24T10:48:06", "url": "https://files.pythonhosted.org/packages/61/07/c7a70efed7177d4e51014304c6fe26f5d4f756af7161d031920969f637f0/mysql_grantparser-1.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "ce923869c0595b68892130355d4d21d4", "sha256": "04d1f708a432a35edca0d2812a9e1fab554d2dfc6553f955c0e193e3e528c594" }, "downloads": -1, "filename": "mysql-grantparser-1.0.3.tar.gz", "has_sig": false, "md5_digest": "ce923869c0595b68892130355d4d21d4", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.5", "size": 5242, "upload_time": "2019-01-24T10:48:08", "url": "https://files.pythonhosted.org/packages/20/de/2e563ca5f19aae4938f98d534e8336f44f1b90afe374fea2c453341ca956/mysql-grantparser-1.0.3.tar.gz" } ] }