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
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
|
#! /usr/bin/python
# $Id: setup.py 896 2016-12-10 15:04:32Z darcy $
"""Setup script for PyGreSQL version 5.0.3
PyGreSQL is an open-source Python module that interfaces to a
PostgreSQL database. It embeds the PostgreSQL query library to allow
easy use of the powerful PostgreSQL features from a Python script.
Authors and history:
* PyGreSQL written 1997 by D'Arcy J.M. Cain <darcy@druid.net>
* based on code written 1995 by Pascal Andre <andre@chimay.via.ecp.fr>
* setup script created 2000 by Mark Alexander <mwa@gate.net>
* improved 2000 by Jeremy Hylton <jeremy@cnri.reston.va.us>
* improved 2001 by Gerhard Haering <gerhard@bigfoot.de>
* improved 2006 and 2016 by Christoph Zwerschke <cito@online.de>
Prerequisites to be installed:
* Python including devel package (header files and distutils)
* PostgreSQL libs and devel packages (header file of the libpq client)
* PostgreSQL pg_config tool (usually included in the devel package)
(the Windows installer has it as part of the database server feature)
The supported versions are Python 2.6-2.7, 3.3-3.5 and PostgreSQL 9.0-9.5.
Use as follows:
python setup.py build # to build the module
python setup.py install # to install it
See docs.python.org/doc/install/ for more information on
using distutils to install Python programs.
"""
version = '5.0.3'
import sys
if (not (2, 6) <= sys.version_info[:2] < (3, 0)
and not (3, 3) <= sys.version_info[:2] < (4, 0)):
raise Exception("Sorry, PyGreSQL %s"
" does not support this Python version" % version)
import os
import platform
import re
import warnings
try:
from setuptools import setup
except ImportError:
from distutils.core import setup
from distutils.extension import Extension
from distutils.command.build_ext import build_ext
from distutils.ccompiler import get_default_compiler
from distutils.sysconfig import get_python_inc, get_python_lib
# For historical reasons, PyGreSQL does not install itself as a single
# "pygresql" package, but as two top-level modules "pg", providing the
# classic interface, and "pgdb" for the modern DB-API 2.0 interface.
# These two top-level Python modules share the same C extension "_pg".
py_modules = ['pg', 'pgdb']
c_sources = ['pgmodule.c']
def pg_config(s):
"""Retrieve information about installed version of PostgreSQL."""
f = os.popen('pg_config --%s' % s)
d = f.readline().strip()
if f.close() is not None:
raise Exception("pg_config tool is not available.")
if not d:
raise Exception("Could not get %s information." % s)
return d
def pg_version():
"""Return the PostgreSQL version as a tuple of integers."""
match = re.search(r'(\d+)\.(\d+)', pg_config('version'))
if match:
return tuple(map(int, match.groups()))
return (9, 0)
pg_version = pg_version()
libraries = ['pq']
# Make sure that the Python header files are searched before
# those of PostgreSQL, because PostgreSQL can have its own Python.h
include_dirs = [get_python_inc(), pg_config('includedir')]
library_dirs = [get_python_lib(), pg_config('libdir')]
define_macros = [('PYGRESQL_VERSION', version)]
undef_macros = []
extra_compile_args = ['-O2', '-funsigned-char', '-Wall', '-Werror']
class build_pg_ext(build_ext):
"""Customized build_ext command for PyGreSQL."""
description = "build the PyGreSQL C extension"
user_options = build_ext.user_options + [
('direct-access', None,
"enable direct access functions"),
('large-objects', None,
"enable large object support"),
('default-vars', None,
"enable default variables use"),
('escaping-funcs', None,
"enable string escaping functions")]
boolean_options = build_ext.boolean_options + [
'direct-access', 'large-objects', 'default-vars', 'escaping-funcs']
def get_compiler(self):
"""Return the C compiler used for building the extension."""
return self.compiler or get_default_compiler()
def initialize_options(self):
build_ext.initialize_options(self)
self.direct_access = True
self.large_objects = True
self.default_vars = True
self.escaping_funcs = pg_version[0] >= 9
if pg_version < (9, 0):
warnings.warn("PygreSQL does not support this PostgreSQL version.")
def finalize_options(self):
"""Set final values for all build_pg options."""
build_ext.finalize_options(self)
if self.direct_access:
define_macros.append(('DIRECT_ACCESS', None))
if self.large_objects:
define_macros.append(('LARGE_OBJECTS', None))
if self.default_vars:
define_macros.append(('DEFAULT_VARS', None))
if self.escaping_funcs and pg_version[0] >= 9:
define_macros.append(('ESCAPING_FUNCS', None))
if sys.platform == 'win32':
bits = platform.architecture()[0]
if bits == '64bit': # we need to find libpq64
for path in os.environ['PATH'].split(os.pathsep) + [
r'C:\Program Files\PostgreSQL\libpq64']:
library_dir = os.path.join(path, 'lib')
if not os.path.isdir(library_dir):
continue
lib = os.path.join(library_dir, 'libpqdll.')
if not (os.path.exists(lib + 'lib')
or os.path.exists(lib + 'a')):
continue
include_dir = os.path.join(path, 'include')
if not os.path.isdir(include_dir):
continue
if library_dir not in library_dirs:
library_dirs.insert(1, library_dir)
if include_dir not in include_dirs:
include_dirs.insert(1, include_dir)
libraries[0] += 'dll' # libpqdll instead of libpq
break
compiler = self.get_compiler()
if compiler == 'mingw32': # MinGW
if bits == '64bit': # needs MinGW-w64
define_macros.append(('MS_WIN64', None))
elif compiler == 'msvc': # Microsoft Visual C++
libraries[0] = 'lib' + libraries[0]
extra_compile_args[1:] = ['-J', '-W3', '-WX',
'-Dinline=__inline'] # needed for MSVC 9
setup(
name="PyGreSQL",
version=version,
description="Python PostgreSQL Interfaces",
long_description=__doc__.split('\n\n', 2)[1], # first passage
keywords="pygresql postgresql database api dbapi",
author="D'Arcy J. M. Cain",
author_email="darcy@PyGreSQL.org",
url="http://www.pygresql.org",
download_url="ftp://ftp.pygresql.org/pub/distrib/",
platforms=["any"],
license="Python",
py_modules=py_modules,
ext_modules=[Extension('_pg', c_sources,
include_dirs=include_dirs, library_dirs=library_dirs,
define_macros=define_macros, undef_macros=undef_macros,
libraries=libraries, extra_compile_args=extra_compile_args)],
zip_safe=False,
cmdclass=dict(build_ext=build_pg_ext),
test_suite='tests.discover',
classifiers=[
"Development Status :: 6 - Mature",
"Intended Audience :: Developers",
"License :: OSI Approved :: Python Software Foundation License",
"Operating System :: OS Independent",
"Programming Language :: C",
'Programming Language :: Python',
'Programming Language :: Python :: 2',
'Programming Language :: Python :: 2.6',
'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 :: SQL",
"Topic :: Database",
"Topic :: Database :: Front-Ends",
"Topic :: Software Development :: Libraries :: Python Modules"]
)
|
