3
<TITLE>class toConnection</TITLE>
5
<META NAME="Generator" CONTENT="KDOC ">
7
<BODY bgcolor="#ffffff" text="#000000" link="#0000ff" vlink="#000099" alink= "#ffffff">
8
<TABLE WIDTH="100%" BORDER="0">
12
<TR><TD valign="top" align="left" cellspacing="10">
13
<h1>class toConnection</h1>
15
<TD valign="top" align="right" colspan="1">
16
<small><A HREF="#longdesc">More...</A></small></TD></TR>
20
<TR><TH>Definition</TH><TD><code>#include <<A HREF="toconnection_h.html">toconnection.h</A>></code></TD></TR>
21
<TR><TH><A HREF="full-list-toConnection.html">List of all Methods</A></TH></TR>
24
<TD align="right"><TABLE BORDER="0"><TR><TD><small><A HREF="index-long.html">Annotated List</A></small></TD></TR>
25
<TR><TD><small><A HREF="header-list.html">Files</A></small></TD></TR>
26
<TR><TD><small><A HREF="all-globals.html">Globals</A></small></TD></TR>
27
<TR><TD><small><A HREF="hier.html">Hierarchy</A></small></TD></TR>
28
<TR><TD><small><A HREF="index.html">Index</A></small></TD></TR>
29
</TABLE></TD></TR></TABLE>
30
<h4>Public Types</h4><ul><LI>class <A HREF="toConnection__exception.html">exception</A>
32
<LI>struct <A HREF="toConnection__objectName.html">objectName</A>
34
<LI>class <i><A HREF="toConnection__connectionImpl.html">connectionImpl</A></i>
36
</ul><h4>Public Methods</h4><ul><LI> <b><A HREF="#ref36">toConnection</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qcstring.html">QCString</A> &provider,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &user,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &password,
37
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &host,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &database,const std::set<<A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A>> &options,
40
<LI> <b><A HREF="#ref37">toConnection</A></b> (const <A HREF="toConnection.html">toConnection</A> &conn)
42
<LI>virtual <b><A HREF="#ref38">~toConnection</A></b> ()
44
<LI>const std::set<<A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A>> & <b><A HREF="#ref39">options</A></b> () const
46
<LI>bool <b><A HREF="#ref40">closeWidgets</A></b> (void)
48
<LI>const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> & <b><A HREF="#ref41">user</A></b> () const
50
<LI>const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> & <b><A HREF="#ref42">password</A></b> () const
52
<LI>void <b><A HREF="#ref43">setPassword</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &pwd)
54
<LI>const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> & <b><A HREF="#ref44">host</A></b> () const
56
<LI>const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> & <b><A HREF="#ref45">database</A></b> () const
58
<LI>const <A HREF="/usr/lib/qt3/doc/html/qcstring.html">QCString</A> & <b><A HREF="#ref46">version</A></b> () const
60
<LI>const <A HREF="/usr/lib/qt3/doc/html/qcstring.html">QCString</A> & <b><A HREF="#ref47">provider</A></b> () const
62
<LI>void <b><A HREF="#ref48">setDatabase</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &database)
64
<LI>virtual <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> <b><A HREF="#ref49">description</A></b> (bool version=true) const
66
<LI>void <b><A HREF="#ref50">setNeedCommit</A></b> (bool needCommit=true)
68
<LI>bool <b><A HREF="#ref51">needCommit</A></b> (void) const
70
<LI>virtual void <b><A HREF="#ref52">commit</A></b> (void)
72
<LI>virtual void <b><A HREF="#ref53">rollback</A></b> (void)
74
<LI>void <b><A HREF="#ref54">parse</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql)
76
<LI>void <b><A HREF="#ref55">parse</A></b> (const <A HREF="toSQL.html">toSQL</A> &sql)
78
<LI>void <b><A HREF="#ref56">execute</A></b> (const <A HREF="toSQL.html">toSQL</A> &sql,
79
<A HREF="#toQList">toQList</A> ¶ms)
81
<LI>void <b><A HREF="#ref57">execute</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql,
82
<A HREF="#toQList">toQList</A> ¶ms)
84
<LI>void <b><A HREF="#ref58">execute</A></b> (const <A HREF="toSQL.html">toSQL</A> &sql,
85
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg1=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg2=QString::null,
86
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg3=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg4=QString::null,
87
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg5=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg6=QString::null,
88
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg7=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg8=QString::null,
89
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg9=QString::null)
91
<LI>void <b><A HREF="#ref59">execute</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql,
92
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg1=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg2=QString::null,
93
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg3=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg4=QString::null,
94
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg5=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg6=QString::null,
95
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg7=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg8=QString::null,
96
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg9=QString::null)
98
<LI>void <b><A HREF="#ref60">allExecute</A></b> (const <A HREF="toSQL.html">toSQL</A> &sql,
99
<A HREF="#toQList">toQList</A> ¶ms)
101
<LI>void <b><A HREF="#ref61">allExecute</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql,
102
<A HREF="#toQList">toQList</A> ¶ms)
104
<LI>void <b><A HREF="#ref62">allExecute</A></b> (const <A HREF="toSQL.html">toSQL</A> &sql,
105
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg1=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg2=QString::null,
106
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg3=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg4=QString::null,
107
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg5=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg6=QString::null,
108
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg7=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg8=QString::null,
109
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg9=QString::null)
111
<LI>void <b><A HREF="#ref63">allExecute</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql,
112
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg1=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg2=QString::null,
113
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg3=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg4=QString::null,
114
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg5=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg6=QString::null,
115
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg7=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg8=QString::null,
116
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg9=QString::null)
118
<LI>void <b><A HREF="#ref64">addWidget</A></b> (<A HREF="/usr/lib/qt3/doc/html/qobject.html">QObject</A> *widget)
120
<LI>void <b><A HREF="#ref65">delWidget</A></b> (<A HREF="/usr/lib/qt3/doc/html/qobject.html">QObject</A> *widget)
122
<LI>void <b><A HREF="#ref66">addInit</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql)
124
<LI>void <b><A HREF="#ref67">delInit</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql)
126
<LI>const std::list<<A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A>> & <b><A HREF="#ref68">initStrings</A></b> () const
128
<LI><A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> <b><A HREF="#ref69">quote</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &name)
130
<LI><A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> <b><A HREF="#ref70">unQuote</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &name)
132
<LI>std::list<objectName> & <b><A HREF="#ref71">objects</A></b> (bool block)
134
<LI>void <b><A HREF="#ref72">addIfNotExists</A></b> (objectName &object)
136
<LI>virtual <A HREF="toSyntaxAnalyzer.html">toSyntaxAnalyzer</A> & <b><A HREF="#ref73">analyzer</A></b> ()
138
<LI>std::map<<A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A>,objectName> & <b><A HREF="#ref74">synonyms</A></b> (bool block)
140
<LI><A HREF="#toQDescList">toQDescList</A> & <b><A HREF="#ref75">columns</A></b> (const objectName &table,bool nocache=false)
142
<LI>void <b><A HREF="#ref76">rereadCache</A></b> (void)
144
<LI>const objectName & <b><A HREF="#ref77">realName</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &object,bool block)
146
<LI>const objectName & <b><A HREF="#ref78">realName</A></b> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &object,<A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &synonym,bool block)
148
<LI>bool <b><A HREF="#ref79">cacheAvailable</A></b> (bool synonyms,bool block=false,bool need=true)
150
<LI>void <b><A HREF="#ref80">cancelAll</A></b> (void)
152
<LI>bool <b><A HREF="#ref81">loadDiskCache</A></b> (void)
154
<LI>void <b><A HREF="#ref82">writeDiskCache</A></b> (void)
156
<LI>std::list<<A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A>> <b><A HREF="#ref83">running</A></b> (void)
158
</ul><h4>Public Static Methods</h4><ul><LI>static <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> <b><A HREF="#ref84">cacheDir</A></b> ()
160
</ul><h4>Public Members</h4><ul><LI>friend class <b><A HREF="#ref85">toQuery</A></b></LI>
161
</ul><HR><H2><A NAME="longdesc">Detailed Description</A></H2><p>
163
<p> TOra - An Oracle Toolkit for DBA's and developers
164
Copyright (C) 2003-2005 Quest Software, Inc
165
Portions Copyright (C) 2005 Other Contributors
167
<p> This program is free software; you can redistribute it and/or
168
modify it under the terms of the GNU General Public License
169
as published by the Free Software Foundation; only version 2 of
170
the License is valid for this program.
172
<p> This program is distributed in the hope that it will be useful,
173
but WITHOUT ANY WARRANTY; without even the implied warranty of
174
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
175
GNU General Public License for more details.
177
<p> You should have received a copy of the GNU General Public License
178
along with this program; if not, write to the Free Software
179
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
181
<p> As a special exception, you have permission to link this program
182
with the Oracle Client libraries and distribute executables, as long
183
as you follow the requirements of the GNU GPL in regard to all of the
184
software in the executable aside from Oracle client libraries.
186
<p> Specifically you are not permitted to link this program with the
187
Qt/UNIX, Qt/Windows or Qt Non Commercial products of TrollTech.
188
And you are not permitted to distribute binaries compiled against
189
these libraries without written consent from Quest Software, Inc.
190
Observe that this does not disallow linking to the Qt Free Edition.
192
<p> You may link this product with any GPL'd Qt library such as Qt/Free
194
<p> All trademarks belong to their respective owners.
197
<A NAME="toConnection__exception.html"></A><A NAME="ref16"></A><table width="100%"><tr bgcolor="#eeeeee"><td><strong>exception</strong> <small>(class)</small></td><td align="right"><h3><strong>exception</strong></h3></td></tr></table><p></p><p> Class that could be used to throw exceptions in connection errors. Must use if you
198
want to indicate error offset.
200
<A NAME="toConnection__objectName.html"></A><A NAME="ref17"></A><table width="100%"><tr bgcolor="#eeeeee"><td><strong>objectName</strong> <small>(struct)</small></td><td align="right"><h3><strong>objectName</strong></h3></td></tr></table><p></p><p> Contain information about a tablename.
202
<A NAME="toConnection__connectionImpl.html"></A><A NAME="ref18"></A><table width="100%"><tr bgcolor="#eeeeee"><td><strong>connectionImpl</strong> <small>(class)</small></td><td align="right"><h3><strong>connectionImpl</strong></h3></td></tr></table><p></p><p> This class is an abstract baseclass to actually implement the comunication with the
204
(See also toQuery::queryImpl and <A HREF="toConnectionProvider.html">toConnectionProvider</A>)
206
<A NAME="toConnection"></A><A NAME="ref36"></A><table width="100%"><tr bgcolor="#eeeeee"><td> <strong>toConnection</strong> (const <A HREF="/usr/lib/qt3/doc/html/qcstring.html">QCString</A> &provider,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &user,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &password,
207
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &host,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &database,const std::set<<A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A>> &options,
209
<br></td><td align="right"><h3><strong>toConnection</strong></h3></td></tr></table><p></p><p> Create a new connection.
211
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
212
<TR><TD align="left" valign="top"><i>provider</i></TD><TD align="left" valign="top">Which database provider to use for this connection.
213
(See to toDatabaseConnection)
215
<TR><TD align="left" valign="top"><i>user</i></TD><TD align="left" valign="top">User to connect to the database with.
217
<TR><TD align="left" valign="top"><i>password</i></TD><TD align="left" valign="top">Password to connect with.
219
<TR><TD align="left" valign="top"><i>host</i></TD><TD align="left" valign="top">Host to connect to the database with.
221
<TR><TD align="left" valign="top"><i>database</i></TD><TD align="left" valign="top">Database to connect to.
223
<TR><TD align="left" valign="top"><i>options</i></TD><TD align="left" valign="top">Options used to connect to the database with.
225
<TR><TD align="left" valign="top"><i>cache</i></TD><TD align="left" valign="top">Enable object cache for this connection.
228
<A NAME="toConnection"></A><A NAME="ref37"></A><table width="100%"><tr bgcolor="#eeeeee"><td> <strong>toConnection</strong> (const <A HREF="toConnection.html">toConnection</A> &conn)
229
<br></td><td align="right"><h3><strong>toConnection</strong></h3></td></tr></table><p></p><p> Create a copy of a connection. Will not cache objects, so objects will never be available
232
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
233
<TR><TD align="left" valign="top"><i>conn</i></TD><TD align="left" valign="top">Connection to copy.
236
<A NAME="~toConnection"></A><A NAME="ref38"></A><table width="100%"><tr bgcolor="#eeeeee"><td> <strong>~toConnection</strong> ()
237
<br></td><td align="right"><h3><strong>~toConnection</strong></h3></td></tr></table><p> <small>[virtual]</small></p><p> Destroy connection.
239
<A NAME="options"></A><A NAME="ref39"></A><table width="100%"><tr bgcolor="#eeeeee"><td>const std::set<<A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A>> & <strong>options</strong> ()
240
<br></td><td align="right"><h3><strong>options</strong></h3></td></tr></table><p> <small>[const]</small></p><A NAME="closeWidgets"></A><A NAME="ref40"></A><table width="100%"><tr bgcolor="#eeeeee"><td>bool <strong>closeWidgets</strong> (void)
241
<br></td><td align="right"><h3><strong>closeWidgets</strong></h3></td></tr></table><p></p><p> Try to close all the widgets associated with this connection.
243
<p><b>Returns</b>: True if all widgets agreed to close.
245
<A NAME="user"></A><A NAME="ref41"></A><table width="100%"><tr bgcolor="#eeeeee"><td>const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> & <strong>user</strong> ()
246
<br></td><td align="right"><h3><strong>user</strong></h3></td></tr></table><p> <small>[const]</small></p><p> Get username of connection.
248
<A NAME="password"></A><A NAME="ref42"></A><table width="100%"><tr bgcolor="#eeeeee"><td>const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> & <strong>password</strong> ()
249
<br></td><td align="right"><h3><strong>password</strong></h3></td></tr></table><p> <small>[const]</small></p><p> Get password of connection.
251
<A NAME="setPassword"></A><A NAME="ref43"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>setPassword</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &pwd)
252
<br></td><td align="right"><h3><strong>setPassword</strong></h3></td></tr></table><p></p><p> Change password of connection.
254
<A NAME="host"></A><A NAME="ref44"></A><table width="100%"><tr bgcolor="#eeeeee"><td>const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> & <strong>host</strong> ()
255
<br></td><td align="right"><h3><strong>host</strong></h3></td></tr></table><p> <small>[const]</small></p><p> Get host of connection.
257
<A NAME="database"></A><A NAME="ref45"></A><table width="100%"><tr bgcolor="#eeeeee"><td>const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> & <strong>database</strong> ()
258
<br></td><td align="right"><h3><strong>database</strong></h3></td></tr></table><p> <small>[const]</small></p><p> Get database of connection.
260
<A NAME="version"></A><A NAME="ref46"></A><table width="100%"><tr bgcolor="#eeeeee"><td>const <A HREF="/usr/lib/qt3/doc/html/qcstring.html">QCString</A> & <strong>version</strong> ()
261
<br></td><td align="right"><h3><strong>version</strong></h3></td></tr></table><p> <small>[const]</small></p><p> Get version of connection.
263
<A NAME="provider"></A><A NAME="ref47"></A><table width="100%"><tr bgcolor="#eeeeee"><td>const <A HREF="/usr/lib/qt3/doc/html/qcstring.html">QCString</A> & <strong>provider</strong> ()
264
<br></td><td align="right"><h3><strong>provider</strong></h3></td></tr></table><p> <small>[const]</small></p><p> Get provider of connection.
266
<A NAME="setDatabase"></A><A NAME="ref48"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>setDatabase</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &database)
267
<br></td><td align="right"><h3><strong>setDatabase</strong></h3></td></tr></table><p></p><p> Change the current database. Observe that this only changes the record of what is the current database. You will still need
268
to change the database oppinion on what database is the current one.
270
<A NAME="description"></A><A NAME="ref49"></A><table width="100%"><tr bgcolor="#eeeeee"><td> <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> <strong>description</strong> (bool version=true)
271
<br></td><td align="right"><h3><strong>description</strong></h3></td></tr></table><p> <small>[const virtual]</small></p><p> Get a description of this connection.
273
<A NAME="setNeedCommit"></A><A NAME="ref50"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>setNeedCommit</strong> (bool needCommit=true)
274
<br></td><td align="right"><h3><strong>setNeedCommit</strong></h3></td></tr></table><p></p><p> Set if this connection needs to be commited.
276
<A NAME="needCommit"></A><A NAME="ref51"></A><table width="100%"><tr bgcolor="#eeeeee"><td>bool <strong>needCommit</strong> (void)
277
<br></td><td align="right"><h3><strong>needCommit</strong></h3></td></tr></table><p> <small>[const]</small></p><p>
278
Get information about if the connection has uncommited data.
281
<p><b>Returns</b>: Whether uncommited data is available.
283
<A NAME="commit"></A><A NAME="ref52"></A><table width="100%"><tr bgcolor="#eeeeee"><td> void <strong>commit</strong> (void)
284
<br></td><td align="right"><h3><strong>commit</strong></h3></td></tr></table><p> <small>[virtual]</small></p><p>
285
Commit connection. This will also close all extra connections except one.
287
<A NAME="rollback"></A><A NAME="ref53"></A><table width="100%"><tr bgcolor="#eeeeee"><td> void <strong>rollback</strong> (void)
288
<br></td><td align="right"><h3><strong>rollback</strong></h3></td></tr></table><p> <small>[virtual]</small></p><p>
289
Rollback connection. This will also close all extra connections except one.
291
<A NAME="parse"></A><A NAME="ref54"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>parse</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql)
292
<br></td><td align="right"><h3><strong>parse</strong></h3></td></tr></table><p></p><p> Parse a query on an actual connection and report any syntax problems encountered.
293
Defaults to not implemented.
295
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
296
<TR><TD align="left" valign="top"><i>conn</i></TD><TD align="left" valign="top">Connection to execute on.
298
<TR><TD align="left" valign="top"><i>sql</i></TD><TD align="left" valign="top">SQL to parse
301
<A NAME="parse"></A><A NAME="ref55"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>parse</strong> (const <A HREF="toSQL.html">toSQL</A> &sql)
302
<br></td><td align="right"><h3><strong>parse</strong></h3></td></tr></table><p></p><p> Parse a query on an actual connection and report any syntax problems encountered.
303
Defaults to not implemented.
305
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
306
<TR><TD align="left" valign="top"><i>conn</i></TD><TD align="left" valign="top">Connection to execute on.
308
<TR><TD align="left" valign="top"><i>sql</i></TD><TD align="left" valign="top">SQL to parse
311
<A NAME="execute"></A><A NAME="ref56"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>execute</strong> (const <A HREF="toSQL.html">toSQL</A> &sql,
312
<A HREF="#toQList">toQList</A> ¶ms)
313
<br></td><td align="right"><h3><strong>execute</strong></h3></td></tr></table><p></p><p> Execute a statement without caring about the result.
315
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
316
<TR><TD align="left" valign="top"><i>sql</i></TD><TD align="left" valign="top">SQL to execute
318
<TR><TD align="left" valign="top"><i>params</i></TD><TD align="left" valign="top">Parameters to pass to query.
321
<A NAME="execute"></A><A NAME="ref57"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>execute</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql,
322
<A HREF="#toQList">toQList</A> ¶ms)
323
<br></td><td align="right"><h3><strong>execute</strong></h3></td></tr></table><p></p><p> Execute a statement without caring about the result.
325
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
326
<TR><TD align="left" valign="top"><i>sql</i></TD><TD align="left" valign="top">SQL to execute
328
<TR><TD align="left" valign="top"><i>params</i></TD><TD align="left" valign="top">Parameters to pass to query.
331
<A NAME="execute"></A><A NAME="ref58"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>execute</strong> (const <A HREF="toSQL.html">toSQL</A> &sql,
332
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg1=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg2=QString::null,
333
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg3=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg4=QString::null,
334
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg5=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg6=QString::null,
335
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg7=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg8=QString::null,
336
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg9=QString::null)
337
<br></td><td align="right"><h3><strong>execute</strong></h3></td></tr></table><p></p><p> Execute a statement without caring about the result.
339
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
340
<TR><TD align="left" valign="top"><i>sql</i></TD><TD align="left" valign="top">SQL to execute
342
<TR><TD align="left" valign="top"><i>arg1</i></TD><TD align="left" valign="top">Parameters to pass to query.
345
<A NAME="execute"></A><A NAME="ref59"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>execute</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql,
346
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg1=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg2=QString::null,
347
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg3=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg4=QString::null,
348
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg5=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg6=QString::null,
349
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg7=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg8=QString::null,
350
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg9=QString::null)
351
<br></td><td align="right"><h3><strong>execute</strong></h3></td></tr></table><p></p><p> Execute a statement without caring about the result.
353
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
354
<TR><TD align="left" valign="top"><i>sql</i></TD><TD align="left" valign="top">SQL to execute
356
<TR><TD align="left" valign="top"><i>arg1</i></TD><TD align="left" valign="top">Parameters to pass to query.
359
<A NAME="allExecute"></A><A NAME="ref60"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>allExecute</strong> (const <A HREF="toSQL.html">toSQL</A> &sql,
360
<A HREF="#toQList">toQList</A> ¶ms)
361
<br></td><td align="right"><h3><strong>allExecute</strong></h3></td></tr></table><p></p><p> Execute a statement without caring about the result on all open database connections.
363
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
364
<TR><TD align="left" valign="top"><i>sql</i></TD><TD align="left" valign="top">SQL to execute
366
<TR><TD align="left" valign="top"><i>params</i></TD><TD align="left" valign="top">Parameters to pass to query.
369
<A NAME="allExecute"></A><A NAME="ref61"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>allExecute</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql,
370
<A HREF="#toQList">toQList</A> ¶ms)
371
<br></td><td align="right"><h3><strong>allExecute</strong></h3></td></tr></table><p></p><p> Execute a statement without caring about the result on all open database connections.
373
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
374
<TR><TD align="left" valign="top"><i>sql</i></TD><TD align="left" valign="top">SQL to execute
376
<TR><TD align="left" valign="top"><i>params</i></TD><TD align="left" valign="top">Parameters to pass to query.
379
<A NAME="allExecute"></A><A NAME="ref62"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>allExecute</strong> (const <A HREF="toSQL.html">toSQL</A> &sql,
380
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg1=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg2=QString::null,
381
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg3=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg4=QString::null,
382
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg5=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg6=QString::null,
383
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg7=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg8=QString::null,
384
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg9=QString::null)
385
<br></td><td align="right"><h3><strong>allExecute</strong></h3></td></tr></table><p></p><p> Execute a statement without caring about the result on all open database connections.
387
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
388
<TR><TD align="left" valign="top"><i>sql</i></TD><TD align="left" valign="top">SQL to execute
390
<TR><TD align="left" valign="top"><i>arg1</i></TD><TD align="left" valign="top">Parameters to pass to query.
393
<A NAME="allExecute"></A><A NAME="ref63"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>allExecute</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql,
394
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg1=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg2=QString::null,
395
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg3=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg4=QString::null,
396
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg5=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg6=QString::null,
397
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg7=QString::null,const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg8=QString::null,
398
const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &arg9=QString::null)
399
<br></td><td align="right"><h3><strong>allExecute</strong></h3></td></tr></table><p></p><p> Execute a statement without caring about the result on all open database connections.
401
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
402
<TR><TD align="left" valign="top"><i>sql</i></TD><TD align="left" valign="top">SQL to execute
404
<TR><TD align="left" valign="top"><i>arg1</i></TD><TD align="left" valign="top">Parameters to pass to query.
407
<A NAME="addWidget"></A><A NAME="ref64"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>addWidget</strong> (<A HREF="/usr/lib/qt3/doc/html/qobject.html">QObject</A> *widget)
408
<br></td><td align="right"><h3><strong>addWidget</strong></h3></td></tr></table><p></p><p>
409
Add a object that uses this connection. This is needed to ensure that all widgets
410
that make use of a connection are destroyed when the connection is closed. Usually
411
tool windows need to call this function.
414
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
415
<TR><TD align="left" valign="top"><i>widget</i></TD><TD align="left" valign="top">The widget to add to the connection.
418
<A NAME="delWidget"></A><A NAME="ref65"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>delWidget</strong> (<A HREF="/usr/lib/qt3/doc/html/qobject.html">QObject</A> *widget)
419
<br></td><td align="right"><h3><strong>delWidget</strong></h3></td></tr></table><p></p><p>
420
Remove a widget from this connection. Should be called by the destructor of the
421
widget that has called addWidget.
424
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
425
<TR><TD align="left" valign="top"><i>widget</i></TD><TD align="left" valign="top">Widget to remove from the widget list.
428
<p><b>See also</b>: addWidget</p>
429
<A NAME="addInit"></A><A NAME="ref66"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>addInit</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql)
430
<br></td><td align="right"><h3><strong>addInit</strong></h3></td></tr></table><p></p><p>
431
Add a statement to be run uppon making new connections.
433
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
434
<TR><TD align="left" valign="top"><i>sql</i></TD><TD align="left" valign="top">Statement to run.
437
<A NAME="delInit"></A><A NAME="ref67"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>delInit</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &sql)
438
<br></td><td align="right"><h3><strong>delInit</strong></h3></td></tr></table><p></p><p>
439
Remove a statement that was added using <A HREF="toConnection.html#addInit">addInit</A>.
441
<A NAME="initStrings"></A><A NAME="ref68"></A><table width="100%"><tr bgcolor="#eeeeee"><td>const std::list<<A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A>> & <strong>initStrings</strong> ()
442
<br></td><td align="right"><h3><strong>initStrings</strong></h3></td></tr></table><p> <small>[const]</small></p><p>
443
Get a list of the current init strings.
445
<A NAME="quote"></A><A NAME="ref69"></A><table width="100%"><tr bgcolor="#eeeeee"><td><A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> <strong>quote</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &name)
446
<br></td><td align="right"><h3><strong>quote</strong></h3></td></tr></table><p></p><p> Return a string representation to address an object.
448
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
449
<TR><TD align="left" valign="top"><i>name</i></TD><TD align="left" valign="top">The name to be quoted.
452
<p><b>Returns</b>: String addressing table.
454
<A NAME="unQuote"></A><A NAME="ref70"></A><table width="100%"><tr bgcolor="#eeeeee"><td><A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> <strong>unQuote</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &name)
455
<br></td><td align="right"><h3><strong>unQuote</strong></h3></td></tr></table><p></p><p> Perform the opposite of <A HREF="toConnection.html#quote">quote</A>.
457
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
458
<TR><TD align="left" valign="top"><i>name</i></TD><TD align="left" valign="top">The name to be un-quoted.
461
<p><b>Returns</b>: String addressing table.
463
<A NAME="objects"></A><A NAME="ref71"></A><table width="100%"><tr bgcolor="#eeeeee"><td>std::list<objectName> & <strong>objects</strong> (bool block)
464
<br></td><td align="right"><h3><strong>objects</strong></h3></td></tr></table><p></p><p>
465
Get the objects available for the current user. Do not modify the returned list.
467
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
468
<TR><TD align="left" valign="top"><i>block</i></TD><TD align="left" valign="top">Indicate wether or not to block until cached objects are available.
471
<p><b>Returns</b>: A list of object available for the current user. The list is sorted in
472
owner and name order.
474
<A NAME="addIfNotExists"></A><A NAME="ref72"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>addIfNotExists</strong> (objectName &object)
475
<br></td><td align="right"><h3><strong>addIfNotExists</strong></h3></td></tr></table><p></p><p> Add a new object to the objectlist if it doesn't exist already.
477
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
478
<TR><TD align="left" valign="top"><i>object</i></TD><TD align="left" valign="top">The object to add
481
<A NAME="analyzer"></A><A NAME="ref73"></A><table width="100%"><tr bgcolor="#eeeeee"><td> <A HREF="toSyntaxAnalyzer.html">toSyntaxAnalyzer</A> & <strong>analyzer</strong> ()
482
<br></td><td align="right"><h3><strong>analyzer</strong></h3></td></tr></table><p> <small>[virtual]</small></p><p>
483
Get syntax analyzer for connection
485
<p><b>Returns</b>: A reference to the syntax analyzer to use for the connection.
487
<A NAME="synonyms"></A><A NAME="ref74"></A><table width="100%"><tr bgcolor="#eeeeee"><td>std::map<<A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A>,objectName> & <strong>synonyms</strong> (bool block)
488
<br></td><td align="right"><h3><strong>synonyms</strong></h3></td></tr></table><p></p><p>
489
Get the synonyms available for objects. Do not modify the returned list.
491
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
492
<TR><TD align="left" valign="top"><i>block</i></TD><TD align="left" valign="top">Indicate wether or not to block until cached objects are available.
495
<p><b>Returns</b>: A list of synonyms to objects available for the current user.
497
<A NAME="columns"></A><A NAME="ref75"></A><table width="100%"><tr bgcolor="#eeeeee"><td><A HREF="#toQDescList">toQDescList</A> & <strong>columns</strong> (const objectName &table,bool nocache=false)
498
<br></td><td align="right"><h3><strong>columns</strong></h3></td></tr></table><p></p><p>
499
Get a list of the available columns for a table. This function caches the responses
500
and should be fairly fast after the first call. Do not modify the returned list.
502
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
503
<TR><TD align="left" valign="top"><i>table</i></TD><TD align="left" valign="top">The table to describe.
505
<TR><TD align="left" valign="top"><i>nocache</i></TD><TD align="left" valign="top">Don't use cached values even if they are available.
508
<p><b>Returns</b>: A list of the columns for a table.
510
<A NAME="rereadCache"></A><A NAME="ref76"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>rereadCache</strong> (void)
511
<br></td><td align="right"><h3><strong>rereadCache</strong></h3></td></tr></table><p></p><p>
512
Reread the object and column cache.
514
<A NAME="realName"></A><A NAME="ref77"></A><table width="100%"><tr bgcolor="#eeeeee"><td>const objectName & <strong>realName</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &object,bool block)
515
<br></td><td align="right"><h3><strong>realName</strong></h3></td></tr></table><p></p><p>
516
Get the real object name of an object.
518
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
519
<TR><TD align="left" valign="top"><i>object</i></TD><TD align="left" valign="top">Object name
521
<TR><TD align="left" valign="top"><i>block</i></TD><TD align="left" valign="top">Block if not done caching object.
524
<A NAME="realName"></A><A NAME="ref78"></A><table width="100%"><tr bgcolor="#eeeeee"><td>const objectName & <strong>realName</strong> (const <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &object,<A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> &synonym,bool block)
525
<br></td><td align="right"><h3><strong>realName</strong></h3></td></tr></table><p></p><p>
526
Get the real object name of a synonym.
528
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
529
<TR><TD align="left" valign="top"><i>object</i></TD><TD align="left" valign="top">Object name
531
<TR><TD align="left" valign="top"><i>synonym</i></TD><TD align="left" valign="top">Filled with the synonym used to access the object returned or empty.
533
<TR><TD align="left" valign="top"><i>block</i></TD><TD align="left" valign="top">Block if not done caching object.
536
<A NAME="cacheAvailable"></A><A NAME="ref79"></A><table width="100%"><tr bgcolor="#eeeeee"><td>bool <strong>cacheAvailable</strong> (bool synonyms,bool block=false,bool need=true)
537
<br></td><td align="right"><h3><strong>cacheAvailable</strong></h3></td></tr></table><p></p><p> Check if cache is available or not.
539
<p><b>Parameters</b>:<TABLE BORDER="0" CELLPADDING="5">
540
<TR><TD align="left" valign="top"><i>synonyms</i></TD><TD align="left" valign="top">If synonyms are needed or not.
542
<TR><TD align="left" valign="top"><i>block</i></TD><TD align="left" valign="top">Block until cache is done.
544
<TR><TD align="left" valign="top"><i>true</i></TD><TD align="left" valign="top">True if you need the cache, or just checking.
547
<p><b>Returns</b>: True if cache is available.
549
<A NAME="cancelAll"></A><A NAME="ref80"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>cancelAll</strong> (void)
550
<br></td><td align="right"><h3><strong>cancelAll</strong></h3></td></tr></table><p></p><p> Try to stop all running queries.
552
<A NAME="loadDiskCache"></A><A NAME="ref81"></A><table width="100%"><tr bgcolor="#eeeeee"><td>bool <strong>loadDiskCache</strong> (void)
553
<br></td><td align="right"><h3><strong>loadDiskCache</strong></h3></td></tr></table><p></p><p> load disk cache
555
<A NAME="writeDiskCache"></A><A NAME="ref82"></A><table width="100%"><tr bgcolor="#eeeeee"><td>void <strong>writeDiskCache</strong> (void)
556
<br></td><td align="right"><h3><strong>writeDiskCache</strong></h3></td></tr></table><p></p><p> write disk cache
558
<A NAME="running"></A><A NAME="ref83"></A><table width="100%"><tr bgcolor="#eeeeee"><td>std::list<<A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A>> <strong>running</strong> (void)
559
<br></td><td align="right"><h3><strong>running</strong></h3></td></tr></table><p></p><p> Get a list of currently running SQL.
561
<A NAME="cacheDir"></A><A NAME="ref84"></A><table width="100%"><tr bgcolor="#eeeeee"><td> <A HREF="/usr/lib/qt3/doc/html/qstring.html">QString</A> <strong>cacheDir</strong> ()
562
<br></td><td align="right"><h3><strong>cacheDir</strong></h3></td></tr></table><p> <small>[static]</small></p><A NAME="toQuery"></A><A NAME="ref85"></A><table width="100%"><tr bgcolor="#eeeeee"><td>friend class <strong>toQuery</strong>
563
</td><td align="right"><h3><strong>toQuery</strong></h3></td></tr></table><p></p><HR>
565
<tr><td><small>Generated by: nneul on skyhawk on Wed Feb 23 19:49:58 2005, using kdoc 2.0a54.</small></td></tr>