/var/opt/nydus/ops/mysql/connector/__pycache__
Edit: /var/opt/nydus/ops/mysql/connector/__pycache__/conversion.cpython-312.pyc (31554B)
N jj d Z ddlZddlZddlZddlZddlZddlmZ ddlm Z ddl
m Z m Z m
Z
mZmZmZmZmZ ddlmZmZmZmZmZmZ ddlmZ dd l m Z m Z m Z m Z m!Z! dd
l"m#Z# d Z$ G d d
Z% G d de% Z&y)z!Converting MySQL and Python types N)Decimal)Enum)AnyCallableDictListOptionalSetTupleUnion )MYSQL_VECTOR_TYPE_CODE!NATIVE_SUPPORTED_CONVERSION_TYPES CharacterSet FieldFlag FieldTypeSQLMode)
HexLiteral)DescriptionTypeMySQLConvertibleTypeMySQLProducedTypePythonProducedType
StrOrBytes)
NUMERIC_TYPESz.Could not convert '{value}' to python {pytype}c e Zd ZdZ ddee dededdfdZ ddee dee ddfd Z dd
eddfd Z
d
e de e e
f fd Zd
ed
ee defdZe dd
edee eef defd Zededefd Zy)MySQLConverterBasezBase class for conversion classes
All class dealing with converting to and from MySQL data types must
be a subclass of this class.
charset use_unicode str_fallbackreturnNc t | _ d | _ d | _ d | _ d| _ | j
| || _ || _ i | _ y )Nr )
r _character_set python_types mysql_typesr
charset_id set_charsetr r _cache_field_types)selfr r r s K/opt/nydus/tmp/pip-target-a90h98xg/lib/python/mysql/connector/conversion.py__init__zMySQLConverterBase.__init__E sW -9N-1,0&* !!,".
character_setc |dv rd}||| _ nd| _ |r|| _ | j j | j d | _ y)zSet character set)utf8mb4utf8mb3utf8Nr )r r" get_charset_infor% )r( r r, s r) r& z MySQLConverterBase.set_charsetX sT , , G "DL "DL "/D -->>t||LQOr+ valuec || _ y)zSet whether to use UnicodeN)r r( r2 s r) set_unicodez MySQLConverterBase.set_unicodei s
r+ c |j j j } t | d| d | }|S # t $ r |cY S w xY w)!Convert Python data type to MySQL_ _to_mysql) __class____name__lowergetattrAttributeErrorr( r2 type_name converteds r) to_mysqlzMySQLConverterBase.to_mysqlm s\ OO,,224 .Ugda {)
A A vtypec |dk( s||d t j k7 ry| j s\i | _ t j j D ]4 \ }} t | d|j
d | j |d < 6 |y | j |d || S # t $ r Y _w xY w# t $ r |cY S w xY w)!Convert MySQL data type to Python Nr
r8
_to_pythonr ) r BITr' descitemsr= r< r> KeyError)r( rC r2 nameinfos r) to_pythonz MySQLConverterBase.to_pythonz s
W
58y}}3L&&&(D # 'nn 2 2 4
d7> $**, z :8D++DG4 5 = 44**584UEB B
& L s$ .B$ B3 $ B0/B03 C Csql_modec | S )z"Escape buffer for sending to MySQL r2 rO s r) escapezMySQLConverterBase.escape s r+ bufc t | S )z!Quote buffer for sending to MySQLstrrT s r) quotezMySQLConverterBase.quote s
3xr+ )r0 TFN)T)r;
__module__ __qualname____doc__r rW boolr* r r& r5 r r r rB r bytesr rN staticmethodr rS r rY rQ r+ r) r r > s) "( " #
( OSP }P5=l5KP
P"! ! ! ) #Z/ 0 $-5e_ 4 155e,-
3 : r+ r c
e Zd ZdZ d2dee dededdf fd
Zed3de d ee
ee f de fd
Z ed ee
e
eeee f de fd Zdedefd
Zdedee defdZededefd Zededefd Zede
dee
fd Zdede
e ef fdZdede
e ef fdZ ede de fd Z ede de fd Z ededefd Z ed4d Z!ede"jD de fd Z#ede"jH de fd Z%ede"jL de fd Z'ede&jP de fd Z)ede"jT de fd Z+ededee fd Z,d e-e d f d!e.e de-ed f fd"Z/ed3de d#ee de
fd$ Z0e0Z1ed3de d#ee defd% Z2e2Z3e2Z4e2Z5e2Z6e2Z7 d3de d#ee defd&Z8e8Z9ed3de d#ee defd' Z:ed3de d(ee defd) Z;e d3de d(ee dee"jH fd* Ze d3de d(ee dee"jD fd, Z?e?Z@ed3de d(ee defd- ZA d3de d(ee deBe fd.ZC d3de d(ee de
eDeBe f fd/ZEeEZFeEZG d3de d(ee de
eDeBe f fd0ZHe d3dee d#ee deeIj fd1 ZJeHZKeHZLeHZM xZNS )5MySQLConvertera 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).
Nr r r r c 6 t | ||| i | _ y rZ )superr* r' )r( r r r r: s r) r* zMySQLConverter.__init__ s# +|<
r+ r2 rO c t |t r|j }t | t t f r|$t j
|v r| j
dd S | j
dd } | j
dd } | j
dd } | j
dd } | j
d
d } | j
d d
} | S t | t rt | t s|$t j
|v r| j
dd S | j
dd } | j
dd } | j
dd } | j
dd } | j
dd } | j
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.
's '' \s \\
s \n
s \rs \' "s \" s \'z''\z\\
z\n
z\rz\'"z\"z\)
isinstancer_ decode bytearrayr NO_BACKSLASH_ESCAPESreplacerW r rR s r) rS zMySQLConverter.escape sR h & (H eeY / 0#(D(D(P }}T511MM%1EMM%0EMM%0EMM';7EMM';7EMM';7E s
#Juj,I#(D(D(P }}S$//MM$/EMM$.EMM$.EMM&*5EMM&*5EMM&*5E r+ rT c t | t rt | j d S t | t d r t d S t d| z dz 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 ''
Returns a bytearray object.
asciiNs NULLrf )rr r rW encodetypert rX s r) rY zMySQLConverter.quote sN c= )s8??7+ + c4: & W% %d*++r+ c t t r j t j t d }|sIt
fdt j D j j j } t | d| d }|S # t $ r8 | j rt j cY S t! d| d dw xY w)r7 c 3 @ K | ] \ }}t | r| y wrZ )rr ).0 data_typerL r2 s r) z*MySQLConverter.to_mysql.. s' +T 4!%3 +Ts r8 r9 zPython 'z%' cannot be converted to a MySQL typeN)rr r r2 r getrz nextrJ r: r; r< r= r> r rW ry TypeErrorr? s ` r) rB zMySQLConverter.to_mysql s eT "KKE ;>>tE{BO +L+R+R+T
((..0
I +R741YKy9Q+R,I 5z((**9+%JK
s B! !.C"C"rC c N |dk( r|d t j k7 ry|y| j s\i | _ t j j D ]4 \ }} t | d|j
d | j |d < 6 | j |d || S # t $ r Y \w xY w# t $ r( |j d cY S # t $ r |cY cY S w xY wt $ r}t | d|d d |d}~wt $ r}t | d|d d |d}~ww xY w) rE r r
Nr8 rG utf-8 (field ))
r rH r' rI rJ r= r< r> rK rs UnicodeDecodeError
ValueErrorr )r( rC r2 rL rM errs r) rN zMySQLConverter.to_python
sD A:%(imm3 =&&&(D # 'nn 2 2 4
d7> $**, z :8D++DG4 5 B44**584UEB B &
||G,,%
C uHU1XJa 89s B Bse8E!H:Q 78c A BsZ .B" B1 " B.-B.1 D$;C D$ C D$ C D$)C>> D$
D D$c t | S )zConvert value to intintr2 s r)
_int_to_mysqlz MySQLConverter._int_to_mysql/ s 5zr+ c t | S )zConvert 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.
r r s r) _long_to_mysqlz MySQLConverter._long_to_mysql4 s 5zr+ c D t j | ryt | S )zConvert value to floatN)mathisnanfloatr s r) _float_to_mysqlz MySQLConverter._float_to_mysql= s ::e U|r+ c $ | j | S )zConvert value to string)_unicode_to_mysqlr4 s r)
_str_to_mysqlz MySQLConverter._str_to_mysqlD s %%e,,r+ c | j }| j }|dk( r d}| j j | d }|j | }|| j j
v rd|v r t
|| S |S )zConvert unicodebinaryr0 r rg )r r% r" r1 ry slash_charsetsr )r( r2 r r% encodeds r) r z MySQLConverter._unicode_to_mysqlH sx ,,__
h G ,,==gFqIJ,,w' ,,;; ;'!!%11r+ c | S zConvert value to bytesrQ r s r) _bytes_to_mysqlz MySQLConverter._bytes_to_mysqlU s r+ c t | S r )r_ r s r) _bytearray_to_mysqlz"MySQLConverter._bytearray_to_mysqlZ s U|r+ c | rdS dS )zConvert value to booleanr
r rQ r s r) _bool_to_mysqlz MySQLConverter._bool_to_mysql_ s q q r+ c y)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.
NrQ r s r) _nonetype_to_mysqlz!MySQLConverter._nonetype_to_mysqld s r+ c | j rnd}|j | j | j | j | j
| j | j | j j d S d}|j | j | 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}rx z/{0:04d}-{1:02d}-{2:02d} {3:02d}:{4:02d}:{5:02d}) microsecondformatyearmonthdayhourminutesecondry )r2 fmts r) _datetime_to_mysqlz!MySQLConverter._datetime_to_mysqlo s KC::
!! fWo
@zz JJ KK II JJ LL LL
&/ r+ c v | j dd| j dd| j dj 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.
04d-02drx )r r r ry r s r) _date_to_mysqlz MySQLConverter._date_to_mysql s: **S!5;;s"31UYYsODKKGTTr+ c | j r | j d j d S | j d j 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.%frx z%H:%M:%S)r strftimery r s r) _time_to_mysqlz MySQLConverter._time_to_mysql sA >>-077@ @~~j)0099r+ c L t j d| j 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:%Srx )timer ry r s r) _struct_time_to_mysqlz$MySQLConverter._struct_time_to_mysql s! }} 0%8??HHr+ c t | j dz | j z }| j r3d}| j dk rd| j z
}|dz }n| j }nd}| j dk rd|z }t |d \ }}t |d \ }}| j r|j ||| }n|j ||| }|j
d
S ) z
Converts a timedelta instance to a string suitable for MySQL.
The returned string has format: %H:%M:%S
Returns a bytes.
iQ z {0:02d}:{1:02d}:{2:02d}.{3:06d}r i@B r
z{0:02d}:{1:02d}:{2:02d}r i < rx )absdaysseconds microsecondsdivmodr ry ) r2 r r mcshours remainderminssecsresults r) _timedelta_to_mysqlz"MySQLConverter._timedelta_to_mysql s ejj5(5==89 3CzzA~ 2 221 ((+C ::>)C #GT 2 i, t ZZtT37FZZtT2F}}W%%r+ c X t | t rt | j d S y)z
Converts a decimal.Decimal instance to a string suitable for
MySQL.
Returns a bytes or None when not valid.
rx N)rr r rW ry r s r) _decimal_to_mysqlz MySQLConverter._decimal_to_mysql s& eW %u:$$W- -r+ row.fieldsc d}dgt | z }| j s\i | _ t j j D ]4 \ }} t | d|j
d | j |d < 6 |D ]O }|d }|| dk( r|t j k7 s|| |dz
}. | j | || | ||< |dz
}Q t | S # t $ r Y w xY w# t $ r3 || j d ||< n# t $ r || ||< Y nw xY wY \t t f$ r} | d|d d| _ d} ~ ww xY w) 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 Nr8 rG r
r r r )lenr' r rI rJ r= r< r> rH rK rs r r r messagetuple)
r( r r ir rL rM field
field_typer s
r)
row_to_pythonz MySQLConverter.row_to_python sw
,06CK+?&&&(D # 'nn 2 2 4
d7> $**, z :8D++DG4 5 E qJA!
imm ;AQ
?D 3 3J ?A Nq
FA+ . V} 7 &
'' #A
g 6F1I) ' #AF1I' *
!$XeAhZq 9
sT
.C+ C( C%$C%( E2D
E
D E D E#E1EErI c t | S )z.
Returns value as float type.
)r r2 rI s r) _float_to_pythonz MySQLConverter._float_to_python s
U|r+ c t | S )z,
Returns value as int type.
r r s r) _int_to_pythonz MySQLConverter._int_to_python
5zr+ c N |j | j }t | S )z5
Returns value as a decimal.Decimal.
)rs r r )r( r2 rI vals r) _decimal_to_pythonz!MySQLConverter._decimal_to_python+ s ll4<<(s|r+ c t | S )z,
Returns value as str type.
rV r s r) _strzMySQLConverter._str6 r r+ dscc | }t | dk rddt | z
z |z }t t j d| d S )z!Returns BIT columntype as integer rF z>Qr )r r structunpack)r2 r int_vals r) _bit_to_pythonz MySQLConverter._bit_to_python= sH wtE{m1 MNTW W Xs 616c d}|j | j }|s
t S t |j d }|S # t $ r }t dt | d |d}~ww xY w)zReturns 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)rs r setr r r )r( r2 r set_typer r s r) _set_to_pythonz MySQLConverter._set_to_python su ll4<<(5L 399S>*H
(e
^D
s A A.A))A.c | j dk( r|S |o|d t j k( r'| j r|j | j S |d t
j z r| j || S |d dk( r|S t |t t f r(| j r |j | j S |S # t $ r |cY S w xY w)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 r
r ? ) r r JSONr rs r SETr rr r_ rt r r( r2 r s r) _string_to_pythonz MySQLConverter._string_to_python s <<8 #L ?1v 'D,<,< ||DLL111v
%**5#661v| eeY / 0T5E5E
||DLL11 &
s &C CCc |?|d t j z r)|d t j z r|d dk( r t | S | j || S )z!Convert BLOB data type to Python.r r r )r BLOBBINARYr_ r r s r) _blob_to_pythonz MySQLConverter._blob_to_python sS ?A 'FY - --FbL U|#%%eS11r+ c | t | t j r| S t | t t f rt j t | S t d| j j )z
Converts a MySQL VECTOR value to a Python array.array type.
Returns an array of floats if `value` isn't `None`, otherwise `None`.
zGot unsupported type )rr arrayr_ rt r r r: r; r s r) _vector_to_pythonz MySQLConverter._vector_to_python sZ =Juekk :L eeY / 0;; 5u= =/0H0H/IJKKr+ )NTFrZ )r2 Nr N)Or; r[ r\ r] r rW r^ r* r` r r r_ rS r r r r rY r r rB r r rN r r r r r r rt r r r r r r r r r struct_timer r r r r r r r _double_to_pythonr _tiny_to_python_short_to_python_int24_to_python_long_to_python_longlong_to_pythonr _newdecimal_to_pythonr r r _NEWDATE_to_pythonr r _timestamp_to_pythonr r
r r r _var_string_to_python_json_to_pythonr r r! _long_blob_to_python_medium_blob_to_python_tiny_blob_to_python
__classcell__)r: s @r) rb rb s5 "& "
#
c XeCJ.?%@ C >
,8E%gz5"H IJ
,u
,
, 2 7H <#B #B #B
#BJ S S c c u % -3 -5
1B+C - s uUJ5F/G u 9 !d !s ! ! ("3"3 > Uhmm U U U :hmm : : : IT%5%5 I% I I &8#5#5 &% & &@
Xe_
0 $0 .2?.C0 !3& '0 f Xo-F RW )e 8O+D PS %O%%$O( ?C "*?"; /E /!: c 4e 4(?*C 4s 4 4 7;#O4 (-- 0 )7;!!#O4! ! !F 7;, , #O4, (## $, , \ /u 8O+D PS >B!)/!: S. >B!)/!: z3s8# $6 .'O >B 2 2!)/!: 2 z3s8# $ 2 BFLL&.&?L %++ L L + ,*r+ rb )'r] r r r r r decimalr enumr typingr r r r r r
r r constantsr r r r r r custom_typesr typesr r r r r utilsr r r rb rQ r+ r) r9 sg : (
I I I % !@
a aHr +' r +r+