Ⅰ. 插件描述
A non-validating SQL parser module for PythonⅡ. 基本信息
|
Ⅲ. 安装方法
使用Vundle管理器安装
在你的.vimrc下添加:Plugin 'andialbrecht/sqlparse':source %
:PluginInstall对于Vundle版本 < 0.10.2，请用上面的Bundle替换Plugin。
使用NeoBundle管理器安装
在你的.vimrc下添加:NeoBundle 'andialbrecht/sqlparse':source %
:NeoBundleInstall使用VimPlug管理器安装
在你的.vimrc下添加:Plug 'andialbrecht/sqlparse':source %
:PlugInstall使用Pathogen管理器安装
在终端中运行以下命令:cd ~/.vim/bundle
git clone https://github.com/andialbrecht/sqlparseⅣ. 文档说明
python-sqlparse - Parse SQL statements
|buildstatus|_
|coverage|_
.. docincludebegin
sqlparse is a non-validating SQL parser for Python.
It provides support for parsing, splitting and formatting SQL statements.
The module is compatible with Python 2.7 and Python 3 (>= 3.4)
and released under the terms of the `New BSD license
https://opensource.org/licenses/BSD-3-Clause`_.
.. note::
Support for Python<3.4 (including 2.x) will be dropped soon.
Visit the project page at https://github.com/andialbrecht/sqlparse for
further information about this project.
Quick Start
.. code-block:: sh
$ pip install sqlparse
.. code-block:: python
import sqlparse
Split a string containing two SQL statements:
raw = 'select from foo; select from bar;'
statements = sqlparse.split(raw)
statements
['select from foo;', 'select from bar;']
Format the first statement and print it out:
first = statements[0]
print(sqlparse.format(first, reindent=True, keyword_case='upper'))
SELECT *
FROM foo;
Parsing a SQL statement:
parsed = sqlparse.parse('select * from foo')[0]
parsed.tokens
[<DML 'select' at 0x7f22c5e15368>, <Whitespace ' ' at 0x7f22c5e153b0>, <Wildcard '*' … ]
Links
Project page
https://github.com/andialbrecht/sqlparse
Bug tracker
https://github.com/andialbrecht/sqlparse/issues
Documentation
https://sqlparse.readthedocs.io/
Online Demo
https://sqlformat.org/
sqlparse is licensed under the BSD license.
Parts of the code are based on pygments written by Georg Brandl and others.
pygments-Homepage: http://pygments.org/
.. |buildstatus| image:: https://secure.travis-ci.org/andialbrecht/sqlparse.png?branch=master
.. _buildstatus: https://travis-ci.org/#!/andialbrecht/sqlparse
.. |coverage| image:: https://coveralls.io/repos/andialbrecht/sqlparse/badge.svg?branch=master&service=github
.. _coverage: https://coveralls.io/github/andialbrecht/sqlparse?branch=master
