File: qsql.html

package info (click to toggle)
python-qt4 4.0.1-5
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 18,632 kB
  • ctags: 2,639
  • sloc: python: 29,409; sh: 5,646; cpp: 3,168; xml: 149; makefile: 109
file content (94 lines) | stat: -rw-r--r-- 5,362 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "DTD/xhtml1-strict.dtd">
<html><head><title>QSql Class Reference</title><style>h3.fn,span.fn { margin-left: 1cm; text-indent: -1cm }
a:link { color: #004faf; text-decoration: none }
a:visited { color: #672967; text-decoration: none }
td.postheader { font-family: sans-serif }
tr.address { font-family: sans-serif }
body { background: #ffffff; color: black; }
</style></head><body><table border="0" cellpadding="0" cellspacing="0" width="100%"><tr /><td align="left" valign="top" width="32"><img align="left" border="0" height="32" src="images/rb-logo.png" width="32" /></td><td width="1">&#160;&#160;</td><td class="postheader" valign="center"><a href="../pyqt4ref.html"><font color="#004faf">Home</font></a>&#160;&#183; <a href="classes.html"><font color="#004faf">All Classes</font></a>&#160;&#183; <a href="modules.html"><font color="#004faf">Modules</font></a></td></table><h1 align="center">QSql Class Reference<br /><sup><sup>[<a href="qtsql.html">QtSql</a> module]</sup></sup></h1><p>The QSql namespace contains miscellaneous identifiers used throughout the Qt SQL library. <a href="#details">More...</a></p>
<h3>Types</h3><ul><li><div class="fn" />enum <b><a href="qsql.html#Location-enum">Location</a></b> { BeforeFirstRow, AfterLastRow }</li><li><div class="fn" />class <b><a href="qsql-paramtype.html">ParamType</a></b></li><li><div class="fn" />enum <b><a href="qsql.html#ParamTypeFlag-enum">ParamTypeFlag</a></b> { In, Out, InOut, Binary }</li><li><div class="fn" />enum <b><a href="qsql.html#TableType-enum">TableType</a></b> { Tables, SystemTables, Views, AllTables }</li></ul><a name="details" /><hr /><h2>Detailed Description</h2><p>The QSql namespace contains miscellaneous identifiers used throughout the Qt SQL library.</p>
<p>See also <a href="qtsql.html">QtSql Module</a>.</p>
<hr /><h2>Type Documentation</h2><h3 class="fn"><a name="Location-enum" />QSql.Location</h3><p>This enum type describes special SQL navigation locations:</p>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<th width="25%">Constant</th>
<th width="15%">Value</th>
<th width="60%">Description</th>
</tr>
<tr>
<td valign="top"><tt>QSql.BeforeFirstRow</tt></td>
<td align="center" valign="top"><tt>-1</tt></td>
<td valign="top">Before the first record.</td>
</tr>
<tr>
<td valign="top"><tt>QSql.AfterLastRow</tt></td>
<td align="center" valign="top"><tt>-2</tt></td>
<td valign="top">After the last record.</td>
</tr>
</table>
<br />
<br />
<p>See also <a href="qsqlquery.html#at">QSqlQuery.at</a>().</p>
<h3 class="fn"><a name="ParamTypeFlag-enum" />QSql.ParamTypeFlag</h3><p>This enum is used to specify the type of a bind parameter.</p>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<th width="25%">Constant</th>
<th width="15%">Value</th>
<th width="60%">Description</th>
</tr>
<tr>
<td valign="top"><tt>QSql.In</tt></td>
<td align="center" valign="top"><tt>0x00000001</tt></td>
<td valign="top">The bind parameter is used to put data into the database.</td>
</tr>
<tr>
<td valign="top"><tt>QSql.Out</tt></td>
<td align="center" valign="top"><tt>0x00000002</tt></td>
<td valign="top">The bind parameter is used to receive data from the database.</td>
</tr>
<tr>
<td valign="top"><tt>QSql.InOut</tt></td>
<td align="center" valign="top"><tt>In | Out</tt></td>
<td valign="top">The bind parameter is used to put data into the database; it will be overwritten with output data on executing a query.</td>
</tr>
<tr>
<td valign="top"><tt>QSql.Binary</tt></td>
<td align="center" valign="top"><tt>0x00000004</tt></td>
<td valign="top">This must be OR'd with one of the other flags if you want to indicate that the data being transferred is raw binary data.</td>
</tr>
</table>
<br />
<br />
<p>The ParamType type is a typedef for <a href="qflags.html">QFlags</a>&lt;ParamTypeFlag&gt;. It stores an OR combination of ParamTypeFlag values.</p>
<h3 class="fn"><a name="TableType-enum" />QSql.TableType</h3><p>This enum type describes types of SQL tables.</p>
<table border="1" cellpadding="2" cellspacing="1" width="100%">
<tr>
<th width="25%">Constant</th>
<th width="15%">Value</th>
<th width="60%">Description</th>
</tr>
<tr>
<td valign="top"><tt>QSql.Tables</tt></td>
<td align="center" valign="top"><tt>0x01</tt></td>
<td valign="top">All the tables visible to the user.</td>
</tr>
<tr>
<td valign="top"><tt>QSql.SystemTables</tt></td>
<td align="center" valign="top"><tt>0x02</tt></td>
<td valign="top">Internal tables used by the database.</td>
</tr>
<tr>
<td valign="top"><tt>QSql.Views</tt></td>
<td align="center" valign="top"><tt>0x04</tt></td>
<td valign="top">All the views visible to the user.</td>
</tr>
<tr>
<td valign="top"><tt>QSql.AllTables</tt></td>
<td align="center" valign="top"><tt>0xff</tt></td>
<td valign="top">All of the above.</td>
</tr>
</table>
<br />
<br />
<address><hr /><div align="center"><table border="0" cellspacing="0" width="100%"><tr class="address"><td width="25%">PyQt&#160;4.0.1 for X11</td><td align="center" width="50%">Copyright &#169; <a href="http://www.riverbankcomputing.com">Riverbank&#160;Computing&#160;Ltd</a> and <a href="http://www.trolltech.com">Trolltech&#160;AS</a> 2006</td><td align="right" width="25%">Qt&#160;4.1.4</td></tr></table></div></address></body></html>