ÿØÿà 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ÿÙ
U

8�]9��@s�dZd
dl
Z
d
dlZ
d
dlZd
dlZz,d
dlmZ
d
dlmZm	Z	
e
Zee	f
WnDek
r�


d
dl
mZ
d
dlmZ
d
dlm	Z	
d
dlmZ
YnXd
dlZd	d
�ZGdd�d�Zdd
d�
Zdd�ZGdd�de�ZdS)z"Abstract crash database interface.�N)
�	Exception)�
quote_plus�urlopen)
�
cmp_to_key)
r)
r)
�URLErrorc

Cst|t
�r|�d
d�S|S)z.Convert str to an unicode if it isn't already.�UTF-8�ignore)�
isinstance�bytes�decode)
�str�r
�0/usr/lib/python3/dist-packages/apport/crashdb.py�_us


rc@sT
eZ
dZd
d�Zdd�Zdd�Zdd�ZdRd
d�
Zdd
�Zdd�Z	dd�Z
dd�Zdd�Zdd�Z
dd�Zdd�ZdSdd�
Zdd �Zd!d"�Zd#d$�Zed%d&��
ZdTd'd(�
Zd)d*�Zd+d,�Zd-d.�ZdUd/d0�
ZdVd2d3�
Zd4d5�Zd6d7�Zd8d9�Zd:d;�Zd<d=�Z d>d?�Z!d@dA�Z"dBdC�Z#dDdE�Z$dFdG�Z%dHdI�Z&dJdK�Z'dLdM�Z(dWdNdO�
Z)dPdQ�Z*d	S)X�
CrashDatabasecCs|
|_||_
d
|_d
S)az
Initialize crash database connection.

        You need to specify an implementation specific file with the
        authentication credentials for retracing access for download() and
        update(). For upload() and get_comment_url() you can use None.

        options is a dictionary with additional settings from crashdb.conf; see
        get_crashdb() for details.
        N)�	auth_file�options�duplicate_db)�selfrrr
r
r�__init__&s


zCrashDatabase.__init__c

Cs|j�
d
�
S)z�Return the base URL for bug patterns.

        See apport.report.Report.search_bug_patterns() for details. If this
        function returns None, bug patterns are disabled.
        Zbug_pattern_url�r�get�
rr
r
r�get_bugpattern_baseurl4sz$CrashDatabase.get_bugpattern_baseurlcCs"d
|jkr|
�
d�
|jd
kSdS)z�Check if this report can be uploaded to this database.

        Crash databases might limit the types of reports they get with e. g.
        the "problem_types" option.
        Z
problem_typesZProblemTypeTr)r�reportr
r
r�accepts<s

zCrashDatabase.acceptsc
Cs~
d
dl}|j
dkstd�
�
d|_tj�|
�
pD|
dkpDtj�|
�
d
k}|j|
dd�|_	|r�|j	�
�}|�d	�

|�d
|jg
�
|�d�

|�d�

|j	��
|j	�
�}|�d
�

|�
�}|dg
kr�tdt|�
�
�
z|�d�

|��}Wn<|j	jk
�
r$
}
zdt|�
k�
rd
g
}W5d}~XYnX|d
|jk�
rFtd|d
�
�
|d
|jk�
rztd|d
|jf�

|�|d
�

dS)z�Initialize duplicate database.

        path specifies an SQLite database. It will be created if it does not
        exist yet.
        r
NZqmarkz/this module assumes qmark dbapi parameter style�z:memory:i )
Ztimeoutz.CREATE TABLE version (format INTEGER NOT NULL)zINSERT INTO version VALUES (?)a
CREATE TABLE crashes (
                signature VARCHAR(255) NOT NULL,
                crash_id INTEGER NOT NULL,
                fixed_version VARCHAR(50),
                last_change TIMESTAMP,
                CONSTRAINT crashes_pk PRIMARY KEY (crash_id))z�CREATE TABLE address_signatures (
                signature VARCHAR(1000) NOT NULL,
                crash_id INTEGER NOT NULL,
                CONSTRAINT address_signatures_pk PRIMARY KEY (signature))zPRAGMA integrity_check)
