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
|
#!/usr/bin/env python
import sys
from distutils.core import setup, Extension
classifiers = """\
Development Status :: 5 - Production/Stable
Intended Audience :: Developers
License :: OSI-Approved Open Source :: GNU Library or Lesser General Public License (LGPL)
Programming Language :: Python
Programming Language :: C
Topic :: Database
Topic :: Software Development :: Libraries :: Python Modules
Operating System :: Microsoft :: Windows
Operating System :: Unix
"""
minpyver = (2, 4)
if sys.version_info < minpyver:
print """
You're using Python %d.%d, but pymssql requires at least Python %d.%d.
Setup cannot continue.
""" % ( sys.version_info[0], sys.version_info[1], minpyver[0], minpyver[1] )
sys.exit(1)
if sys.platform == "win32":
p = ''
import os, os.path
try:
# those modules are available out-of-the box in ActivePython
import win32api, win32con
# try to determine include and lib path
try:
h = win32api.RegOpenKey(win32con.HKEY_LOCAL_MACHINE, r'SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup')
p = win32api.RegQueryValueEx(h,'SQLPath')[0]
except:
e = sys.exc_info()
print """
Setup.py is unable to find path to SQL 2000 tools. Either it's not installed
or you have insufficient permissions to read Windows registry. Please make
sure you've got administrator rights. Setup.py will try some generic paths.
"""
if p:
e = ''
if (not os.path.exists(os.path.join(p, r'DevTools\include'))):
e += "Setup.py is unable to find SQL 2000 developer tools include directory.\n"
if (not os.path.exists(os.path.join(p, r'DevTools\lib'))):
e += "Setup.py is unable to find SQL 2000 developer tools library directory.\n"
if e:
print e + """
Either the developer tools package is not installed or you have insufficient
permissions to read the files. Please make sure you've got administrator
rights. Setup.py will try some generic paths.
"""
except ImportError:
pass
# first some generic paths
include_dirs = [ r'c:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Include', r'c:\mssql7\DevTools\Include',]
library_dirs = [ r'c:\Program Files\Microsoft SQL Server\80\Tools\DevTools\Lib', r'\mssql7\DevTools\Lib',]
libraries = ["ntwdblib", "msvcrt", "kernel32", "user32", "gdi32", "winspool", "comdlg32", "advapi32", "shell32", "ole32", "oleaut32", "uuid", "odbc32", "odbccp32", ]
data_files = [("LIB/site-packages",["ntwdblib.dll",]),]
# prepend path from registry, if any
if p:
include_dirs.insert(0, os.path.join(p, r'DevTools\include'))
library_dirs.insert(0, os.path.join(p, r'DevTools\lib'))
else: # try some generic paths
include_dirs = [
'/usr/include', '/usr/local/include',
'/usr/include/freetds', '/usr/local/include/freetds',
'/usr/pkg/freetds/include' # netbsd
]
library_dirs = [
'/usr/lib', '/usr/local/lib',
'/usr/lib/freetds', '/usr/local/lib/freetds'
'/usr/pkg/freetds/lib' # netbsd
]
libraries = ["sybdb"]
data_files = []
if sys.platform == "cygwin":
libraries.append("iconv")
# we can't use 2.3 or lower anymore...
#if sys.version_info < (2, 3):
# _setup = setup
# def setup(**kwargs):
# if kwargs.has_key("classifiers"):
# del kwargs["classifiers"]
# _setup(**kwargs)
#import pymssql
# no, we can't import pymssql because _mssql is not installed yet
# and it blows up with the following exception:
# DECIMAL = DBAPITypeObject(_mssql.DECIMAL)
# AttributeError: 'module' object has no attribute 'DECIMAL'
setup(name = 'pymssql',
version = '0.8.0',
description = 'A simple database interface to MS-SQL for Python.',
long_description = 'A simple database interface to MS-SQL for Python.',
author = 'Joon-cheol Park',
author_email = 'jooncheol@gmail.com',
maintainer = 'Andrzej Kukula',
maintainer_email = 'akukula@gmail.com',
license = 'LGPL',
url = 'http://pymssql.sourceforge.net',
py_modules = [ 'pymssql', ],
ext_modules = [Extension('_mssql', ['mssqldbmodule.c'],
include_dirs = include_dirs,
library_dirs = library_dirs,
libraries = libraries)],
classifiers = filter(None, classifiers.split('\n')),
data_files = data_files
)
|
