Module sqlutils

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 "<stdin>", 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

Parameters:

• str (string) - string to tokenize
• whitespace (string) - whitespace characters seperating tokens
• quotes (string) - legal quoting characters
• escapes (string) - characters which can escape quoting characters

Returns: sequence of strings

list of tokens

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.

Parameters:

• query (string) - SQL query to transform
• params (sequence of strings) - arguments to query

Returns: tuple with the new command and a dictionary of arguments

converted query and parameters

Execute a python < 2.5 (external sqlite module) style query.

Parameters:

• cursor - A sqlite cursor
• query - The query to execute
• params - An optional list of parameters to the query

Execute a python 2.5 (sqlite3) style query.

Parameters:

• cursor - A sqlite cursor
• query - The query to execute
• params - An optional list of parameters to the query

Execute a python 2.5 (sqlite3) style query.

Parameters:

• cursor - A sqlite cursor
• query - The query to execute
• params - An optional list of parameters to the query

Apply SQLite escaping, if needed. Returns pattern and esc.