<!-- $Header: /cvsroot/pgsql/doc/src/sgml/Attic/pygresql.sgml,v 1.8 2002/09/23 23:20:38 tgl Exp $ -->

<!-- $Header: /cvsroot/pgsql/doc/src/sgml/Attic/pygresql.sgml,v 1.9 2002/12/12 22:49:27 momjian Exp $ -->

<chapter id="pygresql">

<title><application>PyGreSQL</application> - <application>Python</application> Interface</title>

<title>Database Wrapper Class: <classname>DB</classname></title>

<para>

<classname>pg</classname> module contains a class called

<classname>DB</classname>. All <classname>pgobject</classname>

methods are included in this class also. A number of additional

<classname>DB</classname> class methods are described below. The

preferred way to use this module is as follows (See description of

the initialization method below.):

The <literal>pg</literal> module contains a class called

<classname>DB</classname> wrapping a <classname>pgobject</classname>.

This <classname>pgobject</classname> can be addressed as a

<classname>DB</classname> class member named <varname>db</varname>

to get access to the read-only attributes of the corresponding connection

(e.g. <varname>db.error</varname>). All <classname>pgobject</classname>

methods (e.g. <function>query()</function>) are directly included as members

in the class <classname>DB</classname> also. A number of additional

higher level <classname>DB</classname> class methods are described below.

The preferred way to use this module is as follows (see description of the

initialization method below):

<programlisting>

import pg

def__init__(self,*args,**kw):

self.db=apply(connect,args,kw)

forein ('query','reset','close','getnotify','inserttable',

'putline','getline','endcopy',

'host','port','db','options',

'tty','error','status','user',

'locreate','getlo','loimport' ):

ifnothasattr(self,e)andhasattr(self.db,e):

exec'self.%s = self.db.%s'% (e,e )

foreinself.db.__methods__:

setattr(self,e,getattr(self.db,e))

self.__attnames__= {}

self.__pkeys__= {}