Joins multiple queries. >>> SQLQuery.join(['a', 'b'], ', ') <sql: 'a, b'> Optinally, prefix and suf

encodes session dict as a string

Add a row to the table Arguments: row - row of data, should be a list with as many elements as the table

Converts any given object to utf-8 encoded string. >>> safestr('hello') 'hello' >>> safestr(2) '2'

Update `tables` with clause `where` (interpolated using `vars`) and setting `values`. >>> db = DB(None, {})

decodes the data to get back the session dict

executes an sql query

Inserts `values` into `tablename`. Returns current sequence ID. Set `seqname` to the ID if it's not the default, or to `False`

r""" Splits the given text at newline. >>> splitline('foo\nbar') ('foo\n', 'bar') >>> splitline('foo')

Creates a database.

Prepare value of __body__ by joining parts.

Register a database. >>> class LegacyDB(DB): ... def __init__(self, **params): ... pass ...

Adds a processor to the application. >>> urls = ("/(.*)", "echo") >>> app = application(urls, globals()

Returns HTTPError with '404 not found' message

Execute SQL query `sql_query` using dictionary `vars` to interpolate it. If `processed=True`, `vars` is a `reparam`-style list to use

Converts the arguments for use in something like a WHERE clause. >>> sqllist(['a', 'b']) 'a, b' >>> sqllist('a')

Returns the values of the parameters used in the sql query. >>> q = SQLQuery(["SELECT * FROM test WHERE name=", SQLParam('joe')])

Returns a WSGI-compatible function for this application.

Ensures `a` is quoted properly for use in a SQL query. >>> 'WHERE x = ' + sqlquote(True) + ' AND y = ' + sqlquote(3) <sql: "

Return only those data rows that should be printed, based on slicing and sorting. Arguments: options - dictionar

Deletes from `table` with clauses `where` and `using`. >>> db = DB(None, {}) >>> name = 'Joe' >>

Import the first available driver or preferred driver.

Initializes ctx using env.

Converts a load hook into an application processor. >>> app = auto_application() >>> def f(): "something done before han

Opens the specified url.

Returns the query part of the sql query. >>> q = SQLQuery(["SELECT * FROM test WHERE name=", SQLParam('joe')]) >>> q.

r"""Reads one line from the text. Newline is supressed if the line ends with \. >>> readline = Parser().readline >

Takes a string and a dictionary and interpolates the string using values from the dictionary. Returns an `SQLQuery` for the result.

Runs a WSGI function as a FastCGI server.

r""" Converts any given object to unicode string. >>> safeunicode('hello') u'hello' >>> safeunicode(2) u'2'

Selects `what` from `tables` with clauses `where`, `order`, `group`, `limit`, and `offset`. Uses vars to interpolate. Other

Same as urllib.urlencode, but supports unicode strings. >>> urlencode({'text':'foo bar'}) 'text=foo+bar' >>> ur

Returns True if `port` is a valid IPv4 port. >>> validipport('9000') True >>> validipport('foo') False

Creates CherryPy WSGI server listening at `server_address` to serve `wsgi_app`. This function can be overwritten to customize the webserver or us