U
|
£ý°dc ã @ sÊ d Z ddlZddlZddlZddlZddlmZ ddlmZm Z m
|
Z
|
m Z m Z m Z mZmZ ddlmZmZmZ ddlmZ ddlmZmZmZmZmZm 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é )Ú CharacterSetÚ FieldFlagÚ FieldType)Ú
|
HexLiteral)ÚDescriptionTypeÚRowTypeÚ
|
StrOrBytesÚToMysqlInputTypesÚToMysqlOutputTypesÚToPythonOutputTypes)Ú NUMERIC_TYPESz.Could not convert '{value}' to python {pytype}c @ s® e Zd ZdZdee eeddddZee dd d
|
d Zdedd d dZ e
|
e e
|
e f d ddZ eee edddZed eee edddZeeedddZdS ) ÚMySQLConverterBasezBase 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 s8 d | _ d | _d | _d| _| |¡ || _|| _i | _d S )Nr )Z python_typesZ mysql_typesr Ú
|
charset_idÚ set_charsetr r Ú_cache_field_types©Úselfr r r © r# úQd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\mysql/connector/conversion.pyÚ__init__> s
|
ýzMySQLConverterBase.__init__)r r c C s8 |dkr d}|dk r || _ nd| _ t | j ¡d | _dS )zSet character set)Zutf8mb4Zutf8mb3r Nr )r r Úget_charset_infor )r" r r# r# r$ r P s z MySQLConverterBase.set_charset©Úvaluer c C s
|
|| _ dS )zSet whether to use UnicodeN)r ©r" r( r# r# r$ Ú set_unicode[ s z MySQLConverterBase.set_unicodec C sF |j j ¡ }z t| d| d|}|W S tk
|
r@ | Y S X dS )ú!Convert Python data type to MySQLÚ_Ú _to_mysqlN)Ú __class__Ú__name__ÚlowerÚgetattrÚAttributeError©r" r( Z type_nameZ convertedr# r# r$ Úto_mysql_ s ÿzMySQLConverterBase.to_mysql©Úvtyper( r c C s¼ |dks|dkr"|d t jkr"dS | js|i | _t j ¡ D ]B\}}z$t| d| ¡ d| j|d < W q8 tk
|
rx Y q8X q8|dkrdS z| j|d ||W S tk
|
r¶ | Y S X dS )ú!Convert MySQL data type to Pythonó Nr r, Ú
|
_to_pythonr ) r ÚBITr ÚdescÚitemsr1 r0 r2 ÚKeyError)r" r6 r( ÚnameÚinfor# r# r$ Ú to_pythonl s$ ÿz MySQLConverterBase.to_python©r( Úsql_moder c C s | S )z"Escape buffer for sending to MySQLr# ©r( rB r# r# r$ Úescape s zMySQLConverterBase.escape©Úbufr c C s t | S )z!Quote buffer for sending to MySQL©Ústr©rF r# r# r$ Úquote s zMySQLConverterBase.quote)r TF)T)N)r/ Ú
|
__module__Ú __qualname__Ú__doc__r rH Úboolr% r r* r r
|
r r4 r Úbytesr r@ Ú staticmethodr rD r rJ r# r# r# r$ r 7 s8 üû
|
þ þ þýr c @ s e Zd ZdZdPee eeddddZedQe ee e dd d
|
Z
|
eee e e eeef ed d d ZeedddZeee edddZee e dddZee e dddZee ee dddZee eef dddZee eef dd d Z eeedd d Z ee edd d!Z eee dd"d#Z edddd$d%Z!ee"j"edd&d'Z#ee"j$edd(d)Z%ee"j&edd*d+Z'ee&j(edd,d-Z)ee"j*edd.d/Z+eeee dd0d1Z,e-ed2f e.e e/d3d4d5Z0edReee e d6d7d8Z1e1Z2edSeee e d6d9d:Z3e3Z4e3Z5e3Z6e3Z7e3Z8dTeee ed6d;d<Z9e9Z:edUeee ed6d=d>Z;edVeee e d?d@dAZ<edWeee ee"j$ d?dBdCZ=e=Z>edXeee e"j*d?dDdEZ?edYeee ee"j" d?dFdGZ@e@ZAedZeee e d?dHdIZBd[eee eCe d?dJdKZDd\eee e eEeCe f d?dLdMZFeFZGeFZHd]eee e eEeCe f d?dNdOZIeIZJeIZKeIZLdS )^Ú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 C s t | |||¡ i | _d S )N)r r% r r! r# r# r$ r% ¢ s ýzMySQLConverter.__init__rA c C sà t | ttfrl|dkr"| dd¡S | dd¡} | dd¡} | dd ¡} | dd
|
¡} | d d ¡} | d d¡} npt | trÜt | tsÜ|dkr| 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.
|
ZNO_BACKSLASH_ESCAPESó 's ''ó \s \\ó
|
s \nó s \rs \'ó "s \"ó s \ú'z''ú\z\\Ú
|
z\nú z\rz\'ú"z\"úz\)Ú
|
isinstancerO Ú bytearrayÚreplacerH r rC r# r# r$ rD ® s& zMySQLConverter.escaperE c C s> t | trt| d¡S t | tdr.tdS 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 NULLrR )r^ r rH ÚencodeÚtyper_ rI r# r# r$ rJ Ë s
|
|
|
zMySQLConverter.quoter' c C sj |j j ¡ }z t| d| d|}|W S tk
|
rd | jrNt| ¡ Y S td| ddY nX dS )r+ r, r- zPython 'z%' cannot be converted to a MySQL typeN) r. r/ r0 r1 r2 r rH rb Ú TypeErrorr3 r# r# r$ r4 Û s ÿ
|
ÿþzMySQLConverter.to_mysqlr5 c C sV |dkr|d t jkrdS |dkr&dS | jsi | _t j ¡ D ]B\}}z$t| d| ¡ d| j|d < W q< tk
|
r| Y q<X q<z| j|d ||W S tk
|
rØ z| d¡W Y S t
|
k
|
rÒ | Y Y S X Y nz t k
|
r } z t | d|d d|W 5 d}~X Y n> t k
|
rP } z t | d|d d|W 5 d}~X Y nX dS ) r7 r r Nr, r9 úutf-8ú (field ú)) r r: r r; r< r1 r0 r2 r= ÚdecodeÚUnicodeDecodeErrorÚ
|
ValueErrorrd )r" r6 r( r> r? Úerrr# r# r$ r@ ê s2 ÿ*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.
|
rl rn r# r# r$ Ú_long_to_mysql s z MySQLConverter._long_to_mysqlc C s t | ¡rdS t| S )zConvert value to floatN)ÚmathÚisnanÚfloatrn 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_mysql$ s z MySQLConverter._str_to_mysqlc C sP | j }| j}|dkr&d}t |¡d }| |¡}|tjkrLd|krLt||S |S )zConvert unicodeÚbinaryr r rS )r r r r& rb Zslash_charsetsr )r" r( r r Úencodedr# r# r$ ru ( s
|
|
|
z MySQLConverter._unicode_to_mysqlc C s | S ©zConvert value to bytesr# rn r# r# r$ Ú_bytes_to_mysql5 s z MySQLConverter._bytes_to_mysqlc C s t | S ry )rO rn r# r# r$ Ú_bytearray_to_mysql: s z"MySQLConverter._bytearray_to_mysqlc C s | rdS dS )zConvert value to booleanr r r# rn r# r# r$ Ú_bool_to_mysql? 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# rn r# r# r$ Ú_nonetype_to_mysqlD 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}ra z/{0:04d}-{1:02d}-{2:02d} {3:02d}:{4:02d}:{5:02d}) Ú microsecondÚformatÚyearÚmonthÚdayÚhourÚminuteÚsecondrb )r( Úfmtr# r# r$ Ú_datetime_to_mysqlO s0
|
ùø
|
úùz!MySQLConverter._datetime_to_mysqlc C s& | j dd| jdd| 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ú-Z02dra )r r r rb rn r# r# r$ Ú_date_to_mysqlo 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.%fra z%H:%M:%S)r~ Ústrftimerb rn 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:%Sra )Útimer rb rn 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.
|
iQ z {0:02d}:{1:02d}:{2:02d}.{3:06d}r i@B r z{0:02d}:{1:02d}:{2:02d}r i é< ra )ÚabsÚdaysÚsecondsÚ microsecondsÚdivmodr rb ) r( r r ÚmcsÚhoursÚ remainderÚminsÚsecsÚresultr# r# r$ Ú_timedelta_to_mysql s
|
|
|
|
z"MySQLConverter._timedelta_to_mysqlc C s t | trt| d¡S dS )z
|
Converts a decimal.Decimal instance to a string suitable for
|
MySQL.
|
|
Returns a bytes or None when not valid.
|
ra N)r^ r rH rb rn r# r# r$ Ú_decimal_to_mysqlµ s
|
z MySQLConverter._decimal_to_mysql.)ÚrowÚfieldsr c
|
C sf d}dgt | }| jsli | _tj ¡ D ]B\}}z$t| d| ¡ d| j|d < W q( tk
|
rh Y q(X q(|D ]ì}|d }|| dkr|tjks|| dkr¨|d7 }qpz | j| || |||< W n t k
|
r z||
|
d¡||< W n" t k
|
r || ||< Y nX Y n@ t t fk
|
rR } z | d|d d| _ W 5 d} ~ X Y nX |d7 }qpt|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, r9 r re rf rg )Úlenr r r; r< r1 r0 r2 r: r= rh ri rj rd ÚmessageÚtuple)
|
r" r r Úir r> r? ÚfieldZ
|
field_typerk r# r# r$ Ú row_to_python s: ÿ"
|
z MySQLConverter.row_to_python)r( r; r c C s t | S )z.
|
Returns value as float type.
|
)rs ©r( r; r# r# r$ Ú_float_to_pythonõ s z MySQLConverter._float_to_pythonc C s t | S )z,
|
Returns value as int type.
|
rl 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.
|
)rh 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.
|
rG 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é r8 z>Qr )r rm ÚstructÚunpack)r( rª Zint_valr# r# r$ Ú_bit_to_python s z MySQLConverter._bit_to_pythonc C sº t | tjr| S zv| d¡}t|dkr@td| dt| z*t t|d t|d t|d ¡W W S tk
|
r Y W dS X W n. ttfk
|
r´ td t| d
|
dY nX 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) r^ ÚdatetimeÚdateÚsplitr rj rm Ú
|
IndexErrorÚrepr)r( rª Úpartsr# r# r$ Ú_date_to_python% s
|
|
*ÿþz MySQLConverter._date_to_pythonc
|
C sØ d}z"| d¡\}}t| dd¡}W n ttfk
|
rF | }d}Y nX z\dd | d¡D \}}}| d d ks|| d d
|
kr| | | }}}tj||||d W S tttfk
|
rÒ ttj | d d dY nX 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# rl )Ú.0Údr# r# r$ Ú
|
<listcomp>U s z2MySQLConverter._time_to_python.<locals>.<listcomp>ó :é- r )r Úminutesr r údatetime.timedelta©r( Zpytype)
|
r¶ rm Úljustrd rj r´ Ú timedeltar· Ú CONVERT_ERRORr )r( rª r Úhmsr r r r# r# r$ Ú_time_to_python@ s4
|
ý
|
ÿ ÿþz MySQLConverter._time_to_pythonc C s t | tjr| 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 tk
|
rÔ Y W dS X W n. ttfk
|
r tt j
|
| dddY nX |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# rl ©r¾ r¡ r# r# r$ rÀ | s z6MySQLConverter._datetime_to_python.<locals>.<listcomp>r¯ c S s g | ] }t |qS r# rl rÌ r# r# r$ rÀ } s rÁ r± r² rÄ rÅ ) r^ r´ r¶ r rm rÆ rj r· rd rÈ r )r( rª Z datetime_valr Zdate_Ztime_rÉ Zdtvalr# r# r$ Ú_datetime_to_pythond s> ÿÿþÿ ÿþz"MySQLConverter._datetime_to_pythonc
|
C sJ z t | }W n8 tk
|
rD } ztdt| d|W 5 d}~X Y nX |S )z#Returns YEAR column type as integerz Failed converting YEAR to int (rg N)rm rj r¸ )r( rª r rk r# r# r$ Ú_year_to_python s
|
(z MySQLConverter._year_to_pythonc
|
C sj d}| | j¡}|st S zt| d¡}W n8 tk
|
rd } ztdt| d|W 5 d}~X Y nX |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)rh r Úsetr¶ rj r¸ )r" r( rª Úset_typer§ rk r# r# r$ Ú_set_to_python s
|
ÿþz MySQLConverter._set_to_pythonc C s | j dkr|S |dk r`|d tjkr6| jr6| | j ¡S |d tj@ rP| ||¡S |d dkr`|S t|t t
|
fr| jrz| | j ¡W S t k
|
r | Y S X |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.
|
rw Nr é r« é? ) r r ZJSONr rh r ZSETrÒ r^ rO r_ ri ©r" r( rª r# r# r$ Ú_string_to_pythonµ s
|
|
z MySQLConverter._string_to_pythonc C sD |dk r8|d t j@ r8|d t j@ r8|d dkr8t|S | ||¡S )z!Convert BLOB data type to Python.NrÓ r« rÔ )r ZBLOBÚBINARYrO rÖ rÕ r# r# r$ Ú_blob_to_pythonÓ s ÿ þ
|
üz MySQLConverter._blob_to_python)NTF)N)N)N)N)N)N)N)N)N)N)N)N)N)Mr/ rK rL rM r rH rN r% rP r rD r
|
rs rm r r rO rJ r r r4 r r r@ ro rp rt rv ru rz r_ r{ r| r} r´ r rµ r r r Ú struct_timer rÇ 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Ø Z_long_blob_to_pythonZ_medium_blob_to_pythonZ_tiny_blob_to_pythonr# r# r# r$ rQ sð üû $ü %
|
|
|
þ 3 ÿ þ ÿ þ ÿ þ# ÿ þ.
|
ÿ þ ÿ þ ÿ þ rQ )"rM r´ rq r¬ r Údecimalr Útypingr r r r r r r r
|
Ú constantsr r r Z custom_typesr Útypesr r r r r r Úutilsr rÈ r rQ r# r# r# r$ Ú<module> s ( ]
|
