FilesExpand file tree

 master

/

setup.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

108 lines (89 loc) · 3.12 KB

 master

/

setup.py

Copy path

Top

File metadata and controls

• Code
• Blame

108 lines (89 loc) · 3.12 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

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

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

#!/usr/bin/env python

# -*- coding: utf-8 -*-

#

# Copyright (C) 2016 Andi Albrecht, albrecht.andi@gmail.com

#

# This setup script is part of python-sqlparse and is released under

# the BSD License: https://opensource.org/licenses/BSD-3-Clause

import re

from setuptools import setup, find_packages

def get_version():

"""Parse __init__.py for version number instead of importing the file."""

VERSIONFILE = 'sqlparse/__init__.py'

VSRE = r'^__version__ = [\'"]([^\'"]*)[\'"]'

with open(VERSIONFILE) as f:

verstrline = f.read()

mo = re.search(VSRE, verstrline, re.M)

if mo:

return mo.group(1)

raise RuntimeError('Unable to find version in {fn}'.format(fn=VERSIONFILE))

LONG_DESCRIPTION = """

``sqlparse`` is a non-validating SQL parser module.

It provides support for parsing, splitting and formatting SQL statements.

Visit the `project page <https://github.com/andialbrecht/sqlparse>`_ for

additional information and documentation.

**Example Usage**

Splitting SQL statements::

>>> import sqlparse

>>> sqlparse.split('select * from foo; select * from bar;')

[u'select * from foo; ', u'select * from bar;']

Formatting statemtents::

>>> sql = 'select * from foo where id in (select id from bar);'

>>> print sqlparse.format(sql, reindent=True, keyword_case='upper')

SELECT *

FROM foo

WHERE id IN

(SELECT id

FROM bar);

Parsing::

>>> sql = 'select * from someschema.mytable where id = 1'

>>> res = sqlparse.parse(sql)

>>> res

(<Statement 'select...' at 0x9ad08ec>,)

>>> stmt = res[0]

>>> str(stmt) # converting it back to unicode

'select * from someschema.mytable where id = 1'

>>> # This is how the internal representation looks like:

>>> stmt.tokens

(<DML 'select' at 0x9b63c34>,

<Whitespace ' ' at 0x9b63e8c>,

<Operator '*' at 0x9b63e64>,

<Whitespace ' ' at 0x9b63c5c>,

<Keyword 'from' at 0x9b63c84>,

<Whitespace ' ' at 0x9b63cd4>,

<Identifier 'somes...' at 0x9b5c62c>,

<Whitespace ' ' at 0x9b63f04>,

<Where 'where ...' at 0x9b5caac>)

"""

setup(

name='sqlparse',

version=get_version(),

author='Andi Albrecht',

author_email='albrecht.andi@gmail.com',

url='https://github.com/andialbrecht/sqlparse',

description='Non-validating SQL parser',

long_description=LONG_DESCRIPTION,

license='BSD',

classifiers=[

'Development Status :: 4 - Beta',

'Intended Audience :: Developers',

'License :: OSI Approved :: BSD License',

'Operating System :: OS Independent',

'Programming Language :: Python',

'Programming Language :: Python :: 2',

'Programming Language :: Python :: 2.7',

'Programming Language :: Python :: 3',

'Programming Language :: Python :: 3.3',

'Programming Language :: Python :: 3.4',

'Programming Language :: Python :: 3.5',

'Programming Language :: Python :: 3.6',

'Topic :: Database',

'Topic :: Software Development',

],

packages=find_packages(exclude=('tests',)),

entry_points={

'console_scripts': [

'sqlformat = sqlparse.__main__:main',

]

},

)