Get the mysql's tokens by the tool.
Project description
mysqltokenparser
A awesome tool that easy to get MySQL’s tokens.
Free software: MIT license
Documentation: https://mysqltokenparser.readthedocs.io.
Quickstart
0x01 Inistall
pip install mysqltokenparser
0x02 Tutorial
The library is so simple.
All types of SQL have different keys that are easy to identify.
And then You need to explore it.
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 DDL(CREATE table, ALTER table), DML(simple SELECT, INSERT, DELETE, UPDATE).
TODO:SUPPORT MORE SQL STATEMENTS
Credits
This package was created with Cookiecutter and the audreyr/cookiecutter-pypackage project template.
History
2.2.0 (2019-11-25)
Add support DDL(CREATE table, ALTER table), DML(simple SELECT, INSERT, DELETE, UPDATE).
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
Built Distribution
Hashes for mysqltokenparser-2.2.0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6bea93fdef8e99995b2ab1ff7fe4c74f8e85b8fc79c957115aae94023b0880bd |
|
MD5 | 12ac330ba395f558bb86cd99330ee7aa |
|
BLAKE2b-256 | 3f4c7e62fc61ab19e6e770f95a18c7dd97fe829c83a748fc07cc81b646ecd282 |