blob: 1e39f08b0016ab7a42ec287da3fea8a5fddf61ec (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
|
# Copyright (C) 2008 Andi Albrecht, albrecht.andi@gmail.com
#
# This module is part of python-sqlparse and is released under
# the BSD License: http://www.opensource.org/licenses/bsd-license.php.
"""Parse SQL statements."""
__version__ = '0.2.0'
# Setup namespace
from sqlparse import engine, filters, formatter
from sqlparse.filters import serializerUnicode
def parse(sql):
"""Parse sql and return a list of statements.
*sql* is a single string containting one or more SQL statements.
Returns a tuple of :class:`~sqlparse.sql.Statement` instances.
"""
return tuple(parsestream(sql))
def parsestream(stream):
"""Parse sql statements from file-like object.
Returns a generator of Statement instances.
"""
stack = engine.FilterStack()
stack.full_analyze()
return stack.run(stream)
def format(sql, **options):
"""Format *sql* according to *options*.
Available options are documented in :ref:`formatting`.
Returns the formatted SQL statement as string.
"""
stack = engine.FilterStack()
options = formatter.validate_options(options)
stack = formatter.build_filter_stack(stack, options)
stack.postprocess.append(serializerUnicode)
return ''.join(stack.run(sql))
def split(sql):
"""Split *sql* into single statements.
Returns a list of strings.
"""
stack = engine.FilterStack()
stack.split_statements = True
return [unicode(stmt) for stmt in stack.run(sql)]
from sqlparse.engine.filter import statementFilter
def split2(stream):
return list(statementFilter(stream))
|
