<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> <title>Wt: Wt::Dbo::SqlConnection Class Reference</title> <link href="tabs.css" rel="stylesheet" type="text/css"/> <link href="doxygen.css" rel="stylesheet" type="text/css" /> <link href="search/search.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="jquery.js"></script> <script type="text/javascript" src="search/search.js"></script> <script type="text/javascript"> $(document).ready(function() { searchBox.OnSelectItem(0); }); </script> </head> <body> <div id="top"><!-- do not remove this div! --> <div id="titlearea"> <table cellspacing="0" cellpadding="0"> <tbody> <tr style="height: 56px;"> <td style="padding-left: 0.5em;"> <div id="projectname">Wt  <span id="projectnumber">3.2.3</span> </div> </td> </tr> </tbody> </table> </div> <!-- Generated by Doxygen 1.7.5.1 --> <script type="text/javascript"> var searchBox = new SearchBox("searchBox", "search",false,'Search'); </script> <div id="navrow1" class="tabs"> <ul class="tablist"> <li><a href="index.html"><span>Main Page</span></a></li> <li><a href="pages.html"><span>Related Pages</span></a></li> <li><a href="modules.html"><span>Modules</span></a></li> <li><a href="namespaces.html"><span>Namespaces</span></a></li> <li class="current"><a href="annotated.html"><span>Classes</span></a></li> <li><a href="files.html"><span>Files</span></a></li> <li> <div id="MSearchBox" class="MSearchBoxInactive"> <span class="left"> <img id="MSearchSelect" src="search/mag_sel.png" onmouseover="return searchBox.OnSearchSelectShow()" onmouseout="return searchBox.OnSearchSelectHide()" alt=""/> <input type="text" id="MSearchField" value="Search" accesskey="S" onfocus="searchBox.OnSearchFieldFocus(true)" onblur="searchBox.OnSearchFieldFocus(false)" onkeyup="searchBox.OnSearchFieldChange(event)"/> </span><span class="right"> <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a> </span> </div> </li> </ul> </div> <div id="navrow2" class="tabs2"> <ul class="tablist"> <li><a href="annotated.html"><span>Class List</span></a></li> <li><a href="inherits.html"><span>Class Hierarchy</span></a></li> <li><a href="functions.html"><span>Class Members</span></a></li> </ul> </div> <div id="nav-path" class="navpath"> <ul> <li class="navelem"><a class="el" href="namespaceWt.html">Wt</a> </li> <li class="navelem"><a class="el" href="namespaceWt_1_1Dbo.html">Dbo</a> </li> <li class="navelem"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html">SqlConnection</a> </li> </ul> </div> </div> <div class="header"> <div class="summary"> <a href="#pub-methods">Public Member Functions</a> </div> <div class="headertitle"> <div class="title">Wt::Dbo::SqlConnection Class Reference<div class="ingroups"><a class="el" href="group__dbo.html">Database Objects (Wt::Dbo)</a></div></div> </div> </div> <div class="contents"> <!-- doxytag: class="Wt::Dbo::SqlConnection" --> <p>Abstract base class for an SQL connection. <a href="classWt_1_1Dbo_1_1SqlConnection.html#details">More...</a></p> <p><code>#include <Wt/Dbo/SqlConnection></code></p> <div class="dynheader"> Inheritance diagram for Wt::Dbo::SqlConnection:</div> <div class="dyncontent"> <div class="center"><img src="classWt_1_1Dbo_1_1SqlConnection__inherit__graph.png" border="0" usemap="#Wt_1_1Dbo_1_1SqlConnection_inherit__map" alt="Inheritance graph"/></div> <map name="Wt_1_1Dbo_1_1SqlConnection_inherit__map" id="Wt_1_1Dbo_1_1SqlConnection_inherit__map"> <area shape="rect" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html" title="A Firebird connection." alt="" coords="5,80,181,107"/><area shape="rect" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html" title="A PostgreSQL connection." alt="" coords="205,80,392,107"/><area shape="rect" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html" title="An SQLite3 connection." alt="" coords="416,80,589,107"/></map> <center><span class="legend">[<a href="graph_legend.html">legend</a>]</span></center></div> <p><a href="classWt_1_1Dbo_1_1SqlConnection-members.html">List of all members.</a></p> <table class="memberdecls"> <tr><td colspan="2"><h2><a name="pub-methods"></a> Public Member Functions</h2></td></tr> <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a23fffafcf577071d2db5c2d98ecfe60c"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::~SqlConnection" ref="a23fffafcf577071d2db5c2d98ecfe60c" args="()" --> virtual </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a23fffafcf577071d2db5c2d98ecfe60c">~SqlConnection</a> ()</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Destructor. <br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html">SqlConnection</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a60168581b0fdeb4a6404358455a2ac8d">clone</a> () const =0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Clones the connection. <a href="#a60168581b0fdeb4a6404358455a2ac8d"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a2c45628057f538e8a706eff6d4d9f559">executeSql</a> (const std::string &sql)</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Executes an SQL statement. <a href="#a2c45628057f538e8a706eff6d4d9f559"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#abcddbb27f50192113d14c66a5ca10731">startTransaction</a> ()=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Starts a transaction. <a href="#abcddbb27f50192113d14c66a5ca10731"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a38ed9ab4831a0bfd8694f250813803bf">commitTransaction</a> ()=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Commits a transaction. <a href="#a38ed9ab4831a0bfd8694f250813803bf"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#aee5a42b2f3b452d32360a1c31f59f22d">rollbackTransaction</a> ()=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Rolls back a transaction. <a href="#aee5a42b2f3b452d32360a1c31f59f22d"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual <a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html">SqlStatement</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#aedb8c49c71db9e7c60f6cc44a568e3ed">getStatement</a> (const std::string &id) const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the statement with the given id. <a href="#aedb8c49c71db9e7c60f6cc44a568e3ed"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a1c0c4efecf0b2360c54e46edf1cf5f64">saveStatement</a> (const std::string &id, <a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html">SqlStatement</a> *statement)</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Saves a statement with the given id. <a href="#a1c0c4efecf0b2360c54e46edf1cf5f64"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual <a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html">SqlStatement</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#afbebcc0007aef36f6aa02b61f514b853">prepareStatement</a> (const std::string &sql)=0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Prepares a statement. <a href="#afbebcc0007aef36f6aa02b61f514b853"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a7c2b5415d52fa69321d031b65980209d">setProperty</a> (const std::string &name, const std::string &value)</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Sets a property. <a href="#a7c2b5415d52fa69321d031b65980209d"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">std::string </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#ace6e451d52c7c8e88daf3af8f5b578dc">property</a> (const std::string &name) const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns a property. <a href="#ace6e451d52c7c8e88daf3af8f5b578dc"></a><br/></td></tr> <tr><td colspan="2"><div class="groupHeader">Methods that return dialect information</div></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual std::string </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a8c00fd64eb82999880cc813ef3866f5d">autoincrementSql</a> () const =0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the 'autoincrement' SQL type modifier. <a href="#a8c00fd64eb82999880cc813ef3866f5d"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual std::vector< std::string > </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a7922dac3fd8a808dbbeef97a5a772e3f">autoincrementCreateSequenceSql</a> (const std::string &table, const std::string &id) const =0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the SQL statement(s) required to create an id sequence. <a href="#a7922dac3fd8a808dbbeef97a5a772e3f"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual std::vector< std::string > </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a188acc931dd1d3dbd3a21e28783f7bd2">autoincrementDropSequenceSql</a> (const std::string &table, const std::string &id) const =0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the SQL statement(s) required to drop an id sequence. <a href="#a188acc931dd1d3dbd3a21e28783f7bd2"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual std::string </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#aff293ff5ad586e15143729eb38300ad6">autoincrementType</a> () const =0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the 'autoincrement' SQL type. <a href="#aff293ff5ad586e15143729eb38300ad6"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual std::string </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#aec6a5227e676cf373f842e4d1ac75f12">autoincrementInsertSuffix</a> () const =0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the suffix for an 'autoincrement' insert statement. <a href="#aec6a5227e676cf373f842e4d1ac75f12"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual void </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a16913d73967d28ac86476688a59b057a">prepareForDropTables</a> ()</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Execute code before dropping the tables. <a href="#a16913d73967d28ac86476688a59b057a"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#af1f3290a984288175c6d82d088d0636c">dateTimeType</a> (<a class="el" href="namespaceWt_1_1Dbo.html#af213c090c1ccddc36d70d56e0804047f">SqlDateTimeType</a> type) const =0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the date/time type. <a href="#af1f3290a984288175c6d82d088d0636c"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a68a272eaafeef5e04912914f0662da39">blobType</a> () const =0</td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the blob type. <a href="#a68a272eaafeef5e04912914f0662da39"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#ac0530e7ce88b5c720876d430ac0ff675">textType</a> () const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the text type. <a href="#ac0530e7ce88b5c720876d430ac0ff675"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a9ac4a9c6803447204843b722961cf79b">booleanType</a> () const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the boolean type. <a href="#a9ac4a9c6803447204843b722961cf79b"></a><br/></td></tr> <tr><td class="memItemLeft" align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a3930f33892ccf74e74daa31db3579643">usesRowsFromTo</a> () const </td></tr> <tr><td class="mdescLeft"> </td><td class="mdescRight">Returns whether the SQL dialect uses 'ROWS ? TO ?' for partial select results. <a href="#a3930f33892ccf74e74daa31db3579643"></a><br/></td></tr> </table> <hr/><a name="details" id="details"></a><h2>Detailed Description</h2> <div class="textblock"><p>Abstract base class for an SQL connection. </p> <p>An sql connection manages a single connection to a database. It also manages a map of previously prepared statements indexed by id's.</p> <p>This class is part of <a class="el" href="namespaceWt_1_1Dbo.html" title="Namespace for the Database Objects (Wt::Dbo).">Wt::Dbo</a>'s backend API, and should not be used directly. </p> </div><hr/><h2>Member Function Documentation</h2> <a class="anchor" id="a7922dac3fd8a808dbbeef97a5a772e3f"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::autoincrementCreateSequenceSql" ref="a7922dac3fd8a808dbbeef97a5a772e3f" args="(const std::string &table, const std::string &id) const =0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual std::vector<std::string> Wt::Dbo::SqlConnection::autoincrementCreateSequenceSql </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>table</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>id</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td> const<code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the SQL statement(s) required to create an id sequence. </p> <p>This is used by <a class="el" href="classWt_1_1Dbo_1_1Session.html#aba79d84c7c91faae06f954e6d3d390ab" title="Creates the database schema.">Session::createTables()</a> to create the id sequence for a table. The table's name and primary key are passed as arguments to this function and can be used to construct an SQL sequence that is unique for the table. </p> <p>Implemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a61769fc0ebdb13a2374a17a76d2d8560">Wt::Dbo::backend::Sqlite3</a>, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a9d8949cdad9f26e27a7b74682171bc1d">Wt::Dbo::backend::Firebird</a>, and <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#ab6ea8bdba8d248a593df1e66548ff567">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="a188acc931dd1d3dbd3a21e28783f7bd2"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::autoincrementDropSequenceSql" ref="a188acc931dd1d3dbd3a21e28783f7bd2" args="(const std::string &table, const std::string &id) const =0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual std::vector<std::string> Wt::Dbo::SqlConnection::autoincrementDropSequenceSql </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>table</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>id</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td> const<code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the SQL statement(s) required to drop an id sequence. </p> <p>This is used by <a class="el" href="classWt_1_1Dbo_1_1Session.html#a4c1fedb21e4e1cc44b182a34e8ebb4ef" title="Drops the database schema.">Session::dropTables()</a> to drop the id sequence for a table. The table's name and primary key are passed as arguments to this function and can be used to construct an SQL sequence that is unique for the table. </p> <p>Implemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a8d3e3e98ca13095efa0fe7918cbb9bcb">Wt::Dbo::backend::Sqlite3</a>, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a4447de10fa42eff2cb12d0b31ca2a07e">Wt::Dbo::backend::Firebird</a>, and <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#af82c7852c789cfc8dc79dd17a88f9fe2">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="aec6a5227e676cf373f842e4d1ac75f12"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::autoincrementInsertSuffix" ref="aec6a5227e676cf373f842e4d1ac75f12" args="() const =0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual std::string Wt::Dbo::SqlConnection::autoincrementInsertSuffix </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the suffix for an 'autoincrement' insert statement. </p> <p>This is appended to the <code>insert</code> statement, since some back-ends need to be indicated that they should return the autoincrement id. </p> <p>Implemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a597ce9d1ff2702ac08e5dd6a0dcb9a98">Wt::Dbo::backend::Sqlite3</a>, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#ae7187b5489e855833c06e0acc3626f36">Wt::Dbo::backend::Firebird</a>, and <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#af05af24a4bd0c20a090387056d724745">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="a8c00fd64eb82999880cc813ef3866f5d"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::autoincrementSql" ref="a8c00fd64eb82999880cc813ef3866f5d" args="() const =0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual std::string Wt::Dbo::SqlConnection::autoincrementSql </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the 'autoincrement' SQL type modifier. </p> <p>This is used by <a class="el" href="classWt_1_1Dbo_1_1Session.html#aba79d84c7c91faae06f954e6d3d390ab" title="Creates the database schema.">Session::createTables()</a> to create the <em>id</em> column. </p> <p>Implemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a85f442f34549768a96fefa7548045c41">Wt::Dbo::backend::Sqlite3</a>, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a1a5268d9d6576bea4170f306ca880134">Wt::Dbo::backend::Firebird</a>, and <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a92adbae7113272038f0ceb6ca6a93ccc">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="aff293ff5ad586e15143729eb38300ad6"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::autoincrementType" ref="aff293ff5ad586e15143729eb38300ad6" args="() const =0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual std::string Wt::Dbo::SqlConnection::autoincrementType </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the 'autoincrement' SQL type. </p> <p>This is used by <a class="el" href="classWt_1_1Dbo_1_1Session.html#aba79d84c7c91faae06f954e6d3d390ab" title="Creates the database schema.">Session::createTables()</a> to create the <em>id</em> column. </p> <p>Implemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a969dbaea3af070592bc8630425326e99">Wt::Dbo::backend::Sqlite3</a>, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a9f8bb3d439e4125a5f4c1d3aee165090">Wt::Dbo::backend::Firebird</a>, and <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a5671d18ab68b492d590485458cca5122">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="a68a272eaafeef5e04912914f0662da39"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::blobType" ref="a68a272eaafeef5e04912914f0662da39" args="() const =0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual const char* Wt::Dbo::SqlConnection::blobType </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the blob type. </p> <dl class="see"><dt><b>See also:</b></dt><dd><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#ae2bbddef8fd8c11687d23187920dc4da" title="Binds a value to a column.">SqlStatement::bind(int, const std::vector<unsigned char>&)</a> </dd></dl> <p>Implemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a8e9060b7b68a93adb12e407c7658b24f">Wt::Dbo::backend::Sqlite3</a>, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a2d9775679aeef975d0ad0740570499a9">Wt::Dbo::backend::Firebird</a>, and <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a81acebb9e839ed7f976602396ae6ed0a">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="a9ac4a9c6803447204843b722961cf79b"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::booleanType" ref="a9ac4a9c6803447204843b722961cf79b" args="() const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char * Wt::Dbo::SqlConnection::booleanType </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the boolean type. </p> <p>This method will return "boolean" by default. </p> <p>Reimplemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a7d9d9bca98b7ca81d5ed41c533af663d">Wt::Dbo::backend::Firebird</a>.</p> </div> </div> <a class="anchor" id="a60168581b0fdeb4a6404358455a2ac8d"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::clone" ref="a60168581b0fdeb4a6404358455a2ac8d" args="() const =0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html">SqlConnection</a>* Wt::Dbo::SqlConnection::clone </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Clones the connection. </p> <p>Returns a new connection object that is configured like this object. This is used by connection pool implementations to create its connections. </p> <p>Implemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a339c61dbfc8a970c0bc5be02606eb8f8">Wt::Dbo::backend::Firebird</a>, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a85e4a7bf082eff1264f4b7290edd6f8f">Wt::Dbo::backend::Sqlite3</a>, and <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#ae905567f9ed51f9b200222a995c4894f">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="a38ed9ab4831a0bfd8694f250813803bf"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::commitTransaction" ref="a38ed9ab4831a0bfd8694f250813803bf" args="()=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual void Wt::Dbo::SqlConnection::commitTransaction </td> <td>(</td> <td class="paramname"></td><td>)</td> <td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Commits a transaction. </p> <p>This function commits a transaction. </p> <p>Implemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a0bb773ea028a7e0a1dc10f94fcc90b4d">Wt::Dbo::backend::Sqlite3</a>, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a56b3591933329229adbfc1c0ec031185">Wt::Dbo::backend::Firebird</a>, and <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a81966e0110e7d3c2076cf27a7e08e236">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="af1f3290a984288175c6d82d088d0636c"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::dateTimeType" ref="af1f3290a984288175c6d82d088d0636c" args="(SqlDateTimeType type) const =0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual const char* Wt::Dbo::SqlConnection::dateTimeType </td> <td>(</td> <td class="paramtype"><a class="el" href="namespaceWt_1_1Dbo.html#af213c090c1ccddc36d70d56e0804047f">SqlDateTimeType</a> </td> <td class="paramname"><em>type</em></td><td>)</td> <td> const<code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the date/time type. </p> <dl class="see"><dt><b>See also:</b></dt><dd><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#a94c43852e586bbcba7077352588fe1a2" title="Binds a value to a column.">SqlStatement::bind(int, const boost::posix_time::ptime&, SqlDateTimeType)</a> </dd></dl> <p>Implemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a4e4ecfd24b47a820974dc868a66d1eb5">Wt::Dbo::backend::Sqlite3</a>, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a2073cd53c0abfb9932dc8df941770b32">Wt::Dbo::backend::Firebird</a>, and <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a1e978200ba52918f2e2fd26a32dad456">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="a2c45628057f538e8a706eff6d4d9f559"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::executeSql" ref="a2c45628057f538e8a706eff6d4d9f559" args="(const std::string &sql)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Wt::Dbo::SqlConnection::executeSql </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>sql</em></td><td>)</td> <td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Executes an SQL statement. </p> <p>This is a convenience method for preparing a statement, executing it, and deleting it. </p> <p>Reimplemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#a9eaa769e442138ed02a0caed39cfd7f6">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="aedb8c49c71db9e7c60f6cc44a568e3ed"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::getStatement" ref="aedb8c49c71db9e7c60f6cc44a568e3ed" args="(const std::string &id) const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html">SqlStatement</a> * Wt::Dbo::SqlConnection::getStatement </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>id</em></td><td>)</td> <td> const<code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the statement with the given id. </p> <p>Returns 0 if no such statement was already added.</p> <dl class="see"><dt><b>See also:</b></dt><dd><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a1c0c4efecf0b2360c54e46edf1cf5f64" title="Saves a statement with the given id.">saveStatement()</a> </dd></dl> </div> </div> <a class="anchor" id="a16913d73967d28ac86476688a59b057a"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::prepareForDropTables" ref="a16913d73967d28ac86476688a59b057a" args="()" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Wt::Dbo::SqlConnection::prepareForDropTables </td> <td>(</td> <td class="paramname"></td><td>)</td> <td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Execute code before dropping the tables. </p> <p>This method is called before calling <a class="el" href="classWt_1_1Dbo_1_1Session.html#a4c1fedb21e4e1cc44b182a34e8ebb4ef" title="Drops the database schema.">Session::dropTables()</a>. The default implementation is empty. </p> <p>Reimplemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a64153183a5ae0daf2258fccf70144fec">Wt::Dbo::backend::Firebird</a>.</p> </div> </div> <a class="anchor" id="afbebcc0007aef36f6aa02b61f514b853"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::prepareStatement" ref="afbebcc0007aef36f6aa02b61f514b853" args="(const std::string &sql)=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual <a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html">SqlStatement</a>* Wt::Dbo::SqlConnection::prepareStatement </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>sql</em></td><td>)</td> <td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Prepares a statement. </p> <p>Returns the prepared statement. </p> <p>Implemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#ac254f423eb352ed08f63a11e7d9508a1">Wt::Dbo::backend::Sqlite3</a>, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#addca1f52322ec6288b2754026c492299">Wt::Dbo::backend::Firebird</a>, and <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#aa899b3109ba4400bf348384744a31e8f">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="ace6e451d52c7c8e88daf3af8f5b578dc"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::property" ref="ace6e451d52c7c8e88daf3af8f5b578dc" args="(const std::string &name) const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">std::string Wt::Dbo::SqlConnection::property </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>name</em></td><td>)</td> <td> const</td> </tr> </table> </div> <div class="memdoc"> <p>Returns a property. </p> <p>Returns the property value, or an empty string if the property was not set.</p> <dl class="see"><dt><b>See also:</b></dt><dd><a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a7c2b5415d52fa69321d031b65980209d" title="Sets a property.">setProperty()</a> </dd></dl> </div> </div> <a class="anchor" id="aee5a42b2f3b452d32360a1c31f59f22d"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::rollbackTransaction" ref="aee5a42b2f3b452d32360a1c31f59f22d" args="()=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual void Wt::Dbo::SqlConnection::rollbackTransaction </td> <td>(</td> <td class="paramname"></td><td>)</td> <td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Rolls back a transaction. </p> <p>This function rolls back a transaction. </p> <p>Implemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#aade642c39d87b4f796c196415ec5b16a">Wt::Dbo::backend::Sqlite3</a>, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a3c9321d6875365148673d04b5eb8d8de">Wt::Dbo::backend::Firebird</a>, and <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#aea0742af53f3306a3302647014a8e3e2">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="a1c0c4efecf0b2360c54e46edf1cf5f64"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::saveStatement" ref="a1c0c4efecf0b2360c54e46edf1cf5f64" args="(const std::string &id, SqlStatement *statement)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Wt::Dbo::SqlConnection::saveStatement </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>id</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html">SqlStatement</a> * </td> <td class="paramname"><em>statement</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td><code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Saves a statement with the given id. </p> <p>Saves the statement for future reuse using <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#aedb8c49c71db9e7c60f6cc44a568e3ed" title="Returns the statement with the given id.">getStatement()</a> </p> </div> </div> <a class="anchor" id="a7c2b5415d52fa69321d031b65980209d"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::setProperty" ref="a7c2b5415d52fa69321d031b65980209d" args="(const std::string &name, const std::string &value)" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Wt::Dbo::SqlConnection::setProperty </td> <td>(</td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>name</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const std::string & </td> <td class="paramname"><em>value</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div> <div class="memdoc"> <p>Sets a property. </p> <p>Properties may tailor the backend behavior. Some properties are applicable to all backends, while some are backend specific.</p> <p>General properties are:</p> <ul> <li><code>show-queries</code>: when value is "true", queries are shown as they are executed. </li> </ul> </div> </div> <a class="anchor" id="abcddbb27f50192113d14c66a5ca10731"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::startTransaction" ref="abcddbb27f50192113d14c66a5ca10731" args="()=0" --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">virtual void Wt::Dbo::SqlConnection::startTransaction </td> <td>(</td> <td class="paramname"></td><td>)</td> <td><code> [pure virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Starts a transaction. </p> <p>This function starts a transaction. </p> <p>Implemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a20a6959d6b8e0d14f2ccf764361954f6">Wt::Dbo::backend::Sqlite3</a>, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a1c28f7aa543d8abe3d8cdd9e6264e7a6">Wt::Dbo::backend::Firebird</a>, and <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Postgres.html#ac1148a180204342f6ca910d106b58b00">Wt::Dbo::backend::Postgres</a>.</p> </div> </div> <a class="anchor" id="ac0530e7ce88b5c720876d430ac0ff675"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::textType" ref="ac0530e7ce88b5c720876d430ac0ff675" args="() const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">const char * Wt::Dbo::SqlConnection::textType </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns the text type. </p> <p>This method will return "text" by default.</p> <dl class="see"><dt><b>See also:</b></dt><dd><a class="el" href="classWt_1_1Dbo_1_1SqlStatement.html#ad8b53ca87bdef11ceceb96ab05c260b9" title="Binds a value to a column.">SqlStatement::bind(int column, const std::string& value)</a> </dd></dl> <p>Reimplemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#aa277c3c0df80ceb2c9f47baca92ea7b4">Wt::Dbo::backend::Firebird</a>.</p> </div> </div> <a class="anchor" id="a3930f33892ccf74e74daa31db3579643"></a><!-- doxytag: member="Wt::Dbo::SqlConnection::usesRowsFromTo" ref="a3930f33892ccf74e74daa31db3579643" args="() const " --> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">bool Wt::Dbo::SqlConnection::usesRowsFromTo </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const<code> [virtual]</code></td> </tr> </table> </div> <div class="memdoc"> <p>Returns whether the SQL dialect uses 'ROWS ? TO ?' for partial select results. </p> <p>This is an alternative SQL dialect option to the (non-standard) 'OFFSET ? LIMIT ?' syntax.</p> <p>The default implementation returns <code>false</code>. </p> <p>Reimplemented in <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Firebird.html#a915df1060cffbd64eec882a707af7bc5">Wt::Dbo::backend::Firebird</a>.</p> </div> </div> </div> <!-- window showing the filter options --> <div id="MSearchSelectWindow" onmouseover="return searchBox.OnSearchSelectShow()" onmouseout="return searchBox.OnSearchSelectHide()" onkeydown="return searchBox.OnSearchSelectKey(event)"> <a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark"> </span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark"> </span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark"> </span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark"> </span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark"> </span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark"> </span>Enumerator</a></div> <!-- iframe showing the search results (closed by default) --> <div id="MSearchResultsWindow"> <iframe src="javascript:void(0)" frameborder="0" name="MSearchResults" id="MSearchResults"> </iframe> </div> <hr size="1"><address style="text-align: right; margin: 3px"><small> Generated on Thu Nov 1 2012 for <a href="http://www.webtoolkit.eu/wt">the C++ Web Toolkit (Wt)</a> by <a href="http://www.doxygen.org/index.html"><img src="doxygen.png" alt="doxygen" border="0" style="vertical-align: middle; display: inline-block; height: 2em"></a> 1.7.5.1</small></address> </body> </html>