§
    	^µc›&  ã                   ó    — d dl Z d dlZd dlZd dlZd dlZddlmZ d„ Z G d„ dej        ¦  «        Z	 G d„ dej
        j        j        ¦  «        ZdS )	é    Né   )Úindexapic                 ó¢   — |                       dd¦  «        } |                       dd¦  «        } |                      d¦  «        r| d d…         dz   } | S )Nó   _s   \_ó   %s   \%ó   *éÿÿÿÿ)ÚreplaceÚendswith)Úpatterns    ú@/usr/lib/python3/dist-packages/hgext/infinitepush/sqlindexapi.pyÚ_convertbookmarkpatternr      sU   € Ø�oŠo˜d FÑ+Ô+€GØ�oŠo˜d FÑ+Ô+€GØ×Ò˜ÑÔð &Ø˜#˜2˜#”, Ñ%ˆØ€Nó    c                   óp   ‡ — e Zd ZdZ	 	 dˆ f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ˆ xZS )Úsqlindexapiz<
    Sql backend for infinitepush index. See schema.sql
    é,  éx   c                 ón  •— t          t          | ¦  «                             ¦   «          || _        |||||dœ| _        d | _        d | _        |st          j        }t          j
        |¬¦  «         t          j        ¦   «         | _        | j                             |¦  «         d| _        |	| _        |
| _        d S )N)s   hosts   ports   databases   users   password)ÚfilenameF)Úsuperr   Ú__init__ÚreponameÚsqlargsÚsqlconnÚ	sqlcursorÚosÚdevnullÚloggingÚbasicConfigÚ	getLoggerÚlogÚsetLevelÚ
_connectedÚ_waittimeoutÚ_locktimeout)Úselfr   ÚhostÚportÚdatabaseÚuserÚpasswordÚlogfileÚloglevelÚwaittimeoutÚlocktimeoutÚ	__class__s              €r   r   zsqlindexapi.__init__    s»   ø€ õ 	�k˜4Ñ Ô ×)Ò)Ñ+Ô+Ð+Ø ˆŒàØØ!ØØ!ð
ð 
ˆŒð ˆŒØˆŒØð 	!Ý”jˆGÝÔ WÐ-Ñ-Ô-Ð-ÝÔ$Ñ&Ô&ˆŒØŒ×Ò˜(Ñ#Ô#Ð#ØˆŒØ'ˆÔØ'ˆÔÐÐr   c                 ó¨  — | j         rt          j        d¦  «        ‚| j        rt          j        d¦  «        ‚d}	 	 t	          j        j        di | j        ¤Ž| _         | j                              t          ¦  «         d| j         _
        n@# t          j        j        j        $ r# |dz  }|dk    r‚ t          j        d¦  «         Y nw xY wŒ�| j         j                             d	| j        z  ¦  «        }| j                              ¦   «         | _        | j                             d
|z  ¦  «         | j                             d| j        z  ¦  «         d| _        d S )Ns   SQL connection already opens*   SQL cursor already open without connectioné   TFr   r   gš™™™™™É?s   %ss   SET wait_timeout=%ss   SET innodb_lock_wait_timeout=%s© )r   r   Úindexexceptionr   ÚmysqlÚ	connectorÚconnectr   Úset_converter_classÚCustomConverterÚ
autocommitÚerrorsÚErrorÚtimeÚsleepÚ	converterÚescaper$   ÚcursorÚexecuter%   r#   )r&   Úretryr.   s      r   Ú
sqlconnectzsqlindexapi.sqlconnectA   sh  € ØŒ<ð 	JÝÔ)Ð*HÑIÔIÐIØŒ>ð 	ÝÔ)Ø=ñô ð ð ˆð	 ð Ý$œÔ6ÐFÐF¸¼ÐFÐF�”ð ”×0Ò0µÑAÔAÐAØ*/�”Ô'ØøÝ”?Ô)Ô/ð  ð  ð  ð ˜‘
�Ø˜A’:�:ØÝ”
˜3‘”���ð øøøð	 ð& ”lÔ,×3Ò3°E¸DÔ<MÑ4MÑNÔNˆàœ×,Ò,Ñ.Ô.ˆŒØŒ×ÒÐ5¸ÑCÑDÔDÐDØŒ×ÒØ.°Ô1BÑBñ	
ô 	
ð 	
ð ˆŒˆˆs   »AB Â9CÃCc                 ó  — t          j        ¦   «         5  t          j        d¦  «         | j                             ¦   «          | j                             ¦   «          ddd¦  «         n# 1 swxY w Y   d| _        d| _        dS )z(Cleans up the metadata store connection.s   ignoreN)ÚwarningsÚcatch_warningsÚsimplefilterr   Úcloser   ©r&   s    r   rI   zsqlindexapi.closee   s³   € åÔ$Ñ&Ô&ð 	!ð 	!ÝÔ! )Ñ,Ô,Ð,ØŒN× Ò Ñ"Ô"Ð"ØŒL×ÒÑ Ô Ð ð	!ð 	!ð 	!ñ 	!ô 	!ð 	!ð 	!ð 	!ð 	!ð 	!ð 	!øøøð 	!ð 	!ð 	!ð 	!ð ˆŒØˆŒˆˆs   ”AA'Á'A+Á.A+c                 ó<   — | j         s|                      ¦   «          | S ©N)r#   rD   rJ   s    r   Ú	__enter__zsqlindexapi.__enter__n   s!   € ØŒð 	Ø�OŠOÑÔÐØˆr   c                 ór   — |€| j                              ¦   «          d S | j                              ¦   «          d S rL   )r   ÚcommitÚrollback)r&   Úexc_typeÚexc_valÚexc_tbs       r   Ú__exit__zsqlindexapi.__exit__s   s<   € ØÐØŒL×ÒÑ!Ô!Ð!Ð!Ð!àŒL×!Ò!Ñ#Ô#Ð#Ð#Ð#r   c                 ó¤  — | j         s|                      ¦   «          | j                             d| j        |fz  ¦  «         | j                             d|| j        f¬¦  «         |D �]i}| j                             d|                     ¦   «         || j        f¬¦  «         |                     ¦   «         }| 	                    ¦   «         }| 
                    d| 	                    ¦   «         ¦  «        }t          |                     ¦   «         d         ¦  «        }t          | 
                    d|¦  «        ¦  «        }| j                             d|                     ¦   «         |                     ¦   «         |                     ¦   «                              ¦   «         |                     ¦   «                              ¦   «         ||||| j        f	¬¦  «         �Œkd S )	Ns   ADD BUNDLE %r %rs5   INSERT INTO bundles(bundle, reponame) VALUES (%s, %s)©Úparamsss   INSERT INTO nodestobundle(node, bundle, reponame) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE bundle=VALUES(bundle)s	   committerr   s   committer_dates�   INSERT IGNORE INTO nodesmetadata(node, message, p1, p2, author, committer, author_date, committer_date, reponame) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s))r#   rD   r!   Úinfor   r   rB   ÚhexÚextrar*   ÚgetÚintÚdateÚdescriptionÚp1Úp2)	r&   ÚbundleidÚnodesctxÚctxrZ   Úauthor_nameÚcommitter_nameÚauthor_dateÚcommitter_dates	            r   Ú	addbundlezsqlindexapi.addbundley   s©  € ØŒð 	Ø�OŠOÑÔÐØŒ�ŠÐ)¨T¬]¸HÐ,EÑEÑFÔFÐFØŒ×ÒØDØ˜dœmÐ,ð 	ñ 	
