?????????? ????????? - ??????????????? - /home/agenciai/.local/lib/python3.9/site-packages/mysql/connector/__pycache__/conversion.cpython-39.pyc
???????
a ��Jh�g � @ s� d Z ddlZddlZddlZddlZddlZddlmZ ddlm Z m Z m Z m Z m Z mZmZmZ ddlmZmZmZmZmZ ddlmZ ddlmZmZm Z m Z m Z dd l m Z d Z!G d d � d �Z"G d d� de"�Z#dS )z!Converting MySQL and Python types� N)�Decimal)�Any�Callable�Dict�List�Optional�Set�Tuple�Union� )�MYSQL_VECTOR_TYPE_CODE� CharacterSet� FieldFlag� FieldType�SQLMode)� HexLiteral)�DescriptionType�MySQLConvertibleType�MySQLProducedType�PythonProducedType� StrOrBytes)� NUMERIC_TYPESz.Could not convert '{value}' to python {pytype}c @ s� e Zd ZdZdee eedd�dd�Zdee ee dd �d d �Z d edd �d d�Z e e e e f d �dd�Zeee ed�dd�Zed eee eef ed�dd��Zeeed�dd��ZdS ) �MySQLConverterBasez�Base class for conversion classes All class dealing with converting to and from MySQL data types must be a subclass of this class. �utf8TFN��charset� use_unicode� str_fallback�returnc C s@ t � | _d | _d | _d | _d| _| �|� || _|| _i | _ d S )Nr ) r �_character_setZ python_typesZ mysql_typesr � charset_id� set_charsetr r �_cache_field_types��selfr r r � r% �O/home/agenciai/.local/lib/python3.9/site-packages/mysql/connector/conversion.py�__init__C s �zMySQLConverterBase.__init__)r � character_setr c C sD |dv r d}|dur || _ nd| _ |r,|| _| j�| j �d | _dS )zSet character set)Zutf8mb4Zutf8mb3r Nr )r r �get_charset_infor )r$ r r( r% r% r& r! V s z MySQLConverterBase.set_charset��valuer c C s || _ dS )zSet whether to use UnicodeN)r �r$ r+ r% r% r& � set_unicodeg s z MySQLConverterBase.set_unicodec C sD |j j�� }z t| d|� d��|�}|W S ty> | Y S 0 dS )�!Convert Python data type to MySQL�_� _to_mysqlN)� __class__�__name__�lower�getattr�AttributeError�r$ r+ � type_nameZ convertedr% r% r& �to_mysqlk s � zMySQLConverterBase.to_mysql��vtyper+ r c C s� |dks|du r"|d t jkr"dS | jszi | _t j�� D ]@\}}z$t| d|�� � d��| j|d < W q8 tyv Y q80 q8|du r�dS z| j|d ||�W S ty� | Y S 0 dS )�!Convert MySQL data type to Python� Nr r/ � _to_pythonr ) r �BITr" �desc�itemsr4 r3 r5 �KeyError)r$ r: r+ �name�infor% r% r& � to_pythonx s" � z MySQLConverterBase.to_python�r+ �sql_moder c C s | S )z"Escape buffer for sending to MySQLr% �r+ rF r% r% r& �escape� s zMySQLConverterBase.escape��bufr c C s t | �S )z!Quote buffer for sending to MySQL��str�rJ r% r% r& �quote� s zMySQLConverterBase.quote)r TF)N)T)N)r2 � __module__� __qualname__�__doc__r rL �boolr' r r! r- r r r r8 r �bytesr rD � staticmethodr rH r rN r% r% r% r& r < s> �� � � � � ��r c s� e Zd ZdZdRee eedd�� fdd� ZedSe ee ee f e d�d d ��Z eee e eeee f e d �d d ��Zeed�dd�Zeee ed�dd�Zeeed�dd��Zeeed�dd��Zee ee d�dd��Zee e ef d�dd�Zee e ef d�d d �Z ee e d�d d ��Z ee e d�d d!��Z eeed�d"d#��Z eddd�d$d%��Z!ee"j"e d�d&d'��Z#ee"j$e d�d(d)��Z%ee"j&e d�d*d+��Z'ee&j(e d�d,d-��Z)ee"j*e d�d.d/��Z+eeee d�d0d1��Z,e-e d2f e.e e-ed2f d3�d4d5�Z/edTe ee e d6�d7d8��Z0e0Z1edUe ee ed6�d9d:��Z2e2Z3e2Z4e2Z5e2Z6e2Z7dVe ee ed6�d;d<�Z8e8Z9edWe ee ed6�d=d>��Z:edXe ee ed?�d@dA��Z;edYe ee ee"j$ d?�dBdC��Z<e<Z=edZe ee e"j*d?�dDdE��Z>ed[e ee ee"j" d?�dFdG��Z?e?Z@ed\e ee ed?�dHdI��ZAd]e ee eBe d?�dJdK�ZCd^e ee e eDeBe f d?�dLdM�ZEeEZFeEZGd_e ee e eDeBe f d?�dNdO�ZHed`ee ee eeIjI d6�dPdQ��ZJeHZKeHZLeHZM� ZNS )a�MySQLConvertera� Default conversion class for MySQL Connector/Python. o escape method: for escaping values send to MySQL o quoting method: for quoting values send to MySQL in statements o conversion mapping: maps Python and MySQL data types to function for converting them. Whenever one needs to convert values differently, a converter_class argument can be given while instantiating a new connection like cnx.connect(converter_class=CustomMySQLConverterClass). NTFr c s t � �|||� i | _d S )N)�superr' r" r# �r1 r% r& r' � s �zMySQLConverter.__init__rE c C s t |t�r|�� }t | ttf�r�|dur>tj|v r>| �dd�S | �dd�} | �dd�} | �dd �} | �dd �} | �d d �} | �d d�} n~t | t��rt | t��s|dur�tj|v r�| �dd�S | �dd�} | �dd�} | �dd�} | �dd�} | �dd�} | �dd�} | S ) z� Escapes special characters as they are expected to by when MySQL receives them. As found in MySQL source mysys/charset.c Returns the value if not a string, or the escaped string. N� 's ''� \s \\� s \n� s \rs \'� "s \"� s \�'z''�\z\\� z\n� z\rz\'�"z\"�z\) � isinstancerS �decode� bytearrayr ZNO_BACKSLASH_ESCAPES�replacerL r rG r% r% r& rH � s* zMySQLConverter.escaperI c C s> t | t�rt| ��d�S t | td��r.td�S td| d �S )a Quote the parameters for commands. General rules: o numbers are returns as bytes using ascii codec o None is returned as bytearray(b'NULL') o Everything else is single quoted '<buf>' Returns a bytearray object. �asciiNs NULLrX )rd r rL �encode�typerf rM r% r% r& rN � s zMySQLConverter.quoter* c C sh |j j�� }z t| d|� d��|�}|W S tyb | jrLt|��� Y S td|� d��d�Y n0 dS )r. r/ r0 zPython 'z%' cannot be converted to a MySQL typeN) r1 r2 r3 r4 r5 r rL ri � TypeErrorr6 r% r% r& r8 � s � ��zMySQLConverter.to_mysqlr9 c C sT |dkr|d t jkrdS |du r&dS | js~i | _t j�� D ]@\}}z$t| d|�� � d��| j|d < W q< tyz Y q<0 q<z| j|d ||�W S ty� z|� d�W Y S t y� | Y Y S 0 Y n~ t �y } z&t |� d|d � d��|�W Y d}~nHd}~0 t �yN } z&t |� d|d � d��|�W Y d}~n d}~0 0 dS ) r; r r Nr/ r= �utf-8� (field �)) r r> r" r? r@ r4 r3 r5 rA re �UnicodeDecodeError� ValueErrorrk )r$ r: r+ rB rC �errr% r% r& rD � s0 � .zMySQLConverter.to_pythonc C s t | �S )zConvert value to int��int�r+ r% r% r& � _int_to_mysql s z MySQLConverter._int_to_mysqlc C s t | �S )z�Convert value to int Note: There is no type "long" in Python 3 since integers are of unlimited size. Since Python 2 is no longer supported, this method should be deprecated. rr rt r% r% r& �_long_to_mysql# s z MySQLConverter._long_to_mysqlc C s t �| �rdS t| �S )zConvert value to floatN)�math�isnan�floatrt r% r% r& �_float_to_mysql, s z MySQLConverter._float_to_mysqlc C s | � |�S )zConvert value to string)�_unicode_to_mysqlr, r% r% r& � _str_to_mysql3 s z MySQLConverter._str_to_mysqlc C sT | j }| j}|dkr(d}| j�|�d }|�|�}|| jjv rPd|v rPt||�S |S )zConvert unicode�binaryr r rY )r r r r) ri Zslash_charsetsr )r$ r+ r r �encodedr% r% r& r{ 7 s z MySQLConverter._unicode_to_mysqlc C s | S �zConvert value to bytesr% rt r% r% r& �_bytes_to_mysqlD s z MySQLConverter._bytes_to_mysqlc C s t | �S r )rS rt r% r% r& �_bytearray_to_mysqlI s z"MySQLConverter._bytearray_to_mysqlc C s | rdS dS )zConvert value to booleanr r r% rt r% r% r& �_bool_to_mysqlN s z MySQLConverter._bool_to_mysqlc C s dS )z� This would return what None would be in MySQL, but instead we leave it None and return it right away. The actual conversion from None to NULL happens in the quoting functionality. Return None. Nr% rt r% r% r& �_nonetype_to_mysqlS s z!MySQLConverter._nonetype_to_mysqlc C s^ | j r4d}|�| j| j| j| j| j| j| j ��d�S d}|�| j| j| j| j| j| j��d�S )z� Converts a datetime instance to a string suitable for MySQL. The returned string has format: %Y-%m-%d %H:%M:%S[.%f] If the instance isn't a datetime.datetime type, it return None. Returns a bytes. z7{0:04d}-{1:02d}-{2:02d} {3:02d}:{4:02d}:{5:02d}.{6:06d}rh z/{0:04d}-{1:02d}-{2:02d} {3:02d}:{4:02d}:{5:02d}) � microsecond�format�year�month�day�hour�minute�secondri )r+ �fmtr% r% r& �_datetime_to_mysql^ s0 �� ��z!MySQLConverter._datetime_to_mysqlc C s& | j d�d| jd�d| jd���d�S )z� Converts a date instance to a string suitable for MySQL. The returned string has format: %Y-%m-%d If the instance isn't a datetime.date type, it return None. Returns a bytes. Z04d�-Z02drh )r� r� r� ri rt r% r% r& �_date_to_mysql~ s z MySQLConverter._date_to_mysqlc C s& | j r| �d��d�S | �d��d�S )z� Converts a time instance to a string suitable for MySQL. The returned string has format: %H:%M:%S[.%f] If the instance isn't a datetime.time type, it return None. Returns a bytes. z %H:%M:%S.%frh z%H:%M:%S)r� �strftimeri rt r% r% r& �_time_to_mysql� s z MySQLConverter._time_to_mysqlc C s t �d| ��d�S )z� Converts a time.struct_time sequence to a string suitable for MySQL. The returned string has format: %Y-%m-%d %H:%M:%S Returns a bytes or None when not valid. z%Y-%m-%d %H:%M:%Srh )�timer� ri rt r% r% r& �_struct_time_to_mysql� s z$MySQLConverter._struct_time_to_mysqlc C s� t | jd | j �}| jrDd}| jdk r<d| j }|d8 }qH| j}nd}| jdk rZd| }t|d�\}}t|d �\}}| jr�|�||||�}n|�|||�}|�d �S ) z� Converts a timedelta instance to a string suitable for MySQL. The returned string has format: %H:%M:%S Returns a bytes. i�Q z {0:02d}:{1:02d}:{2:02d}.{3:06d}r i@B r z{0:02d}:{1:02d}:{2:02d}r� i �< rh )�abs�days�seconds� microseconds�divmodr� ri ) r+ r� r� �mcs�hours� remainder�mins�secs�resultr% r% r& �_timedelta_to_mysql� s z"MySQLConverter._timedelta_to_mysqlc C s t | t�rt| ��d�S dS )z� Converts a decimal.Decimal instance to a string suitable for MySQL. Returns a bytes or None when not valid. rh N)rd r rL ri rt r% r% r& �_decimal_to_mysql� s z MySQLConverter._decimal_to_mysql.)�row�fieldsr c C sb d}dgt |� }| jsji | _tj�� D ]@\}}z$t| d|�� � d��| j|d < W q( tyf Y q(0 q(|D ]�}|d }|| dkr�|tjks�|| du r�|d7 }qnz | j| || |�||< W n� t �y z|| � d�||< W n t �y || ||< Y n0 Y nB t t f�yN } z$| � d|d � d�| _� W Y d} ~ n d} ~ 0 0 |d7 }qnt|�S ) a Convert a MySQL text result row to Python types The row argument is a sequence containing text result returned by a MySQL server. Each value of the row is converted to the using the field type information in the fields argument. Returns a tuple. r Nr/ r= r rl rm rn )�lenr" r r? r@ r4 r3 r5 r> rA re ro rp rk �message�tuple) r$ r� r� �ir� rB rC �fieldZ field_typerq r% r% r& � row_to_python� s8 � " z MySQLConverter.row_to_python)r+ r? r c C s t | �S )z. Returns value as float type. )ry �r+ r? r% r% r& �_float_to_python s z MySQLConverter._float_to_pythonc C s t | �S )z, Returns value as int type. rr r� r% r% r& �_int_to_python s z MySQLConverter._int_to_pythonc C s |� | j�}t|�S )z5 Returns value as a decimal.Decimal. )re r r )r$ r+ r? �valr% r% r& �_decimal_to_python s z!MySQLConverter._decimal_to_pythonc C s t | �S )z, Returns value as str type. rK r� r% r% r& �_str% s zMySQLConverter._str)r+ �dscr c C s8 | }t |�dk r$ddt |� | }tt�d|�d �S )z!Returns BIT columntype as integer� r< z>Qr )r� rs �struct�unpack)r+ r� Zint_valr% r% r& �_bit_to_python, s z MySQLConverter._bit_to_pythonc C s� t | tj�r| S zt| �d�}t|�dkr@td|� dt|�� ���z*t�t|d �t|d �t|d ��W W S ty� Y W dS 0 W n, ttfy� td t| �� d ��d�Y n0 dS ) z�Converts TIME column MySQL to a python datetime.datetime type. Raises ValueError if the value can not be converted. Returns DATE column type as datetime.date type. � -� �invalid datetime format: � len: r r � NzCould not convert z to python datetime.timedelta) rd �datetime�date�splitr� rp rs � IndexError�repr)r+ r� �partsr% r% r& �_date_to_python4 s * ��z MySQLConverter._date_to_pythonc C s� d}z"| � d�\}}t|�dd��}W n ttfyD | }d}Y n0 z\dd� |� d�D �\}}}| d d ksz| d d kr�| | | }}}tj||||d �W S tttfy� ttj | d d ��d�Y n0 dS )a Converts TIME column value to python datetime.time value type. Converts the TIME column MySQL type passed as bytes to a python datetime.datetime type. Raises ValueError if the value can not be converted. Returns datetime.timedelta type. N� .� � 0r c S s g | ] }t |��qS r% rr )�.0�dr% r% r& � <listcomp>d � z2MySQLConverter._time_to_python.<locals>.<listcomp>� :�- r� )r� �minutesr� r� �datetime.timedelta�r+ Zpytype) r� rs �ljustrk rp r� � timedeltar� � CONVERT_ERRORr� )r+ r� r� �hmsr� r� r� r% r% r& �_time_to_pythonO s. � � ��z MySQLConverter._time_to_pythonc C s t | tj�r| S d}d}z�| �d�\}}t|�dkrT|�d�\}}t|�dd��}n|}d}dd � |�d �D �d d � |�d �D � |g }t|�dk r�td |� dt|�� ���ztj|� }W n ty� Y W dS 0 W n, ttf�y tt j | dd��d�Y n0 |S )z�Converts DATETIME column value to python datetime.time value type. Converts the DATETIME column MySQL type passed as bytes to a python datetime.datetime type. Returns: datetime.datetime type. N� r� r� r� r� r c S s g | ] }t |��qS r% rr �r� r� r% r% r& r� � r� z6MySQLConverter._datetime_to_python.<locals>.<listcomp>r� c S s g | ] }t |��qS r% rr r� r% r% r& r� � r� r� r� r� r� r� ) rd r� r� r� rs r� rp r� rk r� r� )r+ r� Z datetime_valr� Zdate_Ztime_r� Zdtvalr% r% r& �_datetime_to_pythons s> ���� ��z"MySQLConverter._datetime_to_pythonc C sL z t | �}W n: tyF } z"tdt| �� d��|�W Y d}~n d}~0 0 |S )z#Returns YEAR column type as integerz Failed converting YEAR to int (rn N)rs rp r� )r+ r� r� rq r% r% r& �_year_to_python� s ,z MySQLConverter._year_to_pythonc C sl d}|� | j�}|st� S zt|�d��}W n: tyf } z"tdt|�� d��|�W Y d}~n d}~0 0 |S )z�Returns SET column type as set Actually, MySQL protocol sees a SET as a string type field. So this code isn't called directly, but used by STRING_to_python() method. Returns SET column type as a set. N�,zCould not convert set z to a sequence)re r �setr� rp r� )r$ r+ r� �set_typer� rq r% r% r& �_set_to_python� s ��z MySQLConverter._set_to_pythonc C s� | j dkr|S |dur`|d tjkr6| jr6|�| j �S |d tj@ rP| �||�S |d dkr`|S t|t t f�r�| jr�z|�| j �W S t y� | Y S 0 |S )z� Note that a SET is a string too, but using the FieldFlag we can see whether we have to split it. Returns string typed columns as string type. r} Nr � r� �? ) r r ZJSONr re r ZSETr� rd rS rf ro �r$ r+ r� r% r% r& �_string_to_python� s z MySQLConverter._string_to_pythonc C sD |dur8|d t j@ r8|d t j@ r8|d dkr8t|�S | �||�S )z!Convert BLOB data type to Python.Nr� r� r� )r ZBLOBZBINARYrS r� r� r% r% r& �_blob_to_python� s � � �z MySQLConverter._blob_to_pythonc C sH | du st | tj�r| S t | ttf�r2t�t| �S td| jj� ���dS )z� Converts a MySQL VECTOR value to a Python array.array type. Returns an array of floats if `value` isn't `None`, otherwise `None`. NzGot unsupported type )rd �arrayrS rf r rk r1 r2 r� r% r% r& �_vector_to_python� s z MySQLConverter._vector_to_python)NTF)N)N)N)N)N)N)N)N)N)N)N)N)N)N)Or2 rO rP rQ r rL rR r' rT r r rS rH ry rs r r rN r r r8 r r rD ru rv rz r| r{ r� rf r� r� r� r� r� r� r� r� r� � struct_timer� r� r� r� r r r� r� Z_double_to_pythonr� Z_tiny_to_pythonZ_short_to_pythonZ_int24_to_pythonZ_long_to_pythonZ_longlong_to_pythonr� Z_newdecimal_to_pythonr� r� r� Z_NEWDATE_to_pythonr� r� Z_timestamp_to_pythonr� r r� r r� Z_var_string_to_pythonZ_json_to_pythonr� r� r� Z_long_blob_to_pythonZ_medium_blob_to_pythonZ_tiny_blob_to_python� __classcell__r% r% rW r& rU � s� �� " $� % � 3 �� �� ��# ��. �� �� �� � �rU )$rQ r� r� rw r� r� �decimalr �typingr r r r r r r r � constantsr r r r r Z custom_typesr �typesr r r r r �utilsr r� r rU r% r% r% r& �<module> s ( d
| ver. 1.6 |
Github
|
.
| PHP 8.2.30 | ??????????? ?????????: 0 |
proxy
|
phpinfo
|
???????????