Package backend :: Package server :: Package rhnSQL :: Module driver_postgresql

[frames] | no frames]

Module driver_postgresql

Classes

Function
Function implementation for PostgreSQL.

Procedure
PostgreSQL functions are somewhat different than stored procedures in other databases.

Database
Class for PostgreSQL database operations.

Cursor
PostgreSQL specific wrapper over sql_base.Cursor.

Functions

convert_named_query_params(query)
Convert a query with named parameters (i.e.

source code

decimal2intfloat(dec, cursor)
Convert a Decimal to an int or a float with no loss of information.

source code

Function Details

convert_named_query_params(query)

Convert a query with named parameters (i.e. :id, :name, etc) into one that uses %(id)s, %(name)s parameters instead.

python-psycopg2 requires parameters to be in this form, so to keep our existing queries intact we'll convert them when provided to the postgresql driver.

RETURNS: the new query with parameters replaced