3 dec@sdZddlZddlZddlZddlZddlmZddlmZm Z m Z m Z m Z m Z mZmZddlmZmZmZddlmZddlmZmZmZmZmZmZdd lmZd ZGd d d Z Gd dde Z!dS)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@seZdZdZdeeeeddddZeedd d d Zdedd d dZ e e e e fd ddZ eeeedddZedeeeedddZeeedddZdS)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_fallbackreturncCs8d|_d|_d|_d|_|j|||_||_i|_dS)Nr)Z python_typesZ mysql_typesr charset_id set_charsetrr_cache_field_types)selfrrrr!Q/var/www/agendate/envp3/lib/python3.6/site-packages/mysql/connector/conversion.py__init__>s zMySQLConverterBase.__init__)rrcCs8|dkr d}|dk r||_nd|_tj|jd|_dS)zSet character setutf8mb4utf8mb3rNr)r$r%)rr get_charset_infor)r rr!r!r"rPs zMySQLConverterBase.set_charset)valuercCs ||_dS)zSet whether to use UnicodeN)r)r r'r!r!r" set_unicode[szMySQLConverterBase.set_unicodec Cs@|jjj}yt|d|d|}|Stk r:|SXdS)z!Convert Python data type to MySQL_ _to_mysqlN) __class____name__lowergetattrAttributeError)r r' type_name convertedr!r!r"to_mysql_s zMySQLConverterBase.to_mysql)vtyper'rc Cs|dks|dkr"|dtjkr"dS|jsi|_xPtjjD]B\}}y$t|d|jd|j|d<Wq:tk rzYq:Xq:W|dkrdSy|j|d||Stk r|SXdS)z!Convert MySQL data type to PythonNr r) _to_pythonr) rBITrdescitemsr.r-r/KeyError)r r3r'nameinfor!r!r" to_pythonls " zMySQLConverterBase.to_python)r'sql_modercCs|S)z"Escape buffer for sending to MySQLr!)r'r=r!r!r"escapeszMySQLConverterBase.escape)bufrcCst|S)z!Quote buffer for sending to MySQL)str)r?r!r!r"quoteszMySQLConverterBase.quote)rTF)T)N)r, __module__ __qualname____doc__rr@boolr#rr(rr rr2rbytesrr< staticmethodrr>rrAr!r!r!r"r7s      rc@seZdZdZdPeeeeddddZedQe eee dd d Z eee e e eeefed d d ZeedddZeeeedddZee e dddZee e dddZee ee dddZee eefdddZee eefdddZeeedddZeeedd d!Zeee 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+eeeedd0d1Z,e-ed2fe.ee/d3d4d5Z0edReeee d6d7d8Z1e1Z2edSeeee d6d9d:Z3e3Z4e3Z5e3Z6e3Z7e3Z8dTeeeed6d;d<Z9e9Z:edUeeeed6d=d>Z;edVeeee d?d@dAZedXeeee"j*d?dDdEZ?edYeeeee"j"d?dFdGZ@e@ZAedZeeee d?dHdIZBd[eeeeCed?dJdKZDd\eeee eEeCefd?dLdMZFeFZGeFZHd]eeee eEeCefd?dNdOZIeIZJeIZKeIZLdS)^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). NTF)rrrrcCstj||||i|_dS)N)rr#r)r rrrr!r!r"r#szMySQLConverter.__init__)r'r=rcCst|ttfrl|dkr"|jddS|jdd}|jdd}|jdd }|jdd }|jd d }|jd d}nrt|trt|t r|dkr|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. ZNO_BACKSLASH_ESCAPES's''\s\\ s\n s\rs\'"s\"s\'z''\z\\ z\n z\rz\'"z\"z\) isinstancerF bytearrayreplacer@r)r'r=r!r!r"r>s&              zMySQLConverter.escape)r?rcCs>t|trt|jdSt|tdr.tdStd|dS)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. asciiNsNULLrI)rUrr@encodetyperV)r?r!r!r"rAs zMySQLConverter.quote)r'rc Csd|jjj}yt|d|d|}|Stk r^|jrHt|jStd|ddYnXdS)z!Convert Python data type to MySQLr)r*zPython 'z%' cannot be converted to a MySQL typeN) r+r,r-r.r/rr@rY TypeError)r r'r0r1r!r!r"r2s   zMySQLConverter.to_mysql)r3r'rcCsJ|dkr|dtjkrdS|dkr&dS|jsi|_xPtjjD]B\}}y$t|d|jd|j|d<Wq>tk r~Yq>Xq>Wy|j|d||Stk ry |j dSt k r|SXYnzt k r}z t |d|dd|WYdd}~Xn>t k rD}z t |d|dd|WYdd}~XnXdS) z!Convert MySQL data type to Pythonrr Nr)r5zutf-8z (field )) rr6rr7r8r.r-r/r9decodeUnicodeDecodeError ValueErrorr[)r r3r'r:r;errr!r!r"r<s."   *zMySQLConverter.to_pythoncCst|S)zConvert value to int)int)r'r!r!r" _int_to_mysqlszMySQLConverter._int_to_mysqlcCst|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. )ra)r'r!r!r"_long_to_mysqlszMySQLConverter._long_to_mysqlcCstj|rdSt|S)zConvert value to floatN)mathisnanfloat)r'r!r!r"_float_to_mysqls zMySQLConverter._float_to_mysqlcCs |j|S)zConvert value to string)_unicode_to_mysql)r r'r!r!r" _str_to_mysql$szMySQLConverter._str_to_mysqlcCsP|j}|j}|dkr&d}tj|d}|j|}|tjkrLd|krLt||S|S)zConvert unicodebinaryrrrJ)rrr r&rYZslash_charsetsr)r r'rrencodedr!r!r"rh(s   z MySQLConverter._unicode_to_mysqlcCs|S)zConvert value to bytesr!)r'r!r!r"_bytes_to_mysql5szMySQLConverter._bytes_to_mysqlcCst|S)zConvert value to bytes)rF)r'r!r!r"_bytearray_to_mysql:sz"MySQLConverter._bytearray_to_mysqlcCs |rdSdS)zConvert value to booleanr rr!)r'r!r!r"_bool_to_mysql?szMySQLConverter._bool_to_mysqlcCsdS)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!)r'r!r!r"_nonetype_to_mysqlDs z!MySQLConverter._nonetype_to_mysqlcCs^|jr4d}|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}rXz/{0:04d}-{1:02d}-{2:02d} {3:02d}:{4:02d}:{5:02d}) microsecondformatyearmonthdayhourminutesecondrY)r'fmtr!r!r"_datetime_to_mysqlOs( z!MySQLConverter._datetime_to_mysqlcCs&|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. Z04d-Z02drX)rrrsrtrY)r'r!r!r"_date_to_mysqlos zMySQLConverter._date_to_mysqlcCs&|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.%frXz%H:%M:%S)rpstrftimerY)r'r!r!r"_time_to_mysql{s zMySQLConverter._time_to_mysqlcCstjd|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:%SrX)timer|rY)r'r!r!r"_struct_time_to_mysqls z$MySQLConverter._struct_time_to_mysqlc Cst|jd|j}|jrDd}|jdkrQr)rrastructunpack)r'rZint_valr!r!r"_bit_to_pythons zMySQLConverter._bit_to_pythoncCst|tjr|Syn|jd}t|dkr@td|dt|y&tjt|dt|dt|dStk rzdSXWn.ttfk rtd t|d dYnXdS) zConverts 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. -zinvalid datetime format: z len: rr NzCould not convert z to python datetime.timedelta) rUdatetimedatesplitrr_ra IndexErrorrepr)r'rpartsr!r!r"_date_to_python%s   & zMySQLConverter._date_to_pythoncCsd}y"|jd\}}t|jdd}Wn ttfk rF|}d}YnXyZdd|jdD\}}}|dd ks||dd kr| | | }}}tj||||d Stttfk rttj |d d dYnXdS)aConverts 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.0rcSsg|] }t|qSr!)ra).0dr!r!r" Usz2MySQLConverter._time_to_python..:-rz)rminutesrrzdatetime.timedelta)r'pytype) rraljustr[r_r timedeltar CONVERT_ERRORrq)r'rrhmsrrrr!r!r"_time_to_python@s&  zMySQLConverter._time_to_pythoncCst|tjr|Sd}d}y|jd\}}t|dkrT|jd\}}t|jdd}n|}d}dd |jd Dd d |jd D|g}t|dkrtd |dt|ytj|}Wntk rdSXWn.ttfk rtt j |dddYnX|S)zConverts 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 rrrrrcSsg|] }t|qSr!)ra)rrr!r!r"r|sz6MySQLConverter._datetime_to_python..rcSsg|] }t|qSr!)ra)rrr!r!r"r}srzinvalid datetime format: z len: zdatetime.timedelta)r'r) rUrrrrarr_rr[rrq)r'rZ datetime_valrZdate_Ztime_rZdtvalr!r!r"_datetime_to_pythonds0  &   z"MySQLConverter._datetime_to_pythoncCsJy t|}Wn8tk rD}ztdt|d|WYdd}~XnX|S)z#Returns YEAR column type as integerzFailed converting YEAR to int (r\N)rar_r)r'rrrr`r!r!r"_year_to_pythons  (zMySQLConverter._year_to_pythoncCsjd}|j|j}|stSyt|jd}Wn8tk rd}ztdt|d|WYdd}~XnX|S)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`r!r!r"_set_to_pythons  zMySQLConverter._set_to_pythonc Cs|jdkr|S|dk r`|dtjkr6|jr6|j|jS|dtj@rP|j||S|ddkr`|St|t t fr|jry |j|jSt k r|SX|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. rjNr r?) rrZJSONrr]r ZSETrrUrFrVr^)r r'rr!r!r"_string_to_pythons     z MySQLConverter._string_to_pythoncCsD|dk r8|dtj@r8|dtj@r8|ddkr8t|S|j||S)z!Convert BLOB data type to Python.Nrrr)r ZBLOBBINARYrFr)r r'rr!r!r"_blob_to_pythons  zMySQLConverter._blob_to_python)NTF)N)N)N)N)N)N)N)N)N)N)N)N)N)Mr,rBrCrDrr@rEr#rGrr>r rfrarrrFrArrr2rrr<rbrcrgrirhrlrVrmrnrorryrr{r~r} struct_timerrrrr rrrrZ_double_to_pythonrZ_tiny_to_pythonZ_short_to_pythonZ_int24_to_pythonZ_long_to_pythonZ_longlong_to_pythonrZ_newdecimal_to_pythonrrrZ_NEWDATE_to_pythonrrZ_timestamp_to_pythonrrrrrZ_var_string_to_pythonZ_json_to_pythonrZ_long_blob_to_pythonZ_medium_blob_to_pythonZ_tiny_blob_to_pythonr!r!r!r"rHs  $!       1   ! ,    rH)"rDrrdrr~decimalrtypingrrrrrrr r constantsr r rZ custom_typesrtypesrrrrrrutilsrrrrHr!r!r!r"s (   ]