관리-도구
편집 파일: pymssql.cpython-311.pyc
� �܋f� � � � d Z ddlZddlmZ ddlmZ ddlmZ ddlmZ dd lm Z G d � d ej � � Z G d � d e� � Z G d� de� � Z e ZdS )aK .. 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 <http://www.freetds.org/>`_. .. 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_float�sqltypes�Numeric�result_processor)�self�dialect�type_s �t/builddir/build/BUILD/cloudlinux-venv-1.0.6/venv/lib64/python3.11/site-packages/sqlalchemy/dialects/mssql/pymssql.pyr z#_MSNumeric_pymssql.result_processor4 s1 � ��~� K� �&� &��#�4�4�T�7�E�J�J� J� N)�__name__� __module__� __qualname__r � r r r r 3 s( � � � � � �K� K� K� K� Kr r c � � � e Zd Z� fd�Z� 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 �� � �*�D�1�1�:�:�7�C�C�C� !&�� � � 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� fd�Z� xZS )�MSDialect_pymssqlT�pymssqlc �� � 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��.0�xs r � <genexpr>z*MSDialect_pymssql.dbapi.<locals>.<genexpr>R s( � � � �I�I�a�3�q�6�6�I�I�I�I�I�Ir �.)� r r c �D � t | d� � r| nt | � � S )N�decode)�hasattr�str)r. s r �<lambda>z)MSDialect_pymssql.dbapi.<locals>.<lambda>U s � �7�1�h�+?�+?�&K�a�a�S��V�V� r )r zIThe pymssql dialect expects at least the 1.0 series of the pymssql DBAPI.)� __import__�tuple� __version__�split�Binaryr �warn)�cls�module� client_vers r �dbapizMSDialect_pymssql.dbapiN s| � ��I�&�&���I�I�6�+=�+C�+C�C�+H�+H�I�I�I�I�I� � � � !� !� K� K�F�M� �� � � �I�7� � � � � 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.<locals>.<genexpr>b s( � � � �=�=�A��Q���=�=�=�=�=�=r r r1 r � )�scalar�re�matchr8 �group)r � connection�vers�ms r �_get_server_version_infoz*MSDialect_pymssql._get_server_version_info^ sd � �� � �!3�4�4�� �H�?�� F� F�� � ��=�=�����A�q�!�)<�)<�=�=�=�=�=� =��4r c �� � |� d�� � }|� |j � � |� dd � � }|rd|v r|d �d|��|d< g |gS )N�user)�username�port�host�:)�translate_connect_args�update�query�pop)r �url�optsrO s r �create_connect_argsz%MSDialect_pymssql.create_connect_argsf sq � ��)�)�6�)�:�:�� � � �C�I� � � ��x�x���%�%�� � :�F�d�N�N�&*�6�l�l�l�D�D�9�D��L��D�z�r 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 �cursor�msgs r � is_disconnectz MSDialect_pymssql.is_disconnectn s7 � � � � �C� �c�!�f�f�}�}��t�t� � �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_decimal�driverr �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 �<module>rm s ��!� !�D � � � � � � � � � � &� &� &� &� &� &� � � � � � � !� !� !� !� !� !� � � � � � �K� K� K� K� K��)� K� K� K�&� &� &� &� &�#7� &� &� &�C� C� C� C� C� � C� C� C�L ���r