trunk/psycopg2/doc/api/private/psycopg2-module.html

   1 <?xml version="1.0" encoding="utf-8"?>\r
   2 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r
   3           "DTD/xhtml1-transitional.dtd">\r
   4 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r
   5 <head>\r
   6   <title>psycopg2</title>\r
   7   <link rel="stylesheet" href="epydoc.css" type="text/css" />\r
   8 <script type="text/javascript">\r
   9 <!--\r
  10 function setFrame(url1, url2){\r
  11     parent.frames[1].location.href = url1;\r
  12     parent.frames[2].location.href = url2;\r
  13 }\r
  14 -->\r
  15 </script>\r
  16 </head>\r
  17 <body bgcolor="white" text="black" link="blue" vlink="#204080"\r
  18       alink="#204080">\r
  19 \r
  20 <!-- =========== START OF NAVBAR =========== -->\r
  21 <table class="navbar" border="0" width="100%" cellpadding="0" bgcolor="#a0c0ff" cellspacing="0">\r
  22   <tr valign="middle">\r
  23     <th bgcolor="#70b0f0" class="navselect">&nbsp;&nbsp;&nbsp;Home&nbsp;&nbsp;&nbsp;</th>\r
  24     <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="trees.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>\r
  25     <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="indices.html">Index</a>&nbsp;&nbsp;&nbsp;</th>\r
  26     <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>\r
  27     <th class="navbar" width="100%"></th>\r
  28   </tr>\r
  29 </table>\r
  30 <table width="100%" cellpadding="0" cellspacing="0">\r
  31   <tr valign="top">\r
  32     <td width="100%">\r
  33       <span class="breadcrumbs">\r
  34         Package&nbsp;psycopg2\r
  35       </span><br />\r
  36     </td>\r
  37     <td><table cellpadding="0" cellspacing="0">\r
  38       <tr><td align="right"><span class="options">[show&nbsp;private&nbsp;|&nbsp;<a href="../public/psycopg2-module.html">hide&nbsp;private</a>]</span></td></tr>\r
  39       <tr><td align="right"><span class="options">[<a href="frames.html" target="_top">frames</a>&nbsp;|&nbsp;<a href="psycopg2-module.html" target="_top">no&nbsp;frames</a>]</span></td></tr>\r
  40     </table></td>\r
  41 </tr></table>\r
  42 \r
  43 <!-- =========== START OF PACKAGE DESCRIPTION =========== -->\r
  44 <h2 class="package">Package psycopg2</h2>\r
  45 \r
  46 <p>A Python driver for PostgreSQL</p>\r
  47 <p>psycopg is a <a class="reference" href="http://www.postgresql.org/">PostgreSQL</a> database adapter for the <a class="reference" href="http://www.python.org/">Python</a> programming\r
  48 language. This is version 2, a complete rewrite of the original code to\r
  49 provide new-style classes for connection and cursor objects and other sweet\r
  50 candies. Like the original, psycopg 2 was written with the aim of being very\r
  51 small and fast, and stable as a rock.</p>\r
  52 <p>Homepage: <a class="reference" href="http://initd.org/projects/psycopg2">http://initd.org/projects/psycopg2</a></p>\r
  53 <hr/>\r
  54 \r
  55 <!-- =========== START OF SUBMODULES =========== -->\r
  56 <table class="details" border="1" cellpadding="3" cellspacing="0" width="100%" bgcolor="white">\r
  57 <tr bgcolor="#70b0f0" class="details">\r
  58   <th colspan="2">Submodules</th></tr>\r
  59   <tr><td><ul>\r
  60 <li> <strong class="uidlink"><a href="psycopg2.extensions-module.html"><code>extensions</code></a></strong>: <em class="summary">psycopg extensions to the DBAPI-2.0</em></li>\r
  61 <li> <strong class="uidlink"><a href="psycopg2.extras-module.html"><code>extras</code></a></strong>: <em class="summary">Miscellaneous goodies for psycopg2</em></li>\r
  62 <li> <strong class="uidlink"><a href="psycopg2.pool-module.html"><code>pool</code></a></strong>: <em class="summary">Connection pooling for psycopg2</em></li>\r
  63 <li> <strong class="uidlink"><a href="psycopg2.psycopg1-module.html"><code>psycopg1</code></a></strong>: <em class="summary">psycopg 1.1.x compatibility module</em></li>\r
  64 <li> <strong class="uidlink"><a href="psycopg2.tz-module.html"><code>tz</code></a></strong>: <em class="summary">tzinfo implementations for psycopg2</em></li>\r
  65 <li> <strong class="uidlink"><a href="../private/psycopg2._psycopg-module.html"><code>_psycopg</code></a></strong>: <em class="summary">psycopg PostgreSQL driver</em></li>\r
  66   </ul></td></tr>\r
  67 </table><br />\r
  68 \r
  69 \r
  70 <!-- =========== START OF EXCEPTIONS =========== -->\r
  71 <table class="summary" border="1" cellpadding="3" cellspacing="0" width="100%" bgcolor="white">\r
  72 <tr bgcolor="#70b0f0" class="summary">\r
  73   <th colspan="2">Exceptions</th></tr>\r
  74 <tr><td width="15%">\r
  75   <strong><a href="psycopg2.DatabaseError-class.html"><code>DatabaseError</code></a></strong></td>\r
  76   <td>Error related to the database engine.</td></tr>\r
  77 <tr><td width="15%">\r
  78   <strong><a href="psycopg2.DataError-class.html"><code>DataError</code></a></strong></td>\r
  79   <td>Error related to problems with the processed data.</td></tr>\r
  80 <tr><td width="15%">\r
  81   <strong><a href="psycopg2.Error-class.html"><code>Error</code></a></strong></td>\r
  82   <td>Base class for error exceptions.</td></tr>\r
  83 <tr><td width="15%">\r
  84   <strong><a href="psycopg2.IntegrityError-class.html"><code>IntegrityError</code></a></strong></td>\r
  85   <td>Error related to database integrity.</td></tr>\r
  86 <tr><td width="15%">\r
  87   <strong><a href="psycopg2.InterfaceError-class.html"><code>InterfaceError</code></a></strong></td>\r
  88   <td>Error related to the database interface.</td></tr>\r
  89 <tr><td width="15%">\r
  90   <strong><a href="psycopg2.InternalError-class.html"><code>InternalError</code></a></strong></td>\r
  91   <td>The database encountered an internal error.</td></tr>\r
  92 <tr><td width="15%">\r
  93   <strong><a href="psycopg2.NotSupportedError-class.html"><code>NotSupportedError</code></a></strong></td>\r
  94   <td>A not supported datbase API was called.</td></tr>\r
  95 <tr><td width="15%">\r
  96   <strong><a href="psycopg2.OperationalError-class.html"><code>OperationalError</code></a></strong></td>\r
  97   <td>Error related to database operation (disconnect, memory allocation etc).</td></tr>\r
  98 <tr><td width="15%">\r
  99   <strong><a href="psycopg2.ProgrammingError-class.html"><code>ProgrammingError</code></a></strong></td>\r
 100   <td>Error related to database programming (SQL error, table not found etc).</td></tr>\r
 101 <tr><td width="15%">\r
 102   <strong><a href="psycopg2.Warning-class.html"><code>Warning</code></a></strong></td>\r
 103   <td>A database warning.</td></tr>\r
 104 </table><br />\r
 105 \r
 106 \r
 107 <!-- =========== START OF FUNCTION SUMMARY =========== -->\r
 108 <table class="summary" border="1" cellpadding="3" cellspacing="0" width="100%" bgcolor="white">\r
 109 <tr bgcolor="#70b0f0" class="summary">\r
 110   <th colspan="2">Function Summary</th></tr>\r
 111 <tr bgcolor="#e8f0f8" class="group">\r
 112   <th colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;Connections creation</th></tr>\r
 113 <tr><td align="right" valign="top" width="15%" class="rtype"><a href="../private/psycopg2._psycopg.connection-class.html" class="link"><code>extensions.connection</code></a></td>\r
 114   <td><code><span class="summary-sig"><a href="psycopg2-module.html#connect" class="summary-sig-name"><code>connect</code></a>(<span class="summary-sig-arg">dsn</span>,\r
 115           <span class="summary-sig-vararg">...</span>)</span></code>\r
 116 <br />\r
 117 Create a new database connection.</td></tr>\r
 118 <tr bgcolor="#e8f0f8" class="group">\r
 119   <th colspan="2">&nbsp;&nbsp;&nbsp;&nbsp;Value objects constructors</th></tr>\r
 120 <tr><td align="right" valign="top" width="15%" class="rtype">new binary object</td>\r
 121   <td><code><span class="summary-sig"><a href="psycopg2-module.html#Binary" class="summary-sig-name"><code>Binary</code></a>(<span class="summary-sig-arg">buffer</span>)</span></code>\r
 122 <br />\r
 123 Build an object capable to hold a bynary string value.</td></tr>\r
 124 <tr><td align="right" valign="top" width="15%" class="rtype">new date</td>\r
 125   <td><code><span class="summary-sig"><a href="psycopg2-module.html#Date" class="summary-sig-name"><code>Date</code></a>(<span class="summary-sig-arg">year</span>,\r
 126           <span class="summary-sig-arg">month</span>,\r
 127           <span class="summary-sig-arg">day</span>)</span></code>\r
 128 <br />\r
 129 Build an object holding a date value.</td></tr>\r
 130 <tr><td align="right" valign="top" width="15%" class="rtype">new date</td>\r
 131   <td><code><span class="summary-sig"><a href="psycopg2-module.html#DateFromTicks" class="summary-sig-name"><code>DateFromTicks</code></a>(<span class="summary-sig-arg">ticks</span>)</span></code>\r
 132 <br />\r
 133 Build an object holding a date value from the given ticks value.</td></tr>\r
 134 <tr><td align="right" valign="top" width="15%" class="rtype">new time</td>\r
 135   <td><code><span class="summary-sig"><a href="psycopg2-module.html#Time" class="summary-sig-name"><code>Time</code></a>(<span class="summary-sig-arg">hour</span>,\r
 136           <span class="summary-sig-arg">minutes</span>,\r
 137           <span class="summary-sig-arg">seconds</span>,\r
 138           <span class="summary-sig-arg">tzinfo</span>)</span></code>\r
 139 <br />\r
 140 Build an object holding a time value.</td></tr>\r
 141 <tr><td align="right" valign="top" width="15%" class="rtype">new time</td>\r
 142   <td><code><span class="summary-sig"><a href="psycopg2-module.html#TimeFromTicks" class="summary-sig-name"><code>TimeFromTicks</code></a>(<span class="summary-sig-arg">ticks</span>)</span></code>\r
 143 <br />\r
 144 Build an object holding a time value from the given ticks value.</td></tr>\r
 145 <tr><td align="right" valign="top" width="15%" class="rtype">new timestamp</td>\r
 146   <td><code><span class="summary-sig"><a href="psycopg2-module.html#Timestamp" class="summary-sig-name"><code>Timestamp</code></a>(<span class="summary-sig-arg">year</span>,\r
 147           <span class="summary-sig-arg">month</span>,\r
 148           <span class="summary-sig-arg">day</span>,\r
 149           <span class="summary-sig-arg">hour</span>,\r
 150           <span class="summary-sig-arg">minutes</span>,\r
 151           <span class="summary-sig-arg">seconds</span>,\r
 152           <span class="summary-sig-arg">tzinfo</span>)</span></code>\r
 153 <br />\r
 154 Build an object holding a timestamp value.</td></tr>\r
 155 <tr><td align="right" valign="top" width="15%" class="rtype">new timestamp</td>\r
 156   <td><code><span class="summary-sig"><a href="psycopg2-module.html#TimestampFromTicks" class="summary-sig-name"><code>TimestampFromTicks</code></a>(<span class="summary-sig-arg">ticks</span>)</span></code>\r
 157 <br />\r
 158 Build an object holding a timestamp value from the given ticks value.</td></tr>\r
 159 </table><br />\r
 160 \r
 161 \r
 162 <!-- =========== START OF FUNCTION DETAILS =========== -->\r
 163 <table class="details" border="1" cellpadding="3" cellspacing="0" width="100%" bgcolor="white">\r
 164 <tr bgcolor="#70b0f0" class="details">\r
 165   <th colspan="2">Function Details</th></tr>\r
 166 </table>\r
 167 \r
 168 <a name="connect"></a>\r
 169 <table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>\r
 170   <h3><span class="sig"><span class="sig-name">connect</span>(<span class="sig-arg">dsn</span>,\r
 171           <span class="sig-vararg">...</span>)</span>\r
 172   </h3>\r
 173 <p>Create a new database connection.</p>\r
 174 <p>This function supports two different but equivalent sets of arguments.\r
 175 A single data source name or <tt class="docutils literal"><span class="pre">dsn</span></tt> string can be used to specify the\r
 176 connection parameters, as follows:</p>\r
 177 <pre class="literal-block">\r
 178 psycopg2.connect(&quot;dbname=xxx user=xxx ...&quot;)\r
 179 </pre>\r
 180 <p>If <tt class="docutils literal"><span class="pre">dsn</span></tt> is not provided it is possible to pass the parameters as\r
 181 keyword arguments; e.g.:</p>\r
 182 <pre class="literal-block">\r
 183 psycopg2.connect(database='xxx', user='xxx', ...)\r
 184 </pre>\r
 185 <p>The full list of available parameters is:</p>\r
 186 <ul class="rst-simple">\r
 187 <li><tt class="docutils literal"><span class="pre">dbname</span></tt> -- database name (only in 'dsn')</li>\r
 188 <li><tt class="docutils literal"><span class="pre">database</span></tt> -- database name (only as keyword argument)</li>\r
 189 <li><tt class="docutils literal"><span class="pre">host</span></tt> -- host address (defaults to UNIX socket if not provided)</li>\r
 190 <li><tt class="docutils literal"><span class="pre">port</span></tt> -- port number (defaults to 5432 if not provided)</li>\r
 191 <li><tt class="docutils literal"><span class="pre">user</span></tt> -- user name used to authenticate</li>\r
 192 <li><tt class="docutils literal"><span class="pre">password</span></tt> -- password used to authenticate</li>\r
 193 <li><tt class="docutils literal"><span class="pre">sslmode</span></tt> -- SSL mode (see PostgreSQL documentation)</li>\r
 194 </ul>\r
 195 <p>If the <tt class="docutils literal"><span class="pre">connection_factory</span></tt> keyword argument is not provided this\r
 196 function always return an instance of the <code>connection</code> class.\r
 197 Else the given sub-class of <a href="../private/psycopg2._psycopg.connection-class.html" class="link"><code>extensions.connection</code></a> will be used to\r
 198 instantiate the connection object.</p>\r
 199   <dl><dt></dt><dd>\r
 200     <dl><dt>Returns:</dt>\r
 201       <dd>\r
 202 New database connection        <br /><em>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\r
 203         (type=<a href="../private/psycopg2._psycopg.connection-class.html" class="link"><code>extensions.connection</code></a>)</em>\r
 204       </dd>\r
 205     </dl>\r
 206   </dd></dl>\r
 207 </td></tr></table>\r
 208 \r
 209 <a name="Binary"></a>\r
 210 <table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>\r
 211   <h3><span class="sig"><span class="sig-name">Binary</span>(<span class="sig-arg">buffer</span>)</span>\r
 212   </h3>\r
 213 <p>Build an object capable to hold a bynary string value.</p>\r
 214   <dl><dt></dt><dd>\r
 215     <dl><dt>Returns:</dt>\r
 216       <dd>\r
 217 new binary object      </dd>\r
 218     </dl>\r
 219   </dd></dl>\r
 220 </td></tr></table>\r
 221 \r
 222 <a name="Date"></a>\r
 223 <table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>\r
 224   <h3><span class="sig"><span class="sig-name">Date</span>(<span class="sig-arg">year</span>,\r
 225           <span class="sig-arg">month</span>,\r
 226           <span class="sig-arg">day</span>)</span>\r
 227   </h3>\r
 228 <p>Build an object holding a date value.</p>\r
 229   <dl><dt></dt><dd>\r
 230     <dl><dt>Returns:</dt>\r
 231       <dd>\r
 232 new date      </dd>\r
 233     </dl>\r
 234   </dd></dl>\r
 235 </td></tr></table>\r
 236 \r
 237 <a name="DateFromTicks"></a>\r
 238 <table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>\r
 239   <h3><span class="sig"><span class="sig-name">DateFromTicks</span>(<span class="sig-arg">ticks</span>)</span>\r
 240   </h3>\r
 241 <p>Build an object holding a date value from the given ticks value.</p>\r
 242 <p>Ticks are the number of seconds since the epoch; see the documentation of the standard Python time module for details).</p>\r
 243   <dl><dt></dt><dd>\r
 244     <dl><dt>Returns:</dt>\r
 245       <dd>\r
 246 new date      </dd>\r
 247     </dl>\r
 248   </dd></dl>\r
 249 </td></tr></table>\r
 250 \r
 251 <a name="Time"></a>\r
 252 <table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>\r
 253   <h3><span class="sig"><span class="sig-name">Time</span>(<span class="sig-arg">hour</span>,\r
 254           <span class="sig-arg">minutes</span>,\r
 255           <span class="sig-arg">seconds</span>,\r
 256           <span class="sig-arg">tzinfo</span>=<span class="sig-default">None</span>)</span>\r
 257   </h3>\r
 258 <p>Build an object holding a time value.</p>\r
 259   <dl><dt></dt><dd>\r
 260     <dl><dt>Returns:</dt>\r
 261       <dd>\r
 262 new time      </dd>\r
 263     </dl>\r
 264   </dd></dl>\r
 265 </td></tr></table>\r
 266 \r
 267 <a name="TimeFromTicks"></a>\r
 268 <table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>\r
 269   <h3><span class="sig"><span class="sig-name">TimeFromTicks</span>(<span class="sig-arg">ticks</span>)</span>\r
 270   </h3>\r
 271 <p>Build an object holding a time value from the given ticks value.</p>\r
 272 <p>Ticks are the number of seconds since the epoch; see the documentation of the standard Python time module for details).</p>\r
 273   <dl><dt></dt><dd>\r
 274     <dl><dt>Returns:</dt>\r
 275       <dd>\r
 276 new time      </dd>\r
 277     </dl>\r
 278   </dd></dl>\r
 279 </td></tr></table>\r
 280 \r
 281 <a name="Timestamp"></a>\r
 282 <table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>\r
 283   <h3><span class="sig"><span class="sig-name">Timestamp</span>(<span class="sig-arg">year</span>,\r
 284           <span class="sig-arg">month</span>,\r
 285           <span class="sig-arg">day</span>,\r
 286           <span class="sig-arg">hour</span>,\r
 287           <span class="sig-arg">minutes</span>,\r
 288           <span class="sig-arg">seconds</span>,\r
 289           <span class="sig-arg">tzinfo</span>=<span class="sig-default">None</span>)</span>\r
 290   </h3>\r
 291 <p>Build an object holding a timestamp value.</p>\r
 292   <dl><dt></dt><dd>\r
 293     <dl><dt>Returns:</dt>\r
 294       <dd>\r
 295 new timestamp      </dd>\r
 296     </dl>\r
 297   </dd></dl>\r
 298 </td></tr></table>\r
 299 \r
 300 <a name="TimestampFromTicks"></a>\r
 301 <table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>\r
 302   <h3><span class="sig"><span class="sig-name">TimestampFromTicks</span>(<span class="sig-arg">ticks</span>)</span>\r
 303   </h3>\r
 304 <p>Build an object holding a timestamp value from the given ticks value.</p>\r
 305 <p>Ticks are the number of seconds since the epoch; see the documentation of the standard Python time module for details).</p>\r
 306   <dl><dt></dt><dd>\r
 307     <dl><dt>Returns:</dt>\r
 308       <dd>\r
 309 new timestamp      </dd>\r
 310     </dl>\r
 311   </dd></dl>\r
 312 </td></tr></table>\r
 313 <br />\r
 314 \r
 315 \r
 316 <!-- =========== START OF NAVBAR =========== -->\r
 317 <table class="navbar" border="0" width="100%" cellpadding="0" bgcolor="#a0c0ff" cellspacing="0">\r
 318   <tr valign="middle">\r
 319     <th bgcolor="#70b0f0" class="navselect">&nbsp;&nbsp;&nbsp;Home&nbsp;&nbsp;&nbsp;</th>\r
 320     <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="trees.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>\r
 321     <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="indices.html">Index</a>&nbsp;&nbsp;&nbsp;</th>\r
 322     <th class="navbar">&nbsp;&nbsp;&nbsp;<a class="navbar" href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>\r
 323     <th class="navbar" width="100%"></th>\r
 324   </tr>\r
 325 </table>\r
 326 \r
 327 <table border="0" cellpadding="0" cellspacing="0" width="100%">\r
 328   <tr>\r
 329     <td align="left" class="footer">Generated by Epydoc 2.1 on Sat Jan 14 01:42:35 2006</td>\r
 330     <td align="right" class="footer">\r
 331       <a href="http://epydoc.sourceforge.net">http://epydoc.sf.net</a>\r
 332     </td>\r
 333   </tr>\r
 334 </table>\r
 335 </body>\r
 336 </html>\r