forked from pymssql/pymssql
-
Notifications
You must be signed in to change notification settings - Fork 0
/
ChangeLog
395 lines (342 loc) · 17.1 KB
/
ChangeLog
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
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
Change Log
==========
<next release> - <release date>
-------------------------------
+ feature: put compiled FreeTDS for Windows in pymmsql source, add build
instructions to README, better Visual Studio support (#61)
+ feature: support hostname, port, tds_version connect params without freetds.config
+ feature: make pymssql.Cursor.rownumber give accurate results for executemany()
+ feature: bundle FreeTDS libraries & use static libary includes to avoid
most end-user-developers needing to mess with FreeTDS
- bug #46: better handling for byte strings that don't represent ascii data
- bug: custom param handling avoids bugs when '%' is used in the SQL (modulus operator)
- bug: fix pymssql.DBAPIType so that comparisons work as expected
- bug: fetch*() functions would erroneously raise OperationalError when rows exhausted
Tue Nov 02 09:33:00 2010 Damien Churchill <[email protected]>
* _mssql.pyx:
+ feature: add support for nullable ints and nullable bits in
stored procedure parameters.
+ feature: add support for positional parameters in stored
procedures.
+ bugfix: add support for using type subclasses as parameters
+ bugfix: correctly report incorrect logins.
+ feature: add support for setting the application name
+ bugfix: accept more than just the decimal.Decimal type for
money and decimal parameters.
+ bugfix: fix raising exceptions from convert_python_value()
+ bugfix: fix binding parameters of int type when larger than
2^31 - 1 (raise exception).
+ bugfix: use sprintf rather than python strings in the msg_handler
+ bugfix: use sprintf rather than python strings in the err_handler
+ bugfix: make compatible with Cython 0.13
+ feature: remove the trusted parameter to connect()
+ bugfix: fix issue 15, not setting implicit_transactions on connect
+ bugfix: fix issue 32, setting the wrong hostname on login
* pymssql.pyx:
+ feature: add initial support for callproc()
+ feature: add support for setting the application name
+ bugfix: fix issue #7, thanks has.temp3
+ bugfix: fix issue #10, rowcount property being incorrect
+ bugfix: make compatible with Cython 0.13
+ feature: remove the trusted parameter to connect()
+ feature: add returnvalue property with the result of a callproc()
call.
+ feature: fix raising exceptions when args[0] is not a string
* MANIFEST.in:
+ feature: include the tests
+ bugfix: include ez_setup.py
* setup.py:
+ bugfix: fix issue #8, ZipFile don't has the attribute
'extractall' error for python2.5
* version 1.9.909
Wed Apr 28 11:10:00 2010 Damien Churchill <[email protected]>
* MANIFEST.in:
+ bugfix: fix recursive-include for .pyrex
* version 1.9.908
Wed Apr 21 16:02:00 2010 Damien Churchill <[email protected]>
* MANIFEST.in:
+ bugfix: include missing .pyrex folder
* version 1.9.907
Fri Apr 09 13:16:00 2010 Damien Churchill <[email protected]>
* setup.py:
+ bugfix: include hack faking that pyrex is installed to workaround
a bug in setuptools.
* _mssql.pyx:
+ bugfix: add support for connecting using "." and "(local)"
* pymssql.pyx:
+ feature: add the output type to be used with callproc()
+ depreciate: the dsn keyword param to pymssql.connect()
+ feature: add the get/set_max_connections to pymssql
* sqlfront.pxd:
+ feature: tidy up and remove all unused methods.
* version 1.9.906
Mon Nov 23 13:37:00 2009 Damien Churchill <[email protected]>
* _mssql.pyx:
+ feature: add support for varbinary types
+ feature: add support for passing in charset to _quote_data
+ bugfix: rename MSSQLConnection.next_result to
MSSQLConnection.nextresult as before
+ bugfix: set the charset upon login
+ feature: rewrite _remove_locale using C types instead, 20x faster
+ feature: add a charset param to quote_data and relating funcs that
allows the charset to be specified for unicode encodes.
* pymssql.pyx:
+ feature: add DSN support that was missing
+ bugfix: fix rowcount property
* sqlfront.pxd:
add DBSETLCHARSET
* tests:
+ feature: add test for multiple results
* setup.py:
+ feature: fix building on windows
+ feature: clean generated C files in the clean command
+ feature: automatically extract freetds.zip on windows when
building
* version 1.9.903
Fri Nov 20 13:03:00 2009 Damien Churchill <[email protected]>
* mssqldbmodule.c: deprecated in favour of _mssql.pyx
* pymssql.py: deprecated in favour of pymssql.py
+ feature: added support for uniqueidentifer types
+ feature: added support for calling remote procedures programmatically
* version 1.9.901
Tue May 12 15:43:00 2009 Andrzej Kukula <[email protected]>
* mssqldbmodule.c:
+ bugfix: pymssql didn't return second, third etc. result set
in case of multi-result statements, e.g. 'SELECT 1; SELECT 2',
thanks Damien Churchill <[email protected]>
Wed Apr 29 19:31:00 2009 Andrzej Kukula <[email protected]>
* mssqldbmodule.c:
+ fixed possible memory leak, thanks Evgeny Cherkashin
Tue Apr 23 23:00:00 2009 Andrzej Kukula <[email protected]>
+ bugfix: fixed rare quoting bug in select_db()
+ feature: added 'max_conn' parameter to pymssql.connect() and
_mssql.connect() which defaults to 25, thanks Daniel Watrous
* nagios-plugin update - thanks Josselin Mouette <[email protected]>:
+ Include a -P port option, to avoid having to passing it with the
host name
+ Fix the encoding of the comments; utf-8 is the declared encoding
of the file and must be followed
+ Fix a typo in the SQL syntax
+ Connect explicitly to the "master" database (required since 1.0.0)
+ Improve perfdata output.
* version 1.0.2
Tue Apr 21 22:56:00 2009 Andrzej Kukula <[email protected]>
* mssqldbmodule.c:
+ bugfix in format_and_run_query(): query strings were sometimes
overwritten with garbage due to DECREF in wrong place; thanks
Igor Nazarenko <[email protected]>
+ bugfix in get_result(): if a query batch contained DECLARE or
possibly other T-SQL statements, no results were returned
thanks Kay Schluehr <[email protected]>
+ bugfix in execute_scalar(): check if there are any columns in result
+ bugfix: check for FAIL after each dbnextrow()
+ feature: Add support for bigint - #2660972; thanks Alexandr
Zamaraev <[email protected]>
* pymssql.c:
+ bugfix in execute(): if execute is called without second argument,
don't treat '%' in query string as formatting character; restored
compatibility with common sense and with pymssql < 1.0.0; thanks
Corey Bertram <[email protected]>,
Wes McKinney <[email protected]>
+ feature: it is possible to specify 'as_dict' to pymssql.connect
and rows will be returned as dictionaries instead of tuples;
thanks Daniel Watrous <[email protected]>
Thu Jan 30 18:36:00 2009 Andrzej Kukula <[email protected]>
* mssqldbmodule.c:
+ Pyssize_t error on x64 - thanks Josselin Mouette <[email protected]>
+ critical charset updates, thanks Josselin Mouette <[email protected]>
+ more Py_ssize_t updates, further code cleanups
+ fixed some compiler warnings
* pymssql.py:
+ execute() failed, thanks Josselin Mouette <[email protected]>
+ critical charset updates, thanks Josselin Mouette <[email protected]>
+ removed warnings, users don't want them and they are not 'MUST'
priority in DB-API spec
* nagios-plugin: introducted Nagios plugin, thanks Julien Blache
and Josselin Mouette
* version 1.0.1
Thu Jan 29 19:23:00 2009 Andrzej Kukula <[email protected]>
* version 1.0.0
* so many changes I'll not put them here, I'll document
changes from now on.
Mon Sep 25 20:18:00 2006 Andrzej Kukula <[email protected]>
* setup.py: fix for Fink (http://Fink.SF.Net) under OS X (thanks
Terrence Brannon <[email protected]>)
Sun Sep 24 10:44:00 2006 Andrzej Kukula <[email protected]>
* setup.py:
+ it can now dynamically determine the path to SQL 2000 Developer
Tools, if win32api and win32con modules are available
+ simple Python version check to prevent most frequently asked
question
+ version 0.8.0
Wed Sep 13 01:20:00 2006 Andrzej Kukula <[email protected]>
* mssqldbmodule.c:
+ corrected misspellings in docstrings
+ fixed segfault on connection close with Python 2.5; thanks
Justin Francis <[email protected]>
* pymssql.py:
+ fixed two minor DB-API incompatibilities (thanks Matthew Good
+ fixed datetime quoting (thanks Jan Finell <[email protected]>)
* pymssql should be able to build on cygwin (thanks
* docstring fixes, webpage doc updates
Tue May 15 03:18:00 2006 Jooncheol Park <[email protected]>
* setup.py, PKG-INFO, README: license change to LGPL
Wed Mar 15 08:18:00 2006 Andrzej Kukula <[email protected]>
* pymssql.py: fixed datetime issue (thanks Jan Finell
Fri Feb 24 16:11:00 2006 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: fixed typos in docstrings (thanks Konstantin
Veretennicov)
Tue Dec 27 15:14:00 2005 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: bug fixes, improvements and cleanups:
+ implemented set_login_timeout() and set_query_timeout() functions;
+ eliminated unnecessary ODBC code
+ cleaned up exception code and improved exception handling,
SF bug #1335560
+ web page now correctly mentions FreeTDS 0.63 as the minimal
required version
+ stdmsg() method is now deprecated; all errors are concatenated
in errmsg()
+ implemented min_error_severity: all errors at or above that
level will raise the exception; if the severity is lower, they
will just accumulate in errmsg()
+ added setting coltype to NUMBER for float types (found by
Jakub Labath)
* setup.py:
+ reincarnated ntwdblib.dll which turned out to be redistributable
after all; pymssql includes the latest version that allows
connecting to SQL 2005; eliminated some stupid notes from the
web page and will ease set up process for users
* apitest_mssql.py: new file
+ provided by Jakub Labath, this file performs some basic DB-API
compliance tests; it immediately triggered the unicode bug
* version 0.7.4
Sat Oct 22 19:41:00 2005 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: multithreading improvements - from now on pymssql
is thread-safe, it releases GIL in proper places; idea and initial
patch by John-Peter Lee (thanks very much!)
Mon Sep 5 23:29:00 2005 Andrzej Kukula <[email protected]>
* setup.py: fixed an installation issue regarding importing pymssql
that imports _mssql which isn't installed, and blows up with
AttributeError... (thanks Vsevolod Stakhov)
* version 0.7.3
Mon Sep 5 00:32:00 2005 Andrzej Kukula <[email protected]>
* version 0.7.2
Sun Sep 4 23:12:00 2005 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: improvements and cleanups:
+ improved error handling: if the db function fails, the exception
is thrown automatically and immediately; no need to check
return value of conn.query(), just catch _mssql.error
+ improved error handling: it is possible that MS SQL calls message
handler twice; now _mssql catches and reports both of them at once
+ improved error handling: in some cases _mssql.query() returns
success but the results are invalid; now it is handled properly
(example "SELECT CAST(1234.5678 AS NUMERIC(4,2))")
+ added proper connection initialization: a number of SET statements
are executed upon connection setup to set sensible SQL behaviour;
see source for details; one needs to unset them if needed
+ implemented min_{message|error}_severity as it is in php_mssql
to ignore unimportant errors; it's work in progress
+ new function rmv_lcl() initially by Mark Pettit, to strip locale
crap from MONEY values converted to SQLCHAR while generating
Decimal object
+ other small fixes, improvements and janitorial work
Tue Aug 30 00:16:00 2005 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: new features:
+ large numbers (DECIMAL, NUMERIC, MONEY, SMALLMONEY) are returned
as Decimal object -- this helps maintain accuracy; thanks to
Mark Pettit for help
+ COMPUTE clauses are supported (it wouldn't fetch data for those
columns before)
+ ROWID type has been removed from _mssql module
+ new type DECIMAL to denote Decimal objects in result set
Mon Aug 29 21:59:00 2005 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: some improvements:
+ BIT values are returned as Python bool objects, suggested by
Mark Pettit
+ close() method returns None on success (not to be used at all)
and throws exception on error
+ fixed use of uninitialized value when parsing SMALLDATETIME
+ another round of performance improvements in GetRow() - eliminated
unnecessary data conversions and unneeded DB-Lib calls
+ janitorial fixes
Mon Aug 22 04:35:00 2005 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: massive diff:
+ fixed bug with fetching query results of some data types;
found by Mark Pettit
+ fixed IndexError when query returns no rows; patch by Jakub Labath
+ rewritten function GetRow() that fetches query results: performance
improvements, better handling of result data types; datetime
is returned as datetime object instead of string (it's more
consistent with other values -- and more pythonic :)
+ eliminated DetermineRowSize()
+ cleanups: _mssql_init() further improvements w.r.t. Python API
+ janitorial fixes
+ added licensing information
* pymssql.py: docstring changed to look nicer with help()
* version 0.7.2
Thu Aug 11 02:12:00 2005 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: improved module init function: added doc string,
made compliant with Python 2.0+ module interface (there are no more
coredumps on help())
* mssqldbmodule.c: documented that _mssql.connect() is not portable
between FreeTDS-dependent platforms and Windows platforms; documented
host:port usage
Sat Jul 23 14:20:00 2005 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: eliminated problems with Python exiting upon
invalid login credentials with FreeTDS - the culprit was INT_EXIT
and FreeTDS setting DBDEAD
* mssqldbmodule.c: added better error messages (esp. on Windows)
* mssqldbmodule.c: added msg_handler and err_handler debugging
* 0.7.1 packages re-released
Fri Jul 22 03:19:00 2005 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: major change; module revamped to support some
more builtin Python features; some redundant code removed; memset()
removed as there were no benefits but performance decrease
* mssqldbmodule.c: help(_mssql) works; help for conn object works too
* pymssql.py: _quote: removed escaping backslash -- with MSSQL it is
only needed to escape single quotes by duplicating them
* pymssql.py: pymssqlCnx class: added a few checks to properly support
DB-API 2.0 (see .close() in PEP 249)
* version 0.7.1
Wed Jul 20 22:12:00 2005 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: removed the workaround for date issue; there were
more problems than benefits
* mssqldbmodule_tds.c: removed
* some more cleanups and corrections
Tue Jul 19 14:23:00 2005 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: major change; many portability problems fixed
* mssqldbmodule.c: eliminated port setting; this is job for freetds.conf
* mssqldbmodule_tds.c: module to get FreeTDS compile-time settings
* build fixes; now it builds cleanly on FreeBSD, Linux and Windows
* version 0.7.0
Mon Jul 18 15:21:00 2005 Andrzej Kukula <[email protected]>
* mssqldbmodule.c: fix build on Windows: changed MS_WIN32 to MS_WINDOWS
reported by Mirek Rusin <[email protected]>
* mssqldbmodule.c: many small fixes and cleanups; janitorial fixes;
indentation using indent(1L)
* ChangeLog fix! 'mysql' was mentioned instead of 'mssql'...
Fri Feb 25 02:15:01 2005 Andrzej Kukula <[email protected]>
* Fix build on Windows with Visual Studio .NET 2003
and MS SQL Server 2000 SP3a
* mssqldbmodule.c: Fix compile error with Visual Studio .NET 2003
* mssqldbmodule.c: Add detection/workaround for date issue caused by
different dbdatecrack() prototypes
* README.freetds: describe dbdatecrack()-related issue
Thu Feb 24 02:03:14 2005 Alejandro Dubrovsky <[email protected]>
* Export column type names
* mssqldbmodule.c: Return column type information for headers
* Use type information to make cursor.description conform to API 2
2005-02-17 Alejandro Dubrovsky <[email protected]>
* Apply patch by Rob Nichols to get cursor.description closer to API 2 compliance
2005-02-08 Alejandro Dubrovsky <[email protected]>
* Message changes in mssqldbmodule.c (typos, grammar, etc)
2005-02-07 Alejandro Dubrovsky <[email protected]>
* Added ChangeLog
* API Change: add 6th parameter 'port' to connect
* Don't close connection on cursor close (noted by Alberto Pastore on the sourceforge project page)
* Make cursor.fetchone comply with DB-SIG return a tuple, not a list of tuples (report and patch by Chris Curvey)