�okzCorrupt duplicate db:zSELECT format FROM versionz
no such tablez"duplicate DB has unknown format %iz+duplicate db has format %i, upgrading to %i)Zsqlite3Z
paramstyle�AssertionError�format_version�os�path�exists�getsizeZconnectr�cursor�execute�commit�fetchall�SystemErrorr�fetchoneZOperationalError�print�_duplicate_db_upgrade)rr!Zdbapi2Zinit�cur�result�
er
r
r�init_duplicate_dbLsD
�
�
























�zCrashDatabase.init_duplicate_dbNc	Cs.|jst
d
�
�
|s|�|
�
}|�|
|�
d|kr:|d}n|��}g}|r~|�||
�}|r~|D]\}}|�|�

q^|�||
�}z|d��d}Wntt	fk
r�


d}YnXd}d}	|D]0\}}
|
r�|r�t
j�||
�dkr�|}|
}	
�
qq�|�
r|�
|
|dd�
|��}|�
r�|�|�
}|�
r�||k�
r�|dk�
r@|}nH||k�
rf|�|||�
|�||�
n"|�|||�
|�||�
|}d}	|dk	�
r�||
k�
r�|�
r�|�||�
|�||
|�
||	fS|�r|j��}
|
�d|
g
�
|
��d}|dk�r|
�d	t|�
|
df�
|j��
|�r*|�||
�
dS)
aCheck whether a crash is already known.

        If the crash is new, it will be added to the duplicate database and the
        function returns None. If the crash is already known, the function
        returns a pair (crash_id, fixed_version), where fixed_version might be
        None if the crash is not fixed in the latest version yet. Depending on
        whether the version in report is smaller than/equal to the fixed
        version or larger, this calls close_duplicate() or mark_regression().

        If the report does not have a valid crash signature, this function does
        nothing and just returns None.

        By default, the report gets download()ed, but for performance reasons
        it can be explicitly passed to this function if it is already available.
        �-init_duplicate_db() needs to be called before�DuplicateSignatureZPackage�
Nr
�����z0SELECT count(*) FROM crashes WHERE crash_id == ?z7INSERT INTO crashes VALUES (?, ?, ?, CURRENT_TIMESTAMP))rr�download�_mark_dup_checked�crash_signature�_duplicate_search_signature�_duplicate_db_sync_status�split�KeyError�
IndexError�apport�	packaging�compare_versions�mark_regression�crash_signature_addresses�#_duplicate_search_address_signature�close_duplicate�_duplicate_db_merge_id�#_duplicate_db_add_address_signaturer$r%r)rr&)r�idr�sig�existingZex_id�
_Zreport_package_versionZ	master_idZ
master_verZex_verZaddr_sigZ
addr_matchr,Zcount_idr
r
r�check_duplicate�sn













