ô 	
ð 	
ð ð 	ñ 	ˆCØŒN×"Ò"ð)ð Ÿš™	œ	 8¨T¬]Ð;ð	 #ñ ô ð ð —I’I‘K”KˆEØŸ(š(™*œ*ˆKØ"ŸYšY |°S·X²X±Z´ZÑ@Ô@ˆNÝ˜cŸhšh™jœj¨œmÑ,Ô,ˆKÝ  §¢Ð+<¸kÑ!JÔ!JÑKÔKˆNØŒN×"Ò"ð8ð
 —G’G‘I”IØ—O’OÑ%Ô%Ø—F’F‘H”H—L’L‘N”NØ—F’F‘H”H—L’L‘N”NØØ"ØØ"Ø”Mð
ð #ñ ô ð ñ ð	ð 	r   c                 óÎ   — | j         s|                      ¦   «          | j                             d| j        ||fz  ¦  «         | j                             d||| j        f¬¦  «         dS )zRTakes a bookmark name and hash, and records mapping in the metadata
        store.s&   ADD BOOKMARKS %r bookmark: %r node: %rss   INSERT INTO bookmarkstonode(bookmark, node, reponame) VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE node=VALUES(node)rV   N©r#   rD   r!   rX   r   r   rB   )r&   ÚbookmarkÚnodes      r   Úaddbookmarkzsqlindexapi.addbookmark    s‡   € ð Œð 	Ø�OŠOÑÔÐØŒ�ŠØ5ØŒ}˜h¨Ð-ñ.ñ	
