Why Gemfury? Push, build, and install  RubyGems npm packages Python packages Maven artifacts PHP packages Go Modules Debian packages RPM packages NuGet packages

Repository URL to install this package:

Details    
contego / home / tvault / .virtenv / lib / python2.7 / site-packages / pymysql / converters.pyc
Size: Mime:
ó
‡ƛYc@s›ddlmZmZmZmZmZmZddlZddlm	Z	ddl
Z
ddlZddlm
Z
mZddlmZmZdd„Zdd„Zdd	„Zdd
„Zdd„Zdd„Zdd
„Zdd„ZgedƒD]Zeeƒ^qûZded<deedƒ<deedƒ<deedƒ<deedƒ<deedƒ<deedƒ<dd„Zerªdd„Z dd „Z!n>eZ eged!d"ƒD]Z"e#e"ƒ^qÃZ$dd#„Z!dd$„Z%dd%„Z&dd&„Z'dd'„Z(dd(„Z)dd)„Z*dd*„Z+dd+„Z,d,„Z-e
j.d-ƒZ/d.„Z0e
j.d/ƒZ1d0„Z2e
j.d1ƒZ3d2„Z4d3„Z5d4„Z6d5„Z7d6„Z8e8Z9d7„Z:iee;6ee<6ee6ee=6e&e>6e%e6ee?6ee@6eeA6eeB6eeC6e!eD6e'eEdƒ6e+ejF6e*ej6e(ejG6e)ej6e,ejH6ee	6ZIeseserŒe!eIeJ<nie9e
jK6e<e
jL6e<e
jM6e<e
jN6e=e
jO6e=e
jP6e<e
jQ6e<e
jR6e<e
jS6e6e
jT6e0e
jU6e2e
jV6e5e
jW6e7e
jX6e8e
jY6e8e
jZ6e8e
j[6e8e
j\6e8e
j]6e8e
j^6e8e
j_6e	e
j`6e	e
ja6ZbeIjcƒZdedjeebƒe&ZfdS(8i(tPY2t	text_typet	long_typetJYTHONt
IRONPYTHONtunichriÿÿÿÿN(tDecimal(t
FIELD_TYPEtFLAG(t
charset_by_idtcharset_to_encodingcCs›|dkrt}n|jt|ƒƒ}|say|t}Wqatk
r]tdƒ‚qaXn|ttfkrˆ||||ƒ}n|||ƒ}|S(Ns!no default type converter defined(	tNonetencoderstgetttypeRtKeyErrort	TypeErrortescape_dicttescape_sequence(tvaltcharsettmappingtencoder((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytescape_items	
cCsCi}x6|jƒD](\}}t|||ƒ}|||<qW|S(N(titemsR(RRRtntktvtquoted((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pyRs
cCsKg}x-|D]%}t|||ƒ}|j|ƒq
Wddj|ƒdS(Nt(t,t)(Rtappendtjoin(RRRRtitemR((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pyR%s

cCs,djg|D]}t|||ƒ^q
ƒS(NR(R!R(RRRtx((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pyt
escape_set,scCstt|ƒƒS(N(tstrtint(tvalueR((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytescape_bool/scCs
t|ƒS(N(R%(R'R((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pyt
escape_object2scCs
t|ƒS(N(R%(R'R((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pyt
escape_int5scCsd|S(Ns%.15g((R'R((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytescape_float8si€u\0iu\\s\u\ns
u\rs
u\Zsu\"t"u\'t'cCs
|jtƒS(sGescapes *value* without adding quote.

    Value should be unicode
    (t	translatet
_escape_table(R'R((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pyt_escape_unicodeDscCs¶t|tƒrt|ƒSt|ttfƒs4t‚|jddƒ}|jddƒ}|jddƒ}|jddƒ}|jd	d
ƒ}|jddƒ}|jd
dƒ}|S(srescape_string escapes *value* but not surround it with quotes.

        Value should be bytes or unicode.
        s\s\\ts\0s
s\ns
s\rss\ZR-s\'R,s\"(t
isinstancetunicodeR0tbytest	bytearraytAssertionErrortreplace(R'R((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pyt
escape_stringLs
cCs)t|ttfƒst‚dt|ƒS(Ns_binary'%s'(R2R4R5R6R8(R'R((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytescape_bytes]si€ÜiÝcCsd|jdƒjtƒS(Ns_binary'%s'tlatin1(tdecodeR.t_escape_bytes_table(R'R((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pyR9iscCsdt|ƒS(Nu'%s'(R0(R'R((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytescape_unicodemscCsdtt|ƒ|ƒS(Ns'%s'(R8R%(R'R((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pyt
escape_strpscCsdS(NtNULL((R'R((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytescape_NonesscCsƒt|jƒd}t|jdƒd}t|jdƒdt|jƒd}|jrdd}nd}|j||||jƒS(Ni<iis!'{0:02d}:{1:02d}:{2:02d}.{3:06d}'s'{0:02d}:{1:02d}:{2:02d}'(R&tsecondstdaystmicrosecondstformat(tobjRRAtminutesthourstfmt((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytescape_timedeltavs(		cCs%|jrd}nd}|j|ƒS(Ns<'{0.hour:02}:{0.minute:02}:{0.second:02}.{0.microsecond:06}'s)'{0.hour:02}:{0.minute:02}:{0.second:02}'(tmicrosecondRD(RERRH((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytescape_time€s		cCs%|jrd}nd}|j|ƒS(Ns`'{0.year:04}-{0.month:02}-{0.day:02} {0.hour:02}:{0.minute:02}:{0.second:02}.{0.microsecond:06}'sM'{0.year:04}-{0.month:02}-{0.day:02} {0.hour:02}:{0.minute:02}:{0.second:02}'(RJRD(RERRH((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytescape_datetime‡s		cCsd}|j|ƒS(Ns%'{0.year:04}-{0.month:02}-{0.day:02}'(RD(RERRH((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytescape_dateŽscCsttj|d ŒƒS(Ni(RLtdatetime(RER((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytescape_struct_time’scCs*|s
dS|jddƒ}t|d ƒS(Niit0(tljustR&(ts((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pyt_convert_second_fraction•ssM(\d{1,4})-(\d{1,2})-(\d{1,2})[T ](\d{1,2}):(\d{1,2}):(\d{1,2})(?:.(\d{1,6}))?cCs¼tr.t|ttfƒr.|jdƒ}ntj|ƒ}|sMt|ƒSyPt|j	ƒƒ}t
|dƒ|d<tjg|D]}t|ƒ^qƒŒSWnt
k
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

    tasciiiÿÿÿÿN(RR2R4R5R;tDATETIME_REtmatchtconvert_datetlisttgroupsRSRNR&t
ValueError(REtmRYR#((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytconvert_datetimeŸs
*
s0(-)?(\d{1,3}):(\d{1,2}):(\d{1,2})(?:.(\d{1,6}))?c	Csútr.t|ttfƒr.|jdƒ}ntj|ƒ}|sGd	Syšt|j	ƒƒ}t
|dƒ|d<|dr€dnd}|d\}}}}tjdt
|ƒdt
|ƒdt
|ƒdt
|ƒƒ|}|SWntk
rõd	SXd	S(
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.
    RTiÿÿÿÿiiRGRFRARCN(RR2R4R5R;tTIMEDELTA_RERVRRXRYRSRNt	timedeltaR&RZ(	RER[RYtnegateRGRFRARCttdelta((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytconvert_timedeltaÀs&	
s,(\d{1,2}):(\d{1,2}):(\d{1,2})(?:.(\d{1,6}))?cCsÖtr.t|ttfƒr.|jdƒ}ntj|ƒ}|sGdSyvt|j	ƒƒ}t
|dƒ|d<|\}}}}tjdt
|ƒdt
|ƒdt
|ƒdt
|ƒƒ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.
    RTiÿÿÿÿthourtminutetsecondRJN(RR2R4R5R;tTIME_RERVRRXRYRSRNttimeR&RZ(RER[RYRGRFRARC((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytconvert_timeës!
cCs}tr.t|ttfƒr.|jdƒ}ny6tjg|jddƒD]}t|ƒ^qJŒSWnt	k
rxdSXdS(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

    RTt-iN(RR2R4R5R;RNtdatetsplitR&RZR(RER#((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pyRWs6
c
Cstr.t|ttfƒr.|jdƒ}n|ddkrHt|ƒS|ddt|ƒ7}t|d ƒt|dd!ƒt|dd!ƒt|dd!ƒt|dd	!ƒt|d	d!ƒf\}}}}}}y tj||||||ƒSWnt	k
r	d
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

    RTiRhRPiiii