zCrashDatabase.check_duplicatec
Cs<
|j�
d
�
sdSdD�
] }|dkr>d|
kr4|
d}qF|
��}n|
��}|sLq|�|�
}|s`
dStj�|jd
|t|�
�}z.t	|�
}|�
��d�
}|��
d|kr�WqWnt
tfk
r�


YqYnX|��D]f}z|�dd�\}	}
t|	�
}	Wntk
�
r


Yq�YnX|
|kr�|�|
|	�}|�
s(d	}|

Sq�qdS)
a�Check if the crash db already knows about the crash signature.

        Check if the report has a DuplicateSignature, crash_signature(), or
        StacktraceAddressSignature, and ask the database whether the problem is
        already known. If so, return an URL where the user can check the status
        or subscribe (if available), or just return True if the report is known
        but there is no public URL. In that case the report will not be
        uploaded (i. e. upload() will not be called).

        Return None if the report does not have any signature or the crash
        database does not support checking for duplicates on the client side.

        The default implementation uses a text file format generated by
        duplicate_db_publish() at an URL specified by the "dupdb_url" option.
        Subclasses are free to override this with a custom implementation, such
        as a real database lookup.
        Z	dupdb_urlN)rF�addressrFr1rz<title>404 Not Foundr2�
1)rrr6r@�duplicate_sig_hashr r!�joinrr�readr�close�IOErrorr�
splitlinesr9�int�
ValueError�
get_id_url)rrZkindrF�
hZurl�
f�contents�linerE�
sr-r
r
r�known�sD


























zCrashDatabase.knowncCsD|jst
d
�
�
|j��}|�d||
f�}|jdks6t
�
|j��
dS)z�Mark given crash ID as fixed in the duplicate database.

        version specifies the package version the crash was fixed in (None for
        'still unfixed').
        r0zXUPDATE crashes SET fixed_version = ?, last_change = CURRENT_TIMESTAMP WHERE crash_id = ?r2N)rrr$r%Zrowcountr&)rrE�versionr,�
nr
r
r�duplicate_db_fixed2
s


�
z CrashDatabase.duplicate_db_fixedcCsB|jst
d
�
�
|j��}|�d|
g
�
|�d|
g
�
|j��
dS)z{Remove crash from the duplicate database.

        This happens when a report got rejected or manually duplicated.
        r0�&DELETE FROM crashes WHERE crash_id = ?z1DELETE FROM address_signatures WHERE crash_id = ?N�rrr$r%r&)rrEr,r
r
r�duplicate_db_remove@
s




z!CrashDatabase.duplicate_db_removecCsF|jst
d
�
�
|j��}|�d||
g�
|�d||
g�
|j��
dS)zChange a crash ID.r0zSUPDATE crashes SET crash_id = ?, last_change = CURRENT_TIMESTAMP WHERE crash_id = ?�=UPDATE address_signatures SET crash_id = ? WHERE crash_id = ?Nr_)rZold_idZnew_idr,r
r
r�duplicate_db_change_master_idL
s


�
�z+CrashDatabase.duplicate_db_change_master_idcCs�
|jst
d
�
�
|
d}t�|�

tj�|d�}t�|�

d}d}|j��}|�d�

|��D]Z\}}|�	|�
}	|	dkrxq\|	|kr�|	}|r�|�
�
ttj�||�d�}|�d||f�

q\|r�|�
�
tj�|d�}
t�|
�

d}d}|�d	�

|��D]f\}}|�	|�
}	|	dk�
rq�|	|k�
rD|	}|�
r0|�
�
ttj�|
|�d
�}|�d||f�
d�
�

q�|�
rl|�
�
tj�|
�
�
r�t�|
|
d�
t�||
�
tj�|
d�
�
r�t�|
d�

dS)
a�Create text files suitable for www publishing.

        Create a number of text files in the given directory which Apport
        clients can use to determine whether a problem is already reported to
        the database, through the known() method. This directory is suitable
        for publishing to the web.

        The database is indexed by the first two fields of the duplicate or
        crash signature, to avoid having to download the entire database every
        time.

        If the directory already exists, it will be updated. The new content is
        built in a new directory which is the given one with ".new" appended,
        then moved to the given name in an almost atomic way.
        r0z.newrJNz3SELECT * from address_signatures ORDER BY signature�
wz%i %s
rFz:SELECT signature, crash_id from crashes ORDER BY signature�wbrz.old)rrr �mkdirr!rMr$r%r'rLrO�open�write�encoder"�rename�shutilZrmtree)r�dir�outZ	addr_baseZcur_hashZcur_filer,rFrErUZsig_baser
r
r�duplicate_db_publishX
sV






































z"CrashDatabase.duplicate_db_publishcCsD|
d
krtd�
�
|j
��}|�d|
f
�
|j
��
|
|jks@t�
dS)z"Upgrade database to current formatrz2Cannot upgrade database from format earlier than 3zUPDATE version SET format = ?N)r(rr$r%r&rr)rZ
cur_formatr,r
r
rr+�
s



z#CrashDatabase._duplicate_db_upgradecCs^|j�
�}|�d
t|
�
|g�
|��}dd�}tjddkrN|jt|�
d�

n|j|d�

|S)aLook up signature in the duplicate db.

        Return [(id, fixed_version)] tuple list.

        There might be several matches if a crash has been reintroduced in a
        later version. The results are sorted so that the highest fixed version
        comes first, and "unfixed" being the last result.

        id is the bug we are looking to find a duplicate for. The result will
        never contain id, to avoid marking a bug as a duplicate of itself if a
        bug is reprocessed more than once.
        zQSELECT crash_id, fixed_version FROM crashes WHERE signature = ? AND crash_id <> ?cSsr|d
}|
d
}
||
krdS|dkr4|
dkr0dSd
S|
dkrL|dkrHd
SdS|dkrXd
S|
dkrddStj
�||
�S)Nr2r
�r3)r<r=r>)�
x�
yr
r
r�cmp�
s"














z6CrashDatabase._duplicate_search_signature.<locals>.cmpr
�
3)
�key)
rq)	rr$r%rr'�sysr[�sortr)rrFrEr,rGrqr
r
rr7�
s



z)CrashDatabase._duplicate_search_signaturecCsP|
sd
S|j�
�}|�d|
g
�
|��}t|�
dk
s8t�
|rH|ddSd
Sd
S)z]Return ID for crash address signature.

        Return None if signature is unknown.
        Nz<SELECT crash_id FROM address_signatures WHERE signature == ?r2r
)rr$r%r'�lenr)rrFr,Zexisting_idsr
r
rrA�
s





z1CrashDatabase._duplicate_search_address_signatureFcCs\|jst
d
�
�
i}|j��}|�d�

|D],\}}}}|
rJ|||f||<q*||f||<q*|S)aY
Return the entire duplicate database as a dictionary.

        The returned dictionary maps "signature" to (crash_id, fixed_version)
        pairs.

        If with_timestamps is True, then the map will contain triples
        (crash_id, fixed_version, last_change) instead.

        This is mainly useful for debugging and test suites.
        r0zSELECT * FROM crashes)rrr$r%)rZwith_timestamps�dumpr,rFrEZverZlast_changer
r
r�_duplicate_db_dump�
s







z CrashDatabase._duplicate_db_dumpcCs�|jst
d
�
�
|j��}|�d|
g
�
|��}|s6dS|d}|�|
�
}|dkrjtd|
�

|�|
�

dS|s�|r�td|
|f�

|�|
|�
dS|r�|s�td|
|f�

|�|
|�
dSdS)	a
Update the duplicate db to the reality of the report in the crash db.

        This uses get_fixed_version() to get the status of the given crash.
        An invalid ID gets removed from the duplicate db, and a crash which got
        fixed is marked as such in the database.
        r0z4SELECT fixed_version FROM crashes WHERE crash_id = ?Nr
Zinvalidz5DEBUG: bug %i was invalidated, removing from databasez8DEBUG: bug %i got fixed in version %s, updating databasezCDEBUG: bug %i got reopened, dropping fixed version %s from database)	rrr$r%r)�get_fixed_versionr*r`r])rrEr,Zdb_fixed_versionZreal_fixed_versionr
r
rr8s(
















z'CrashDatabase._duplicate_db_sync_statuscCsV|�|
�
}|r*||krRt
d
||
|f�
�
n(|j��}|�dt|
�
|f�
|j��
dS)NzIID %i has signature %s, but database already has that signature for ID %iz,INSERT INTO address_signatures VALUES (?, ?))rAr(rr$r%rr&)rrFrErGr,r
r
rrD/s




