w:@/?charset=utf8
pymssql is a Python module that provides a Python DBAPI interface around
`FreeTDS `_.
.. note::
pymssql is currently not included in SQLAlchemy's continuous integration
(CI) testing.
Modern versions of this driver worked very well with SQL Server and FreeTDS
from Linux and were highly recommended. However, pymssql is currently
unmaintained and has fallen behind the progress of the Microsoft ODBC driver in
its support for newer features of SQL Server. The latest official release of
pymssql at the time of this document is version 2.1.4 (August, 2018) and it
lacks support for:
1. table-valued parameters (TVPs),
2. ``datetimeoffset`` columns using timezone-aware ``datetime`` objects
(values are sent and retrieved as strings), and
3. encrypted connections (e.g., to Azure SQL), when pymssql is installed from
the pre-built wheels. Support for encrypted connections requires building
pymssql from source, which can be a nuisance, especially under Windows.
The above features are all supported by mssql+pyodbc when using Microsoft's
ODBC Driver for SQL Server (msodbcsql), which is now available for Windows,
(several flavors of) Linux, and macOS.
N ) MSDialect)MSIdentifierPreparer )
processors)types)utilc e Zd Zd ZdS )_MSNumeric_pymssqlc j | j s t j S t j | || S N) asdecimalr to_floatsqltypesNumericresult_processor)selfdialecttype_s u/builddir/build/BUILD/cloudlinux-venv-1.0.12/venv/lib64/python3.11/site-packages/sqlalchemy/dialects/mssql/pymssql.pyr z#_MSNumeric_pymssql.result_processor4 s1 ~ K & ,T7EJJ J N)__name__
__module__ __qualname__r r r r r 3 s( K K K K Kr r c e Zd Z fdZ xZS ) MSIdentifierPreparer_pymssqlc f t t | | d| _ d S )NF)superr __init___double_percents)r r __class__s r r z%MSIdentifierPreparer_pymssql.__init__< s2
*D11::7CCC !& r )r r r r
__classcell__r" s @r r r ; s8 & & & & & & & & &r r c e Zd ZdZdZeZ ej e j
e j e
e j e j i Z
ed Zd Zd Zd Z fdZ xZS )MSDialect_pymssqlTpymssqlc t d }t d |j d D }|dk rd |_ |dk rt j d |S )Nr' c 3 4 K | ]}t | V d S r
int.0xs r z*MSDialect_pymssql.dbapi..R s( IIa3q66IIIIIIr .) r r c D t | d r| nt | S )Ndecode)hasattrstr)r. s r z)MSDialect_pymssql.dbapi..U s 71h+?+?&KaaSVV r )r zIThe pymssql dialect expects at least the 1.0 series of the pymssql DBAPI.)
__import__tuple __version__splitBinaryr warn)clsmodule
client_vers r dbapizMSDialect_pymssql.dbapiN s| I&&II6+=+C+CC+H+HIIIII
! ! K KFM I7
r c | d }t j d| }|r/t d | dddd D S d S )Nzselect @@versionz'Microsoft .*? - (\d+).(\d+).(\d+).(\d+)c 3 4 K | ]}t | V d S r
r* r, s r r/ z=MSDialect_pymssql._get_server_version_info..b s( ==AQ======r r r1 r )scalarrematchr8 group)r
connectionversms r _get_server_version_infoz*MSDialect_pymssql._get_server_version_info^ sd !344 H? F F ==Aq!)<)<===== =4r c | d }| |j | dd }|rd|v r|d d||d< g |gS )Nuser)usernameporthost:)translate_connect_argsupdatequerypop)r urloptsrO s r create_connect_argsz%MSDialect_pymssql.create_connect_argsf sq ))6):: CI xx%% :FdNN&*6lllDD9DLDzr c 8 dD ]}|t | v r dS dS )N) z$Adaptive Server connection timed outz-Net-Lib error during Connection reset by peerz
message 20003z Error 10054z"Not connected to any MS SQL serverzConnection is closedz
message 20006z
message 20017z
message 20047TF)r5 )r erH cursormsgs r
is_disconnectz MSDialect_pymssql.is_disconnectn s7
C c!ff}}tt 5r c |dk r| d d S | d t t | || d S )N
AUTOCOMMITTF)
autocommitr r& set_isolation_level)r rH levelr" s r ra z%MSDialect_pymssql.set_isolation_level sn L ! !$ ' ' ' ' ' ! !% ( ( ( #T * * > >E
r )r r r supports_native_decimaldriverr preparerr update_copyr colspecsr r r Float classmethodr@ rK rX r] ra r# r$ s @r r& r& C s "
F+H t -x~x~N H
[
" r r& )__doc__rE baser r r r r r r r r r& r r r r rm s ! !D
& & & & & & ! ! ! ! ! ! K K K K K) K K K& & & & & & &C C C C C C C CL r