Home       Trees       Indices       Help   
Object Relational Membrane (v2)
Package orm2 :: Package adapters :: Package pgsql :: Module datasource :: Class zpsycopg_db_conn
[hide private]
[frames] | no frames]

Class zpsycopg_db_conn

source code

        sql.datasource --+        
                         |        
datasource.datasource_base --+    
                             |    
                    datasource --+
                                 |
                                zpsycopg_db_conn
Instance Methods [hide private]
  __init__(self, context, ds_name)
DSN - PostgreSLQ dsn it's basically a string like 'field1=value field2=value' fields are describe below (from the pgsql Programmer's Manual):
  _dbconn(self)
Return the dbconn for this ds
  execute(self, query, modify=False)
Run a query on the database connection.
  rollback(self)
Undo the changes you made to the database since the last commit()

Inherited from datasource: backend_encoding, backend_version, check_cast_handler, connect, dsn, select_after_insert_where

Inherited from datasource (private): _from_connection, _from_params

Inherited from datasource.datasource_base: close, commit, count, cursor, delete_by_primary_key, flush_updates, insert, join_select, primary_key_where, query_one, run_select, select, select_after_insert, select_by_primary_key, select_for_update, select_one, update, update_cursor

Inherited from sql.datasource: escape_string, identifyer_quotes, string_quotes


Static Methods [hide private]

Inherited from datasource: from_connection, from_params


Class Variables [hide private]

Inherited from datasource: encodings, escaped_chars

Inherited from datasource (private): _ERRORS_BEFORE_RECONNECT, _dbfailures

Inherited from datasource.datasource_base (private): _format_funcs


Method Details [hide private]

__init__(self, context, ds_name)
(Constructor)

source code 
DSN - PostgreSLQ dsn it's basically a string like 'field1=value field2=value' fields are describe below (from the pgsql Programmer's Manual):

host

Name of host to connect to. If this begins with a slash, it specifies Unix-domain communication rather than TCP/IP communication; the value bis the name of the directory in which the socket file is stored. The default is to connect to a Unix-domain socket in /tmp. hostaddr

IP address of host to connect to. This should be in standard numbers-and-dots form, as used by the BSD functions inet_aton et al. If a nonzero-length string is specified, TCP/IP communication is used.

Using hostaddr instead of host allows the application to avoid a host name look-up, which may be important in applications with time constraints. However, Kerberos authentication requires the host name. The following therefore applies. If host is specified without hostaddr, a host name lookup is forced. If hostaddr is specified without host, the value for hostaddr gives the remote address; if Kerberos is used, this causes a reverse name query. If both host and hostaddr are specified, the value for hostaddr gives the remote address; the value for host is ignored, unless Kerberos is used, in which case that value is used for Kerberos authentication. Note that authentication is likely to fail if libpq is passed a host name that is not the name of the machine at hostaddr.

Without either a host name or host address, libpq will connect using a local Unix domain socket. port

Port number to connect to at the server host, or socket file name extension for Unix-domain connections.

dbname

The database name.

user

User name to connect as.

password

Password to be used if the server demands password authentication.

options

Trace/debug options to be sent to the server.

tty

A file or tty for optional debug output from the backend.

requiressl

Set to 1 to require SSL connection to the backend. Libpq will then refuse to connect if the server does not support SSL. Set to 0 (default) to negotiate with server. example= 'host=localhost dbname=test user=test'
Overrides: datasource.__init__
(inherited documentation)

_dbconn(self)

source code 
Return the dbconn for this ds
Overrides: datasource.datasource_base._dbconn
(inherited documentation)

execute(self, query, modify=False)

source code 

Run a query on the database connection.

This function also performs failure accounting and will re-connect to the database if a certain threshold has passed.
Overrides: datasource.execute
(inherited documentation)

rollback(self)

source code 
Undo the changes you made to the database since the last commit()
Overrides: datasource.datasource_base.rollback

   Home       Trees       Indices       Help   
Object Relational Membrane (v2)
Generated by Epydoc 3.0alpha3 on Wed Feb 20 18:17:24 2008 http://epydoc.sourceforge.net