ó Ñs/Uc@sÛddlZddlZddlZddlZddlmZmZddlmZej ddkZ ye WnIe k r¼yddl mZ Wq½ek r¸ddl mZ q½XnXejdƒZid d 6d d 6d d6dd6dd6dd6dd6Zd„Zd„Zd„Zd„Zd„Zd„Zd„ZeZd„Zd„Zd „Zd!„Zd"„Z d#„Z!d$„Z"d%„Z#d&„Z$d'„Z%d(„Z&d)„Z'd*„Z(d+„Z)d,„Z*d-„Z+d.„Z,d/„Z-d0„Z.d1„Z/iee06ee16ee26ee36ee46ee56ee66ee76ee 6ee86ee9dƒ6e#ej;6e"ej6e ej<6e!ej6e$ej=6Z>ie+ej?6e-ej@6e-ejA6e.ejB6e/ejC6e/ejD6e/ejE6e/ejF6e.ejG6e-ejH6e-ejI6e)ejJ6e%ejK6e&ejL6e(ejM6e*ejN6e,ejO6e,ejP6e,ejQ6e,ejR6e,ejS6e,ejT6e,ejU6ZVeVZWyJdd2lXmYZYd3„ZZeZeVejEeY5sR!(tmapR$(RR((RsJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt escape_set4scCstt|ƒƒS(N(RR(tvalue((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt escape_bool8scCs t|ƒS(N(R(R*((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt escape_object;scCs|S(N((R*((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt escape_int>scCsd|S(Ns%.15g((R*((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt escape_floatCscCsdtjd„|ƒS(Ns'%s'cSstj|jdƒƒS(Ni(t ESCAPE_MAPtgettgroup(tmatch((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyR'Hs(t ESCAPE_REGEXtsub(R*((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt escape_stringFs cCs t|ƒS(N(R5(R*((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pytescape_unicodeJscCsdS(NtNULL((R*((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt escape_NoneMscCsit|jƒd}t|jdƒd}t|jdƒdt|jƒd}td|||fƒS(Ni<iis%02d:%02d:%02d(RtsecondstdaysR5(tobjR9tminutesthours((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pytescape_timedeltaPs(cCsUdt|jƒt|jƒt|jƒf}|jrK|d|j7}nt|ƒS(Ns%02d:%02d:%02ds.%f(Rthourtminutetsecondt microsecondR5(R;ts((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt escape_timeVs  cCst|jdƒƒS(Ns%Y-%m-%d %H:%M:%S(R5tstrftime(R;((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pytescape_datetime^scCst|jdƒƒS(Ns%Y-%m-%d(R5RE(R;((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt escape_dateascCsttj|d ŒƒS(Ni(RFtdatetime(R;((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pytescape_struct_timedscCsÛt|tƒs$|j|jƒ}nd|kr9d}n%d|krNd}nt|||ƒSyX|j|dƒ\}}tjg|jdƒ|jdƒD]}t|ƒ^qœŒSWntk rÖt|||ƒSXdS(sÂReturns a DATETIME or TIMESTAMP column value as a datetime object: >>> datetime_or_None('2007-02-25 23:06:20') datetime.datetime(2007, 2, 25, 23, 6, 20) >>> datetime_or_None('2007-02-25T23:06:20') datetime.datetime(2007, 2, 25, 23, 6, 20) Illegal values are returned as None: >>> datetime_or_None('2007-02-31T23:06:20') is None True >>> datetime_or_None('0000-00-00 00:00:00') is None True t tTit-t:N( RRRRt convert_datetsplitRHRt ValueError(t connectiontfieldR;tseptymdthmsR&((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pytconvert_datetimegs    @ c CsÉy°d}t|tƒs-|j|jƒ}nd|kr]|jdƒ\}}t|ƒ}n|jdƒ\}}}tjdt|ƒdt|ƒdt|ƒd|ƒ}|SWntk rÄdSXdS( séReturns a TIME column as a timedelta object: >>> timedelta_or_None('25:06:17') datetime.timedelta(1, 3977) >>> timedelta_or_None('-25:06:17') datetime.timedelta(-2, 83177) Illegal values are returned as None: >>> timedelta_or_None('random crap') is None True Note that MySQL always returns TIME columns as (+|-)HH:MM:SS, but can accept values as (+|-)DD HH:MM:SS. The latter format will not be parsed correctly by this function. it.RMR=R<R9t microsecondsN( RRRRRORRHt timedeltaRPtNone( RQRRR;RXttailR=R<R9ttdelta((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pytconvert_timedelta†s        c CsŸy†d}d|kr9|jdƒ\}}t|ƒ}n|jdƒ\}}}tjdt|ƒdt|ƒdt|ƒd|ƒSWntk ršdSXdS( sÐReturns a TIME column as a time object: >>> time_or_None('15:06:17') datetime.time(15, 6, 17) Illegal values are returned as None: >>> time_or_None('-25:06:17') is None True >>> time_or_None('random crap') is None True Note that MySQL always returns TIME columns as (+|-)HH:MM:SS, but can accept values as (+|-)DD HH:MM:SS. The latter format will not be parsed correctly by this function. Also note that MySQL's TIME column corresponds more closely to Python's timedelta and not time. However if you want TIME columns to be treated as time-of-day and not a time offset, then you can use set this function as the converter for FIELD_TYPE.TIME. iRWRMR?R@RARBN(RORRHttimeRPRZ(RQRRR;RXR[R=R<R9((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt convert_time©s ! cCssyZt|tƒs'|j|jƒ}ntjg|jddƒD]}t|ƒ^q@ŒSWntk rndSXdS(sReturns a DATE column as a date object: >>> date_or_None('2007-02-26') datetime.date(2007, 2, 26) Illegal values are returned as None: >>> date_or_None('2007-02-31') is None True >>> date_or_None('0000-00-00') is None True RLiN( RRRRRHtdateRORRPRZ(RQRRR;R&((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyRNÊs 6 c Cs t|tƒs$|j|jƒ}n|ddkrDt|||ƒS|ddt|ƒ7}t|d ƒt|dd!ƒt|dd!ƒt|dd!ƒt|dd!ƒt|dd!ƒf\}}}}}}y tj||||||ƒSWntk rd SXd S( s@Convert a MySQL TIMESTAMP to a Timestamp object. MySQL >= 4.1 returns TIMESTAMP in the same format as DATETIME: >>> mysql_timestamp_converter('2007-02-25 22:32:17') datetime.datetime(2007, 2, 25, 22, 32, 17) MySQL < 4.1 uses a big string of numbers: >>> mysql_timestamp_converter('20070225223217') datetime.datetime(2007, 2, 25, 22, 32, 17) Illegal values are returned as None: >>> mysql_timestamp_converter('2007-02-31 22:32:17') is None True >>> mysql_timestamp_converter('00000000000000') is None True iRLt0iiii i N( RRRRRVtlenRRHRPRZ( RQRRt timestamptyeartmonthtdayR?R@RA((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pytconvert_mysql_timestampßs-H  cCst|jdƒƒS(NR!(R RO(RC((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt convert_setscCs|S(N((RQRRtb((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt convert_bitscCs›t|jƒj}|jtj@r5t|j|ƒƒS|jtj@rI|S|j rd|j|ƒ}n3|j |kr—|j|ƒ}|j |j ƒ}n|S(N( Rt charsetnrtnametflagsRtSETRhRtBINARYt use_unicodeRR(RQRRtdatat field_charset((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pytconvert_characters s cCs t|ƒS(N(R(RQRRRq((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt convert_intscCs t|ƒS(N(tlong(RQRRRq((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt convert_longscCs t|ƒS(N(tfloat(RQRRRq((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyt convert_float!s(tDecimalcCs|j|jƒ}t|ƒS(N(RRRy(RQRRRq((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pytconvert_decimalYscCs t|ƒS(N(R(R;((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pytescape_decimal_s(\treRHR^tsyst constantsRRRRt version_infoRR t NameErrortsetsRt ImportErrorRtcompileR3R/RRR R)R+R,R-t escape_longR.R5R6R8R>RDRFRGRIRVR]R_RNRgRhRjRsRtRvRxtboolRRuRwRRR R R RRZR`RYt struct_timeRtBITtTINYtSHORTtLONGtFLOATtDOUBLEtDECIMALt NEWDECIMALtLONGLONGtINT24tYEARt TIMESTAMPtDATETIMEtTIMEtDATERntBLOBt TINY_BLOBt MEDIUM_BLOBt LONG_BLOBtSTRINGt VAR_STRINGtVARCHARtdecoderst conversionstdecimalRyRzR{(((sJ/var/www/c4bv.valis/web2py-ge-R-2.10.3/gluon/contrib/pymysql/converters.pyts¾                        # !  #