skip to navigation
skip to content

psycopgwrap 1.05

A wrapper around psycopg2 to make common things easier.

Here are a few of the features:

Query results can be accessed as a dictionary of columns.

Queries return indexable iterators with dictionary syntax, so you can do things like "for row in query", and "query(cmd)[0]". Note that indexes can only be larger than or equal to the last index.

Query arguments are passed as discrete arguments, not as a tuple. Passing as a tuple always makes me want to do a "%" and if I accidentally do that it can open up a SQL injection.

There's an "insert" helper that takes a table name and keyword arguments. Similarly there's a "dictinsert" helper that takes a dictionary of row:values.