ô 	
ð 	
ð 	Œ×ÒðMà˜d D¤MÐ2ð 	ñ 	
ô 	
ð 	
ð 	
ð 	
r   c                 óD  — | j         s|                      ¦   «          g }g }|                     ¦   «         D ]7\  }}|                     d¦  «         |                     ||| j        f¦  «         Œ8d                     |¦  «        }| j                             d|z  |¬¦  «         d S )Ns   (%s, %s, %s)ó   ,si   INSERT INTO bookmarkstonode(bookmark, node, reponame) VALUES %s ON DUPLICATE KEY UPDATE node=VALUES(node)rV   )	r#   rD   ÚitemsÚappendÚextendr   Újoinr   rB   )r&   Ú	bookmarksÚargsÚvaluesrk   rl   s         r   Úaddmanybookmarkszsqlindexapi.addmanybookmarks¯   s½   € ØŒð 	Ø�OŠOÑÔÐØˆØˆØ'ŸošoÑ/Ô/ð 	;ð 	;‰NˆH�dØ�KŠK˜Ñ(Ô(Ð(Ø�MŠM˜8 T¨4¬=Ð9Ñ:Ô:Ð:Ð:Ø�yŠy˜‰ŒˆàŒ×ÒðCØEIñJàð 	ñ 	
ô 	
ð 	
ð 	
ð 	
r   c                 óä   — | j         s|                      ¦   «          | j                             d|z  ¦  «         |D ]4}t	          |¦  «        }| j                             d|| j        f¬¦  «         Œ5dS )zÈAccepts list of bookmark patterns and deletes them.
        If `commit` is set then bookmark will actually be deleted. Otherwise
        deletion will be delayed until the end of transaction.
        s   DELETE BOOKMARKS: %ssF   DELETE from bookmarkstonode WHERE bookmark LIKE (%s) and reponame = %srV   N)r#   rD   r!   rX   r   r   rB   r   )r&   Úpatternsr   s      r   Údeletebookmarkszsqlindexapi.deletebookmarks¿   s‘   € ð
 Œð 	Ø�OŠOÑÔÐØŒ�ŠÐ-°Ñ8Ñ9Ô9Ð9Øð 	ð 	ˆGÝ-¨gÑ6Ô6ˆGØŒN×"Ò"ð%à ¤Ð/ð #ñ ô ð ð ð	ð 	r   c                 óâ  — | j         s|                      ¦   «          | j                             d| j        |fz  ¦  «         | j                             d|| j        f¬¦  «         | j                             ¦   «         }t          |¦  «        dk    st          |d         ¦  «        dk    r| j                             d¦  «         dS |d         d         }| j                             d|z  ¦  «         |S )	zAReturns the bundleid for the bundle that contains the given node.s   GET BUNDLE %r %rsB   SELECT bundle from nodestobundle WHERE node = %s AND reponame = %srV   r   r   s   No matching nodeNs   Found bundle %r©	r#   rD   r!   rX   r   r   rB   ÚfetchallÚlen)r&   rl   ÚresultÚbundles       r   Ú	getbundlezsqlindexapi.getbundleÏ   së   € àŒð 	Ø�OŠOÑÔÐØŒ�ŠÐ)¨T¬]¸DÐ,AÑAÑBÔBÐBØŒ×Òð1à˜$œ-Ð(ð 	ñ 	
ô 	
ð 	
ð
 ”×(Ò(Ñ*Ô*ˆÝˆv‰;Œ;˜!ÒÐ�s 6¨!¤9™~œ~°Ò2Ð2ØŒH�MŠMÐ-Ñ.Ô.Ð.Ø�4Ø˜”˜1”ˆØŒ�ŠÐ(¨6Ñ1Ñ2Ô2Ð2Øˆr   c                 óâ  — | j         s|                      ¦   «          | j                             d| j        |fz  ¦  «         | j                             d|| j        f¬¦  «         | j                             ¦   «         }t          |¦  «        dk    st          |d         ¦  «        dk    r| j                             d¦  «         dS |d         d         }| j                             d|z  ¦  «         |S )	zBReturns the node for the given bookmark. None if it doesn't exist.s"   GET NODE reponame: %r bookmark: %rsF   SELECT node from bookmarkstonode WHERE bookmark = %s AND reponame = %srV   r   r   s   No matching bookmarkNs   Found node %rr|   )r&   rk   r   rl   s       r   Úgetnodezsqlindexapi.getnodeá   só   € àŒð 	Ø�OŠOÑÔÐØŒ�ŠØ1°T´]ÀHÐ4MÑMñ	