�



z1CrashDatabase._duplicate_db_add_address_signaturecCsD|jst
d
�
�
|j��}|�d|
g
�
|�d||
g�
|j��
dS)z�Merge two crash IDs.

        This is necessary when having to mark a bug as a duplicate if it
        already is in the duplicate DB.
        r0r^raNr_)r�dup�masterr,r
r
rrC;s



�z$CrashDatabase._duplicate_db_merge_idcCs`d
|
krdS|
�dd�d}d�
|�dd�dd��
}|�d	d�}t|�d
�
�
}|dd�}|S)z5Create a www/URL proof hash for a duplicate signature�

N�
 r2r
rH�
:��
/r��)r9rM�replacerrh)�klassrF�
ir
r
rrLIs


z CrashDatabase.duplicate_sig_hashcCstd
�
�
dS)a�Upload given problem report return a handle for it.

        This should happen noninteractively.

        If the implementation supports it, and a function progress_callback is
        passed, that is called repeatedly with two arguments: the number of
        bytes already sent, and the total number of bytes to send. This can be
        used to provide a proper upload progress indication on frontends.

        Implementations ought to "assert self.accepts(report)". The UI logic
        already prevents uploading a report to a database which does not accept
        it, but for third-party users of the API this should still be checked.

        This method can raise a NeedsCredentials exception in case of failure.
        �6this method must be implemented by a concrete subclassN�
�NotImplementedError)rrZprogress_callbackr
r
r�uploadaszCrashDatabase.uploadcCstd
�
�
dS)a8
Return an URL that should be opened after report has been uploaded
        and upload() returned handle.

        Should return None if no URL should be opened (anonymous filing without
        user comments); in that case this function should do whichever
        interactive steps it wants to perform.
        r�Nr�)rrZhandler
r
r�get_comment_urlsszCrashDatabase.get_comment_urlcCstd
�
�
dS)z�Return URL for a given report ID.

        The report is passed in case building the URL needs additional
        information from it, such as the SourcePackage name.

        Return None if URL is not available or cannot be determined.
        r�Nr�)rrrEr
r
rrT}szCrashDatabase.get_id_urlcCstd
�
�
dS)z>Download the problem report from given ID and return a Report.r�Nr��rrEr
r
rr4�szCrashDatabase.downloadcCstd
�
�
dS)ahUpdate the given report ID with all data from report.

        This creates a text comment with the "short" data (see
        ProblemReport.write_mime()), and creates attachments for all the
        bulk/binary data.

        If change_description is True, and the crash db implementation supports
        it, the short data will be put into the description instead (like in a
        new bug).

        comment will be added to the "short" data. If attachment_comment is
        given, it will be added to the attachment uploads.

        If key_filter is a list or set, then only those keys will be added.
        r�Nr�)rrEr�commentZchange_descriptionZattachment_comment�
key_filterr
r
r�update�szCrashDatabase.updaterncCs|j|
||d
dddgd�
dS)z�Update the given report ID for retracing results.

        This updates Stacktrace, ThreadStacktrace, StacktraceTop,
        and StacktraceSource. You can also supply an additional comment.
        Z
StacktraceZThreadStacktraceZStacktraceSourceZ
StacktraceTop)
r�N)
r�)rrErr�r
r
r�
update_traces�s

�zCrashDatabase.update_tracescCstd
�
�
dS)zSet username and password.r�Nr�)rZusernameZpasswordr
r
r�set_credentials�szCrashDatabase.set_credentialscCstd
�
�
dS)z2Get 'DistroRelease: <release>' from the report ID.r�Nr�r�r
r
r�get_distro_release�sz CrashDatabase.get_distro_releasec

Cstd
�
�
dS)z�Return set of crash IDs which have not been retraced yet.

        This should only include crashes which match the current host
        architecture.
        r�Nr�rr
r
r�get_unretraced�szCrashDatabase.get_unretracedc

Cstd
�
�
dS)a
Return set of crash IDs which need duplicate checking.

        This is mainly useful for crashes of scripting languages such as
        Python, since they do not need to be retraced. It should not return
        bugs that are covered by get_unretraced().
        r�Nr�rr
r
r�get_dup_unchecked�szCrashDatabase.get_dup_uncheckedc

Cstd
�
�
dS)aX
Return an ID set of all crashes which are not yet fixed.

        The list must not contain bugs which were rejected or duplicate.

        This function should make sure that the returned list is correct. If
        there are any errors with connecting to the crash database, it should
        raise an exception (preferably IOError).
        r�Nr�rr
r
r�get_unfixed�s	zCrashDatabase.get_unfixedcCstd
�
�
dS)aReturn the package version that fixes a given crash.

        Return None if the crash is not yet fixed, or an empty string if the
        crash is fixed, but it cannot be determined by which version. Return
        'invalid' if the crash report got invalidated, such as closed a
        duplicate or rejected.

        This function should make sure that the returned result is correct. If
        there are any errors with connecting to the crash database, it should
        raise an exception (preferably IOError).
        r�Nr�r�r
r
rry�szCrashDatabase.get_fixed_versioncCstd
�
�
dS)z5Return list of affected source packages for given ID.r�Nr�r�r
r
r�get_affected_packages�sz#CrashDatabase.get_affected_packagescCstd
�
�
dS)z3Check whether the user is the reporter of given ID.r�Nr�r�r
r
r�is_reporter�szCrashDatabase.is_reportercCstd
�
�
dS)aB
Check whether the user is eligible to update a report.

        A user should add additional information to an existing ID if (s)he is
        the reporter or subscribed, the bug is open, not a duplicate, etc. The
        exact policy and checks should be done according to  the particular
        implementation.
        r�Nr�r�r
r
r�
can_update�szCrashDatabase.can_updatecCstd
�
�
dS)zcReturn master ID for a duplicate bug.

        If the bug is not a duplicate, return None.
        r�Nr�r�r
r
r�duplicate_of�szCrashDatabase.duplicate_ofcCstd
�
�
dS)zlMark a crash id as duplicate of given master ID.

        If master is None, id gets un-duplicated.
        r�Nr�)rrrEr{r
r
rrB�szCrashDatabase.close_duplicatecCstd
�
�
dS)zpMark a crash id as reintroducing an earlier crash which is
        already marked as fixed (having ID 'master').r�Nr�)rrEr{r
r
rr?�szCrashDatabase.mark_regressioncCstd
�
�
dS)zMark crash id as retraced.r�Nr�r�r
r
r�
mark_retracedszCrashDatabase.mark_retracedcCstd
�
�
dS)z�Mark crash id as 'failed to retrace'.

        If invalid_msg is given, the bug should be closed as invalid with given
        message, otherwise just marked as a failed retrace.

        This can be a no-op if you are not interested in this.
        r�Nr�)rrEZinvalid_msgr
r
r�mark_retrace_failed	sz!CrashDatabase.mark_retrace_failedcCstd
�
�
dS)z�Mark crash id as checked for being a duplicate

        This is an internal method that should not be called from outside.
        r�Nr�)rrErr
r
rr5szCrashDatabase._mark_dup_checked)
N)
F)
N)FNN)
rn)
N)+�__name__�
__module__�__qualname__rrrr/rIrZr]r`rbrmr+r7rArxr8rDrC�classmethodrLr�r�rTr4r�r�r�r�r�r�r�ryr�r�r�r�rBr?r�r�r5r
r
r
rr%sV
9
fGN-
$





