U
|
¸ý°d: ã @ s d Z ddlZddlmZ ddlmZ ddlmZ ddlmZ dd l m
|
Z
|
G d
|
d d ej Z G d d d eZ G dd deZeZdS )aq
|
.. dialect:: mssql+pymssql
|
:name: pymssql
|
:dbapi: pymssql
|
:connectstring: mssql+pymssql://<username>:<password>@<freetds_name>/?charset=utf8
|
|
pymssql is a Python module that provides a Python DBAPI interface around
|
`FreeTDS <https://www.freetds.org/>`_.
|
|
.. versionchanged:: 2.0.5
|
|
pymssql was restored to SQLAlchemy's continuous integration testing
|
|
|
é Né )Ú MSDialect)ÚMSIdentifierPrepareré )Útypes)Úutil)Ú
|
processorsc @ s e Zd Zdd ZdS )Ú_MSNumeric_pymssqlc C s | j s tjS tj | ||¡S d S ©N)Z asdecimalr Zto_floatÚsqltypesÚNumericÚresult_processor)ÚselfÚdialectÚtype_© r úXd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/dialects/mssql/pymssql.pyr # s z#_MSNumeric_pymssql.result_processorN)Ú__name__Ú
|
__module__Ú __qualname__r r r r r r " s r c s e Zd Z fddZ ZS )Ú MSIdentifierPreparer_pymssqlc s t |¡ d| _d S )NF)ÚsuperÚ__init__Z_double_percents)r r ©Ú __class__r r r + s z%MSIdentifierPreparer_pymssql.__init__)r r r r Ú __classcell__r r r r r * s r c s| e Zd ZdZdZdZdZeZe
|
e j e jee je ji¡Z edd Zdd Zdd Zd d
|
Z fd d Z fd dZ ZS )ÚMSDialect_pymssqlTÚpymssqlc C sJ t d}tdd |j d¡D }|dk r4dd |_|dk rFt d ¡ |S )
|
Nr c s s | ]}t |V qd S r
|
©Úint©Ú.0Úxr r r Ú <genexpr>C s z1MSDialect_pymssql.import_dbapi.<locals>.<genexpr>Ú.)é r r c S s t | dr| S t| S )NÚdecode)ÚhasattrÚstr)r" r r r Ú<lambda>F ó z0MSDialect_pymssql.import_dbapi.<locals>.<lambda>)r zIThe pymssql dialect expects at least the 1.0 series of the pymssql DBAPI.)Ú
|
__import__ÚtupleÚ __version__ÚsplitÚBinaryr Úwarn)ÚclsÚmoduleZ
|
client_verr r r Ú import_dbapi? s
|
ÿz MSDialect_pymssql.import_dbapic C sD | d¡ ¡ }t d|¡}|r<tdd | dddd¡D S d S d S ) Nzselect @@versionz*Microsoft .*? - (\d+)\.(\d+)\.(\d+)\.(\d+)c s s | ]}t |V qd S r
|
r r r r r r# S s z=MSDialect_pymssql._get_server_version_info.<locals>.<genexpr>r r% r é )Zexec_driver_sqlZscalarÚreÚmatchr, Úgroup)r Ú
|
connectionÚversÚmr r r Ú_get_server_version_infoO s
|
z*MSDialect_pymssql._get_server_version_infoc C sL |j dd}| |j¡ | dd ¡}|rDd|krDd|d |f |d< g |fS )NÚuser)ÚusernameÚportÚhostz%s:%s)Ztranslate_connect_argsÚupdateÚqueryÚpop)r ÚurlÚoptsr> r r r Úcreate_connect_argsW s z%MSDialect_pymssql.create_connect_argsc C s dD ]}|t |kr dS qdS )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)r( )r Úer8 ÚcursorÚmsgr r r Ú is_disconnect_ s z MSDialect_pymssql.is_disconnectc s t |¡dg S )NÚ
|
AUTOCOMMIT)r Úget_isolation_level_values)r Údbapi_connectionr r r rK p s
|
ÿz,MSDialect_pymssql.get_isolation_level_valuesc s0 |dkr| d¡ n| d¡ t ||¡ d S )NrJ TF)Z
|
autocommitr Úset_isolation_level)r rL Úlevelr r r rM u s
|
z%MSDialect_pymssql.set_isolation_level)r r r Zsupports_statement_cacheZsupports_native_decimalZsupports_native_uuidZdriverr Úpreparerr Z update_copyr Zcolspecsr r r ZFloatÚ classmethodr3 r; rE rI rK rM r r r r r r 2 s þ
|
r )Ú__doc__r5 Úbaser r Ú r r r Zenginer r r r r r r r r r Ú<module>
|
s K
|
