관리-도구
편집 파일: zxjdbc.cpython-311.pyc
� �܋f� � � � d Z ddlZddlmZ ddlmZ ddlmZ ddlmZ dd lm Z dd l m Z G d � d e� � Z G d � de� � Z G d� de e� � ZeZdS )a� .. dialect:: mysql+zxjdbc :name: zxjdbc for Jython :dbapi: zxjdbc :connectstring: mysql+zxjdbc://<user>:<password>@<hostname>[:<port>]/<database> :driverurl: http://dev.mysql.com/downloads/connector/j/ .. note:: Jython is not supported by current versions of SQLAlchemy. The zxjdbc dialect should be considered as experimental. Character Sets -------------- SQLAlchemy zxjdbc dialects pass unicode straight through to the zxjdbc/JDBC layer. To allow multiple character sets to be sent from the MySQL Connector/J JDBC driver, by default SQLAlchemy sets its ``characterEncoding`` connection property to ``UTF-8``. It may be overridden via a ``create_engine`` URL parameter. � N� )�BIT)� MySQLDialect)�MySQLExecutionContext� )�types)�util)�ZxJDBCConnectorc � � e Zd Zd� ZdS )� _ZxJDBCBitc � � d� }|S )z@Converts boolean or byte arrays from MySQL Connector/J to longs.c �~ � | �| S t | t � � rt | � � S d}| D ] }|dz |dz z }�|} | S )Nr � � )� isinstance�bool�int)�value�v�is �W/opt/cloudlinux/venv/lib64/python3.11/site-packages/sqlalchemy/dialects/mysql/zxjdbc.py�processz,_ZxJDBCBit.result_processor.<locals>.process+ s\ � ��}� � ��%��&�&� "��5�z�z�!��A�� (� (����F�a�$�h�'����E��L� � )�self�dialect�coltyper s r �result_processorz_ZxJDBCBit.result_processor( s � � � � � �r N)�__name__� __module__� __qualname__r r r r r r ' s# � � � � � �� � � � r r c � � e Zd Zd� ZdS )� MySQLExecutionContext_zxjdbcc � � | � � � }|� d� � |� � � d }|� � � |S )NzSELECT LAST_INSERT_ID()r )� create_cursor�execute�fetchone�close)r �cursor� lastrowids r � get_lastrowidz*MySQLExecutionContext_zxjdbc.get_lastrowid: sM � ��#�#�%�%�����0�1�1�1��O�O�%�%�a�(� �� � �����r N)r r r! r+ r r r r# r# 9 s# � � � � � �� � � � r r# c �z � e Zd ZdZdZeZ ej e j e j e j e ei� � Z d� Zd� Zd� Zd� ZdS )�MySQLDialect_zxjdbc�mysqlzcom.mysql.jdbc.Driverc �� � |� d� � }d� | � |� � D � � }dD ]"}|� |d� � r || c S �#t j d� � dS )z:Sniff out the character set in use for connection results.z%SHOW VARIABLES LIKE 'character_set%%'c �, � i | ]}|d |d ��S )r r r )�.0�rows r � <dictcomp>z7MySQLDialect_zxjdbc._detect_charset.<locals>.<dictcomp>U s" � �D�D�D�3��A���A��D�D�Dr )�character_set_connection� character_setNz@Could not detect the connection character set. Assuming latin1.�latin1)r& �_compat_fetchall�getr �warn)r � connection�rs�opts�keys r �_detect_charsetz#MySQLDialect_zxjdbc._detect_charsetL s� � � � � � G� H� H��D�D�$�*?�*?��*C�*C�D�D�D��@� !� !�C��x�x��T�"�"� !��C�y� � � � !� � � � � � � �xr c �$ � t dd�� � S )z+return kw arg dict to be sent to connect().zUTF-8�false)�characterEncoding�yearIsDateType)�dict)r s r �_driver_kwargsz"MySQLDialect_zxjdbc._driver_kwargs` s � ��g�g�F�F�F�Fr c �� � t j d� � � t |j � � � � }|� d� � }|rt |� � S d S )Nz\[SQLCode\: (\d+)\]r )�re�compile�search�str�args�groupr )r � exception�m�cs r �_extract_error_codez'MySQLDialect_zxjdbc._extract_error_coded sX � � �J�-� .� .� 5� 5�c�)�.�6I�6I� J� J�� �G�G�A�J�J�� � ��q�6�6�M� � r c �$ � |j }g }t j d� � }|� |j � � D ]J} |� t |� � � � �&# t $ r |� |� � Y �Gw xY wt |� � S )Nz[.\-]) r: rF rG �split� dbversion�appendr � ValueError�tuple)r r: � dbapi_con�version�r�ns r �_get_server_version_infoz,MySQLDialect_zxjdbc._get_server_version_infol s� � � �)� ��� �J�x� � ������,�-�-� "� "�A� "����s�1�v�v�&�&�&�&�� � "� "� "����q�!�!�!�!�!� "�����W�~�~� s �"A � B �?B N)r r r! � jdbc_db_name�jdbc_driver_namer# �execution_ctx_clsr � update_copyr �colspecs�sqltypes�Timer r r> rD rO rZ r r r r- r- B s� � � � � � ��L�.��4�� �t� �� �� �x�}�c�:� N�� �H�� � �(G� G� G�� � � � � � � r r- )�__doc__rF �baser r r � r r` r �connectors.zxJDBCr r r# r- r r r r �<module>rf s ��� �* � � � � � � � � � � � � � � � � '� '� '� '� '� '� !� !� !� !� !� !� � � � � � � 0� 0� 0� 0� 0� 0�� � � � �� � � �$� � � � �#8� � � �3 � 3 � 3 � 3 � 3 �/�<� 3 � 3 � 3 �l ���r