�

		


rc	Cs
|stj
�d
d�}i}t|�
�}tt|��|d�|�
W5QRX|d}tj�|�
r�t�	|�
D]�}tj�
||�}tj�|�
r^|�d�
r^z2t|�
� }tt|��|d�|d�
W5QRXWq^t
k
r�
}
ztj�d|t|�
f�

W5d}~XYq^Xq^|
�
s|d	}
t||d|
�S)
aNReturn a CrashDatabase object for the given crash db name.

    This reads the configuration file 'conf'.

    If name is None, it defaults to the 'default' value in conf.

    If conf is None, it defaults to the environment variable
    APPORT_CRASHDB_CONF; if that does not exist, the hardcoded default is
    /etc/apport/crashdb.conf. This Python syntax file needs to specify:

    - A string variable 'default', giving a default value for 'name' if that is
      None.

    - A dictionary 'databases' which maps names to crash db configuration
      dictionaries. These need to have at least the key 'impl' (Python module
      in apport.crashdb_impl which contains a concrete 'CrashDatabase' class
      implementation for that crash db type). Other generally known options are
      'bug_pattern_url', 'dupdb_url', and 'problem_types'.
    ZAPPORT_CRASHDB_CONFz/etc/apport/crashdb.conf�execz.dz.confZ	databaseszInvalid file %s: %s
N�default)r �environrrfr��compilerNr!�isdir�listdirrM�isfile�endswithrrt�stderrrgr�load_crashdb)	r�name�confZsettingsrVZconfdDirZcfZcfpathr.r
r
r�get_crashdbs&




 







(


r�cCs(td
|
dt
�t�dg
�}|�||
�S)z�Return a CrashDatabase object for a given DB specification.

    spec is a crash db configuration dictionary as described in get_crashdb().
    zapport.crashdb_impl.�implr)�
__import__�globals�localsr)r�spec�
mr
r
rr�Ms
r�c
@seZ
dZd
ZdS)�NeedsCredentialsz8This may be raised when unable to log in to the crashdb.N)r�r�r��__doc__r
r
r
rr�Vs

r�)NN)r�r �os.pathrtrj�
exceptionsrZurllibrrrPr�ImportError�	functoolsrZurllib.parseZurllib.requestZurllib.errorr<rrr�r�r�r
r
r
r�<module>
s. 








.