<!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::backend::Sqlite3 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"><b>backend</b> </li>
<li class="navelem"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html">Sqlite3</a> </li>
</ul>
</div>
</div>
<div class="header">
<div class="summary">
<a href="#pub-types">Public Types</a> |
<a href="#pub-methods">Public Member Functions</a> </div>
<div class="headertitle">
<div class="title">Wt::Dbo::backend::Sqlite3 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::backend::Sqlite3" --><!-- doxytag: inherits="Wt::Dbo::SqlConnection" -->
<p>An SQLite3 connection.
<a href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#details">More...</a></p>
<p><code>#include <Wt/Dbo/backend/Sqlite3></code></p>
<div class="dynheader">
Inheritance diagram for Wt::Dbo::backend::Sqlite3:</div>
<div class="dyncontent">
<div class="center"><img src="classWt_1_1Dbo_1_1backend_1_1Sqlite3__inherit__graph.png" border="0" usemap="#Wt_1_1Dbo_1_1backend_1_1Sqlite3_inherit__map" alt="Inheritance graph"/></div>
<map name="Wt_1_1Dbo_1_1backend_1_1Sqlite3_inherit__map" id="Wt_1_1Dbo_1_1backend_1_1Sqlite3_inherit__map">
<area shape="rect" href="classWt_1_1Dbo_1_1SqlConnection.html" title="Abstract base class for an SQL connection." alt="" coords="12,5,172,32"/></map>
<center><span class="legend">[<a href="graph_legend.html">legend</a>]</span></center></div>
<p><a href="classWt_1_1Dbo_1_1backend_1_1Sqlite3-members.html">List of all members.</a></p>
<table class="memberdecls">
<tr><td colspan="2"><h2><a name="pub-types"></a>
Public Types</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">enum  </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#ae6e6142ccb1da626677b05ef8852fdaa">DateTimeStorage</a> { <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#ae6e6142ccb1da626677b05ef8852fdaaaad8bd1d664eb10133d13264263665e74">ISO8601AsText</a>,
<a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#ae6e6142ccb1da626677b05ef8852fdaaafb2526a0a5cfb42c452f3b002854c06d">PseudoISO8601AsText</a>,
<a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#ae6e6142ccb1da626677b05ef8852fdaaa83b21617ea295e7fceb7f6bc916a9b8a">JulianDaysAsReal</a>,
<a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#ae6e6142ccb1da626677b05ef8852fdaaa9f021d0996b88c6b5cea9facf3e52651">UnixTimeAsInteger</a>
}</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Configuration of date time storage. <a href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#ae6e6142ccb1da626677b05ef8852fdaa">More...</a><br/></td></tr>
<tr><td colspan="2"><h2><a name="pub-methods"></a>
Public Member Functions</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#ad392317a2278c700364f6096fcf12e67">Sqlite3</a> (const std::string &db)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Opens a new SQLite3 backend connection. <a href="#ad392317a2278c700364f6096fcf12e67"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a292580940953e8fea523144db1087766"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::Sqlite3" ref="a292580940953e8fea523144db1087766" args="(const Sqlite3 &other)" -->
 </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a292580940953e8fea523144db1087766">Sqlite3</a> (const <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html">Sqlite3</a> &other)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Copies an SQLite3 connection. <br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a8cdca9bc5d744a76663d14d1255af483">~Sqlite3</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Destructor. <a href="#a8cdca9bc5d744a76663d14d1255af483"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">virtual <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html">Sqlite3</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a85e4a7bf082eff1264f4b7290edd6f8f">clone</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Clones the connection. <a href="#a85e4a7bf082eff1264f4b7290edd6f8f"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a89c9fd929b5e051d187dabfb2f238ffc"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::connection" ref="a89c9fd929b5e051d187dabfb2f238ffc" args="()" -->
