Metadata-Version: 2.1
Name: mysqltokenparser
Version: 1.0.0
Summary: Get the mysql's tokens by the tool.
Home-page: https://github.com/LoveXiaoLiu/mysqltokenparser
Author: gra55
Author-email: shuai.grass@gmail.com
License: MIT license
Keywords: mysqltokenparser
Platform: UNKNOWN
Classifier: Development Status :: 2 - Pre-Alpha
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: MIT License
Classifier: Natural Language :: English
Classifier: Programming Language :: Python :: 2
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.4
Classifier: Programming Language :: Python :: 3.5
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: Python :: 3.7
Requires-Dist: antlr4-python2-runtime (==4.7.2)

================
mysqltokenparser
================


.. image:: https://img.shields.io/pypi/v/mysqltokenparser.svg
        :target: https://pypi.python.org/pypi/mysqltokenparser

.. image:: https://img.shields.io/travis/LoveXiaoLiu/mysqltokenparser.svg
        :target: https://travis-ci.org/LoveXiaoLiu/mysqltokenparser

.. image:: https://readthedocs.org/projects/mysqltokenparser/badge/?version=latest
        :target: https://mysqltokenparser.readthedocs.io/en/latest/?badge=latest
        :alt: Documentation Status


.. image:: https://pyup.io/repos/github/LoveXiaoLiu/mysqltokenparser/shield.svg
     :target: https://pyup.io/repos/github/LoveXiaoLiu/mysqltokenparser/
     :alt: Updates



A awesome tool that easy to get MySQL's tokens.


* Free software: MIT license
* Documentation: https://mysqltokenparser.readthedocs.io.


Quickstart
----------

0x01 安装

.. code:: shell

   pip install mysqltokenparser

0x02 使用教程

.. code:: python

    import mysqltokenparser as mtp

    sql = u"""
        CREATE TABLE `aaa`.`t_zcm_operation_luck_award_record` (
          `id` bigint(20) NOT NULL,
          `operation_seq` varchar(30) NOT NULL,
          `award_user_id` bigint(20) NOT NULL,
          `award_type` int(11) DEFAULT NULL,
          `award_id` varchar(40) DEFAULT NULL UNIQUE KEY,
          `award_content` varchar(20)  DEFAULT NULL,
          `award_reason` varchar(30)  DEFAULT NULL,
          `award_source` int(11) DEFAULT NULL,
          `state` tinyint(4) NOT NULL PRIMARY KEY,
          `addtime` datetime NOT NULL,
          `updatetime` datetime NOT NULL,
          `ip` varchar(50)  DEFAULT NULL,
          `imei` varchar(50)  DEFAULT NULL,
          `intext` int(11) DEFAULT NULL,
          `longext` bigint(20) DEFAULT NULL,
          `strext` varchar(200)  DEFAULT NULL,
          PRIMARY KEY (id),
          UNIQUE KEY `idx_op_seq_uid_type` (`operation_seq`,`award_user_id`,`award_type`),
          KEY `idx_op_uid_type` (`award_user_id`,`award_type`),
          KEY `idx_op_uid_sss` (longext(10))
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    """

    token_obj = mtp.mysql_token_parser(sql)
    tokens = token_obj.get_tokens()
    print tokens
    # {
    #     'uniquekey': ['award_id'],
    #     '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'],
    #     'tablenames': [u'aaa.t_zcm_operation_luck_award_record'],
    #     'sqltype': ['ddl'],
    #     'primarykey': ['state'],
    #     'indexnames': [u'id', u'operation_seq,award_user_id,award_type', u'award_user_id,award_type', u'longext(10)']
    # }


Features
--------

* TODO

Credits
-------

This package was created with Cookiecutter_ and the `audreyr/cookiecutter-pypackage`_ project template.

.. _Cookiecutter: https://github.com/audreyr/cookiecutter
.. _`audreyr/cookiecutter-pypackage`: https://github.com/audreyr/cookiecutter-pypackage


=======
History
=======

0.1.0 (2019-07-08)
------------------

* First release on PyPI.


