__init__

ExamplePostgresWrapper.__init__(*args, **kwargs)[source]

Initialise the database wrapper class.

Parameters

  • db (str) – Database name

  • db_user (str) – Account username with permission for db (defaults to root)

  • db_pass (str) – Account password for db_user (defaults to None)

  • db_host (str) – Database host (defaults to unix socket)

Key str db_schema

(Default: 'public') Schema used for querying table existence

Key str query_mode

Either 'flat' (query returns tuples) or 'dict' (query returns dicts). More details in PyDoc block under query_mode

Key psycopg2.extensions.cursor cursor_cls

If necessary, you may override the Psycopg2 cursor class used by specifying this kwarg. If this isn’t specified, cursor_cls will default to either psycopg2.extras.RealDictCursor if query_mode is dict, or psycopg2.extras.NamedTupleCursor if query_mode is flat.