"iTdZddlZddlZddlZddlZddlmZddlmZm Z m Z ddl m Z ddl mZdZGd d eZGd d eZdS) z"Converting MySQL and Python types N)Decimal) FieldType FieldFlag CharacterSet) NUMERIC_TYPES) HexLiteralz.Could not convert '{value}' to python {pytype}c@eZdZdZd dZdZddZdZd Zd Z d Z d S)MySQLConverterBasezBase class for conversion classes All class dealing with converting to and from MySQL data types must be a subclass of this class. utf8TFcd|_d|_d|_d|_d|_||||_||_i|_dS)Nr) python_types mysql_typescharset charset_id use_unicode set_charset str_fallback_cache_field_typesselfrrrs R/srv/django_bis/venv311/lib/python3.11/site-packages/mysql/connector/conversion.py__init__zMySQLConverterBase.__init__4sZ   !!!&("$c|dkrd}|||_nd|_tj|jd|_dS)zSet character setutf8mb4r Nr)rrget_charset_infor)rrs rrzMySQLConverterBase.set_charset?sG i  G  "DLL"DL&7 EEaHrc||_dS)zSet whether to use UnicodeN)rrvalues r set_unicodezMySQLConverterBase.set_unicodeJs rc|jj} t|d||S#t $r|cYSwxYw)!Convert Python data type to MySQL _{0}_to_mysql) __class____name__lowergetattrformatAttributeErrorrr type_names rto_mysqlzMySQLConverterBase.to_mysqlNsiO,2244  C74!7!7 !B!BCCEJJ J   LLL s+A AAc|dks||dtjkrdS|jsmi|_tjD]G\}} t |d||j|d<8#t$rYDwxYw |j|d||S#t$r|cYSwxYw)!Convert MySQL data type to PythonNr_{0}_to_pythonr) rBITrdescitemsr(r)r*KeyError)rvtyper nameinfos r to_pythonzMySQLConverterBase.to_pythonVs W   58y}3L3L4& &(D #'n2244   d7>.55d;;8=8=D+DG44%D 44*584UEBB B   LLL s$1B BBB33 CCc|S)z"Escape buffer for sending to MySQLrs rescapezMySQLConverterBase.escapel rc t|S)z!Quote buffer for sending to MySQLstrrbufs rquotezMySQLConverterBase.quoteps 3xxrN)r TF)T) r& __module__ __qualname____doc__rrr!r-r9r<rCr;rrr r -s % % % % I I I!!!!,rr c*eZdZdZd&dZdZdZdZd Zd Z d Z d Z d Z dZ dZdZdZdZdZdZdZdZdZdZdZd'dZeZd'dZeZeZeZeZeZ d'dZ!e!Z"d'dZ#d'dZ$d'dZ%e%Z&d'd Z'd'd!Z(e(Z)d'd"Z*d'd#Z+d'd$Z,e,Z-e,Z.d'd%Z/e/Z0e/Z1e/Z2dS)(MySQLConverteraDefault 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). NTFcNt||||i|_dSN)r rrrs rrzMySQLConverter.__init__s*##D'; MMM"$rc||St|tr|St|ttfr|dd}|dd}|dd}|dd }|d d }|d d }n|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\n s\r's\'"s\"s\\z\\ z\n z\r'z\'"z\"z\) isinstancerbytes bytearrayreplacers rr<zMySQLConverter.escapes' =L } - - L eeY/ 0 0 6MM%11EMM%00EMM%00EMM';77EMM';77EMM';77EEMM$//EMM$..EMM$..EMM&*55EMM&*55EMM&*55E rct|tr"t|dSt|t drt dSt d|zdzS)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. asciiNsNULLrO)rXrr@encodetyperZrAs rrCzMySQLConverter.quotesk c= ) ) &s88??7++ + T$ZZ ( ( &W%% %d*+++rcL|jj} t|d||S#t $rM|jr#t|cYStd|wxYw)r#r$z0Python '{0}' cannot be converted to a MySQL type) r%r&r'r(r)r*rr@r^ TypeErrorr+s rr-zMySQLConverter.to_mysqlsO,2244  <C74!7!7 !B!BCCEJJ J < < <  +5zz((*****))/ ):):<< < .55d;;8=8=D+DG44%D 44*584UEBB B    ||G,,,,,%      @ @ @U1XXX>?? ? ? ? ?sssE!HHH=>> >  sZ1B BBB55 D=CD= C(#D='C(( D=4D D=D77D=c t|SzConvert value to intintrs r _int_to_mysqlzMySQLConverter._int_to_mysql5zzrc t|Srjrkrs r_long_to_mysqlzMySQLConverter._long_to_mysqlrnrcLtj|rdSt|S)zConvert value to floatN)mathisnanfloatrs r_float_to_mysqlzMySQLConverter._float_to_mysqls% :e   4U||rc,||S)zConvert value to string)_unicode_to_mysqlrs r _str_to_mysqlzMySQLConverter._str_to_mysqls%%e,,,rc|j}|j}|dkrd}tj|d}||}|tjvrd|vrt ||S|S)zConvert unicodebinaryr rrL)rrrrr^slash_charsetsr )rr rrencodeds rrwz MySQLConverter._unicode_to_mysqlst,_ h  G%6w??BJ,,w'' 4 4 4'!!!%111rc|SzConvert value to bytesr;rs r_bytes_to_mysqlzMySQLConverter._bytes_to_mysqlr=rc t|Sr~)rYrs r_bytearray_to_mysqlz"MySQLConverter._bytearray_to_mysqlsU||rc|rdSdS)zConvert value to booleanrrr;rs r_bool_to_mysqlzMySQLConverter._bool_to_mysqls  1qrcdS)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;rs r_nonetype_to_mysqlz!MySQLConverter._nonetype_to_mysql s trc P|jrSd}||j|j|j|j|j|j|jdSd}||j|j|j|j|j|jdS)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}r]z/{0:04d}-{1:02d}-{2:02d} {3:02d}:{4:02d}:{5:02d}) microsecondr)yearmonthdayhourminutesecondr^)rr fmts r_datetime_to_mysqlz!MySQLConverter._datetime_to_mysqls   3KC:: EK EL%,!##$*6'?? 3 @zz J UY J el444:F7OO Drctd|j|j|jdS)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. z{0:04d}-{1:02d}-{2:02d}r])r)rrrr^rs r_date_to_mysqlzMySQLConverter._date_to_mysql*s5)// EK05 ;;;A6'?? Krc|jr(|ddS|ddS)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.%fr]z%H:%M:%S)rstrftimer^rs r_time_to_mysqlzMySQLConverter._time_to_mysql6sP   A>>-0077@@ @~~j))00999rcRtjd|dS)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:%Sr])timerr^rs r_struct_time_to_mysqlz$MySQLConverter._struct_time_to_mysqlCs%}0%88??HHHrct|jdz|jz}|jr%d}|jdkrd|jz }|dz}n |j}nd}|jdkrd|z}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. iQz{0:02d}:{1:02d}:{2:02d}.{3:06d}ri@Brz{0:02d}:{1:02d}:{2:02d}-i<r])absdaysseconds microsecondsdivmodr)r^) rr rrmcshours remainderminssecsresults r_timedelta_to_mysqlz"MySQLConverter._timedelta_to_mysqlMsej5(5=899   ,3CzA~~ 221 (+C :>>)C#GT22 i,, t   3ZZtT377FFZZtT22F}}W%%%rctt|tr"t|dSdS)z Converts a decimal.Decimal instance to a string suitable for MySQL. Returns a bytes or None when not valid. r]N)rXrr@r^rs r_decimal_to_mysqlz MySQLConverter._decimal_to_mysqlms5 eW % % .u::$$W-- -trc d}dgt|z}|jsmi|_tjD]G\}} t |d||j|d<8#t$rYDwxYw|D]}|d}||dkr|tjks|||dz }4 |j||||||<n#t$r> || d||<n#t$r||||<YnwxYwYnGttf$r4} dt| |d| _d} ~ wwxYw|dz }t!|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. rNr1rrcz{0} (field {1}))lenrrr3r4r(r)r*r2r5rerfrgrar@messagetuple) rrowfieldsirr7r8field field_typerhs r row_to_pythonzMySQLConverter.row_to_pythonys F #& &(D #'n2244   d7>.55d;;8=8=D+DG44%D  EqJA! im ; ;AQ ?D3J?ANNq  ' ' '' #A g 6 6F1II)''' #AF1III' *   /66s3xxqJJ   FAAV}}sT1A:: BB C"" E--D  E- D$!E-#D$$E-)E-9/E((E-c t|S)z. Returns value as float type. )rtrr r3s r_FLOAT_to_pythonzMySQLConverter._FLOAT_to_pythonsU||rc t|S)z, Returns value as int type. rkrs r_INT_to_pythonzMySQLConverter._INT_to_python5zzrcT||j}t|S)z5 Returns value as a decimal.Decimal. )rerr)rr r3vals r_DECIMAL_to_pythonz!MySQLConverter._DECIMAL_to_pythons#ll4<((s||rc t|S)z, Returns value as str type. r?rs r_strzMySQLConverter._strrrc|}t|dkrddt|z z|z}tjd|dS)z!Returns BIT columntype as integerr0z>Qr)rstructunpack)rr dscint_vals r_BIT_to_pythonzMySQLConverter._BIT_to_pythonsI w<z2MySQLConverter._TIME_to_python..s"C"C"Ca3q66"C"C"Cr:-r)rminutesrrdatetime.timedeltar pytype) rrlljustrargr timedeltar CONVERT_ERRORr))rr rhmsrrrrs r_TIME_to_pythonzMySQLConverter._TIME_to_pythons= T**JS#cii4(())CC:&   CCCC  P"C"C399T??"C"C"C UD$Qx2~~qS#'%$Cd%E4.2FFF FIz2 P P P]119M2OOPP P Ps;>AAAB66AC7ct|tjr|Sd} |d\}}t|dkr<|d\}}t |dd}n|}d}d|d Dd |d Dz|gz}t|dkr0t d |t| tj|}n#t $rYdSwxYwn>#ttf$r*t t|d wxYw|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 rrrrrc,g|]}t|Sr;rkrrs rrz6MySQLConverter._DATETIME_to_python..s777SVV777rrc,g|]}t|Sr;rkrs rrz6MySQLConverter._DATETIME_to_python..s555SVV555rrrrr) rXrrrrlrrgr)rrar) rr r datetime_valdate_time_rrdtvals r_DATETIME_to_pythonz"MySQLConverter._DATETIME_to_pythons eX. / / L  P"[[..NUE5zzA~~"[[.. c#))At,,--77U[[%6%677755SYYt__55569<@E5zzA~~ "$$*F5#e**$=$=??? #+#4e#>**HH P P PFNOO O Ps "AA.c|jdkr|S|p|dtjkr!|jr||jS|dt jzr|||S|ddkr|St|ttfr4|jr- ||jS#t$r|cYSwxYw|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. rzNrr?) rrJSONrrerSETrrXrYrZrfrr rs r_STRING_to_pythonz MySQLConverter._STRING_to_pythonHs <8 # #L ?1v''D,<'||DL1111v % 7**5#6661v|| eeY/ 0 0 T5E  ||DL111%      s$B>> C  C c|9|dtjzr$|dtjzrt|S|||S)z!Convert BLOB data type to Python.Nr)rBLOBBINARYrYrrs r_BLOB_to_pythonzMySQLConverter._BLOB_to_pythoncsO ?1v & $3q6I4D+D $U||#%%eS111r)NTFrJ)3r&rDrErFrr<rCr-r9rmrprurxrwrrrrrrrrrrrr_DOUBLE_to_pythonr_TINY_to_python_SHORT_to_python_INT24_to_python_LONG_to_python_LONGLONG_to_pythonr_NEWDECIMAL_to_pythonrrr_NEWDATE_to_pythonrr_TIMESTAMP_to_pythonrrr_VAR_STRING_to_python_JSON_to_pythonr_LONG_BLOB_to_python_MEDIUM_BLOB_to_python_TINY_BLOB_to_pythonr;rrrHrHus  %%%%8 , , , < < <B ---    DDD* K K K : : :III&&&@   ,,,\ ) %O%%$O(/ ////.)PPPP4%%%%N/$0.'O2222+,*rrH)rFrrrrrdecimalr constantsrrrutilsr custom_typesr robjectr rHr;rrrs: 9999999999 $$$$$$@ EEEEEEEEPw+w+w+w+w+'w+w+w+w+w+r