@icdZddlZddlZddlZddlZddlmZddlmZm Z m Z m Z m Z m Z mZmZddlmZmZmZddlmZddlmZmZmZmZmZmZdd lmZd ZGd d Z Gd de Z!y)z"Converting MySQL and Python types N)Decimal)AnyCallableDictListOptionalSetTupleUnion) CharacterSet FieldFlag FieldType) HexLiteral)DescriptionTypeRowType StrOrBytesToMysqlInputTypesToMysqlOutputTypesToPythonOutputTypes) NUMERIC_TYPESz.Could not convert '{value}' to python {pytype}c eZdZdZ ddeedededdfdZdeeddfdZdd eddfd Z d e de e e ffd Z d ed eedefd Ze dd edeedefdZededefdZy)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_fallbackreturnNcd|_d|_d|_d|_|j |||_||_i|_y)Nr) python_types mysql_typesr charset_id set_charsetrr_cache_field_typesselfrrrs T/var/www/html/aiagents/fe/lib/python3.12/site-packages/mysql/connector/conversion.py__init__zMySQLConverterBase.__init__>sM 8<6:&*   !!,".  c|dvrd}|||_nd|_tj|jd|_y)zSet character set)utf8mb4utf8mb3utf8Nr)rr get_charset_infor!)r%rs r&r"zMySQLConverterBase.set_charsetPsA , ,G  "DL"DL&77 EaHr(valuec||_y)zSet whether to use UnicodeN)rr%r.s r& set_unicodezMySQLConverterBase.set_unicode[s  r(c|jjj} t|d|d|}|S#t$r|cYSwxYw)!Convert Python data type to MySQL_ _to_mysql) __class____name__lowergetattrAttributeErrorr%r. type_name converteds r&to_mysqlzMySQLConverterBase.to_mysql_s\OO,,224  ,SGDAi[ :R,S-I  L s> A  A vtypec|dk(s||dtjk7ry|js\i|_tjj D]4\}} t |d|j d|j|d<6|y |j|d||S#t$rY_wxYw#t$r|cYSwxYw)!Convert MySQL data type to PythonNr r4 _to_pythonr) rBITr#descitemsr9r8r:KeyError)r%r?r.nameinfos r& to_pythonzMySQLConverterBase.to_pythonls W  58y}}3L&&&(D #'nn224  d7>$**,z:8D++DG4  = 44**584UEB B & L s$.B$ B3$ B0/B03 CCsql_modec|S)z"Escape buffer for sending to MySQLr.rKs r&escapezMySQLConverterBase.escapes  r(bufct|S)z!Quote buffer for sending to MySQLstrrPs r&quotezMySQLConverterBase.quotes 3xr()r,TF)TN)r7 __module__ __qualname____doc__rrSboolr'r"r1rr rr>rbytesrrJ staticmethodrrOrrUrMr(r&rr7s"( " #   $ I8C= IT I!!! &   *, - $-5e_ 4#'3- 3:r(rc eZdZdZ d1deedededdfdZed2de d eede fd Z ed ee e e eeefdefd Zdedefd ZdedeedefdZede de fdZede de fdZede dee fdZdede eeffdZdede eeffdZededefdZededefdZedede fdZ ed3dZ!ede"jDdefdZ#ede"jHdefdZ%ede"jLdefdZ'ede&jPdefdZ)ede"jTdefdZ+ededeefdZ,de-ed fd!e.ede/fd"Z0ed2ded#eede fd$Z1e1Z2ed2ded#eede fd%Z3e3Z4e3Z5e3Z6e3Z7e3Z8 d2ded#eedefd&Z9e9Z:ed2ded#eedefd'Z;ed2ded(eede fd)Ze d2ded(eede"jTfd+Z?e d2ded(eedee"jDfd,Z@e@ZAed2ded(eede fd-ZB d2ded(eedeCefd.ZD d2ded(eede eEeCeffd/ZFeFZGeFZH d2ded(eede eEeCeffd0ZIeIZJeIZKeIZLy)4MySQLConverteraDefault 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). NrrrrcBtj||||i|_yrV)rr'r#r$s r&r'zMySQLConverter.__init__s% ##D'; M  r(r.rKct|ttfr|dk(r|jddS|jdd}|jdd}|jdd }|jdd }|jd d }|jd d}|St|trt|t s|dk(r|jddS|jdd}|jdd}|jdd}|jdd}|jdd}|jdd}|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. NO_BACKSLASH_ESCAPES's''\s\\ s\n s\rs\'"s\"s\'z''\z\\ z\n z\rz\'"z\"z\) isinstancer[ bytearrayreplacerSrrNs r&rOzMySQLConverter.escapes( eeY/ 011}}T511MM%1EMM%0EMM%0EMM';7EMM';7EMM';7E s #Juj,I11}}S$//MM$/EMM$.EMM$.EMM&*5EMM&*5EMM&*5E r(rPct|trt|jdSt|t dr t 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. asciiNsNULLrb)rnrrSencodetyperorTs r&rUzMySQLConverter.quotesN c= )s8??7+ + c4: &W% %d*++r(c|jjj} t|d|d|}|S#t$r8|j rt |jcYStd|ddwxYw)r3r4r5zPython 'z%' cannot be converted to a MySQL typeN) r6r7r8r9r:rrSrs TypeErrorr;s r&r>zMySQLConverter.to_mysqlsOO,,224  ,SGDAi[ :R,S-I    5z((**9+%JK  s>.A?.A?r?cN|dk(r|dtjk7ry|y|js\i|_tjj D]4\}} t |d|j d|j|d<6 |j|d||S#t$rY\wxYw#t$r( |jdcYS#t$r|cYcYSwxYwt$r}t|d|dd|d}~wt$r}t|d|dd|d}~wwxYw) rArr Nr4rCutf-8 (field )) rrDr#rErFr9r8r:rGdecodeUnicodeDecodeError ValueErrorrv)r%r?r.rHrIerrs r&rJzMySQLConverter.to_pythonsI A:%(imm3 =&&&(D #'nn224  d7>$**,z:8D++DG4  B44**584UEB B &   ||G,,%    CuHU1XJa89s B Bse8E!H:Q78c A BsZ.B" B1" B.-B.1 D$;C D$ CD$C D$)C>> D$ DD$ct|S)zConvert value to intintr.s r& _int_to_mysqlzMySQLConverter._int_to_mysqls5zr(ct|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. rrs r&_long_to_mysqlzMySQLConverter._long_to_mysqls5zr(cDtj|ryt|S)zConvert value to floatN)mathisnanfloatrs r&_float_to_mysqlzMySQLConverter._float_to_mysqls ::e U|r(c$|j|S)zConvert value to string)_unicode_to_mysqlr0s r& _str_to_mysqlzMySQLConverter._str_to_mysql$s%%e,,r(c|j}|j}|dk(rd}tj|d}|j |}|tj vrd|vr t ||S|S)zConvert unicodebinaryr,rrc)rr!r r-rsslash_charsetsr)r%r.rr!encodeds r&rz MySQLConverter._unicode_to_mysql(sl,,__ h G%66w?BJ,,w' 44 4'!!%11r(c|SzConvert value to bytesrMrs r&_bytes_to_mysqlzMySQLConverter._bytes_to_mysql5s  r(ct|Sr)r[rs r&_bytearray_to_mysqlz"MySQLConverter._bytearray_to_mysql:sU|r(c|rdSdS)zConvert value to booleanr rrMrs r&_bool_to_mysqlzMySQLConverter._bool_to_mysql?sq q r(cy)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. NrMrs r&_nonetype_to_mysqlz!MySQLConverter._nonetype_to_mysqlDsr(c |jrnd}|j|j|j|j|j |j |j|jjdSd}|j|j|j|j|j |j |jjdS)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}rrz/{0:04d}-{1:02d}-{2:02d} {3:02d}:{4:02d}:{5:02d}) microsecondformatyearmonthdayhourminutesecondrs)r.fmts r&_datetime_to_mysqlz!MySQLConverter._datetime_to_mysqlOs   KC::      !!fWo @zz JJ KK II JJ LL LL   &/ r(cv|jdd|jdd|jdjdS)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-02drr)rrrrsrs r&_date_to_mysqlzMySQLConverter._date_to_mysqlos:**S!5;;s"31UYYsODKKGTTr(c|jr |jdjdS|jdjdS)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.%frrz%H:%M:%S)rstrftimersrs r&_time_to_mysqlzMySQLConverter._time_to_mysql{sA   >>-077@ @~~j)0099r(cLtjd|jdS)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:%Srr)timerrsrs r&_struct_time_to_mysqlz$MySQLConverter._struct_time_to_mysqls!}}0%8??HHr(ct|jdz|jz}|jr3d}|jdkrd|jz }|dz}n|j}nd}|jdkrd|z}t |d\}}t |d \}}|jr|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. iQz{0:02d}:{1:02d}:{2:02d}.{3:06d}ri@Br z{0:02d}:{1:02d}:{2:02d}ri<rr)absdaysseconds microsecondsdivmodrrs) r.rrmcshours remainderminssecsresults r&_timedelta_to_mysqlz"MySQLConverter._timedelta_to_mysqlsejj5(5==89   3CzzA~ 2 221 ((+C ::>)C#GT2 i, t   ZZtT37FZZtT2F}}W%%r(cXt|trt|jdSy)z Converts a decimal.Decimal instance to a string suitable for MySQL. Returns a bytes or None when not valid. rrN)rnrrSrsrs r&_decimal_to_mysqlz MySQLConverter._decimal_to_mysqls& eW %u:$$W- -r(row.fieldscd}dgt|z}|js\i|_tjj D]4\}} t |d|j d|j|d<6|D]O}|d}||dk(r|tjk7s|||dz }. |j||||||<|dz }Qt|S#t$rYwxYw#t$r3 ||jd||<n#t$r ||||<YnwxYwY\ttf$r} | d|dd| _d} ~ wwxYw) 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. rNr4rCr rxryrz)lenr#rrErFr9r8r:rDrGr{r|r}rvmessagetuple) r%rrirrHrIfield field_typer~s r& row_to_pythonzMySQLConverter.row_to_pythons -1FS[,@&&&(D #'nn224  d7>$**,z:8D++DG4  EqJA! imm ;AQ ?D33J?ANq  FA+ .V}7& '' #A g 6F1I)' #AF1I' * !$XeAhZq9  sT .C+C( C%$C%( E2D  E DEDE#E1EErEct|S)z. Returns value as float type. )rr.rEs r&_float_to_pythonzMySQLConverter._float_to_pythons U|r(ct|S)z, Returns value as int type. rrs r&_int_to_pythonzMySQLConverter._int_to_python 5zr(cN|j|j}t|S)z5 Returns value as a decimal.Decimal. )r{rr)r%r.rEvals r&_decimal_to_pythonz!MySQLConverter._decimal_to_python s ll4<<(s|r(ct|S)z, Returns value as str type. rRrs r&_strzMySQLConverter._strrr(dscc|}t|dkrddt|z z|z}ttjd|dS)z!Returns BIT columntype as integerrBz>Qr)rrstructunpack)r.rint_vals r&_bit_to_pythonzMySQLConverter._bit_to_pythonsH wtE{m1MNTW W Xs  616cd}|j|j}|s tS t|jd}|S#t$r}t dt |d|d}~wwxYw)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)r{rsetrr}r)r%r.rset_typerr~s r&_set_to_pythonzMySQLConverter._set_to_pythonsull4<<(5L 399S>*H   (e ^D  sA A.A))A.c|jdk(r|S|o|dtjk(r'|jr|j |jS|dt j zr|j||S|ddk(r|St|ttfr(|jr |j |jS|S#t$r|cYSwxYw)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. rr r?) rrJSONrr{rSETrrnr[ror|r%r.rs r&_string_to_pythonz MySQLConverter._string_to_pythons <<8 #L ?1v'D,<,<||DLL111v %**5#661v| eeY/ 0T5E5E ||DLL11 &   s&C CCc|?|dtjzr)|dtjzr|ddk(r t|S|j ||S)z!Convert BLOB data type to Python.r rr )rBLOBBINARYr[rr s r&_blob_to_pythonzMySQLConverter._blob_to_pythonsS ?A'FY---FbLU|#%%eS11r()NTFrV)r.NrN)Mr7rWrXrYrrSrZr'r\rrOr rrrrr[rUrrr>rrrJrrrrrrrorrrrrrrrr struct_timerrrrr rrrr_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_pythonrr rrr_var_string_to_python_json_to_pythonr_long_blob_to_python_medium_blob_to_python_tiny_blob_to_pythonrMr(r&r^r^s "& " #     cXc]c8 ,8E%gz5"HIJ ,u , , / 4F #B#B#B  #BJSSccu% -3-5 1B+C- s uUJ5F/G u9!d!s!!("3"3> Uhmm U U U :hmm : : :IT%5%5I%II&8#5#5&%&&@  Xe_  0$0.2?.C0 0fXo-FRW )e8O+DPS %O%%$O(?C"*?"; /E/!:c 4e4(?*C4s447;#O4 (-- 0)7;!!#O4!   !!F7;,,#O4, (## $,,\/u8O+DPS>B!)/!: S.>B!)/!: z3s8# $6.'O>B 2 2!)/!: 2 z3s8# $ 2+,*r(r^)"rYrrrrdecimalrtypingrrrrrr r r constantsr rr custom_typesrtypesrrrrrrutilsrrrr^rMr(r&r(s]: III99$!@ ZZzO +'O +r(