sqlite3 * </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a89c9fd929b5e051d187dabfb2f238ffc">connection</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the underlying connection. <br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a720823b4e4e9bfba9f732988bcd9a465"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::connectionString" ref="a720823b4e4e9bfba9f732988bcd9a465" args="()" -->
std::string </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a720823b4e4e9bfba9f732988bcd9a465">connectionString</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the underlying connection string. <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_1backend_1_1Sqlite3.html#a571f4019950aafc2b855d46d4e7072d5">setDateTimeStorage</a> (<a class="el" href="namespaceWt_1_1Dbo.html#af213c090c1ccddc36d70d56e0804047f">SqlDateTimeType</a> type, <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#ae6e6142ccb1da626677b05ef8852fdaa">DateTimeStorage</a> format)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Configures how to store date or date time. <a href="#a571f4019950aafc2b855d46d4e7072d5"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a975659c1b4349467a5f667323fc0f134"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::dateTimeStorage" ref="a975659c1b4349467a5f667323fc0f134" args="(SqlDateTimeType type) const " -->
<a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#ae6e6142ccb1da626677b05ef8852fdaa">DateTimeStorage</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#a975659c1b4349467a5f667323fc0f134">dateTimeStorage</a> (<a class="el" href="namespaceWt_1_1Dbo.html#af213c090c1ccddc36d70d56e0804047f">SqlDateTimeType</a> type) const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the date time storage. <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_1backend_1_1Sqlite3.html#a20a6959d6b8e0d14f2ccf764361954f6">startTransaction</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Starts a transaction. <a href="#a20a6959d6b8e0d14f2ccf764361954f6"></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_1backend_1_1Sqlite3.html#a0bb773ea028a7e0a1dc10f94fcc90b4d">commitTransaction</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Commits a transaction. <a href="#a0bb773ea028a7e0a1dc10f94fcc90b4d"></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_1backend_1_1Sqlite3.html#aade642c39d87b4f796c196415ec5b16a">rollbackTransaction</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Rolls back a transaction. <a href="#aade642c39d87b4f796c196415ec5b16a"></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_1backend_1_1Sqlite3.html#ac254f423eb352ed08f63a11e7d9508a1">prepareStatement</a> (const std::string &sql)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Prepares a statement. <a href="#ac254f423eb352ed08f63a11e7d9508a1"></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_1backend_1_1Sqlite3.html#a85f442f34549768a96fefa7548045c41">autoincrementSql</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the 'autoincrement' SQL type modifier. <a href="#a85f442f34549768a96fefa7548045c41"></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_1backend_1_1Sqlite3.html#a61769fc0ebdb13a2374a17a76d2d8560">autoincrementCreateSequenceSql</a> (const std::string &table, const std::string &id) const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the SQL statement(s) required to create an id sequence. <a href="#a61769fc0ebdb13a2374a17a76d2d8560"></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_1backend_1_1Sqlite3.html#a8d3e3e98ca13095efa0fe7918cbb9bcb">autoincrementDropSequenceSql</a> (const std::string &table, const std::string &id) const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the SQL statement(s) required to drop an id sequence. <a href="#a8d3e3e98ca13095efa0fe7918cbb9bcb"></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_1backend_1_1Sqlite3.html#a969dbaea3af070592bc8630425326e99">autoincrementType</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the 'autoincrement' SQL type. <a href="#a969dbaea3af070592bc8630425326e99"></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_1backend_1_1Sqlite3.html#a597ce9d1ff2702ac08e5dd6a0dcb9a98">autoincrementInsertSuffix</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the suffix for an 'autoincrement' insert statement. <a href="#a597ce9d1ff2702ac08e5dd6a0dcb9a98"></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_1backend_1_1Sqlite3.html#a4e4ecfd24b47a820974dc868a66d1eb5">dateTimeType</a> (<a class="el" href="namespaceWt_1_1Dbo.html#af213c090c1ccddc36d70d56e0804047f">SqlDateTimeType</a> type) const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the date/time type. <a href="#a4e4ecfd24b47a820974dc868a66d1eb5"></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_1backend_1_1Sqlite3.html#a8e9060b7b68a93adb12e407c7658b24f">blobType</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Returns the blob type. <a href="#a8e9060b7b68a93adb12e407c7658b24f"></a><br/></td></tr>
</table>
<hr/><a name="details" id="details"></a><h2>Detailed Description</h2>
<div class="textblock"><p>An SQLite3 connection. </p>
<p>This class provides the backend implementation for SQLite3 databases. </p>
</div><hr/><h2>Member Enumeration Documentation</h2>
<a class="anchor" id="ae6e6142ccb1da626677b05ef8852fdaa"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::DateTimeStorage" ref="ae6e6142ccb1da626677b05ef8852fdaa" args="" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">enum <a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#ae6e6142ccb1da626677b05ef8852fdaa">Wt::Dbo::backend::Sqlite3::DateTimeStorage</a></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Configuration of date time storage. </p>
<p>SQlite3 does not provide real type support for date time. Instead, it offers 3 choices for storing a date time, each of these compatible with the use of the built-in arithmetic functions. </p>
<dl><dt><b>Enumerator: </b></dt><dd><table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"><em><a class="anchor" id="ae6e6142ccb1da626677b05ef8852fdaaaad8bd1d664eb10133d13264263665e74"></a><!-- doxytag: member="ISO8601AsText" ref="ae6e6142ccb1da626677b05ef8852fdaaaad8bd1d664eb10133d13264263665e74" args="" -->ISO8601AsText</em> </td><td>
<p>As 'text' in ISO8601 format.</p>
<p>This also interprets correctly dates stored in the database using the PseudoISO8601AsText format. </p>
</td></tr>
<tr><td valign="top"><em><a class="anchor" id="ae6e6142ccb1da626677b05ef8852fdaaafb2526a0a5cfb42c452f3b002854c06d"></a><!-- doxytag: member="PseudoISO8601AsText" ref="ae6e6142ccb1da626677b05ef8852fdaaafb2526a0a5cfb42c452f3b002854c06d" args="" -->PseudoISO8601AsText</em> </td><td>
<p>As 'text' in ISO8601-like format, but using a space (' ') instead of 'T' as a separator character between date and time. This is the behaviour of <a class="el" href="namespaceWt_1_1Dbo.html" title="Namespace for the Database Objects (Wt::Dbo).">Wt::Dbo</a> prior to <a class="el" href="namespaceWt.html" title="The namespace for Wt.">Wt</a> 3.2.3.</p>
<p>This also interprets correctly dates stored in the database using the ISO8601AsText format. </p>
</td></tr>
<tr><td valign="top"><em><a class="anchor" id="ae6e6142ccb1da626677b05ef8852fdaaa83b21617ea295e7fceb7f6bc916a9b8a"></a><!-- doxytag: member="JulianDaysAsReal" ref="ae6e6142ccb1da626677b05ef8852fdaaa83b21617ea295e7fceb7f6bc916a9b8a" args="" -->JulianDaysAsReal</em> </td><td>
<p>As 'real', the number of julian days. Note that this does not support second accuracy for a date time, but is the preferred format for a plain date. </p>
</td></tr>
<tr><td valign="top"><em><a class="anchor" id="ae6e6142ccb1da626677b05ef8852fdaaa9f021d0996b88c6b5cea9facf3e52651"></a><!-- doxytag: member="UnixTimeAsInteger" ref="ae6e6142ccb1da626677b05ef8852fdaaa9f021d0996b88c6b5cea9facf3e52651" args="" -->UnixTimeAsInteger</em> </td><td>
<p>As 'integer', number of seconds since UNIX Epoch. </p>
</td></tr>
</table>
</dd>
</dl>
</div>
</div>
<hr/><h2>Constructor & Destructor Documentation</h2>
<a class="anchor" id="ad392317a2278c700364f6096fcf12e67"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::Sqlite3" ref="ad392317a2278c700364f6096fcf12e67" args="(const std::string &db)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">Wt::Dbo::backend::Sqlite3::Sqlite3 </td>
<td>(</td>
<td class="paramtype">const std::string & </td>
<td class="paramname"><em>db</em></td><td>)</td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Opens a new SQLite3 backend connection. </p>
<p>The <code>db</code> may be any of the values supported by sqlite3_open(). </p>
</div>
</div>
<a class="anchor" id="a8cdca9bc5d744a76663d14d1255af483"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::~Sqlite3" ref="a8cdca9bc5d744a76663d14d1255af483" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">Wt::Dbo::backend::Sqlite3::~Sqlite3 </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Destructor. </p>
<p>Closes the connection. </p>
</div>
</div>
<hr/><h2>Member Function Documentation</h2>
<a class="anchor" id="a61769fc0ebdb13a2374a17a76d2d8560"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::autoincrementCreateSequenceSql" ref="a61769fc0ebdb13a2374a17a76d2d8560" args="(const std::string &table, const std::string &id) const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">std::vector< std::string > Wt::Dbo::backend::Sqlite3::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> [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>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a7922dac3fd8a808dbbeef97a5a772e3f">Wt::Dbo::SqlConnection</a>.</p>
</div>
</div>
<a class="anchor" id="a8d3e3e98ca13095efa0fe7918cbb9bcb"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::autoincrementDropSequenceSql" ref="a8d3e3e98ca13095efa0fe7918cbb9bcb" args="(const std::string &table, const std::string &id) const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">std::vector< std::string > Wt::Dbo::backend::Sqlite3::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> [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>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a188acc931dd1d3dbd3a21e28783f7bd2">Wt::Dbo::SqlConnection</a>.</p>
</div>
</div>
<a class="anchor" id="a597ce9d1ff2702ac08e5dd6a0dcb9a98"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::autoincrementInsertSuffix" ref="a597ce9d1ff2702ac08e5dd6a0dcb9a98" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">std::string Wt::Dbo::backend::Sqlite3::autoincrementInsertSuffix </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td> const<code> [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>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#aec6a5227e676cf373f842e4d1ac75f12">Wt::Dbo::SqlConnection</a>.</p>
</div>
</div>
<a class="anchor" id="a85f442f34549768a96fefa7548045c41"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::autoincrementSql" ref="a85f442f34549768a96fefa7548045c41" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">std::string Wt::Dbo::backend::Sqlite3::autoincrementSql </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td> const<code> [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>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a8c00fd64eb82999880cc813ef3866f5d">Wt::Dbo::SqlConnection</a>.</p>
</div>
</div>
<a class="anchor" id="a969dbaea3af070592bc8630425326e99"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::autoincrementType" ref="a969dbaea3af070592bc8630425326e99" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">std::string Wt::Dbo::backend::Sqlite3::autoincrementType </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td> const<code> [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>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#aff293ff5ad586e15143729eb38300ad6">Wt::Dbo::SqlConnection</a>.</p>
</div>
</div>
<a class="anchor" id="a8e9060b7b68a93adb12e407c7658b24f"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::blobType" ref="a8e9060b7b68a93adb12e407c7658b24f" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">const char * Wt::Dbo::backend::Sqlite3::blobType </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td> const<code> [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>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a68a272eaafeef5e04912914f0662da39">Wt::Dbo::SqlConnection</a>.</p>
</div>
</div>
<a class="anchor" id="a85e4a7bf082eff1264f4b7290edd6f8f"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::clone" ref="a85e4a7bf082eff1264f4b7290edd6f8f" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html">Sqlite3</a> * Wt::Dbo::backend::Sqlite3::clone </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td> const<code> [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>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a60168581b0fdeb4a6404358455a2ac8d">Wt::Dbo::SqlConnection</a>.</p>
</div>
</div>
<a class="anchor" id="a0bb773ea028a7e0a1dc10f94fcc90b4d"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::commitTransaction" ref="a0bb773ea028a7e0a1dc10f94fcc90b4d" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void Wt::Dbo::backend::Sqlite3::commitTransaction </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Commits a transaction. </p>
<p>This function commits a transaction. </p>
<p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#a38ed9ab4831a0bfd8694f250813803bf">Wt::Dbo::SqlConnection</a>.</p>
</div>
</div>
<a class="anchor" id="a4e4ecfd24b47a820974dc868a66d1eb5"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::dateTimeType" ref="a4e4ecfd24b47a820974dc868a66d1eb5" args="(SqlDateTimeType type) const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">const char * Wt::Dbo::backend::Sqlite3::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> [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>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#af1f3290a984288175c6d82d088d0636c">Wt::Dbo::SqlConnection</a>.</p>
</div>
</div>
<a class="anchor" id="ac254f423eb352ed08f63a11e7d9508a1"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::prepareStatement" ref="ac254f423eb352ed08f63a11e7d9508a1" args="(const std::string &sql)" -->
<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::backend::Sqlite3::prepareStatement </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>Prepares a statement. </p>
<p>Returns the prepared statement. </p>
<p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#afbebcc0007aef36f6aa02b61f514b853">Wt::Dbo::SqlConnection</a>.</p>
</div>
</div>
<a class="anchor" id="aade642c39d87b4f796c196415ec5b16a"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::rollbackTransaction" ref="aade642c39d87b4f796c196415ec5b16a" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void Wt::Dbo::backend::Sqlite3::rollbackTransaction </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Rolls back a transaction. </p>
<p>This function rolls back a transaction. </p>
<p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#aee5a42b2f3b452d32360a1c31f59f22d">Wt::Dbo::SqlConnection</a>.</p>
</div>
</div>
<a class="anchor" id="a571f4019950aafc2b855d46d4e7072d5"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::setDateTimeStorage" ref="a571f4019950aafc2b855d46d4e7072d5" args="(SqlDateTimeType type, DateTimeStorage format)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void Wt::Dbo::backend::Sqlite3::setDateTimeStorage </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>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype"><a class="el" href="classWt_1_1Dbo_1_1backend_1_1Sqlite3.html#ae6e6142ccb1da626677b05ef8852fdaa">DateTimeStorage</a> </td>
<td class="paramname"><em>format</em> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Configures how to store date or date time. </p>
<p>The default format is ISO8601AsText. </p>
</div>
</div>
<a class="anchor" id="a20a6959d6b8e0d14f2ccf764361954f6"></a><!-- doxytag: member="Wt::Dbo::backend::Sqlite3::startTransaction" ref="a20a6959d6b8e0d14f2ccf764361954f6" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void Wt::Dbo::backend::Sqlite3::startTransaction </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Starts a transaction. </p>
<p>This function starts a transaction. </p>
<p>Implements <a class="el" href="classWt_1_1Dbo_1_1SqlConnection.html#abcddbb27f50192113d14c66a5ca10731">Wt::Dbo::SqlConnection</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>
