Skip to main content

Get the mysql's tokens by the tool.

Project description

mysqltokenparser

https://img.shields.io/pypi/v/mysqltokenparser.svg https://img.shields.io/travis/LoveXiaoLiu/mysqltokenparser.svg Documentation Status Updates

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

Quickstart

0x01 安装

pip install mysqltokenparser

0x02 使用教程

import mysqltokenparser as mtp

sql = u"""
    ALTER TABLE t_a_gun2_6_dw_pfm_emp_cm ADD INDEX idx_eob_date(empid_org_bus (200),pfm_date);
"""

tokens = mtp.mysql_token_parser(sql)
print tokens
#{
#    "type": "ddl",
#    "data": {
#        "type": "altertable",
#        "data": {
#            "tablename": "t_a_gun2_6_dw_pfm_emp_cm",
#            "alter_data": [{
#                "type": "addindex",
#                "data": {
#                    "indexdefinition": {
#                        "columnnames": ["empid_org_bus", "pfm_date"]
#                    },
#                    "indexname": "idx_eob_date"
#                }
#            }]
#        }
#    }
#}

Features

  • Current version only support create and alter table

  • TODO:SUPPORT MORE SQL STATEMENTS

Credits

This package was created with Cookiecutter and the audreyr/cookiecutter-pypackage project template.

History

2.0.0 (2019-11-14)

  • Refactor API.

0.1.0 (2019-07-08)

  • First release on PyPI.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

mysqltokenparser-2.1.2.tar.gz (402.1 kB view hashes)

Uploaded Source

Built Distribution

mysqltokenparser-2.1.2-py2.py3-none-any.whl (408.7 kB view hashes)

Uploaded Python 2 Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page