<!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"/> <meta http-equiv="X-UA-Compatible" content="IE=9"/> <meta name="generator" content="Doxygen 1.8.8"/> <title>VSQLite++: sqlite::command Struct Reference</title> <link href="tabs.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="jquery.js"></script> <script type="text/javascript" src="dynsections.js"></script> <link href="search/search.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="search/search.js"></script> <script type="text/javascript"> $(document).ready(function() { searchBox.OnSelectItem(0); }); </script> <link href="doxygen.css" rel="stylesheet" type="text/css" /> </head> <body> <div id="top"><!-- do not remove this div, it is closed by doxygen! --> <div id="titlearea"> <table cellspacing="0" cellpadding="0"> <tbody> <tr style="height: 56px;"> <td style="padding-left: 0.5em;"> <div id="projectname">VSQLite++  <span id="projectnumber">0.3</span> </div> </td> </tr> </tbody> </table> </div> <!-- end header part --> <!-- Generated by Doxygen 1.8.8 --> <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="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="classes.html"><span>Class Index</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> <!-- 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><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(9)"><span class="SelectionMark"> </span>Friends</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> <div id="nav-path" class="navpath"> <ul> <li class="navelem"><a class="el" href="namespacesqlite.html">sqlite</a></li><li class="navelem"><a class="el" href="structsqlite_1_1command.html">command</a></li> </ul> </div> </div><!-- top --> <div class="header"> <div class="summary"> <a href="#pub-methods">Public Member Functions</a> | <a href="#pro-methods">Protected Member Functions</a> | <a href="#pro-attribs">Protected Attributes</a> | <a href="#pri-methods">Private Member Functions</a> | <a href="#pri-attribs">Private Attributes</a> | <a href="structsqlite_1_1command-members.html">List of all members</a> </div> <div class="headertitle"> <div class="title">sqlite::command Struct Reference</div> </div> </div><!--header--> <div class="contents"> <p><em>command</em> is the base class of all sql command classes An object of this class is not copyable <a href="structsqlite_1_1command.html#details">More...</a></p> <p><code>#include <<a class="el" href="command_8hpp_source.html">command.hpp</a>></code></p> <div class="dynheader"> Inheritance diagram for sqlite::command:</div> <div class="dyncontent"> <div class="center"><img src="structsqlite_1_1command__inherit__graph.png" border="0" usemap="#sqlite_1_1command_inherit__map" alt="Inheritance graph"/></div> <map name="sqlite_1_1command_inherit__map" id="sqlite_1_1command_inherit__map"> <area shape="rect" id="node3" href="structsqlite_1_1execute.html" title="execute can be used for SQL commands which should executed the constructor is defined in a way that i..." alt="" coords="5,549,177,641"/><area shape="rect" id="node4" href="structsqlite_1_1query.html" title="query should be used to execute SQL queries An object of this class is not copyable ..." alt="" coords="201,520,384,671"/></map> </div> <div class="dynheader"> Collaboration diagram for sqlite::command:</div> <div class="dyncontent"> <div class="center"><img src="structsqlite_1_1command__coll__graph.png" border="0" usemap="#sqlite_1_1command_coll__map" alt="Collaboration graph"/></div> <map name="sqlite_1_1command_coll__map" id="sqlite_1_1command_coll__map"> <area shape="rect" id="node3" href="structsqlite_1_1connection.html" title="connection is used to open, close, attach and detach a database. Further it has to be passed to all c..." alt="" coords="232,132,435,297"/></map> </div> <table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-methods"></a> Public Member Functions</h2></td></tr> <tr class="memitem:ab5242cec317e5433de48dd7a56e5a55c"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#ab5242cec317e5433de48dd7a56e5a55c">command</a> (<a class="el" href="structsqlite_1_1connection.html">connection</a> &con, std::string const &sql)</td></tr> <tr class="memdesc:ab5242cec317e5433de48dd7a56e5a55c"><td class="mdescLeft"> </td><td class="mdescRight"><em>command</em> constructor <a href="#ab5242cec317e5433de48dd7a56e5a55c">More...</a><br /></td></tr> <tr class="separator:ab5242cec317e5433de48dd7a56e5a55c"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a6cd7d9d2631335298f563159b43c81ca"><td class="memItemLeft" align="right" valign="top">virtual </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a6cd7d9d2631335298f563159b43c81ca">~command</a> ()</td></tr> <tr class="memdesc:a6cd7d9d2631335298f563159b43c81ca"><td class="mdescLeft"> </td><td class="mdescRight"><em>command</em> destructor <a href="#a6cd7d9d2631335298f563159b43c81ca">More...</a><br /></td></tr> <tr class="separator:a6cd7d9d2631335298f563159b43c81ca"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ab197be74f84a0b75e695005a59181741"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#ab197be74f84a0b75e695005a59181741">clear</a> ()</td></tr> <tr class="memdesc:ab197be74f84a0b75e695005a59181741"><td class="mdescLeft"> </td><td class="mdescRight">clear is used if you'd like to reuse a command object <a href="#ab197be74f84a0b75e695005a59181741">More...</a><br /></td></tr> <tr class="separator:ab197be74f84a0b75e695005a59181741"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a4c17284c56d287ee2017b66b3b0fb899"><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a4c17284c56d287ee2017b66b3b0fb899">emit</a> ()</td></tr> <tr class="memdesc:a4c17284c56d287ee2017b66b3b0fb899"><td class="mdescLeft"> </td><td class="mdescRight">emit executes the sql command If you have used placeholders you must have replaced all placeholders <a href="#a4c17284c56d287ee2017b66b3b0fb899">More...</a><br /></td></tr> <tr class="separator:a4c17284c56d287ee2017b66b3b0fb899"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ad991475054ed5554664d54930133c4ba"><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#ad991475054ed5554664d54930133c4ba">operator()</a> ()</td></tr> <tr class="memdesc:ad991475054ed5554664d54930133c4ba"><td class="mdescLeft"> </td><td class="mdescRight">works exactly like the method <em><a class="el" href="structsqlite_1_1command.html#a4c17284c56d287ee2017b66b3b0fb899" title="emit executes the sql command If you have used placeholders you must have replaced all placeholders ...">command::emit</a></em> <a href="#ad991475054ed5554664d54930133c4ba">More...</a><br /></td></tr> <tr class="separator:ad991475054ed5554664d54930133c4ba"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a09a49212b0c0b760035f160e3eb4ed63"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a09a49212b0c0b760035f160e3eb4ed63">bind</a> (int idx)</td></tr> <tr class="memdesc:a09a49212b0c0b760035f160e3eb4ed63"><td class="mdescLeft"> </td><td class="mdescRight">binds NULL to the given 1 based index <a href="#a09a49212b0c0b760035f160e3eb4ed63">More...</a><br /></td></tr> <tr class="separator:a09a49212b0c0b760035f160e3eb4ed63"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a6cca51b28db12ae910b529b0c47b196d"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a6cca51b28db12ae910b529b0c47b196d">bind</a> (int idx, int v)</td></tr> <tr class="memdesc:a6cca51b28db12ae910b529b0c47b196d"><td class="mdescLeft"> </td><td class="mdescRight">binds the 32-Bit integer v to the given 1 based index <a href="#a6cca51b28db12ae910b529b0c47b196d">More...</a><br /></td></tr> <tr class="separator:a6cca51b28db12ae910b529b0c47b196d"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a689f675f36e0434031d5c404d49d48bc"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a689f675f36e0434031d5c404d49d48bc">bind</a> (int idx, boost::int64_t v)</td></tr> <tr class="memdesc:a689f675f36e0434031d5c404d49d48bc"><td class="mdescLeft"> </td><td class="mdescRight">binds the 64-Bit integer v to the given 1 based index <a href="#a689f675f36e0434031d5c404d49d48bc">More...</a><br /></td></tr> <tr class="separator:a689f675f36e0434031d5c404d49d48bc"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a1a9a2ec75af89ad25dfea3e53f8ee3f6"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a1a9a2ec75af89ad25dfea3e53f8ee3f6">bind</a> (int idx, double v)</td></tr> <tr class="memdesc:a1a9a2ec75af89ad25dfea3e53f8ee3f6"><td class="mdescLeft"> </td><td class="mdescRight">binds the double v to the given 1 based index <a href="#a1a9a2ec75af89ad25dfea3e53f8ee3f6">More...</a><br /></td></tr> <tr class="separator:a1a9a2ec75af89ad25dfea3e53f8ee3f6"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ad62b405d3482e6e3d943a6314f088fd8"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#ad62b405d3482e6e3d943a6314f088fd8">bind</a> (int idx, std::string const &v)</td></tr> <tr class="memdesc:ad62b405d3482e6e3d943a6314f088fd8"><td class="mdescLeft"> </td><td class="mdescRight">binds the text/string v to the given 1 based index <a href="#ad62b405d3482e6e3d943a6314f088fd8">More...</a><br /></td></tr> <tr class="separator:ad62b405d3482e6e3d943a6314f088fd8"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a07656657dcbba77da862c88073ea16a9"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a07656657dcbba77da862c88073ea16a9">bind</a> (int idx, void const *buf, size_t buf_size)</td></tr> <tr class="memdesc:a07656657dcbba77da862c88073ea16a9"><td class="mdescLeft"> </td><td class="mdescRight">binds the binary/blob buf to the given 1 based index <a href="#a07656657dcbba77da862c88073ea16a9">More...</a><br /></td></tr> <tr class="separator:a07656657dcbba77da862c88073ea16a9"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a77d5ea1040b34eb46e2d3a93294514b9"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a77d5ea1040b34eb46e2d3a93294514b9">bind</a> (int idx, std::vector< unsigned char > const &v)</td></tr> <tr class="memdesc:a77d5ea1040b34eb46e2d3a93294514b9"><td class="mdescLeft"> </td><td class="mdescRight">binds the binary/blob v to the given 1 based index <a href="#a77d5ea1040b34eb46e2d3a93294514b9">More...</a><br /></td></tr> <tr class="separator:a77d5ea1040b34eb46e2d3a93294514b9"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a8c2f6d181f0b41793e24d34d534cf5b2"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structsqlite_1_1command.html">command</a> & </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a8c2f6d181f0b41793e24d34d534cf5b2">operator%</a> (<a class="el" href="structsqlite_1_1null__type.html">null_type</a> const &p)</td></tr> <tr class="memdesc:a8c2f6d181f0b41793e24d34d534cf5b2"><td class="mdescLeft"> </td><td class="mdescRight">replacement for void <a class="el" href="structsqlite_1_1command.html#a09a49212b0c0b760035f160e3eb4ed63" title="binds NULL to the given 1 based index ">command::bind(int idx)</a>; To use this operator% you have to use the global object <em>nil</em> Indexes are given automatically first call uses 1 as index, second 2 and so on <a href="#a8c2f6d181f0b41793e24d34d534cf5b2">More...</a><br /></td></tr> <tr class="separator:a8c2f6d181f0b41793e24d34d534cf5b2"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:afd2b031a1d335d84962d2508ed7d76bc"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structsqlite_1_1command.html">command</a> & </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#afd2b031a1d335d84962d2508ed7d76bc">operator%</a> (int p)</td></tr> <tr class="memdesc:afd2b031a1d335d84962d2508ed7d76bc"><td class="mdescLeft"> </td><td class="mdescRight">replacement for void <a class="el" href="structsqlite_1_1command.html#a6cca51b28db12ae910b529b0c47b196d" title="binds the 32-Bit integer v to the given 1 based index ">command::bind(int idx,int)</a>; Indexes are given automatically first call uses 1 as index, second 2 and so on <a href="#afd2b031a1d335d84962d2508ed7d76bc">More...</a><br /></td></tr> <tr class="separator:afd2b031a1d335d84962d2508ed7d76bc"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a64aa21195e672adddb9d7486e8270fa7"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structsqlite_1_1command.html">command</a> & </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a64aa21195e672adddb9d7486e8270fa7">operator%</a> (boost::int64_t p)</td></tr> <tr class="memdesc:a64aa21195e672adddb9d7486e8270fa7"><td class="mdescLeft"> </td><td class="mdescRight">replacement for void <a class="el" href="structsqlite_1_1command.html#a689f675f36e0434031d5c404d49d48bc" title="binds the 64-Bit integer v to the given 1 based index ">command::bind(int idx,boost::int64_t)</a>; Indexes are given automatically first call uses 1 as index, second 2 and so on <a href="#a64aa21195e672adddb9d7486e8270fa7">More...</a><br /></td></tr> <tr class="separator:a64aa21195e672adddb9d7486e8270fa7"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:acf06fbd88ed1b6b58f51c534156949f8"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structsqlite_1_1command.html">command</a> & </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#acf06fbd88ed1b6b58f51c534156949f8">operator%</a> (double p)</td></tr> <tr class="memdesc:acf06fbd88ed1b6b58f51c534156949f8"><td class="mdescLeft"> </td><td class="mdescRight">replacement for void <a class="el" href="structsqlite_1_1command.html#a1a9a2ec75af89ad25dfea3e53f8ee3f6" title="binds the double v to the given 1 based index ">command::bind(int idx,double)</a>; Indexes are given automatically first call uses 1 as index, second 2 and so on <a href="#acf06fbd88ed1b6b58f51c534156949f8">More...</a><br /></td></tr> <tr class="separator:acf06fbd88ed1b6b58f51c534156949f8"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ac6d745eac1295d54ee1e9af320715c08"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structsqlite_1_1command.html">command</a> & </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#ac6d745eac1295d54ee1e9af320715c08">operator%</a> (std::string const &p)</td></tr> <tr class="memdesc:ac6d745eac1295d54ee1e9af320715c08"><td class="mdescLeft"> </td><td class="mdescRight">replacement for void <a class="el" href="structsqlite_1_1command.html#ad62b405d3482e6e3d943a6314f088fd8" title="binds the text/string v to the given 1 based index ">command::bind(int idx,std::string const&)</a>; Indexes are given automatically first call uses 1 as index, second 2 and so on <a href="#ac6d745eac1295d54ee1e9af320715c08">More...</a><br /></td></tr> <tr class="separator:ac6d745eac1295d54ee1e9af320715c08"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a8603fbfc5e95924dd02275a75127d9cf"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structsqlite_1_1command.html">command</a> & </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a8603fbfc5e95924dd02275a75127d9cf">operator%</a> (std::vector< unsigned char > const &p)</td></tr> <tr class="memdesc:a8603fbfc5e95924dd02275a75127d9cf"><td class="mdescLeft"> </td><td class="mdescRight">replacement for void <a class="el" href="structsqlite_1_1command.html#a77d5ea1040b34eb46e2d3a93294514b9" title="binds the binary/blob v to the given 1 based index ">command::bind(int idx,std::vector<unsigned char> const&)</a>; Indexes are given automatically first call uses 1 as index, second 2 and so on <a href="#a8603fbfc5e95924dd02275a75127d9cf">More...</a><br /></td></tr> <tr class="separator:a8603fbfc5e95924dd02275a75127d9cf"><td class="memSeparator" colspan="2"> </td></tr> </table><table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pro-methods"></a> Protected Member Functions</h2></td></tr> <tr class="memitem:a206242474ec820779a931e1ef719c327"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a206242474ec820779a931e1ef719c327">access_check</a> ()</td></tr> <tr class="separator:a206242474ec820779a931e1ef719c327"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a4d37a70ff3a1d7d8f3b689fc09501e89"><td class="memItemLeft" align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a4d37a70ff3a1d7d8f3b689fc09501e89">step</a> ()</td></tr> <tr class="separator:a4d37a70ff3a1d7d8f3b689fc09501e89"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ae51ebc71e8e032d5bafd0cba7edd6c96"><td class="memItemLeft" align="right" valign="top">struct sqlite3 * </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#ae51ebc71e8e032d5bafd0cba7edd6c96">get_handle</a> ()</td></tr> <tr class="separator:ae51ebc71e8e032d5bafd0cba7edd6c96"><td class="memSeparator" colspan="2"> </td></tr> </table><table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pro-attribs"></a> Protected Attributes</h2></td></tr> <tr class="memitem:ab6147e3325e3115f7f39628525a89027"><td class="memItemLeft" align="right" valign="top">sqlite3_stmt * </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#ab6147e3325e3115f7f39628525a89027">stmt</a></td></tr> <tr class="separator:ab6147e3325e3115f7f39628525a89027"><td class="memSeparator" colspan="2"> </td></tr> </table><table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pri-methods"></a> Private Member Functions</h2></td></tr> <tr class="memitem:a03213c5834406b50076c424d3dd57608"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a03213c5834406b50076c424d3dd57608">prepare</a> ()</td></tr> <tr class="separator:a03213c5834406b50076c424d3dd57608"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a0f6ee7ea384ed0a49a00d52c4cf74ca9"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a0f6ee7ea384ed0a49a00d52c4cf74ca9">finalize</a> ()</td></tr> <tr class="separator:a0f6ee7ea384ed0a49a00d52c4cf74ca9"><td class="memSeparator" colspan="2"> </td></tr> </table><table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pri-attribs"></a> Private Attributes</h2></td></tr> <tr class="memitem:a11e316d1fe19728311fa5ce42072689f"><td class="memItemLeft" align="right" valign="top"><a class="el" href="structsqlite_1_1connection.html">connection</a> & </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a11e316d1fe19728311fa5ce42072689f">m_con</a></td></tr> <tr class="separator:a11e316d1fe19728311fa5ce42072689f"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a4e8ef964c2da7327b100aa57a3dd8a71"><td class="memItemLeft" align="right" valign="top">std::string </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a4e8ef964c2da7327b100aa57a3dd8a71">m_sql</a></td></tr> <tr class="separator:a4e8ef964c2da7327b100aa57a3dd8a71"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a3b932c3200242e0062906c48d8ee171e"><td class="memItemLeft" align="right" valign="top">int </td><td class="memItemRight" valign="bottom"><a class="el" href="structsqlite_1_1command.html#a3b932c3200242e0062906c48d8ee171e">last_arg_idx</a></td></tr> <tr class="separator:a3b932c3200242e0062906c48d8ee171e"><td class="memSeparator" colspan="2"> </td></tr> </table> <a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2> <div class="textblock"><p><em>command</em> is the base class of all sql command classes An object of this class is not copyable </p> <p>Definition at line <a class="el" href="command_8hpp_source.html#l00057">57</a> of file <a class="el" href="command_8hpp_source.html">command.hpp</a>.</p> </div><h2 class="groupheader">Constructor & Destructor Documentation</h2> <a class="anchor" id="ab5242cec317e5433de48dd7a56e5a55c"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">sqlite::command::command </td> <td>(</td> <td class="paramtype"><a class="el" href="structsqlite_1_1connection.html">connection</a> & </td> <td class="paramname"><em>con</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">std::string const & </td> <td class="paramname"><em>sql</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p><em>command</em> constructor </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">con</td><td>takes a reference to the database connection type <em>connection</em> </td></tr> <tr><td class="paramname">sql</td><td>is the SQL string. The sql string can contain placeholder the question mark '?' is used as placeholder the <em><a class="el" href="structsqlite_1_1command.html#a09a49212b0c0b760035f160e3eb4ed63" title="binds NULL to the given 1 based index ">command::bind</a></em> methods or <a class="el" href="structsqlite_1_1command.html#a8c2f6d181f0b41793e24d34d534cf5b2" title="replacement for void command::bind(int idx); To use this operator% you have to use the global object ...">command::operator%</a> syntax must be used to replace the placeholders </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a6cd7d9d2631335298f563159b43c81ca"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">virtual sqlite::command::~command </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">virtual</span></span> </td> </tr> </table> </div><div class="memdoc"> <p><em>command</em> destructor </p> </div> </div> <h2 class="groupheader">Member Function Documentation</h2> <a class="anchor" id="a206242474ec820779a931e1ef719c327"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">void sqlite::command::access_check </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">protected</span></span> </td> </tr> </table> </div><div class="memdoc"> </div> </div> <a class="anchor" id="a09a49212b0c0b760035f160e3eb4ed63"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void sqlite::command::bind </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>idx</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>binds NULL to the given 1 based index </p> </div> </div> <a class="anchor" id="a6cca51b28db12ae910b529b0c47b196d"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void sqlite::command::bind </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>idx</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">int </td> <td class="paramname"><em>v</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>binds the 32-Bit integer v to the given 1 based index </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">idx</td><td>1 based index of the placeholder within the sql statement </td></tr> <tr><td class="paramname">v</td><td>32-Bit integer value which should replace the placeholder </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a689f675f36e0434031d5c404d49d48bc"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void sqlite::command::bind </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>idx</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">boost::int64_t </td> <td class="paramname"><em>v</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>binds the 64-Bit integer v to the given 1 based index </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">idx</td><td>1 based index of the placeholder within the sql statement </td></tr> <tr><td class="paramname">v</td><td>64-Bit integer value which should replace the placeholder </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a1a9a2ec75af89ad25dfea3e53f8ee3f6"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void sqlite::command::bind </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>idx</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">double </td> <td class="paramname"><em>v</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>binds the double v to the given 1 based index </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">idx</td><td>1 based index of the placeholder within the sql statement </td></tr> <tr><td class="paramname">v</td><td>double value which should replace the placeholder </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="ad62b405d3482e6e3d943a6314f088fd8"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void sqlite::command::bind </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>idx</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">std::string const & </td> <td class="paramname"><em>v</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>binds the text/string v to the given 1 based index </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">idx</td><td>1 based index of the placeholder within the sql statement </td></tr> <tr><td class="paramname">v</td><td>text/string value which should replace the placeholder </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a07656657dcbba77da862c88073ea16a9"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void sqlite::command::bind </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>idx</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">void const * </td> <td class="paramname"><em>buf</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">size_t </td> <td class="paramname"><em>buf_size</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>binds the binary/blob buf to the given 1 based index </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">idx</td><td>1 based index of the placeholder within the sql statement </td></tr> <tr><td class="paramname">buf</td><td>binary/blob buf which should replace the placeholder </td></tr> <tr><td class="paramname">buf_size</td><td>size in bytes of the binary buffer </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a77d5ea1040b34eb46e2d3a93294514b9"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void sqlite::command::bind </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>idx</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">std::vector< unsigned char > const & </td> <td class="paramname"><em>v</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>binds the binary/blob v to the given 1 based index </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">idx</td><td>1 based index of the placeholder within the sql statement </td></tr> <tr><td class="paramname">v</td><td>binary/blob buffer which should replace the placeholder v is a std::vector<unsigned char> const & </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="ab197be74f84a0b75e695005a59181741"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void sqlite::command::clear </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>clear is used if you'd like to reuse a command object </p> </div> </div> <a class="anchor" id="a4c17284c56d287ee2017b66b3b0fb899"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">bool sqlite::command::emit </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>emit executes the sql command If you have used placeholders you must have replaced all placeholders </p> </div> </div> <a class="anchor" id="a0f6ee7ea384ed0a49a00d52c4cf74ca9"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">void sqlite::command::finalize </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">private</span></span> </td> </tr> </table> </div><div class="memdoc"> </div> </div> <a class="anchor" id="ae51ebc71e8e032d5bafd0cba7edd6c96"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">struct sqlite3* sqlite::command::get_handle </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">protected</span></span> </td> </tr> </table> </div><div class="memdoc"> </div> </div> <a class="anchor" id="a8c2f6d181f0b41793e24d34d534cf5b2"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="structsqlite_1_1command.html">command</a>& sqlite::command::operator% </td> <td>(</td> <td class="paramtype"><a class="el" href="structsqlite_1_1null__type.html">null_type</a> const & </td> <td class="paramname"><em>p</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>replacement for void <a class="el" href="structsqlite_1_1command.html#a09a49212b0c0b760035f160e3eb4ed63" title="binds NULL to the given 1 based index ">command::bind(int idx)</a>; To use this operator% you have to use the global object <em>nil</em> Indexes are given automatically first call uses 1 as index, second 2 and so on </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">p</td><td>should be <em>nil</em> </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="afd2b031a1d335d84962d2508ed7d76bc"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="structsqlite_1_1command.html">command</a>& sqlite::command::operator% </td> <td>(</td> <td class="paramtype">int </td> <td class="paramname"><em>p</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>replacement for void <a class="el" href="structsqlite_1_1command.html#a6cca51b28db12ae910b529b0c47b196d" title="binds the 32-Bit integer v to the given 1 based index ">command::bind(int idx,int)</a>; Indexes are given automatically first call uses 1 as index, second 2 and so on </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">p</td><td>should be a 32-Bit integer </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a64aa21195e672adddb9d7486e8270fa7"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="structsqlite_1_1command.html">command</a>& sqlite::command::operator% </td> <td>(</td> <td class="paramtype">boost::int64_t </td> <td class="paramname"><em>p</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>replacement for void <a class="el" href="structsqlite_1_1command.html#a689f675f36e0434031d5c404d49d48bc" title="binds the 64-Bit integer v to the given 1 based index ">command::bind(int idx,boost::int64_t)</a>; Indexes are given automatically first call uses 1 as index, second 2 and so on </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">p</td><td>should be a 64-Bit integer </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="acf06fbd88ed1b6b58f51c534156949f8"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="structsqlite_1_1command.html">command</a>& sqlite::command::operator% </td> <td>(</td> <td class="paramtype">double </td> <td class="paramname"><em>p</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>replacement for void <a class="el" href="structsqlite_1_1command.html#a1a9a2ec75af89ad25dfea3e53f8ee3f6" title="binds the double v to the given 1 based index ">command::bind(int idx,double)</a>; Indexes are given automatically first call uses 1 as index, second 2 and so on </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">p</td><td>a double variable </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="ac6d745eac1295d54ee1e9af320715c08"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="structsqlite_1_1command.html">command</a>& sqlite::command::operator% </td> <td>(</td> <td class="paramtype">std::string const & </td> <td class="paramname"><em>p</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>replacement for void <a class="el" href="structsqlite_1_1command.html#ad62b405d3482e6e3d943a6314f088fd8" title="binds the text/string v to the given 1 based index ">command::bind(int idx,std::string const&)</a>; Indexes are given automatically first call uses 1 as index, second 2 and so on </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">p</td><td>should be a Zero Terminated C-style string (char * or char const*), or a std::string object, </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a8603fbfc5e95924dd02275a75127d9cf"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="structsqlite_1_1command.html">command</a>& sqlite::command::operator% </td> <td>(</td> <td class="paramtype">std::vector< unsigned char > const & </td> <td class="paramname"><em>p</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>replacement for void <a class="el" href="structsqlite_1_1command.html#a77d5ea1040b34eb46e2d3a93294514b9" title="binds the binary/blob v to the given 1 based index ">command::bind(int idx,std::vector<unsigned char> const&)</a>; Indexes are given automatically first call uses 1 as index, second 2 and so on </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">p</td><td>a constant reference to a std::vector<unsigned char> object (For blob/binary data) </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="ad991475054ed5554664d54930133c4ba"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">bool sqlite::command::operator() </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>works exactly like the method <em><a class="el" href="structsqlite_1_1command.html#a4c17284c56d287ee2017b66b3b0fb899" title="emit executes the sql command If you have used placeholders you must have replaced all placeholders ...">command::emit</a></em> </p> </div> </div> <a class="anchor" id="a03213c5834406b50076c424d3dd57608"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">void sqlite::command::prepare </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">private</span></span> </td> </tr> </table> </div><div class="memdoc"> </div> </div> <a class="anchor" id="a4d37a70ff3a1d7d8f3b689fc09501e89"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">bool sqlite::command::step </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">protected</span></span> </td> </tr> </table> </div><div class="memdoc"> </div> </div> <h2 class="groupheader">Member Data Documentation</h2> <a class="anchor" id="a3b932c3200242e0062906c48d8ee171e"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">int sqlite::command::last_arg_idx</td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">private</span></span> </td> </tr> </table> </div><div class="memdoc"> <p>Definition at line <a class="el" href="command_8hpp_source.html#l00189">189</a> of file <a class="el" href="command_8hpp_source.html">command.hpp</a>.</p> </div> </div> <a class="anchor" id="a11e316d1fe19728311fa5ce42072689f"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname"><a class="el" href="structsqlite_1_1connection.html">connection</a>& sqlite::command::m_con</td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">private</span></span> </td> </tr> </table> </div><div class="memdoc"> <p>Definition at line <a class="el" href="command_8hpp_source.html#l00184">184</a> of file <a class="el" href="command_8hpp_source.html">command.hpp</a>.</p> </div> </div> <a class="anchor" id="a4e8ef964c2da7327b100aa57a3dd8a71"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">std::string sqlite::command::m_sql</td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">private</span></span> </td> </tr> </table> </div><div class="memdoc"> <p>Definition at line <a class="el" href="command_8hpp_source.html#l00185">185</a> of file <a class="el" href="command_8hpp_source.html">command.hpp</a>.</p> </div> </div> <a class="anchor" id="ab6147e3325e3115f7f39628525a89027"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">sqlite3_stmt* sqlite::command::stmt</td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">protected</span></span> </td> </tr> </table> </div><div class="memdoc"> <p>Definition at line <a class="el" href="command_8hpp_source.html#l00187">187</a> of file <a class="el" href="command_8hpp_source.html">command.hpp</a>.</p> </div> </div> <hr/>The documentation for this struct was generated from the following file:<ul> <li>include/sqlite/<a class="el" href="command_8hpp_source.html">command.hpp</a></li> </ul> </div><!-- contents --> <!-- start footer part --> <hr class="footer"/><address class="footer"><small> Generated on Fri Oct 31 2014 11:19:54 for VSQLite++ by  <a href="http://www.doxygen.org/index.html"> <img class="footer" src="doxygen.png" alt="doxygen"/> </a> 1.8.8 </small></address> </body> </html>