iN(RR2R4R5R;R\tlenR&RNRZR(t	timestamptyeartmonthtdayRbRcRd((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytconvert_mysql_timestamp(s
-H 
cCs;t|ttfƒr(t|jdƒƒSt|jdƒƒS(NR(R2R4R5tsetRj(RR((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytconvert_setJscCs|S(N((R#((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytthroughPscCs§t|jƒj}t|ƒ}|jtj@rAt|j|ƒƒS|jtj	@rU|S|j
rp|j|ƒ}n3|j|kr£|j|ƒ}|j|j
ƒ}n|S(N(R	t	charsetnrtnameR
tflagsRtSETRrR;tBINARYtuse_unicodeRtencodetencoding(t
connectiontfieldtdatat
field_charsetR{((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pytconvert_characters]s	(gt_compatRRRRRRRNtdecimalRtreRft	constantsRRRR	R
RRRRR$R(R)R*R+trangeR#R/tordR0R8R9titchrR<R=R>R@RIRKRLRMRORStcompileRUR\R]RaReRgRWRpRrRstconvert_bitR€tboolR&tfloatR%ttupleRXRqt	frozensettdictR5RRiR^tstruct_timeRR4tBITtTINYtSHORTtLONGtFLOATtDOUBLEtLONGLONGtINT24tYEARt	TIMESTAMPtDATETIMEtTIMEtDATERwtBLOBt	TINY_BLOBtMEDIUM_BLOBt	LONG_BLOBtSTRINGt
VAR_STRINGtVARCHARtDECIMALt
NEWDECIMALtdecoderstcopytconversionstupdatet
Thing2Literal(((sG/home/tvault/.virtenv/lib/python2.7/site-packages/pymysql/converters.pyt<module>sÆ.%
,
			(	'		"