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
|
=============
Release notes
=============
Release notes -- All breaking changes and other noteworthy things.
pymssql 2.0.0
=============
This is a new major version of pymssql. It is totally rewritten from scratch in
Cython. Our goals for this version were to:
* Provide support for Python 3.0 and newer,
* Implement support for stored procedures,
* Rewrite DB-API compliant pymssql module in C (actually in Cython) for
increased performance,
* Clean up the module API and the code.
That's why we decided to bump major version number. Unfortunately new version
introduces incompatible changes in API. Existing scripts may not work with it,
and you'll have to audit them. If you care about compatibility, just continue
using pymssql 1.0.x and slowly move to 2.0.
Project hosting has also changed. Now pymssql is developed on GitHub:
http://github.com/pymssql/pymssql.
Credits for the release go to:
* Marc Abramowitz <msabramo_at_gmail_com> who joined the project in Jan 2013 and
is responsible for the actual release of the 2.0 version by fixing many old
tickets, coding the port to Python 3 and driving the migration to Git and
GitHub.
* Randy Syring who converted the repository to Mercurial, extended tests and
ported them to nose, enhanced the code in several fronts like multi-platform
(compilers, OSes) compatibility, error handling, support of new data types,
SQLAlchemy compatibility and expanded the documentation.
* Damien Churchill <damoxc_at_gmail_com> who set the foundations of the new
Cython-based code base, release engineering, new site features like Sphinx,
SimpleJSON and others,
* Andrzej KukuĊa <akukula_at_gmail_com> who did all the docs, site migration,
and other boring but necessary stuff.
* Jooncheol Park <jooncheol_at_gmail_com> who did develop the initial version
of pymssql (until 0.5.2). Now just doing boring translation docs for Korean.
``pymssql`` module
------------------
* Rewritten from scratch in C, you should observe even better performance than before
* ``dsn`` parameter to :func:`pymssql.connect()` has been removed
* ``host`` parameter to :func:`pymssql.connect()` has been renamed to ``server``
to be consistent with ``_mssql`` module
* ``max_conn`` parameter to :func:`pymssql.connect()` has been removed
``Connection`` class
~~~~~~~~~~~~~~~~~~~~
* ``autocommit()`` function has been changed to
:attr:`pymssql.Connection.autocommit` property that you can set or get
its current state.
``Cursor`` class
~~~~~~~~~~~~~~~~
* ``fetchone_asdict()`` method has been removed. Just use
:func:`pymssql.connect()` with ``as_dict=True``, then use regular
:meth:`~pymssql.Cursor.fetchone()`
* ``fetchmany_asdict()`` method has been removed. Just use
:func:`pymssql.connect()` with ``as_dict=True``, then use regular
:meth:`~pymssql.Cursor.fetchmany()`
* ``fetchall_asdict()`` method has been removed. Just use
:func:`pymssql.connect()` with ``as_dict=True``, then use regular
:meth:`~pymssql.Cursor.fetchall()`
``_mssql`` module
-----------------
* Added native support for stored procedures
(:class:`~_mssql.MSSQLStoredProcedure` class)
* ``maxconn`` parameter to :func:`_mssql.connect()` has been removed
* ``timeout`` and ``login_timeout`` parameter to :func:`_mssql.connect()` has
been added
* :func:`~_mssql.get_max_connections()` and :func:`~_mssql.set_max_connections()`
module-level methods have been added
* Class names have changed:
====================== ======================
Old Name New name
====================== ======================
MssqlException MSSQLException
MssqlDriverException MSSQLDriverException
MssqlDatabaseException MSSQLDatabaseException
MssqlRowIterator MSSQLRowIterator
MssqlConnection MSSQLConnection
====================== ======================
``MSSQLConnection`` class
~~~~~~~~~~~~~~~~~~~~~~~~~
* Added :attr:`~_mssql.MSSQLConnection.tds_version` property.
|
