ó N_c@s·dZyddlZWnek r5ddlZnXdefd„ƒYZdddd„Zd „Zdd „Z dd „Z ej d d kr›e Z ne Z d„Z d„ZdS(s« utility functions to handle differences in pysqlite versions These are from Wichert Akkerman 's python-dhm http://www.wiggy.net/code/python-dhm iÿÿÿÿNt TokenizeErrorcBseZdZRS(sTokenizer error class(t__name__t __module__t__doc__(((s0/usr/lib/python2.7/site-packages/yum/sqlutils.pyRss s"s\cCs™|gddf\}}}}y,x%|rH|d|krCd}nø|dkrl|d|krl|d}nÏ|d|krÐ|dkr™||d7}q;|j|ƒd}xŒ|d|krÌ|d}q¯Wnk|d|kr|dkrù|d}n||d7}|d}n'|dkr-|d}n||d7}|d}q$WWntk rftd‚nX|rytd‚n|dkr•|j|ƒn|S(s–String tokenizer This function tokenizes a string while taking quotation and escaping into account. >>> import dhm.strtools >>> dhm.strtools.Tokenize("this is a test") ['this', 'is', 'a', 'test'] >>> dhm.strtools.Tokenize("this "is a" test") ['this', 'is a', 'test'] >>> dhm.strtools.Tokenize("this \"is\" a test") ['this', '"is"', 'a', 'test'] >>> dhm.strtools.Tokenize("this "is a test") Traceback (most recent call last): File "", line 1, in ? File "/usr/local/lib/python2.2/site-packages/dhm/strtools.py", line 80, in Tokenize raise TokenizeError, "Unexpected end of string in quoted text" dhm.strtools.TokenizeError: Unexecpted end of string in quoted text @param str: string to tokenize @type str: string @param whitespace: whitespace characters separating tokens @type whitespace: string @param quotes: legal quoting characters @type quotes: string @param escapes: characters which can escape quoting characters @type escapes: string @return: list of tokens @rtype: sequence of strings iisUnexpected end of strings'Unexpected end of string in quoted textN(tNonetappendt IndexErrorR(tstrt whitespacetquotestescapestbufferttokenstcurtokentquote((s0/usr/lib/python2.7/site-packages/yum/sqlutils.pytTokenizes<              c Cst|ddƒ}g}d}x¨|D] }|jdƒr`|j|d d|ƒ|d7}q%|jdƒs~|jdƒr¸|d d|}||d7}|j|ƒ|d7}q%|j|ƒq%Wi}d}x&|D]}||d |<|d7}qÜWd j|ƒ|fS( sêConvert from qmark to pyformat parameter style. The python DB-API 2.0 specifies four different possible parameter styles that can be used by drivers. This function converts from the qmark style to pyformat style. @param query: SQL query to transform @type query: string @param params: arguments to query @type params: sequence of strings @return: converted query and parameters @rtype: tuple with the new command and a dictionary of arguments R t'it?iÿÿÿÿs %%(param%d)ss?,s?)iþÿÿÿsparam%dt (RtendswithRtjoin( tquerytparamsR toutputtcountttokentntokentdicttparam((s0/usr/lib/python2.7/site-packages/yum/sqlutils.pytQmarkToPyformatgs&     cCsJ|dkr|j|ƒS|jƒ}t||ƒ\}}|j||ƒS(sÐ Execute a python < 2.5 (external sqlite module) style query. @param cursor: A sqlite cursor @param query: The query to execute @param params: An optional list of parameters to the query N(RtexecutetstripR(tcursorRRtqtp((s0/usr/lib/python2.7/site-packages/yum/sqlutils.pytexecuteSQLPyFormats    cCs)|dkr|j|ƒS|j||ƒS(s¿ Execute a python 2.5 (sqlite3) style query. @param cursor: A sqlite cursor @param query: The query to execute @param params: An optional list of parameters to the query N(RR(R RR((s0/usr/lib/python2.7/site-packages/yum/sqlutils.pytexecuteSQLQmarks  iicCsgd}d|ksd|kr]d}|jddƒ}|jddƒ}|jddƒ}n||fS( s< Apply SQLite escaping, if needed. Returns pattern and esc. tt_t%s ESCAPE "!"t!s!!s!%s!_(treplace(tpatterntesc((s0/usr/lib/python2.7/site-packages/yum/sqlutils.pytsql_esc°scCstg}xg|D]_}d|kr#gSt|ƒ\}}|jddƒ}|jddƒ}|j||fƒq W|S(sZ Converts patterns to SQL LIKE format, if required (or gives up if not possible). t[t*R'RR&(R,R)R(tpatternstretR*R+((s0/usr/lib/python2.7/site-packages/yum/sqlutils.pyt sql_esc_globºs  (Rtsqlite3tsqlitet ImportErrort ExceptionRRRRR#R$t version_infot executeSQLR,R1(((s0/usr/lib/python2.7/site-packages/yum/sqlutils.pyts H &