관리-도구
편집 파일: mxodbc.cpython-311.pyc
� �܋f� � �J � d Z ddlZddlZddlZddlmZ G d� de� � ZdS )a� Provide a SQLALchemy connector for the eGenix mxODBC commercial Python adapter for ODBC. This is not a free product, but eGenix provides SQLAlchemy with a license for use in continuous integration testing. This has been tested for use with mxODBC 3.1.2 on SQL Server 2005 and 2008, using the SQL Server Native driver. However, it is possible for this to be used on other database platforms. For more info on mxODBC, see http://www.egenix.com/ � N� )� Connectorc � � e Zd ZdZdZdZdZdZed� � � Z ed� � � Z d� Z d� Z d� Z d � Zd � Zd � Zdd �Zdd�Zd S )�MxODBCConnector�mxodbcFTc � � | � � � t j }|dk rddlm} n'd|v rddlm} n |dk rddlm} nt d� � �|S ) N�win32r )�Windows�linux)�unixODBC�darwin)�iODBCz'Unrecognized platform for mxODBC import)�_load_mx_exceptions�sys�platform�mx.ODBCr r r � ImportError)�clsr �Modules �o/builddir/build/BUILD/cloudlinux-venv-1.0.6/venv/lib64/python3.11/site-packages/sqlalchemy/connectors/mxodbc.py�dbapizMxODBCConnector.dbapi& s� � � � � �!�!�!��<�� �w� � � 1� 1� 1� 1� 1� 1� 1� �� � � 2� 2� 2� 2� 2� 2� 2� �� !� !� /� /� /� /� /� /� /� � G�H�H� H�� � c � � ddl ma ddl ma dS )z�Import mxODBC exception classes into the module namespace, as if they had been imported normally. This is done here to avoid requiring all SQLAlchemy users to install mxODBC. r )�InterfaceError)�ProgrammingErrorN)r r r )r s r r z#MxODBCConnector._load_mx_exceptions7 s. � � +�*�*�*�*�*�,�,�,�,�,�,�,�,r c � � � � fd�}|S )Nc � �� �j j | _ �j j | _ �j j | _ �� � � | _ d S �N) r �MIXED_STRINGFORMAT� stringformat�PYDATETIME_DATETIMEFORMAT�datetimeformat�DECIMAL_DECIMALFORMAT� decimalformat�_error_handler� errorhandler)�conn�selfs �r �connectz+MxODBCConnector.on_connect.<locals>.connectB sD �� � $� � =�D� �"&�*�"F�D� �!%��!A�D� � $� 3� 3� 5� 5�D� � � r � )r( r) s ` r � on_connectzMxODBCConnector.on_connectA s# �� � 6� 6� 6� 6� 6� �r c � �� ddl m� �fd�}|S )ziReturn a handler that adjusts mxODBC's raised Warnings to emit Python standard warnings. r )�Warningc � �� t |�� � r3t f|_ t j t |� � |d�� � d S ||� � �)N� )�message�category� stacklevel)� issubclassr- � __bases__�warnings�warn�str)� connection�cursor� errorclass� errorvalue� MxOdbcWarnings �r � error_handlerz5MxODBCConnector._error_handler.<locals>.error_handlerP sa �� ��*�m�4�4� -�(/�z� �$�� � � �O�O�j�Q�� � � � � � !�j��,�,�,r )� mx.ODBC.Errorr- )r( r= r< s @r r% z MxODBCConnector._error_handlerJ s8 �� � ;�:�:�:�:�:� -� -� -� -� -� � r c �� � |� d�� � }|� |j � � |� d� � }|� dd� � |� dd� � |f|fS )a� Return a tuple of \*args, \**kwargs for creating a connection. The mxODBC 3.x connection constructor looks like this: connect(dsn, user='', password='', clear_auto_commit=1, errorhandler=None) This method translates the values in the provided uri into args and kwargs needed to instantiate an mxODBC Connection. The arg 'errorhandler' is not used by SQLAlchemy and will not be populated. �user)�username�host�portN�database)�translate_connect_args�update�query�pop)r( �url�opts�argss r �create_connect_argsz#MxODBCConnector.create_connect_args[ ss � � �)�)�6�)�:�:�� � � �C�I� � � ��x�x�� � �� ����� � � � ����T�"�"�"��w��}� r c � � t || j j � � rdt |� � v S t || j j � � rdt |� � v S dS )Nzconnection already closedz[08S01]F)� isinstancer r r7 �Error)r( �er8 r9 s r � is_disconnectz MxODBCConnector.is_disconnectq sY � � �a���4� 5� 5� �.�#�a�&�&�8� 8� ��4�:�+� ,� ,� � ��A���&� &��5r c �L � |j }g }t j d� � }|� |� d� � d � � D ]J} |� t |� � � � �&# t $ r |� |� � Y �Gw xY wt |� � S )Nz[.\-]� r ) r8 �re�compile�split�getinfo�append�int� ValueError�tuple)r( r8 � dbapi_con�version�r�ns r �_get_server_version_infoz(MxODBCConnector._get_server_version_info{ s� � � �)� ��� �J�x� � ������*�*�2�.�.�q�1�2�2� "� "�A� "����s�1�v�v�&�&�&�&�� � "� "� "����q�!�!�!�!�!� "�����W�~�~� s �"A2�2 B�Bc �P � |r#|j � dd� � }|du rdndS dS )N�native_odbc_execute�autoTF)�execution_options�get)r( �contextrb s r � _get_directzMxODBCConnector._get_direct� sC � � � �")�";�"?�"?�%�v�#� #� � 0�4� 7� 7�5�5�T� A��4r Nc �\ � |� ||| � |� � �� � d S �N)�direct)� executemanyrg �r( r9 � statement� parametersrf s r �do_executemanyz MxODBCConnector.do_executemany� s> � ���� �z�$�*:�*:�7�*C�*C� � � � � � r c �\ � |� ||| � |� � �� � d S ri )�executerg rl s r � do_executezMxODBCConnector.do_execute� s. � ����y�*�T�5E�5E�g�5N�5N��O�O�O�O�Or r )�__name__� __module__� __qualname__�driver� supports_sane_multi_rowcount�supports_unicode_statements�supports_unicode_binds�supports_native_decimal� classmethodr r r+ r% rL rQ r` rg ro rr r* r r r r s� � � � � � � �F�#(� �"&� � !�� "���� � �[�� �-� -� �[�-�� � � � � �" � � �,� � � � � � � � � � � � � P� P� P� P� P� Pr r )�__doc__rT r r5 � r r r* r r �<module>r~ s� �� � � � � � � � � � � ���� � � � � � �}P� }P� }P� }P� }P�i� }P� }P� }P� }P� }Pr