ÿØÿà JFIF 

  
 
  ÿÛ „ 	 ( %"1!%)+...383,7(-.+




-+++--++++---+-+-----+---------------+---+-++7-----ÿÀ  ß â
" 

ÿÄ   

           
 ÿÄ H 
     
 !1AQaq"‘¡2B±ÁÑð#R“Ò Tbr‚²á3csƒ’ÂñDS¢³$CÿÄ 
 


            
ÿÄ %

 
       
!1AQa"23‘ÿÚ 
  ? ôÿ ¨pŸªáÿ —åYõõ\?àÒü©ŠÄï¨pŸªáÿ —åYõõ\?àÓü©ŠÄá 0Ÿªáÿ Ÿå[úƒ	ú®ði~TÁb
qÐ8OÕpÿ ƒOò¤Oè`–RÂáœá™êi€ßÉ< FtŸI“öÌ8úDf´°å}“¾œ6
öFá°y¥jñÇh†ˆ¢ã/ÃÐ:ªcÈ
"Y¡ðÑl>ÿ ”ÏËte:qž\oäŠe÷󲍷˜HT4&ÿ ÓÐü6ö®¿øþßèô	Ÿ•7Ñi’•j|“ñì>b…þS?*Óôÿ ÓÐü*h¥£ír¶ü UãSç‚Ÿ[AÐaè[ûª•õ&õj?†Éö+EzP—WeÒírJFt	‘BŒ†Ï‡%#tE Øz ¥OÛ«!1›üä±Í™%º<!vB™'èÔ6´Ña¿«e`Àà0U[-ÂБ4)M÷YK*³hï÷%ÎÎkÇ«m‘-íWŽLsã?nÂ~«†üö®þ¡ÂlÃaÿ ‰ÿ l©°Õ¥ åÜá¿r ºL[Çâ°(Çè'Vãôl8´ÏRÀvLvPõ:…ÙNçF™÷ë>Íãö]°î(–:@<‹ŒÊö×òÆt¦ãº+‡¦%ÌÁ²h´OƒJŒtMÜ>ÀÜÊw3
Y´•牋4ǍýʏTì>œú=Íwhyë,¾Ôò×õ¿ßÊa»«þˆѪQ|%6ž™A	õ%:øj<>É—ÿ Å_ˆCbõ¥š±ý¯Ýƒï…¶|RëócÍf溪“t.СøTÿ *Ä¿-{†çàczůŽ_–^XþŒ±miB[X±d 1,é”zEù»&
î9gœf™9Ð'.;—™i}!ôšåîqêÛ٤ёý£½ÆA–àôe"A$˝Úsäÿ 
÷Û	#°xŸëí(l
	 »ý3—¥5m!
rt`†0~'j2(]S¦¦kv,ÚÇl¦øJA£Šƒ
J3E8ÙiŽ:cÉžúeZ°€¯\®kÖ(79«Ž:¯X”¾³Š&¡* ….‰Ž(ÜíŸ2¥ª‡×Hi²TF¤ò[¨íÈRëÉ䢍mgÑ.Ÿ<öäS0í„ǹÁU´f#Vß;Õ–…P@3ío<ä-±»Ž.L|kªÀê›fÂ6@»eu‚|ÓaÞÆŸ…¨ááå>åŠ?cKü6ùTÍÆ”†sĤÚ;H2RÚ†õ\Ö·Ÿn'¾ ñ#ºI¤Å´%çÁ­‚â7›‹qT3Iï¨Ö
Ú5I7Ë!ÅOóŸ¶øÝñØôת¦$Tcö‘[«Ö³šÒ';Aþ ¸èíg
A2Z
"i¸vdÄ÷.iõ®§)¿]¤À†–‡É&ä{V¶iŽ”.Ó×Õÿ û?h¬Mt–íª[ÿ Ñÿ ÌV(í}=ibÔ¡›¥¢±b
 Lô¥‡piη_Z<‡z§èŒ)iÖwiÇ 2hÙ3·=’d÷8éŽ1¦¸c¤µ€7›7Ø	ð\á)}	¹fËí›pAÃL%âc2 í§æQz¿;T8sæ°qø)QFMð‰XŒÂ±
N¢aF¨…8¯!U		Z©RÊ ÖPVÄÀÍin™Ì-GˆªÅËŠ›•zË}º±ŽÍFò¹}Uw×#ä5B¤{î}Ð<ÙD
é©¤&‡ïDbàÁôMÁ."
¤‡ú*õ'VŽ|¼´Úgllº¼klz[Æüï÷Aób‡Eÿ dÑ»Xx9ÃÜ£ÁT/`¼¸vI±Ýµ·Ë‚“G³þ*Ÿû´r|*}<¨îºœ @¦mÄ’M¹”.œ«Y–|6ÏU¤jç¥ÕÞqO
˜kDÆÁ¨5ÿ š;Њ¦¦€GÙk \
	–Þ=â¼=SͧµªS°ÚÍpÜãQűÀõ¬?ÃÁ1Ñ•õZà?hóœ€
L¦l{Y*K˜Ù›zc˜–ˆâø+¾	­-Ök¥%ùEÜA'}ˆ><ÊIè“bpÍ/qÞâvoX€w,\úªò6Z[XdÒæ­@Ö—€$òJí#é>'°Ú
ôª˜<)4ryÙ£|óAÅn5žêŸyÒäMÝ2{"}‰–¤l÷ûWX\l¾Á¸góÉOÔ /óñB¤f¸çñ[.P˜ZsÊË*ßT܈§QN¢’¡¨§V¼(Üù*eÕ“”5T¨‹Âê¥FŒã½Dü[8'Ò¥a…Ú¶k7a
*•›¼'Ò·\8¨ª\@\õ¢¦íq+DÙrmÎ…_ªæ»ŠÓœ¡¯’Ré9MÅ×D™lælffc+ŒÑ,ý™ÿ ¯þǤ=Å’Á7µ÷ÚÛ/“Ü
€ñýã¼àí¾ÕÑ+ƒ,uµMâÀÄbm:ÒÎPæ{˜Gz[ƒ¯«® KHà`ßØŠéí¯P8Aq.C‰ à€kòpj´kN¶qô€…Õ,ÜNŠª-­{Zö’æû44‰sŽè‰îVíRœÕm"
6?³D9¡ÇTíÅꋇ`4«¸ÝÁô ï’ýorqКÇZ«x4Žâéþuïf¹µö[P ,Q£éaX±`PÉÍZ ¸äYúgüAx
’6Lê‚xÝÓ*äQ
Ï’¨hÍ
=²,6ï#rÃ<¯–£»ƒ‹,–ê•€ aÛsñ'%Æ"®ÛüìBᝠHÚ3ß°©$“XnœÖ’î2ËTeûìxîß
¦å¿çÉ
ðK§þ{‘t‚Ϋ¬jéîZ[”š7L¥4VÚCE×]m¤Øy”ä4-dz£œ§¸x.*ã
ÊÊ b÷•h:©‡¦s`BTÁRû¾g⻩‹jø sF¢àJøFl‘È•Xᓁà~*j¯ +(ÚÕ6-£¯÷GŠØy‚<Ç’.F‹Hœw(+)ÜÜâÈzÄäT§FߘãÏ;DmVœ3Àu@mÚüXÝü•3B¨òÌÁÛ<·ÃÜz,Ì@õÅ·d2]ü8s÷IôÞ¯^Ç9¢u„~ëAŸï4«M?
K]­ÅàPl@s_ p:°¬ZR”´›JC[CS.h‹ƒïËœ«Æ]–÷ó‚wR×k7X‰k›‘´ù¦=¡«‰¨¨Â')—71ó’c‡Ðúµ
`é.{§p¹ój\Ž{1h{o±Ý=áUÊïGÖŒõ–-BÄm+AZX¶¡
ïHðæ¥JmÙ;…ä¡Ÿˆ¦ ° äšiÉg«$üMk5¤L“’çÊvïâï	,=f“"íἊ5ô¬x6{ɏžID0e¸vçmi'︧ºð9$ò¹÷*£’9ÿ ²TÔ…×>JV¥}Œ}$p[bÔ®*[jzS*8
”·T›Í–ñUîƒwo$áè=LT™ç—~ô·¤ÈÚ$榍q‰„+´kFm)ž‹©i–ËqÞŠ‰à¶ü( ‚•§ •°ò·‡#5ª•µÊ﯅¡X¨šÁ*F#TXJÊ
ušJVÍ&=iÄs1‚3•'fý§5Ñ<=[íÞ­
PÚ;ѱÌ_~Ä££8rÞ
²w;’hDT°>ÈG¬8Á²ÚzŽ®ò®qZcqJêäÞ-ö[ܘbň±çb“Š¶31²n×iƒðÕ;1¶þÉ
ªX‰,ßqÏ$>•î íZ¥Z 1{ç൵+ƒÕµ¥°T$§K]á»Ûï*·¤tMI’ÂZbŽÕiÒ˜}bÓ0£ª5›¨[5Ž^ÝœWøÂÝh°
¢OWun£¤5 a2Z.G2³YL]jåtì”
ä	ÁÓ‘%"©<ÔúÊ°sº UZvä‡ÄiÆÒM .÷V·™ø#kèýií<NçŽôª¦„lË»{ƒ®<
[¦Y‹éƒ}j•*‚±€I‡e&gbéšp9å^!®€ö?ù^àTzo@Q¨Aêœ& [”…üÔ}пF’Hq‚©´{“ëH·?.½%úå»É Á´9¿¼Ò‰Á¼Ì¥Ús¼zW¶aÃhwÖ…ÑÏ$mò´ë:×Ñγ|”x§
µ0Âз$·aÆn µ†šÇ³£‰Ì®ž
õ@kŽ«gtí䢩ÒP×5¤?µÿ m´Ì^ ‡8¸Á8‹”žÆWÑ ¡™„,Ì“»à‹ÃéV¸®á›ÐÇŽBÀ®Ã…Z”ØÛë8;é|Ñ5)7aÕ&2Ù¸÷©ö—Ð;‡¬7"¿"7M·d
ñœÒÌf5”ê ;"Ãp5¯¬3‹ùJÚÝG›½&¯<{òñKÎÖ“3:¦ÀòGPÅS¨;
à‘Ün´öpð±W)z'¬öÀÖ#Xf2& æ
Œ‹é¾"‹\!Ñ9…
0±2A›*ØMÄ $X
끫ØXÖ,X¥ ô'ËnFÍãlqJXçuaJ4¦„ëµ7ê;h"Zã¾Áä£,vÛ‹’N©E(Öu÷)…ÁaÜÇÔkˆ$‘1kmG¨øtÛ>Ì–ª)µT[)BˆõÑ
xB¾B€ÖT¨.¥~ð@VĶr#¸ü*åZNDŽH;âi 
],©£öØpù(šºãö¼T.uCê•4@ÿ GÕÛ)Cx›®0ø#:ÏðFÒbR\(€€Ä
®fã4Þ‰Fä¯HXƒÅ,†öEÑÔÜ]Öv²?tLÃvBY£ú6Êu5ÅAQ³1‘’¬x–HŒÐ‡ ^	¸KwJôÖŽ5×CÚ¨vÜ«/B0$×k°=ðbÇ(Ï)w±A†Á†	11Í=èQšµ626ŒÜ/`G«µ<}—-Ö7KEHÈÉðóȤmݱû±·ø«Snmá=“ä«šmݱŸ¡¶~ó·“äUóJæúòB|E LêŽy´jDÔ$G¢þÐñ7óR8ýÒ…Ç›	WVe#·Ÿ	p·Fx~•ݤF÷0Èÿ K¯æS<6’¡WШ
;´ÿ ¥Êø\Òuî†åÝ–VNœkÒ7oòX¨Á­Ø÷FÎÑä±g÷ÿ M~Çî=p,X´
ÝÌÚÅ‹
’ÃjÖ.ØöÏñ
qïQ¤ÓZE†° =6·]܈ s¸>v•Ž^Ý\wq9r‰Î\¸¡kURÒ$­*‹Nq?Þª*!sŠÆ:TU_u±T+øX¡
®¹¡,ÄâÃBTsÜ$Ø›4m椴zÜK]’’›Pƒ@€#â˜`é¹=I‡fiV•Ôî“nRm+µFPOhÍ0B£
€+¬5c
v•:P'ÒyÎ ‰V~‚Ó†ÖuókDoh$å\*ö%Ю=£«…aȼ½÷Û.-½VŒŠ¼'lyî±1¬3ó#ÞE¿ÔS¤gV£m›<HqÚ,sVºóÆß¼Hïô…¹…Méi‡Ò" µùEîØÏj|ÓøVOuœ"f’aÞÞëx…˜ÌO`dHHš×4K*H$‡5×
ÚÄ
Â×CUÅAŠŒsr»2°ÄÁiÚ±Çéõe•¶_SÕÆÃ3ˆ•-3´‘¸¡‡cgDîÚ¦ÃcX}'êûJè½9ñìÓ­ä±	×ÓûçÁmO”üVÞ¸÷¥ I~“ÒôhhûýÑwxlïZ¹G¡4ž=”)º£ò
®vÆŽ%UqÝ4qž©­hûÎí‡š§é1R±cÜèðà y' °ôy¦£q§Ýï¬;šÖõ„Sÿ ›  z('S†$Ï}*evÚ¾Kýº8ý
¨å	jÛ]´-‚6«¶ÖK+8ÊiS45jrœèËQDüDØ]R”˜SPÃ
xJÕl>
=§\û"—WU¤ÚǼÿ ÂnÁ
GŒÃ
‚õN	D³õNÚíŒÕ;HôyÄÈ©P¹Ä{:?R‘Ô¨âF÷ø£bÅó® JS|‚R÷ivýáâ€Æé¡è³´IئÑT!§˜•Øª‚¬â@q€wnïCWÄ@JU€ê¯m6]Ï:£âx
'+ÒðXvÓ¦Úm=–´7œ $ì“B£~p%ÕŸUþ« N@¼üï~w˜ñø5®—'Ôe»¤5ã//€ž~‰Tþ›Å7•#¤×Íö
pÄ$ùeåì*«ÓŠEØWEÈsßg¦ûvžSsLpºÊW–âµEWöˬH;™!CYõZÃÄf æ#1W.
\uWâ\,\Çfj’<qTbên›Î[vxx£ë 'ö¨1›˜ÀM¼Pÿ H)ƒêêŒA7s,|F“꺸k³9Ìö*ç®;Ö!Ö$Eiž•¹ÒÚ†ýóéÝû¾ÕS®ó$’NÝäŸz¤5r¦ãÄÃD÷Üø!°ø‡Ô&@m™Ì^Ãä­d	q5Lnÿ N;.6½·N|#ä"1Nƒx“ã<3('&ñß
t  ~ªu”1Tb㫨9ê–›–bìd$ߣ=#ÕãÒmU¯eí$EFù5ýYô櫨æ왍Ǘ±ssM]·á¿
0ÕåJRÓªîiƒ+O58ÖñªŠÒx"	\µâá¨i’¤i
—Ö
”
M+M¤ë9‚‰A¦°Qõ¾ßøK~¼Ã‘g…Ö´~÷Ï[3GUœÒ½#…kàÔ®Ò”‰³·dWV‰IP‰Ú8u¹”E
ÖqLj¾êÕCBš{A^Âß;–¨`¯¬ìö
˼	×tìø.tƐm*n¨y4o&Àx¥n¦×î‡aupáÛj8¿m›è¶ã!o½;ß0y^ý×^EÑ¿ÒjzŒ­)vÚÑnÄL
…^ªô× ‡—‚3k	Îý­hï]içå–îÏ*÷ñþ»Ô
CÒjøjÍznˆ´
¹#b'Fô‹
‰v¥'’à'T´ƒHýÍ%M‰ ƒ&ÆÇŒï1 ‘	–Þ
‰i¬s žR-Ÿ kŠ¬á¬7:þ 0ŒÅÒÕ/aÙ¬ÃÝ#Úøœ
©aiVc‰. ¹¦ãµ”
›Yg¦›ÆÎýº°f³7ƒhá·¸­}&D9¡ÂsÉÙÞèŠõØàC™¨ñbFC|´Ü(ŸƒÚÒ-%»'a	Ì¿)ËÇn¿úÿ ÞŽX…4ÊÅH^ôΑí@ù¹Eh¶“L8Çjù
¼ÎåVªóR©Ï5uÃ
V4lZß®=€xÖŸ–ÑÈ
÷”¨°¾__yM1tÉ?uÆþIkÄgæ@þ[¢†°XÃJ£j·:nkÅ¢u‘}âGzö­/IµèŠ¬¼48q¦F°ŽR¼=ûì{´¯RýicS
ÕÛ íNtÍÙï£,w4rêì®»~x(©Uñ§#Ñ&œÕ¤>ÎåÍÓ9’Ö{9eV­[Öjâ²ãu]˜å2›qÑšÕJç0€sÄ|Êëè0튔bÁ>“{×_F`Ø©ºê:µä,v¤ðfc1±"«ÔÍän1#=·
Âøv~H<Q-Ìk7Æ;•L´©ÙC°.7
¯hKL@ävÊâž$´4¸ð‚¦­R–ÂZ7ÕÃj±·¿rÓrªJ_PÕ.#g¤gÀ)©`ª<KžèÝ'ä©èÒ3rwû€Ø¦ÒƒLf¤
,¿I½{Ƕ8‘$KÝU/Oi>½ÐßA¾¿Ü€Óš]Õ; I¾÷ç‚Qi†î¹9ywÔKG˜áñ zQY—§ÃÕZ07§X‚Áh;ÁM)iÌCH-¯T‘ë|A0{Ò½LÚ–TâÖkÜ’dÀ“rmm»”جPF³ÖcbE§T€ÒxKºû’Ó®7±²(\4ŽÃ¸Uu@j™yĵ;³µ!Á¢b.W¤=mõ´êµKk
¸K^ÜÛ#p*Ü14qkZç5ïë†°5Ï%ÍÛ<Õ¤×Ô¥ê†C	Õ´¼ú$ƒÖ“”]Ù¬qÞÚ[4©ý!ûÏ—Áb쳐XµA¬â~`›Çr¸8ìùÝ䫦<>ä÷«?xs´ÇÑ	/á;¹øüÊÈÙà{"@Žïzâ¬[âß‚ U_<ÇŸ½4èN˜ú61®qŠu ¦þF£»äJ_ˆÙÎ~ ÞAã–Ý„Ï—rŠD;xTž‘ô`É«…suãO`?³à™ô
Lý#Íc5öoæØ‚y´´÷«ZR§<&JÇ+éâô´€i!Àˆ0æAoàðLèÖ-2ŸõW.’t^–(KÁmHµV@xÜÇy®Ñø­â^:Ú3w· 7½¹°ñ¸â¹®:',«Mœ—n­Á+Ãbš
LÈ‘ÄnRÓÅœ%¦²‰¨ùQ:¤f‚ "PÕtô¸…cæl…&˜Ú˜Ôkv‹ž+vŠ,=¢v­6—X
y*¥t£«<™:“aï<QÝ&Ó]i4音äzçáíHÚÕxcòãæäÝÔm퐡 `Â)C×ehÀdHP6ÅMEöZ®Í¨	é¾Tr뢘6*¶;´sÙì]ÊŽŽÛíÉwRÈ´up* Ã	‚m´:Û{·”MUë©õ̤êÔo7:ŽÕ
qÏ'E ˆk^uãT€$Ú$Æ{•ŸBP°al¾Ž©ŒÃ^}äA
,º­$Ü]ºÚ.í:‹¤ÜöXnno7X€¥BÂà ±1ã>Œºîϲ=¦6rO]XI¿Œ÷¤zÚ­›¶ 6÷”w\dü~v®ˆÌk«^m<ÿ ¢‰Õ\)ùºŽ;… lîÙÅEŠ®cѾ@vnMÏ,¼“
ñ•ŽBxðÃzãÇç%3ˆ"}Ù•Åî>
BÉú;Ò]V+P˜F_´ßé>
Øše|ï‡ÄOmFæÇ ãqÞ$/xÐx­z`ï9"œÜij‚!7.\Td…9M‡•iŽ‹¾‘50ÞŽn¥ß4ÉôO¹*í^QêËÜÇÌ8=Ž
§s‰'ÂëÙ«á%Pú[O
†ÅP¯VsŽ°.‰,kc¶ ¬A9n˜XÎ-ÞšN["¹QÕ‰ƒMýÁߺXJæÍaLj¾×Ãmã¾ãÚ uñÒþåQô¦¥
/ÄUx:‚ÍÜ’ Đ©ØÝ3V¨‰ÕnÐ6ó*óúK­«…c ¯U òhsý­jóÔj#,ímŒRµ«lbïUTŒÑ8†Ä0œÏr`ð¡¬É	Ї
ë"À²

™	6¥ f¶¢ÚoܱԷ-<Àî)†a¶ž'Ú»¨TXqØæ¶÷Y
ÄHy˜9ÈIW­YÀuMFë
ºÏ’AqÌ4·/Ú
†ô'i$øä­=Ä
Ý|öK×40è|È6p‘0§)o¥ctî§H+CA-“ xØ|ÐXŠç
l8íºð3Ø:³¤¬KX¯UÿÙ
�
�Y:Zc
@
sdd
lm
Z

ddlmZmZmZmZmZmZ
ddl	Z	ddl
mZ
ddlZddl
Z
ddlZddlZddlZddlZddlZddlZddlmZmZmZ
ddlmZmZmZmZmZ
ddlmZ
dd	l m!Z!
dd
l"m#Z#
ddl$m%Z%m&Z&
ddlm'Z'
yddl(Z(e)Z*Wne+k
r�



e,Z(e-Z*n
Xyddl.Z.e.j/�Z0[.Wne+e1fk
r�



e,Z0n
Xe-Z2ej3d
 Z4er�
nhe4ddfkrDge5d�
D].Z6e6dkr"e7e6�
n
e7e6d�
^qZ8d�Z9n	d�Z9eoWervddl:m;Z;
d�Z<n	d�Z<e=ej>ej?ej@ejAejBejCejDejEejFg	�
ZGeejHd�ZIdZJdZKdZLdZMdZNdZOd
ddZPd�ZQd ZRd!�ZSd"�ZTd#ZUd$eVf
d%��YZWd&�ZXd'�ZYd(�ZZd)�Z[d*eVf
d+��YZ\d,e\f
d-��YZ]d.eVf
d/��YZ^d0eVf
d1��YZ_d2eVf
d3��YZ`d4eVf
d5��YZad6eVf
d7��YZbd8eVf
d9��YZcdS(:i����(
tprint_functioni
(tPY2t
range_typet	text_typetstr_typetJYTHONt
IRONPYTHONN(
tpartial(tMBLENGTHtcharset_by_namet
charset_by_id(tCLIENTtCOMMANDtCRt
FIELD_TYPEt
SERVER_STATUS(
t
converters(
tCursor(
tParser(tbyte2inttint2byte(
terriiii
i�i�c

C
s|jd
�
j
t�
S(Ntlatin1(tdecodet	translatet_surrogateescape_table(
t
s((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt_fast_surrogateescape5s
c

C
s|jd
d�S(Ntasciitsurrogateescape(
R(
R((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR8s
(
tSocketIOcC
stj
t||
��
S(
N(tiotBufferedReaderR(tsocktmode((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt	_makefileCs
cC
s
|j|
�
S(
N(
tmakefile(R!R"((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR#Gs
tsha1i�i�i�i�Ric

sH
d
��yntdt
|�
�
xFtdd�D]5}
tj|
�
}td|
|jj|jf�

q/Wtdd�

Wntk
r�


n
Xgt	dt
t
|�
d	�d
�D]}
||
|
d
!^q�}xb|D]Z}tdjtd�|��
d
d
t
|�
ddjt�f
d�|��
�

q�Wtdd�

t�
dS(Nc

S
sCd
t|�
k
odk
n
r?t
|t�r;t|�
S|SdS(NiAizt
.(Rt
isinstancetinttchr(
tdata((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytis_asciids

"




spacket length:i
iscall[%d]: %s (line %d)t
-iBii
it
 c

S
sd
jt
|�
�
S(Ns{:02X}(tformatR(
t
x((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt<lambda>uts   iR1c


sd
j�|�
�
S(Ns{}(
R.(
R/(
R+(s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR0wR1s  (
tprinttlentrangetsyst	_getframetf_codetco_nametf_linenot
ValueErrorRtmintjointmap(R*t
it
ft	dump_datat
d((
R+s7/usr/lib/python2.7/site-packages/pymysql/connections.pytdump_packetcs 
	



$




?



.
'

icC
s�|s
d
Str't
dt|�
�

nt|�
j�}t|�
j�}t�}|j|
t �

|j|�

|j�}t||�S(NR1s	password=(tDEBUGR2tstrtsha_newtdigesttupdatetSCRAMBLE_LENGTHt	_my_crypt(tpasswordtmessagetstage1tstage2Rtresult((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt	_scramble~s





	




cC
s�t|�
}d
}xjt
|�
D]\}tjd|||d!�dtjd|
||d!�dA}|tjd|�7}qW|S(NR1t
Bi
i(R3Rtstructtunpacktpack(tmessage1tmessage2tlengthRNR>R/((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRI�s




"

itRandStruct_323c
B
seZ
d�Zd
�ZRS(cC
s-d
|_|
|j|_
||j|_dS(Ni���?(t	max_valuetseed1tseed2(tselfRYRZ((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt__init__�s
	

c

C
sV|jd
|j
|j|_|j|j
d|j|_
t|j�
t|j�
S(Nii!(RYRZRXtfloat(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytmy_rnd�s


(t__name__t
__module__R\R^(((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRW�s
	cC
s2
t|�
}t|
t
 �
}tjd
|�}tjd
|�}t|d|dA|d|dA�}tj�}xJttt
t	|
�
��
D]-}|j
tt|j
�d�
d�
�

q�Wtt|j
�d�
�
}	|j�}
tj�}x1|
D])}|j
tt|�
t|	�
A�
�

q�W|j�S(Ns>LLii
ii@(t_hash_password_323tSCRAMBLE_LENGTH_323RQRRRWRtBytesIORR;R3twriteRR(R^tgetvalueR(RJRKt	hash_passthash_messagethash_pass_nthash_message_ntrand_sttoutbuft
_textratoutt
c((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt
_scramble_323�s






"
+





'
c
C
s�d
}
d}d}xyg|D]}|dkrt|�
^qD]L}|
|
d@|||
d	>d
@N}
||d	>|
Ad
@}||d
@}q>W|
d@}|d@}t
jd
||�S(Ni5W0PiiqV4R-s
	i i	i?iI����i
is>LL(R-s
	i i	I�i���I�i���(RRQRS(RJtnrtaddtnr2R/Rotr1tr2((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRa�s


2
"





c

C
stj
d
|�d S(Ns<Ii(RQRS(
t
n((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt
pack_int24�s
c

C
s�|d
krtd|�
�
n�|dkr5t
|�
S|dkrUdtjd|�S|dkryd	tjd
|�d S|dkr�d
tjd|�Std|df�
�
dS(NisFEncoding %d is less than 0 - no representation in LengthEncodedIntegeri�i
is
�s<His
�s<Iii@s
�s<QsIEncoding %x is larger than %x - no representation in LengthEncodedIntegeri
i
ll(R:RRQRS(
R>((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt
lenenc_int�s










tMysqlPacketcB
s
eZ
dZdZd�Zd�Zd�Zd�Zd�Zdd	�
Z	d
d�
Z
erid�Zn	d
�Zd�Z
d�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�Zd�ZRS(srRepresentation of a MySQL response packet.

    Provides an interface for reading/parsing the packet results.
    t	_positiont_datacC
sd
|_|
|_
dS(Ni(RzR{(R[R*tencoding((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR\�s
	
c


C
s|jS(
N(
R{(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytget_all_data�s
cC
s�|j|j
|j
|
!}t|�
|
kr�d
|
t|�
|j
t|j�
f}trqt|�

|j�
nt|�
�
n|j
|
7_
|S(sCRead the first 'size' bytes in packet and advance cursor past them.s\Result length not requested length:
Expected=%s.  Actual=%s.  Position: %s.  Data Length: %s(R{RzR3RCR2tdumptAssertionError(R[tsizeRNterror((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytread�s

%







c
C
s|j|j
}
d
|_
|
S(s`Read all remaining data in the packet.

        (Subsequent read() will return errors.)
        N(R{RztNone(R[RN((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytread_all�s
	
cC
sT|j|
}|d
ks.|t
|j�
krGtd|
|f�
�
n||_dS(s1Advance the cursor in data buffer 'length' bytes.is4Invalid advance amount (%s) for cursor.  Position=%sN(RzR3R{t	Exception(R[RVtnew_position((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytadvance�s


!


icC
sA|
d
ks!|
t|j
�
kr4td|
�
�
n|
|_dS(s9Set the position of the data buffer cursor to 'position'.is)Invalid position to rewind cursor to: %s.N(R3R{R�Rz(R[tposition((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytrewind
s!

i
cC
s|j|
|
|!S(
s>
Get 'length' bytes starting at 'position'.

        Position is start of payload (first four packet header bytes are not
        included) starting at index '0'.

        No error checking is done.  If requesting outside end of buffer
        an empty string (or string shorter than 'length') may be returned!
        (
R{(R[R�RV((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt	get_bytes
s	c
C
s)t|j
|j�
}
|jd
7_|
S(Ni
(tordR{Rz(R[RN((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt
read_uint8
s


c
C
s#|j|j
}
|j
d
7_
|
S(Ni
(R{Rz(R[RN((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
s


c
C
s2tj
d
|j|j�d}
|jd7_|
S(Ns<Hii(RQtunpack_fromR{Rz(R[RN((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytread_uint16"
s


c
C
s<tj
d
|j|j�\}
}|jd7_|
|d>S(Ns<HBii(RQR�R{Rz(R[tlowthigh((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytread_uint24'
s
!

c
C
s2tj
d
|j|j�d}
|jd7_|
S(Ns<Iii(RQR�R{Rz(R[RN((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytread_uint32,
s


c
C
s2tj
d
|j|j�d}
|jd7_|
S(Ns<Qii(RQR�R{Rz(R[RN((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytread_uint641
s


c
C
sL|jj
d
|j�}
|
dkr(dS|j|j|
!}|
d|_|S(Ns
ii
(R{tfindRzR�(R[tend_posRN((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytread_string6
s






c
C
sr|j�}
|
t
krd
S|
tkr,|
S|
tkrB|j�S|
tkrX|j�S|
tkrn|j	�Sd
S(s�Read a 'Length Coded Binary' number from the data buffer.

        Length coded numbers can be anywhere from 1 to 9 bytes depending
        on the value of the first byte.
        N(
R�tNULL_COLUMNR�tUNSIGNED_CHAR_COLUMNtUNSIGNED_SHORT_COLUMNR�tUNSIGNED_INT24_COLUMNR�tUNSIGNED_INT64_COLUMNR�(R[Ro((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytread_length_encoded_integer>
s











c
C
s)|j�}
|
d
krd
S|j|
�
S(s
Read a 'Length Coded String' from the data buffer.

        A 'Length Coded String' consists first of a length coded
        (unsigned, positive) integer represented in 1-9 bytes followed by
        that many bytes of binary data.  (For example "cat" would be "3cat".)
        N(R�R�R�(R[RV((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytread_length_coded_stringP
s


cC
s=tj
|
�
}|j|j|j�}|j|j7_|S(
N(RQtStructR�R{RzR�(R[tfmtRRN((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytread_struct\
s



c

C
s)|jd
d!dko(t
|j�
dkS(Nii
s
i(R{R3(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytis_ok_packetb
sc

C
s)|jd
d!dko(t
|j�
dkS(Nii
s
�i	(R{R3(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt
is_eof_packetf
sc

C
s|jd
d!dkS(Nii
s
�(
R{(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytis_auth_switch_requestl
sc
C
s.t|j
d
d!�
}
d|
k
o+dk
S
S(Nii
i�(R�R{(R[tfield_count((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytis_resultset_packetp
s

c

C
s|jd
d!dkS(Nii
s
�(
R{(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytis_load_local_packett
s
c

C
s|jd
d!dkS(Nii
s
�(
R{(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytis_error_packetw
s
c
C
s\|j�rX|j
�
|jd
�

|j�}
trEtd|
�
ntj|j�

ndS(Ni
serrno =(	R�R�R�R�RCR2Rtraise_mysql_exceptionR{(R[terrno((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytcheck_errorz
s







c

C
st|j
�

dS(
N(RBR{(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR~�
s
(RzR{(R_R`t__doc__t	__slots__R\R}R�R�R�R�R�R
R�R�R�R�R�R�R�R�R�R�R�R�R�R�R�R�R~(((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRy�s8
						
																tFieldDescriptorPacketc
B
s;eZ
dZd
�Zd�Zd�Zd�Zd�ZRS(s�A MysqlPacket that represents a specific column's metadata in the result.

    Parsing is automatically done and the results are exported via public
    attributes on the class such as: db, table_name, name, length, type_code.
    cC
s$tj
||
|�
|j|�

dS(
N(RyR\t_parse_field_descriptor(R[R*R|((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR\�
s

cC
s�|j�|_
|j�|_|j�j|
�
|_|j�j|
�
|_|j�j|
�
|_|j�j|
�
|_|jd
�
\|_	|_
|_|_|_
dS(s�Parse the 'Field Descriptor' (Metadata) packet.

        This is compatible with MySQL 4.1+ (not compatible with MySQL 4.0).
        s	<xHIBHBxxN(R�tcatalogtdbRt
table_namet	org_tabletnametorg_nameR�t	charsetnrRVt	type_codetflagstscale(R[R|((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR��
s




c

C
s;|j|j
d|j�|j�|j|jd
dkfS(sBProvides a 7-item tuple compatible with the Python PEP249 DB Spec.iiN(R�R�R�tget_column_lengthR�R�(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytdescription�
s


	
	

c
C
s9|jt
jkr2tj|jd
�}
|j|
S|jS(Ni
(R�Rt
VAR_STRINGRtgetR�RV(R[tmblen((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR��
s



c

C
s,d
|j|j
|j|j|j|jfS(Ns%s %r.%r.%r, type=%s, flags=%x(t	__class__R�R�R�R�R�(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt__str__�
s


(R_R`R�R\R�R�R�R�(((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR��
s				tOKPacketWrapperc
B
s eZ
dZd
�Zd�ZRS(s�
    OK Packet Wrapper. It uses an existing packet object, and wraps
    around it, exposing useful variables while still providing access
    to the original packet objects variables and methods.
    cC
s�|
j�s/t
d
t|jj�
d�
�
n|
|_|jjd�

|jj�|_|jj�|_	|j
d�
\|_|_|jj
�|_|jtj@|_dS(NsCannot create s  object from invalid packet typei
s<HH(R�R:RDR�R_tpacketR�R�t
affected_rowst	insert_idR�t
server_statust
warning_countR�RKRtSERVER_MORE_RESULTS_EXISTSthas_next(R[tfrom_packet((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR\�
s



	




cC
st|j
|
�S(
N(tgetattrR�(R[tkey((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt__getattr__�
s
(R_R`R�R\R�(((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR��
s	tEOFPacketWrapperc
B
s eZ
dZd
�Zd�ZRS(s�
    EOF Packet Wrapper. It uses an existing packet object, and wraps
    around it, exposing useful variables while still providing access
    to the original packet objects variables and methods.
    cC
s~|
j�s't
d
j|j�
�
�
n|
|_|jjd�
\|_|_trgt	d|j�
n|jt
j@|_dS(Ns3Cannot create '{0}' object from invalid packet types<xhhsserver_status=(
R�R:R.R�R�R�R�R�RCR2RR�R�(R[R�((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR\�
s



	


cC
st|j
|
�S(
N(R�R�(R[R�((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR��
s
(R_R`R�R\R�(((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR��
s	tLoadLocalPacketWrapperc
B
s eZ
dZd
�Zd�ZRS(s�
    Load Local Packet Wrapper. It uses an existing packet object, and wraps
    around it, exposing useful variables while still providing access
    to the original packet objects variables and methods.
    cC
sc|
j�s't
d
j|j�
�
�
n|
|_|jj�d|_tr_td|j�
ndS(Ns3Cannot create '{0}' object from invalid packet typei
s	filename=(	R�R:R.R�R�R}tfilenameRCR2(R[R�((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR\�
s



	

cC
st|j
|
�S(
N(R�R�(R[R�((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR��
s
(R_R`R�R\R�(((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR��
s	
t
Connectionc B
s~eZ
dZd1Zd
ZeZd1d1d
d1dd1d
d1d1d1d1ded1dd1d1d1d1d1ed1d1ed3eid1d1d1ed�Z	d�Z
d�Zed	��
Z
d
�ZeZd�Zd�Zd
�Zd�Zd�Zd�Zd�Zd�Zd�Zd1d�
Zd�Zd�Zd�Zd1d�
Zd�Zd�Zed�
Z ed�
Z!d�Z"d�Z#e$d�
Z%d �Z&d1d!�
Z'd"�Z(e)d#�
Z*d$�Z+d%�Z,ed&�
Z-d'�Z.d(�Z/d)�Z0d*�Z1d+�Z2d,�Z3d-�Z4d.�Z5d/�Z6d0�Z7e8j9Z9e8j:Z:e8j;Z;e8j<Z<e8j=Z=e8j>Z>e8j?Z?e8j@Z@e8jAZAe8jBZBRS(4s
    Representation of a socket with a mysql server.

    The proper way to get an instance of this class is to call
    connect().

    Establish a connection to the MySQL database. Accepts several
    arguments:

    :param host: Host where the database server is located
    :param user: Username to log in as
    :param password: Password to use.
    :param database: Database to use, None to not use a particular one.
    :param port: MySQL port to use, default is usually OK. (default: 3306)
    :param bind_address: When the client has multiple network interfaces, specify
        the interface from which to connect to the host. Argument can be
        a hostname or an IP address.
    :param unix_socket: Optionally, you can use a unix socket rather than TCP/IP.
    :param charset: Charset you want to use.
    :param sql_mode: Default SQL_MODE to use.
    :param read_default_file:
        Specifies  my.cnf file to read these parameters from under the [client] section.
    :param conv:
        Conversion dictionary to use instead of the default one.
        This is used to provide custom marshalling and unmarshaling of types.
        See converters.
    :param use_unicode:
        Whether or not to default to unicode strings.
        This option defaults to true for Py3k.
    :param client_flag: Custom flags to send to MySQL. Find potential values in constants.CLIENT.
    :param cursorclass: Custom cursor class to use.
    :param init_command: Initial SQL statement to run when connection is established.
    :param connect_timeout: Timeout before throwing an exception when connecting.
        (default: 10, min: 1, max: 31536000)
    :param ssl:
        A dict of arguments similar to mysql_ssl_set()'s parameters.
        For now the capath and cipher arguments are not supported.
    :param read_default_group: Group to read from in the configuration file.
    :param compress: Not supported
    :param named_pipe: Not supported
    :param autocommit: Autocommit mode. None means use server default. (default: False)
    :param local_infile: Boolean to enable the use of LOAD DATA LOCAL command. (default: False)
    :param max_allowed_packet: Max size of packet sent to server in bytes. (default: 16MB)
        Only used to limit size of "LOAD LOCAL INFILE" data packet smaller than default (16KB).
    :param defer_connect: Don't explicitly connect on contruction - wait for connect call.
        (default: False)
    :param auth_plugin_map: A dict of plugin names to a class that processes that plugin.
        The class will take the Connection object as the argument to the constructor.
        The class needs an authenticate method taking an authentication packet as
        an argument.  For the dialog plugin, a prompt(echo, prompt) method can be used
        (if no authenticate method) for returning a string from the user. (experimental)
    :param db: Alias for database. (for compatibility to MySQLdb)
    :param passwd: Alias for password. (for compatibility to MySQLdb)
    :param binary_prefix: Add _binary prefix on bytes and bytearray. (default: False)
    R1ii
iic %
s|dk	rt
jd
t�
n|dkrGtjddkrGt}n|dk	rh|dkrh|}n|dk	r�|r�|}n|s�|r�td�
�
nt|�
|_	|j	r�|t
jO}n�
r�|	r�tjj
d�
r�d}	q�d}	n|	r2�
s

d�
nt���jtjj|	�
�

��
fd	�} | d
|�}| d|�}| d|
�}
| d
|�}| d|�}t| d|��
}| d|�}| d|�}|s�
i}nt|t�r2xOdddddgD]5}!| d|!|j|!�
�}"|"r�
|"||!<q�
q�
Wq2nt|_|r�tsVtd�
�
nt|_|t
jO}|j|�
|_n|
p�d|_|p�d|_|p�t|_ |p�d|_!||_"||_#||_$d|ko�dk
n
st%d�
�
n|pd|_&|dk	r9|dk
r9t%d�
�
n||_'|dk	ri|dk
rit%d�
�
n||_(|r�||_)t|_*nt+|_)t|_*|dk	r�||_*nt,|j)�
j-|_-|t
j.O}|j"r�|t
j/O}n||_0|
|_1d|_2d|_3d |_4||_5|
dkr@t6j7}
ntg|
j8�D]*\}#}$t9|#�
tk	rP|#|$f^qP�
|_:tg|
j8�D]*\}#}$t9|#�
tkr�|#|$f^q��
|_;||_<||_=||_>||_?||_@|rd|_An
|jB�
dS(!Nsno_delay option is deprecatediis3compress and named_pipe arguments are not supportedtwins	c:\my.inis/etc/my.cnftclientc
s7|
r
|
Sy�j�
|�SWnt
k
r2


|
SXdS(
N(R�R�(R�targ(tcfgtread_default_group(s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt_configcs






tuserRJthosttdatabasetsockettportsbind-addresssdefault-character-settcatcapathtcertR�tciphersssl-sssl module not foundt	localhosti�R1i�3�
s+connect_timeout should be >0 and <=31536000sread_timeout should be >= 0swrite_timeout should be >= 0s
Not connected(CR�twarningstwarntDeprecationWarningR5tversion_infotTruetNotImplementedErrortboolt
_local_infileRtLOCAL_FILEStplatformt
startswithRR�tostpatht
expanduserR(R'tdictR�tFalsetssltSSL_ENABLEDtSSLt_create_ssl_ctxtctxR�R�tDEFAULT_USERR�RJR�tunix_sockettbind_addressR:tconnect_timeoutt
_read_timeoutt_write_timeouttcharsettuse_unicodetDEFAULT_CHARSETR	R|tCAPABILITIEStCONNECT_WITH_DBtclient_flagtcursorclasst_resultt_affected_rowst	host_infotautocommit_modeRtconversionstitemsttypetencoderstdecoderstsql_modetinit_commandtmax_allowed_packett_auth_plugin_mapt_binary_prefixt_socktconnect(%R[R�R�RJR�R�R�R�R
tread_default_filetconvR�R
R

R
R�R�R�tcompresst
named_pipetno_delayt
autocommitR�tpasswdtlocal_infileR

t
defer_connecttauth_plugin_maptread_timeoutt
write_timeoutR�t
binary_prefixR�R�tvaluet
kt
v((R�R�s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR\9s�

	
	

	

	



		

		









	




	



	






	
	
	





	


	

	
	
	


	

			
	
		
F
F
	
	
	
	
	

cC
s
t|
t
j�r|
S|
jd
�
}|
jd�
}|dkoI|dk}t
jd|d|�}|oz|
jdt�|_|r�t
jnt
j	|_
d|
kr�|j|
dd|
jd�
�


nd|
kr�|j|
d�

n|j
t
jO_
|j
t
jO_
|S(	NR�R�tcafiletcheck_hostnameR�tkeyfileR�R�(R'R�t
SSLContextR�R�tcreate_default_contextR�R#
t	CERT_NONEt
CERT_REQUIREDtverify_modetload_cert_chaintset_cipherstoptionstOP_NO_SSLv2tOP_NO_SSLv3(R[tsslpR�R�thasnocaR�((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR��s









#




c
C
s�|jrt
jd
�
�
nt|_|jdkr7dStjddtj	�}
z)y|j
|
�

Wntk
rv


n
XWd|j�
XdS(s*Send the quit message and close the socketsAlready closedNs<iBi
(
t_closedRtErrorR�R
R�RQRSRtCOM_QUITt_write_bytesR�t_force_close(R[t	send_data((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytclose�s	

	







c

C
s
|jdk	S(
N(R
R�(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytopen�sc

C
s=|jr'y|jj
�
Wq'


q'Xnd
|_d
|_d
S(s%Close connection without QUIT messageN(R
R7
R�t_rfile(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR5
�s	




	
cC
s8t|
�
|_
|j�}|
|kr4|j�
ndS(
N(R�R
tget_autocommitt_send_autocommit_mode(R[R
tcurrent((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR
�s



c

C
st|j
tj@�
S(
N(R�R�RtSERVER_STATUS_AUTOCOMMIT(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR:
�s
	
c
C
sI|j�}
|
j
�s-tjd
d��
nt|
�
}|j|_|S(Ni�sCommand Out of Sync(t_read_packetR�RtOperationalErrorR�R�(R[tpkttok((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt_read_ok_packet�s





c

C
s1|jt
jd
|j|j�
�
|j�
dS(s2Set whether or not to commit after every execute()sSET AUTOCOMMIT = %sN(t_execute_commandRt	COM_QUERYtescapeR
RB
(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR;
�s

c

C
s!|jt
jd
�
|j�
dS(sBegin transaction.tBEGINN(RC
RRD
RB
(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytbegins
c

C
s!|jt
jd
�
|j�
dS(s Commit changes to stable storagetCOMMITN(RC
RRD
RB
(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytcommit
s
c

C
s!|jt
jd
�
|j�
dS(s!Roll back the current transactiontROLLBACKN(RC
RRD
RB
(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytrollbacks
c
C
s0|jt
jd�
t|�
}
|
j�
|
jS(
s
SHOW WARNINGS(RC
RRD
tMySQLResultR�trows(R[RN((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt
show_warningss



cC
s!|jt
j|
�
|j�
d
S(sSet current dbN(RC
RtCOM_INIT_DBRB
(R[R�((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt	select_dbs
cC
s{t|
t
�r$d
|j|
�
d
St|
ttf�rb|j|
�
}|jr^d|}n|Stj|
|j	d|�
S(s�Escape whatever value you pass to it.
        
        Non-standard, for internal use; do not use this in your applications.
        t
't_binarytmapping(
R'Rt
escape_stringtbytest	bytearrayt_quote_bytesR
Rtescape_itemR�(R[tobjRS
tret((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRE
 s



	



cC
s|j|
|j
�S(
srAlias for escape()
        
        Non-standard, for internal use; do not use this in your applications.
        (RE
R	
(R[RY
((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytliteral.scC
s-|jt
j@r |
jd
d�Stj|
�
S(NRQ
s''(R�Rt"SERVER_STATUS_NO_BACKSLASH_ESCAPEStreplaceRRT
(R[R((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRT
5s




cC
s:|jt
j@r-d
t|
jdd��
f
Stj|
�
S(Ns'%s'RQ
s''(R�RR\
RR]
Rtescape_bytes(R[R((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRW
;s




cC
s|
r|
|�
S|j|�
S(
s+Create a new cursor to execute queries with(
R

(R[tcursor((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR_
As


c


C
s
|j�S(
s%Context manager that returns a Cursor(
R_
(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt	__enter__Gsc
C
s!|
r|j�
n
|j
�
d
S(s2On successful exit, commit. On exception, rollbackN(RK
RI
(R[texcR
t	traceback((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt__exit__Ks

cC
s~t|
t
�rOtptrOtr7|
j|j�
}
qO|
j|jd
�}
n|jtj	|
�
|j
d|�
|_|jS(NRt
unbuffered(R'RRRR
tencodeR|RC
RRD
t_read_query_resultR
(R[tsqlRd
((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytquerySs




cC
s|jd
|
�
|_
|j
S(NRd
(Rf
R
(R[Rd
((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytnext_result_s

c


C
s|jS(
N(
R
(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�cs
cC
s/tj
d
|
�}|jtj|�
|j�S(Ns<I(RQRSRC
RtCOM_PROCESS_KILLRB
(R[t	thread_idR�((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytkillfs


cC
s�|jdkr:|
r(|j�
t}
q:tjd
�
�
ny!|jtjd�
|j	�
Wn4t
k
r�


|
r�|j�
|jt�

q��n
XdS(sCheck if the server is alivesAlready closedR1N(R
R�R
R�RR2
RC
RtCOM_PINGRB
R�tping(R[t	reconnect((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRn
ks



	








cC
sOt|
�
j
}|jtjd
|j|
�
�
|j�
|
|_||_
dS(NsSET NAMES %s(R	R|RC
RRD
RE
R>
R�(R[R�R|((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytset_charset}s
 


	
cC
st|_
yU|
dkr�
|jr�|jdkr�tjtjtj�}
|
j|j	�

|
j
|j�

d|_trd
t
d�

qd
n�i}|jdk	r�|jdf|d<nxjtr
y)tj|j|jf|j	|�}
PWq�ttfk
r

}
|jtjkr
q�n�q�Xq�Wd|j|jf|_trK
t
d�

n|
jtjtjd	�
|
jd�

|
jtjtjd	�
n|
|_t|
d
�|_d|_|j�
|j �
|j!dk	r�
|j"�}|j#d|j!f
�
n|j$dk	r;|j"�}|j#|j$�

|j%�
|j&�
n|j'dk	r]|j(|j'�

nWn�t)k
r
}
d|_|
dk	r�y|
j%�
Wq�


q�Xnt*|tttj+f�rt,j-dd
|j|f�}||_.t/j0�|_/trt
|j/�

n|�
n�n
XdS(NR�s	127.0.0.1sLocalhost via UNIX socketsconnected using unix_socketitsource_addressssocket %s:%dsconnected using socketi
trbsSET sql_mode=%si�s(Can't connect to MySQL server on %r (%s)(R�s	127.0.0.1(1R�R1
R�R�R�R�tAF_UNIXtSOCK_STREAMt
settimeoutR�R
R
RCR2R�R�tcreate_connectionR�tOSErrortIOErrorR�tEINTRt
setsockopttIPPROTO_TCPtTCP_NODELAYt
SOL_SOCKETtSO_KEEPALIVER
R#R9
t_next_seq_idt_get_server_informationt_request_authenticationR
R_
texecuteR
R7
RI
R
R
t
BaseExceptionR'R�RR?
toriginal_exceptionRb
t
format_exc(R[R!tkwargst
eRoRa
((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR
�s|
	






	



	



	












	

	













	








	


	cC
s[tt
|
�
�
t|j�
|
}tr6t|�

n|j|�

|jd
d|_dS(swWrites an entire "mysql packet" in its entirety to the network
        addings its length and sequence number.
        i
i
N(RwR3RR
RCRBR4
(R[tpayloadR*((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytwrite_packet�s
#




c
C
s)
d
}x
tr
|j
d�
}tjd|�\}}}||d>}||jkr�|j�
|dkr�tjtj	d��
ntj
d||jf�
�
n|jdd	|_|j
|�
}tr�t|�

n||7}|d
kr�q	n|t
kr	Pq	q	W|
||j�}	|	j�
|	S(s�Read an entire "mysql packet" in its entirety from the network
        and return a MysqlPacket type that represents the results.
        R1is<HBBiis,Lost connection to MySQL server during querys1Packet sequence number wrong - got %d expected %di
i
i���(R�t_read_bytesRQRRR
R5
RR?
R
tCR_SERVER_LOSTt
InternalErrorRCRBtMAX_PACKET_LENR|R�(
R[tpacket_typetbufft
packet_headertbtrltbtrht
packet_numbert
bytes_to_readt	recv_dataR�((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR>
�s4
	





















cC
s�|jj
|j�

x{tr�y|jj|
�
}PWqttfk
r�
}
|jtj	krcqn|j
�
tjt
jd
|f
��
qXqWt|�
|
kr�|j
�
tjt
jd��
n|S(Ns1Lost connection to MySQL server during query (%s)s,Lost connection to MySQL server during query(R
Ru
R�R�R9
R�Rx
Rw
R�Ry
R5
RR?
R
R�
R3(R[t	num_bytesR*R�
((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
�s"

	
















cC
sg|jj
|j�

y|jj|
�

Wn9tk
rb
}
|j�
tjtj	d
|f
��
n
XdS(NsMySQL server has gone away (%r)(
R
Ru
R�tsendallRx
R5
RR?
R
tCR_SERVER_GONE_ERROR(R[R*R�
((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR4
s








cC
s�|
rByt|�
}|j
�
WqX


t|_d|_�qXXnt|�
}|j�
||_|jdk	r|j|_n|j	S(
N(
RL
tinit_unbuffered_queryR�tunbuffered_activeR�t
connectionR�R
R�R�(R[Rd
RN((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRf
s





	
	




	


c


C
s|jr|jj
Sd
SdS(Ni(R
R�(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�+s
	

cC
s
|jst
jd
�
�
n|jdk	r||jjrStjd�

|jj�
nx|jj	ro|j
�
qVWd|_nt|t�r�|j
|j�
}nttt|�
d�}tjd||
�}|||d }|j|�

tr
t|�

nd|_|tkr
dS||d}xQtrz
ttt|�
�}|j|| �

||}|r*
|tkr*
Pq*
q*
WdS(Ns(0, '')s.Previous unbuffered result was left incompletei
s<iB(R
RtInterfaceErrorR
R�R�
R�R�t_finish_unbuffered_queryR�Ri
R'RRe
R|R;R�
R3RQRSR4
RCRBR
R�R�
(R[tcommandRg
tpacket_sizetpreludeR�((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRC
1s6
	














	

	





c
C
st|j
jd
d�d�
dkr:|jtjO_n|jdkrXtd�
�
nt	|j
�
j}
t|jt
�r�|jj|j�
|_ntjd|jd|
d�}|jr
|jtj@r
|j|�

|jj|jd|j�

|_t|jd	�|_n||jd
}d}|jdkr[
t|jjd�
|j�}n|jtj @r�
|t!t"|�
�
|7}nA|jtj#@r�
|tjd
t"|�
�|7}n||d
7}|j$r#|jtj%@r#t|j$t
�r|j$j|j�
|_$n||j$d
7}n|jtj&@rn|j}t|t
�r]|jd�
}n||d
7}n|j|�

|j'�}|j(�r|j)�
|j*�}|jtj&@r�|dk	r�|j+||�}qt,|jjd�
|j�d
}|j|�

|j'�}ndS(NR&i
iisDid not specify a usernames<iIB23sR1tserver_hostnameRr
s
tmysql_native_passwordRRPR(R1R�
(-R(tserver_versiontsplitR
Rt
MULTI_RESULTSR�R�R:R	R�tidR'RRe
R|RQRSR�tserver_capabilitiesR�R�
R�twrap_socketR
R�R#R9
t_auth_plugin_nameRORJtsalttPLUGIN_AUTH_LENENC_CLIENT_DATARxR3tSECURE_CONNECTIONR�R�tPLUGIN_AUTHR>
R�R�R�t
_process_authRp(R[t
charset_idt	data_initR*tauthrespR�tauth_packettplugin_name((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
WsP%





!


!


#



	








"


cC
s�|jj
|
�
}|s6|jj
|
jd
�
�
}n|r�y||�
}|j|�
SWq�tk
r�


|
dkr�tjdd|
|f��
q�q�tk
r�


tjdd|
|f��
q�Xnd}|
dkr�t	|j
jd�
|j��}n�
|
dkr1
t
|j
jd�
|j��d	}n�
|
d
krV
|j
jd�
d	}n}
|
dkr�|}xN
tr�|j�}|d@dk}|d
@d
k}	|j�}
|
dkr�
|j|j
jd�
d	�

n�|rmd}y'|j||
�}|j|d	�

Wq�tk
r7


tjdd|
|f��
q�tk
ri


tjdd|
|||
f��
q�Xntjdd|
|f��
|j�}|j�
|j�s�|	rk
Pqk
qk
W|Stjdd|
��
|j|�

|j�}|j�
|S(NRtdialogisGAuthentication plugin '%s' not loaded: - %r missing authenticate methodsXAuthentication plugin '%s' not loaded: - %r cannot be constructed with connection objectR�
Rtmysql_old_passwords
tmysql_clear_passwordiii
s
Password: s3no response - TypeError within plugin.prompt methodsAAuthentication plugin '%s' not loaded: - %r missing prompt methodi
sTAuthentication plugin '%s' %r didn't respond with string. Returned '%r' to prompt %rs.Authentication plugin '%s' (%r) not configureds)Authentication plugin '%s' not configured(R
R�RtauthenticatetAttributeErrorRR?
t	TypeErrorR�RORJRe
R�RpR�R�R�
tpromptR>
R�R�(R[R�
R�
tplugin_classthandlerR*R@
tflagtechotlastR�
tresp((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
�sh
















$
(



	




 























c

C
s|jd
S(Ni(
tserver_thread_id(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRk
�s
c


C
s|jS(
N(
R�(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytcharacter_set_name�s
c


C
s|jS(
N(
R
(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt
get_host_info�s
c


C
s|jS(
N(
tprotocol_version(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytget_proto_info�s
c
	C
s�d
}
|j�}|j
�}t||
|
d!�
|_|
d7}
|jd|
�}||
|!jd�
|_|d}
tjd||
|
d!�|_	|
d7}
||
|
d!|_
|
d7}
tjd	||
|
d
!�d
|_|
d
7}
t|�
|
dkr�
tjd||
|
d!�\}}}}|
d7}
||_
yt|�
j|_Wntk
rq



d|_n
X||_tr�
td
|�

n|j|d>O_tr�
td|�
ntd|d�}n|
d7}
t|�
|
|kr|j
||
|
|!7_
|
|7}
n|
d7}
|jtj@r�t|�
|
kr�|jd|
�}|d
kr{||
jd�
|_q�||
|!jd�
|_ndS(Nii
s
Rs<Iiii	s<Hiis<BHHBsserver_status: %xis	salt_len:ii
(R>
R}RR�
R�RR�
RQRRR�
R�
R�
R3tserver_languageR
R�tserver_charsettKeyErrorR�R�RCR2tmaxRR�
R�
(	R[R>R�R*t
server_endtlangtstattcap_htsalt_len((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
�sN







 



$


)

	




	






"
c


C
s|jS(
N(
R�
(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pytget_server_infos
Ni@i
(CR_R`R�R�R
R�
R�R1
RR\R�R7
tpropertyR8
R5
t__del__R
R:
RB
R;
RG
RI
RK
RN
RP
RE
R[
RT
RW
R_
R`
Rc
Rh
Ri
R�Rl
R�Rn
Rp
R
R�
RyR>
R�
R4
Rf
R�RC
R�
R�
Rk
R�
R�
R�
R�
R�
RtWarningR2
R�
t
DatabaseErrort	DataErrorR?
tIntegrityErrorR�
tProgrammingErrortNotSupportedError(((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR��
s�7

	
	

	
	
	
	


	
z			
																		H	$		
		&	=	?					?		
	
	
	
	
	
	
	
	
RL
c
B
s}eZ
d�Zd
�Zd�Zd�Zd�Zd�Zd�Zd�Z	d�Z
d	�Zd
�Zd�Z
d�ZRS(
cC
sg|
|_d|_d|_d|_d
|_d|_d
|_d|_d|_	d|_
t|_dS(s.
        :type connection: Connection
        iN(
R�
R�R�R�R�R�RKR�R�RM
R�R�R�
(R[R�
((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR\/s	
	
	
	
	
	
	
	
	
	
c


C
s|jr|j
�
ndS(
N(R�
R�
(
R[((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
?s
	
c
C
sizX|jj
�}
|
j�r.|j|
�

n)|
j�rJ|j|
�

n
|j|
�

Wdd|_XdS(
N(R�
R>
R�RB
R�t_read_load_local_packett_read_result_packetR�(R[tfirst_packet((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�Cs




c
C
s�t|_
|jj�}
|
j�rF|j|
�

t|_
d|_nP|
j�rt|j	|
�

t|_
d|_n"|
j
�|_|j�
d
|_
dS(Nl����(R�R�
R�
R>
R�RB
R�R�R�R�
R�R�t_get_descriptionsR�(R[R�
((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
Ps
	



	




	


cC
sXt|
�
}|j
|_
|j|_|j|_|j|_|j|_|j|_dS(
N(R�R�R�R�R�RKR�(R[R�
t	ok_packet((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRB
es






cC
s�|jj
std
�
�
nt|
�
}t|j|j�}y|j�
Wn


|jj�
�n
X|jj�}|j�s�t	j
dd��
n|j|�

dS(NsF**WARN**: Received LOAD_LOCAL packet but local_infile option is false.i�sCommands Out of Sync(R�
R�tRuntimeErrorR�t
LoadLocalFileR�R6
R>
R�RR?
RB
(R[R�
tload_packettsenderR�
((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
ns













cC
s8|
j�st
St|
�
}|j|_|j|_tS(
N(R�R�R�R�R�R�(R[R�twp((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt_check_packet_is_eofs




cC
s'|
j�|_
|j�
|j�
dS(
N(R�R�R�
t_read_rowdata_packet(R[R�
((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
�s



c
C
sr|js
dS|j
j�}
|j|
�
rJt|_d|_
d|_dS|j|
�
}d
|_|f
|_|S(Ni
(	R�
R�
R>
R�
R�R�RM
t_read_row_from_packetR�(R[R�trow((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt_read_rowdata_packet_unbuffered�s	


	
	
	

	

c
C
sGx@|jrB|j
j�}
|j|
�
rt|_d|_
qqWdS(
N(R�
R�
R>
R�
R�R�(R[R�((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
�s



	
c
C
svg}
xKtrS|j
j�}|j|�
r:d
|_
Pn|
j|j|�
�

q	Wt|
�
|_t	|
�
|_
d
S(s:Read a rowdata packet for each data row in the result set.N(R�R�
R>
R�
R�tappendR�
R3R�ttupleRM
(R[RM
R�((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
�s
	


	


cC
s�g}x�|jD]�\}}y|
j
�}Wntk
r@


Pn
X|dk	r�|dk	rk|j|�
}ntr�td
|�
n|dk	r�||�
}q�n|j|�

qWt|�
S(NsDEBUG: DATA = (	RR�t
IndexErrorR�RRCR2R�
R�
(R[R�R�
R|t	converterR*((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
�s













c

C
sf
g|_g|_
|jj}
|jj}g}x
t|j�
D]
}|jjt�
}|jj	|�

|j	|j
��

|j}|
r�|tj
kr�|}q�|tkr�|jd
kr�d}q�|}q�d}nd}|jjj|�
}|t
jkr
d}ntr*
tdj||��

n|j
j	||f�

q@W|jj�}	t|�
|_
dS(s>Read a column descriptor packet for each column in the result.i?RsDEBUG: field={}, converter={}N(tfieldsRR�
R�R|RR�R>
R�R�
R�R�RtJSONt
TEXT_TYPESR�R�R

R�tthroughRCR2R.R�
(
R[R�t
conn_encodingR�R>tfieldt
field_typeR|R�
t
eof_packet((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
�s6	
	






	

	

			


	

(R_R`R\R�
R�R�
RB
R�
R�
R�
R�
R�
R�
R�
R�
(((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyRL
-s			
								
	
	R�
c
B
seZ
d�Zd
�ZRS(cC
s|
|_||_
dS(
N(R�R�
(R[R�R�
((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR\�s
	
c
C
s�|jj
stjd
�
�
n|j}
z�ydt|jd��L}t|
jd	�}x0tr�|j	|�
}|svPn|
j
|�

qWWWdQXWn/tk
r�


tjddj
|j�
��
n
XWd|
j
d�

XdS(
s3Send data packets from the local file to the servers(0, '')Rr
iiNi�sCan't find file '{0}'R1i@(R�
R
RR�
R8
R�R;R

R�R�R�
Rx
R?
R.(R[tconnt	open_fileR�
tchunk((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR6
�s

	


	






&(R_R`R\R6
(((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyR�
�s
	(dt
__future__Rt_compatR
RRRRRR�t	functoolsRthashlibRR�R�RQR5Rb
R�R�RR	R
t	constantsRRR
RRR1RtcursorsRt
optionfileRtutilRRRR�R�R�tImportErrorR�R�tgetpasstgetuserR�R�
RCR�t_py_versionR4R>R)RRt	_socketioRR#tsettBITtBLOBt	LONG_BLOBtMEDIUM_BLOBtSTRINGt	TINY_BLOBR�tVARCHARtGEOMETRYR�
tnewRER�R�R�R�R�R�R�
RBRHRORIRbtobjectRWRpRaRwRxRyR�R�R�R�R�RL
R�
(((s7/usr/lib/python2.7/site-packages/pymysql/connections.pyt<module>s�
.









(




















A	
	












		
	
				�2���4