{ "info": { "author": "gra55", "author_email": "shuai.grass@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 2 - Pre-Alpha", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Natural Language :: English", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7" ], "description": "================\r\nmysqltokenparser\r\n================\r\n\r\n\r\n.. image:: https://img.shields.io/pypi/v/mysqltokenparser.svg\r\n :target: https://pypi.python.org/pypi/mysqltokenparser\r\n\r\n.. image:: https://img.shields.io/travis/LoveXiaoLiu/mysqltokenparser.svg\r\n :target: https://travis-ci.org/LoveXiaoLiu/mysqltokenparser\r\n\r\n.. image:: https://readthedocs.org/projects/mysqltokenparser/badge/?version=latest\r\n :target: https://mysqltokenparser.readthedocs.io/en/latest/?badge=latest\r\n :alt: Documentation Status\r\n\r\n\r\n.. image:: https://pyup.io/repos/github/LoveXiaoLiu/mysqltokenparser/shield.svg\r\n :target: https://pyup.io/repos/github/LoveXiaoLiu/mysqltokenparser/\r\n :alt: Updates\r\n\r\n\r\n\r\nA awesome tool that easy to get MySQL's tokens.\r\n\r\n\r\n* Free software: MIT license\r\n* Documentation: https://mysqltokenparser.readthedocs.io.\r\n\r\n\r\nQuickstart\r\n----------\r\n\r\n0x01 \u5b89\u88c5\r\n\r\n.. code:: shell\r\n\r\n pip install mysqltokenparser\r\n\r\n0x02 \u4f7f\u7528\u6559\u7a0b\r\n\r\n.. code:: python\r\n\r\n import mysqltokenparser as mtp\r\n\r\n sql = u\"\"\"\r\n CREATE TABLE `aaa`.`t_zcm_operation_luck_award_record` (\r\n `id` bigint(20) NOT NULL,\r\n `operation_seq` varchar(30) NOT NULL,\r\n `award_user_id` bigint(20) NOT NULL,\r\n `award_type` int(11) DEFAULT NULL,\r\n `award_id` varchar(40) DEFAULT NULL UNIQUE KEY,\r\n `award_content` varchar(20) DEFAULT NULL,\r\n `award_reason` varchar(30) DEFAULT NULL,\r\n `award_source` int(11) DEFAULT NULL,\r\n `state` tinyint(4) NOT NULL PRIMARY KEY,\r\n `addtime` datetime NOT NULL,\r\n `updatetime` datetime NOT NULL,\r\n `ip` varchar(50) DEFAULT NULL,\r\n `imei` varchar(50) DEFAULT NULL,\r\n `intext` int(11) DEFAULT NULL,\r\n `longext` bigint(20) DEFAULT NULL,\r\n `strext` varchar(200) DEFAULT NULL,\r\n PRIMARY KEY (id),\r\n UNIQUE KEY `idx_op_seq_uid_type` (`operation_seq`,`award_user_id`,`award_type`),\r\n KEY `idx_op_uid_type` (`award_user_id`,`award_type`),\r\n KEY `idx_op_uid_sss` (longext(10))\r\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n \"\"\"\r\n\r\n token_obj = mtp.mysql_token_parser(sql)\r\n tokens = token_obj.get_tokens()\r\n print tokens\r\n # {\r\n # 'uniquekey': ['award_id'],\r\n # 'columnnames': [u'id', u'operation_seq', u'award_user_id', u'award_type', u'award_id', u'award_content', u'award_reason', u'award_source', u'state', u'addtime', u'updatetime', u'ip', u'imei', u'intext', u'longext', u'strext'],\r\n # 'tablenames': [u'aaa.t_zcm_operation_luck_award_record'],\r\n # 'sqltype': ['ddl'],\r\n # 'primarykey': ['state'],\r\n # 'indexnames': [u'id', u'operation_seq,award_user_id,award_type', u'award_user_id,award_type', u'longext(10)']\r\n # }\r\n\r\n\r\nFeatures\r\n--------\r\n\r\n* TODO\r\n\r\nCredits\r\n-------\r\n\r\nThis package was created with Cookiecutter_ and the `audreyr/cookiecutter-pypackage`_ project template.\r\n\r\n.. _Cookiecutter: https://github.com/audreyr/cookiecutter\r\n.. _`audreyr/cookiecutter-pypackage`: https://github.com/audreyr/cookiecutter-pypackage\r\n\r\n\r\n=======\r\nHistory\r\n=======\r\n\r\n0.1.0 (2019-07-08)\r\n------------------\r\n\r\n* First release on PyPI.\r\n\r\n\r\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/LoveXiaoLiu/mysqltokenparser", "keywords": "mysqltokenparser", "license": "MIT license", "maintainer": "", "maintainer_email": "", "name": "mysqltokenparser", "package_url": "https://pypi.org/project/mysqltokenparser/", "platform": "", "project_url": "https://pypi.org/project/mysqltokenparser/", "project_urls": { "Homepage": "https://github.com/LoveXiaoLiu/mysqltokenparser" }, "release_url": "https://pypi.org/project/mysqltokenparser/1.0.0/", "requires_dist": [ "antlr4-python2-runtime (==4.7.2)" ], "requires_python": "", "summary": "Get the mysql's tokens by the tool.", "version": "1.0.0" }, "last_serial": 5578274, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "b1c9c801ae6d3b55acfded520565910c", "sha256": "bcfe42633cde8ae31590056dd7a3ecedbca12288099852435fce4bceb2cbf63c" }, "downloads": -1, "filename": "mysqltokenparser-0.1.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "b1c9c801ae6d3b55acfded520565910c", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 3414, "upload_time": "2019-07-08T12:41:10", "url": "https://files.pythonhosted.org/packages/19/87/970050b3880c27cbf1dddc53357cca454bc4f7ed7dc1594db342246b75b7/mysqltokenparser-0.1.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "eeb4cd9f559f20b309ae25c945415f17", "sha256": "b793f8df76639b513778a5e7a2f0930a3ebd5443e6cf8c826c6ad354a684da41" }, "downloads": -1, "filename": "mysqltokenparser-0.1.0.tar.gz", "has_sig": false, "md5_digest": "eeb4cd9f559f20b309ae25c945415f17", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8102, "upload_time": "2019-07-08T12:41:13", "url": "https://files.pythonhosted.org/packages/05/36/0e28c0e06e94837cf031e9c6968d2b3337b3e851e8f1c9b49f16a7c531c2/mysqltokenparser-0.1.0.tar.gz" } ], "0.2.0": [ { "comment_text": "", "digests": { "md5": "96de9631ae8f577866a42dbc6489e860", "sha256": "47aaf4bb3b7497d14d4da3a168364286d06dc757ae61ab1f350e257e0df6b5c2" }, "downloads": -1, "filename": "mysqltokenparser-0.2.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "96de9631ae8f577866a42dbc6489e860", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 405179, "upload_time": "2019-07-08T16:45:33", "url": "https://files.pythonhosted.org/packages/2f/b4/af6e02db0bcf40947c0d2831d3617ae33b1812089958e35b1ca554c4b626/mysqltokenparser-0.2.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9f19e5ae88a11426095ef4f11401ad54", "sha256": "655e1ffa5bfff4f516dc5df41ff0ae463c95f474567f578c9d404b39b4f5867c" }, "downloads": -1, "filename": "mysqltokenparser-0.2.0.tar.gz", "has_sig": false, "md5_digest": "9f19e5ae88a11426095ef4f11401ad54", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 399019, "upload_time": "2019-07-08T16:45:42", "url": "https://files.pythonhosted.org/packages/47/61/afc0ce2ffcb7807a9336b9281efff562bee8bdfd0b7f6e270a5583a96596/mysqltokenparser-0.2.0.tar.gz" } ], "0.3.0": [ { "comment_text": "", "digests": { "md5": "d83cc1cfcda0bde2157b635aa40d16ed", "sha256": "9a9436e2dc972fa7d93017f0e82601ed9318266245b9152e517cf27755caf99c" }, "downloads": -1, "filename": "mysqltokenparser-0.3.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "d83cc1cfcda0bde2157b635aa40d16ed", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 405214, "upload_time": "2019-07-08T17:18:44", "url": "https://files.pythonhosted.org/packages/1c/46/db2f2849a4ff55b0edc868158c5bd66b7c7c053e6bbdd4f31b94597dba42/mysqltokenparser-0.3.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "d19785a1b7ea45ba6c0c45b5c0b11bd4", "sha256": "5a5a0fa9b7729e315f9bb9ff03857fd0dfd5b028c28582a6f69e29a0f4e15cb4" }, "downloads": -1, "filename": "mysqltokenparser-0.3.0.tar.gz", "has_sig": false, "md5_digest": "d19785a1b7ea45ba6c0c45b5c0b11bd4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 399044, "upload_time": "2019-07-08T17:18:52", "url": "https://files.pythonhosted.org/packages/db/95/bb50f51190a6cd04592664d5e74d12a605038a391921f722c9d6661f9798/mysqltokenparser-0.3.0.tar.gz" } ], "1.0.0": [ { "comment_text": "", "digests": { "md5": "3139409664d7591b00db9bc38f944383", "sha256": "cc9e7c128e8703628839e302ffcd5797741bd1bfa832f0a769d7dce44e85754e" }, "downloads": -1, "filename": "mysqltokenparser-1.0.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "3139409664d7591b00db9bc38f944383", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 405071, "upload_time": "2019-07-24T15:47:45", "url": "https://files.pythonhosted.org/packages/12/18/692c7462333e869be8cf9ffbd224a91ca048e4261d35fd5d0c60392e9efe/mysqltokenparser-1.0.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "0aff45a7a4d13c174b4484a1d0ba18cc", "sha256": "ad13ca34e70d681de86ce7e024fd1e643069494c25146a0c2fe3fdb1eb6e43f7" }, "downloads": -1, "filename": "mysqltokenparser-1.0.0.tar.gz", "has_sig": false, "md5_digest": "0aff45a7a4d13c174b4484a1d0ba18cc", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 399709, "upload_time": "2019-07-24T15:48:00", "url": "https://files.pythonhosted.org/packages/e1/67/4e2eedf142e3be55bb10e9de32ee876176a5a8efa0cf67d51981d67dec40/mysqltokenparser-1.0.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "3139409664d7591b00db9bc38f944383", "sha256": "cc9e7c128e8703628839e302ffcd5797741bd1bfa832f0a769d7dce44e85754e" }, "downloads": -1, "filename": "mysqltokenparser-1.0.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "3139409664d7591b00db9bc38f944383", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 405071, "upload_time": "2019-07-24T15:47:45", "url": "https://files.pythonhosted.org/packages/12/18/692c7462333e869be8cf9ffbd224a91ca048e4261d35fd5d0c60392e9efe/mysqltokenparser-1.0.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "0aff45a7a4d13c174b4484a1d0ba18cc", "sha256": "ad13ca34e70d681de86ce7e024fd1e643069494c25146a0c2fe3fdb1eb6e43f7" }, "downloads": -1, "filename": "mysqltokenparser-1.0.0.tar.gz", "has_sig": false, "md5_digest": "0aff45a7a4d13c174b4484a1d0ba18cc", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 399709, "upload_time": "2019-07-24T15:48:00", "url": "https://files.pythonhosted.org/packages/e1/67/4e2eedf142e3be55bb10e9de32ee876176a5a8efa0cf67d51981d67dec40/mysqltokenparser-1.0.0.tar.gz" } ] }