ô 	
ð 	
ð 	Œ×Òð/à˜dœmÐ,ð 	ñ 	
ô 	
ð 	
ð
 ”×(Ò(Ñ*Ô*ˆÝˆv‰;Œ;˜!ÒÐ�s 6¨!¤9™~œ~°Ò2Ð2ØŒH�MŠMÐ1Ñ2Ô2Ð2Ø�4Ø�aŒy˜Œ|ˆØŒ�ŠÐ&¨Ñ-Ñ.Ô.Ð.Øˆr   c                 ó¬  — | j         s|                      ¦   «          | j                             d| j        |fz  ¦  «         t          |¦  «        }| j                             d| j        |f¬¦  «         | j                             ¦   «         }i }|D ]D}t          |¦  «        dk    r| j                             d|z  ¦  «         Œ3|d         ||d         <   ŒE|S )Ns&   QUERY BOOKMARKS reponame: %r query: %rsS   SELECT bookmark, node from bookmarkstonode WHERE reponame = %s AND bookmark LIKE %srV   é   s   Bad row returned: %sr   r   )
r#   rD   r!   rX   r   r   r   rB   r}   r~   )r&   Úqueryr   rt   Úrows        r   Úgetbookmarkszsqlindexapi.getbookmarksõ   sð   € ØŒð 	Ø�OŠOÑÔÐØŒ�ŠØ5¸¼ÈÐ8NÑNñ	
ô 	
ð 	
õ (¨Ñ.Ô.ˆØŒ×Òð2à”M 5Ð)ð 	ñ 	
ô 	
ð 	
ð
 ”×(Ò(Ñ*Ô*ˆØˆ	Øð 	'ð 	'ˆCÝ�3‰xŒx˜1Š}ˆ}Ø”—’Ð5¸Ñ;Ñ<Ô<Ð<ØØ # A¤ˆI�c˜!”fÑÐØÐr   c                 óÎ   — | j         s|                      ¦   «          | j                             d| j        ||fz  ¦  «         | j                             d|| j        |f¬¦  «         d S )NsH   INSERT METADATA, QUERY BOOKMARKS reponame: %r node: %r, jsonmetadata: %ssP   UPDATE nodesmetadata SET optional_json_metadata=%s WHERE reponame=%s AND node=%srV   rj   )r&   rl   Újsonmetadatas      r   Úsaveoptionaljsonmetadataz$sqlindexapi.saveoptionaljsonmetadata
  sˆ   € ØŒð 	Ø�OŠOÑÔÐØŒ�Šð0ð Œ}˜d LÐ1ñ	2ñ	
ô 	
ð 	
ð 	Œ×Òð'à  $¤-°Ð6ð 	ñ 	
ô 	
ð 	
ð 	
ð 	
r   )r   r   )Ú__name__Ú
__module__Ú__qualname__Ú__doc__r   rD   rI   rM   rT   rh   rm   rw   rz   r�   rƒ   rˆ   r‹   Ú__classcell__)r0   s   @r   r   r      s  ø€ € € € € ðð ð Øð(ð (ð (ð (ð (ð (ðB"ð "ð "ðHð ð ðð ð ð
$ð $ð $ð%ð %ð %ðN
ð 
ð 
ð
ð 
ð 
ð ð ð ð ð ð ð$ð ð ð(ð ð ð*
ð 
ð 
ð 
ð 
ð 
ð 
r   r   c                   ó*   — e Zd ZdZdd„Zdd„Zdd„ZdS )r9   ziEnsure that all values being returned are returned as python string
    (versus the default byte arrays).Nc                 ó    — t          |¦  «        S rL   ©Ústr©r&   ÚvalueÚdscs      r   Ú_STRING_to_pythonz!CustomConverter._STRING_to_python   ó   € Ý�5‰zŒzÐr   c                 ó    — t          |¦  «        S rL   r“   r•   s      r   Ú_VAR_STRING_to_pythonz%CustomConverter._VAR_STRING_to_python#  r™   r   c                 ó    — t          |¦  «        S rL   r“   r•   s      r   Ú_BLOB_to_pythonzCustomConverter._BLOB_to_python&  r™   r   rL   )rŒ   r�   rŽ   r�   r˜   r›   r�   r3   r   r   r9   r9     sZ   € € € € € ð)ð )ðð ð ð ðð ð ð ðð ð ð ð ð r   r9   )r   r   r=   rF   Úmysql.connectorr5   Ú r   r   r   r6   Ú
conversionÚMySQLConverterr9   r3   r   r   ú<module>r¢      sÊ   ðð €€€Ø 	€	€	€	Ø €€€à €€€Ø Ð Ð Ð à Ð Ð Ð Ð Ð ðð ð ð~
ð ~
ð ~
ð ~
ð ~
�(Ô#ñ ~
ô ~
ð ~
ðBð ð ð ð �e”oÔ0Ô?ñ ô ð ð ð r   