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
6 <title>psycopg2.psycopg1.cursor</title>
\r
7 <link rel="stylesheet" href="epydoc.css" type="text/css" />
\r
8 <script type="text/javascript">
\r
10 function setFrame(url1, url2){
\r
11 parent.frames[1].location.href = url1;
\r
12 parent.frames[2].location.href = url2;
\r
17 <body bgcolor="white" text="black" link="blue" vlink="#204080"
\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 class="navbar"> <a class="navbar" href="psycopg2-module.html">Home</a> </th>
\r
24 <th class="navbar"> <a class="navbar" href="trees.html">Trees</a> </th>
\r
25 <th class="navbar"> <a class="navbar" href="indices.html">Index</a> </th>
\r
26 <th class="navbar"> <a class="navbar" href="help.html">Help</a> </th>
\r
27 <th class="navbar" width="100%"></th>
\r
30 <table width="100%" cellpadding="0" cellspacing="0">
\r
33 <span class="breadcrumbs">
\r
34 <a href="psycopg2-module.html">Package psycopg2</a> ::
\r
35 <a href="psycopg2.psycopg1-module.html">Module psycopg1</a> ::
\r
39 <td><table cellpadding="0" cellspacing="0">
\r
40 <tr><td align="right"><span class="options">[show private | <a href="../public/psycopg2.psycopg1.cursor-class.html">hide private</a>]</span></td></tr>
\r
41 <tr><td align="right"><span class="options">[<a href="frames.html" target="_top">frames</a> | <a href="psycopg2.psycopg1.cursor-class.html" target="_top">no frames</a>]</span></td></tr>
\r
45 <!-- =========== START OF CLASS DESCRIPTION =========== -->
\r
46 <h2 class="class">Type cursor</h2>
\r
48 <pre class="base-tree">
\r
49 <a href="__builtin__.object-class.html"><code>object</code></a> --+
\r
51 <a href="../private/psycopg2._psycopg.cursor-class.html"><code>cursor</code></a> --+
\r
53 <strong class="uidshort">cursor</strong>
\r
58 <p>psycopg 1.1.x cursor.</p>
\r
59 <p>Note that this cursor implements the exact procedure used by psycopg 1 to
\r
60 build dictionaries out of result rows. The DictCursor in the
\r
61 psycopg.extras modules implements a much better and faster algorithm.</p>
\r
65 <!-- =========== START OF METHOD SUMMARY =========== -->
\r
66 <table class="summary" border="1" cellpadding="3" cellspacing="0" width="100%" bgcolor="white">
\r
67 <tr bgcolor="#70b0f0" class="summary">
\r
68 <th colspan="2">Method Summary</th></tr>
\r
69 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
70 <td><code><a name="dictfetchall"></a><span class="summary-sig"><span class="summary-sig-name">dictfetchall</span>(<span class="summary-sig-arg">self</span>)</span></code>
\r
72 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
73 <td><code><a name="dictfetchmany"></a><span class="summary-sig"><span class="summary-sig-name">dictfetchmany</span>(<span class="summary-sig-arg">self</span>,
\r
74 <span class="summary-sig-arg">size</span>)</span></code>
\r
76 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
77 <td><code><a name="dictfetchone"></a><span class="summary-sig"><span class="summary-sig-name">dictfetchone</span>(<span class="summary-sig-arg">self</span>)</span></code>
\r
79 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
80 <td><code><a name="__build_dict"></a><span class="summary-sig"><span class="summary-sig-name">__build_dict</span>(<span class="summary-sig-arg">self</span>,
\r
81 <span class="summary-sig-arg">row</span>)</span></code>
\r
83 <tr bgcolor="#e8f0f8" class="group">
\r
84 <th colspan="2"> Inherited from cursor</th></tr>
\r
85 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
86 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#__init__" class="summary-sig-name"><code>__init__</code></a>(<span class="summary-sig-vararg">...</span>)</span></code>
\r
88 x.__init__(...) initializes x; see x.__class__.__doc__ for signature</td></tr>
\r
89 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
90 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#__iter__" class="summary-sig-name"><code>__iter__</code></a>(<span class="summary-sig-arg">x</span>)</span></code>
\r
92 Return iter(x)...</td></tr>
\r
93 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
94 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#__new__" class="summary-sig-name"><code>__new__</code></a>(<span class="summary-sig-arg">T</span>,
\r
95 <span class="summary-sig-arg">S</span>,
\r
96 <span class="summary-sig-vararg">...</span>)</span></code>
\r
98 Return a new object with type S, a subtype of T...</td></tr>
\r
99 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
100 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#__repr__" class="summary-sig-name"><code>__repr__</code></a>(<span class="summary-sig-arg">x</span>)</span></code>
\r
102 Return repr(x)...</td></tr>
\r
103 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
104 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#__str__" class="summary-sig-name"><code>__str__</code></a>(<span class="summary-sig-arg">x</span>)</span></code>
\r
106 Return str(x)...</td></tr>
\r
107 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
108 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#callproc" class="summary-sig-name"><code>callproc</code></a>(<span class="summary-sig-arg">procname</span>,
\r
109 <span class="summary-sig-arg">parameters</span>,
\r
110 <span class="summary-sig-arg">async</span>)</span></code>
\r
112 Execute stored procedure.</td></tr>
\r
113 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
114 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#close" class="summary-sig-name"><code>close</code></a>()</span></code>
\r
116 Close the cursor.</td></tr>
\r
117 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
118 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#copy_from" class="summary-sig-name"><code>copy_from</code></a>(<span class="summary-sig-arg">file</span>,
\r
119 <span class="summary-sig-arg">table</span>,
\r
120 <span class="summary-sig-arg">sep</span>,
\r
121 <span class="summary-sig-arg">null</span>)</span></code>
\r
123 Copy table from file.</td></tr>
\r
124 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
125 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#copy_to" class="summary-sig-name"><code>copy_to</code></a>(<span class="summary-sig-arg">file</span>,
\r
126 <span class="summary-sig-arg">table</span>,
\r
127 <span class="summary-sig-arg">sep</span>,
\r
128 <span class="summary-sig-arg">null</span>)</span></code>
\r
130 Copy table to file.</td></tr>
\r
131 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
132 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#execute" class="summary-sig-name"><code>execute</code></a>(<span class="summary-sig-arg">query</span>,
\r
133 <span class="summary-sig-arg">vars</span>,
\r
134 <span class="summary-sig-arg">async</span>)</span></code>
\r
136 Execute query with bound vars.</td></tr>
\r
137 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
138 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#executemany" class="summary-sig-name"><code>executemany</code></a>(<span class="summary-sig-arg">query</span>,
\r
139 <span class="summary-sig-arg">vars_list</span>,
\r
140 <span class="summary-sig-arg">async</span>)</span></code>
\r
142 Execute many queries with bound vars.</td></tr>
\r
143 <tr><td align="right" valign="top" width="15%" class="rtype">list of tuple</td>
\r
144 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#fetchall" class="summary-sig-name"><code>fetchall</code></a>()</span></code>
\r
146 Return all the remaining rows of a query result set.</td></tr>
\r
147 <tr><td align="right" valign="top" width="15%" class="rtype">list of tuple</td>
\r
148 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#fetchmany" class="summary-sig-name"><code>fetchmany</code></a>(<span class="summary-sig-arg">size</span>)</span></code>
\r
150 Return the next <a href="../private/psycopg2._psycopg.cursor-class.html#fetchmany" class="link"><code>size</code></a> rows of a query result set in the form of a list
\r
151 of tuples (by default) or using the sequence factory previously set in
\r
152 the <a href="../private/psycopg2._psycopg.cursor-class.html#row_factory" class="link"><code>row_factory</code></a> attribute.</td></tr>
\r
153 <tr><td align="right" valign="top" width="15%" class="rtype">tuple or None</td>
\r
154 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#fetchone" class="summary-sig-name"><code>fetchone</code></a>()</span></code>
\r
156 Return the next row of a query result set in the form of a tuple (by
\r
157 default) or using the sequence factory previously set in the
\r
158 <a href="../private/psycopg2._psycopg.cursor-class.html#row_factory" class="link"><code>row_factory</code></a> attribute.</td></tr>
\r
159 <tr><td align="right" valign="top" width="15%" class="rtype">int</td>
\r
160 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#fileno" class="summary-sig-name"><code>fileno</code></a>()</span></code>
\r
162 Return file descriptor associated to database connection.</td></tr>
\r
163 <tr><td align="right" valign="top" width="15%" class="rtype">bool</td>
\r
164 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#isready" class="summary-sig-name"><code>isready</code></a>()</span></code>
\r
166 Return True if data is ready after an async query.</td></tr>
\r
167 <tr><td align="right" valign="top" width="15%" class="rtype">str</td>
\r
168 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#mogrify" class="summary-sig-name"><code>mogrify</code></a>(<span class="summary-sig-arg">query</span>,
\r
169 <span class="summary-sig-arg">vars</span>)</span></code>
\r
171 Return query after vars binding.</td></tr>
\r
172 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
173 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#next" class="summary-sig-name"><code>next</code></a>(<span class="summary-sig-arg">x</span>)</span></code>
\r
175 Return the next value, or raise StopIteration...</td></tr>
\r
176 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
177 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#nextset" class="summary-sig-name"><code>nextset</code></a>()</span></code>
\r
179 Skip to next set of data.</td></tr>
\r
180 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
181 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#scroll" class="summary-sig-name"><code>scroll</code></a>(<span class="summary-sig-arg">value</span>,
\r
182 <span class="summary-sig-arg">mode</span>)</span></code>
\r
184 Scroll to new position according to mode.</td></tr>
\r
185 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
186 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#setinputsizes" class="summary-sig-name"><code>setinputsizes</code></a>(<span class="summary-sig-arg">sizes</span>)</span></code>
\r
188 Set memory areas before execute.</td></tr>
\r
189 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
190 <td><code><span class="summary-sig"><a href="../private/psycopg2._psycopg.cursor-class.html#setoutputsize" class="summary-sig-name"><code>setoutputsize</code></a>(<span class="summary-sig-arg">size</span>,
\r
191 <span class="summary-sig-arg">column</span>)</span></code>
\r
193 Set column buffer size.</td></tr>
\r
194 <tr bgcolor="#e8f0f8" class="group">
\r
195 <th colspan="2"> Inherited from object</th></tr>
\r
196 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
197 <td><code><span class="summary-sig"><a href="__builtin__.object-class.html#__delattr__" class="summary-sig-name"><code>__delattr__</code></a>(<span class="summary-sig-vararg">...</span>)</span></code>
\r
199 x.__delattr__('name') <==> del x.name</td></tr>
\r
200 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
201 <td><code><span class="summary-sig"><a href="__builtin__.object-class.html#__getattribute__" class="summary-sig-name"><code>__getattribute__</code></a>(<span class="summary-sig-vararg">...</span>)</span></code>
\r
203 x.__getattribute__('name') <==> x.name</td></tr>
\r
204 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
205 <td><code><span class="summary-sig"><a href="__builtin__.object-class.html#__hash__" class="summary-sig-name"><code>__hash__</code></a>(<span class="summary-sig-arg">x</span>)</span></code>
\r
207 Return hash(x)...</td></tr>
\r
208 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
209 <td><code><span class="summary-sig"><a href="__builtin__.object-class.html#__reduce__" class="summary-sig-name"><code>__reduce__</code></a>(<span class="summary-sig-vararg">...</span>)</span></code>
\r
211 helper for pickle</td></tr>
\r
212 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
213 <td><code><span class="summary-sig"><a href="__builtin__.object-class.html#__reduce_ex__" class="summary-sig-name"><code>__reduce_ex__</code></a>(<span class="summary-sig-vararg">...</span>)</span></code>
\r
215 helper for pickle</td></tr>
\r
216 <tr><td align="right" valign="top" width="15%" class="rtype"> </td>
\r
217 <td><code><span class="summary-sig"><a href="__builtin__.object-class.html#__setattr__" class="summary-sig-name"><code>__setattr__</code></a>(<span class="summary-sig-vararg">...</span>)</span></code>
\r
219 x.__setattr__('name', value) <==> x.name = value</td></tr>
\r
223 <!-- =========== START OF PROPERTY SUMMARY =========== -->
\r
224 <table class="summary" border="1" cellpadding="3" cellspacing="0" width="100%" bgcolor="white">
\r
225 <tr bgcolor="#70b0f0" class="summary">
\r
226 <th colspan="2">Property Summary</th></tr>
\r
227 <tr bgcolor="#e8f0f8" class="group">
\r
228 <th colspan="2"> Inherited from cursor</th></tr>
\r
229 <tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
230 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#arraysize"><code>arraysize</code></a></strong>: Number of records <a href="../private/psycopg2._psycopg.cursor-class.html#fetchmany" class="link"><code>fetchmany()</code></a> must fetch if not explicitely specified.</td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
231 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#binary_types"><code>binary_types</code></a></strong></td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
232 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#connection"><code>connection</code></a></strong>: The connection where the cursor comes from.</td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
233 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#description"><code>description</code></a></strong>: Cursor description as defined in DBAPI-2.0.</td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
234 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#lastrowid"><code>lastrowid</code></a></strong>: The <tt class="docutils literal docutils literal"><span class="pre">oid</span></tt> of the last row inserted by the cursor.</td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
235 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#name"><code>name</code></a></strong></td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
236 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#query"><code>query</code></a></strong>: The last query text sent to the backend.</td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
237 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#row_factory"><code>row_factory</code></a></strong></td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
238 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#rowcount"><code>rowcount</code></a></strong>: Number of rows read from the backend in the last command.</td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
239 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#rownumber"><code>rownumber</code></a></strong>: The current row position.</td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
240 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#statusmessage"><code>statusmessage</code></a></strong>: The return message of the last command.</td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
241 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#string_types"><code>string_types</code></a></strong></td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
242 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#typecaster"><code>typecaster</code></a></strong></td></tr><tr><td align="right" valign="top" width="15%" class="ptype"> </td>
\r
243 <td><strong><a href="../private/psycopg2._psycopg.cursor-class.html#tzinfo_factory"><code>tzinfo_factory</code></a></strong></td></tr></table><br />
\r
246 <!-- =========== START OF METHOD DETAILS =========== -->
\r
247 <table class="details" border="1" cellpadding="3" cellspacing="0" width="100%" bgcolor="white">
\r
248 <tr bgcolor="#70b0f0" class="details">
\r
249 <th colspan="2">Method Details</th></tr>
\r
252 <a name="dictfetchall"></a>
\r
253 <table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>
\r
254 <h3><span class="sig"><span class="sig-name">dictfetchall</span>(<span class="sig-arg">self</span>)</span>
\r
260 <a name="dictfetchmany"></a>
\r
261 <table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>
\r
262 <h3><span class="sig"><span class="sig-name">dictfetchmany</span>(<span class="sig-arg">self</span>,
\r
263 <span class="sig-arg">size</span>)</span>
\r
269 <a name="dictfetchone"></a>
\r
270 <table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>
\r
271 <h3><span class="sig"><span class="sig-name">dictfetchone</span>(<span class="sig-arg">self</span>)</span>
\r
277 <a name="__build_dict"></a>
\r
278 <table width="100%" class="func-details" bgcolor="#e0e0e0"><tr><td>
\r
279 <h3><span class="sig"><span class="sig-name">__build_dict</span>(<span class="sig-arg">self</span>,
\r
280 <span class="sig-arg">row</span>)</span>
\r
288 <!-- =========== START OF NAVBAR =========== -->
\r
289 <table class="navbar" border="0" width="100%" cellpadding="0" bgcolor="#a0c0ff" cellspacing="0">
\r
290 <tr valign="middle">
\r
291 <th class="navbar"> <a class="navbar" href="psycopg2-module.html">Home</a> </th>
\r
292 <th class="navbar"> <a class="navbar" href="trees.html">Trees</a> </th>
\r
293 <th class="navbar"> <a class="navbar" href="indices.html">Index</a> </th>
\r
294 <th class="navbar"> <a class="navbar" href="help.html">Help</a> </th>
\r
295 <th class="navbar" width="100%"></th>
\r
299 <table border="0" cellpadding="0" cellspacing="0" width="100%">
\r
301 <td align="left" class="footer">Generated by Epydoc 2.1 on Sat Jan 14 01:42:33 2006</td>
\r
302 <td align="right" class="footer">
\r
303 <a href="http://epydoc.sourceforge.net">http://epydoc.sf.net</a>
\r