<!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>libsq3: sq3.cpp Source File</title> <link href="tabs.css" rel="stylesheet" type="text/css"/> <link href="doxygen.css" rel="stylesheet" type="text/css"/> </head> <body> <!-- Generated by Doxygen 1.6.2-20100208 --> <div class="navigation" id="top"> <div class="tabs"> <ul> <li><a href="index.html"><span>Main Page</span></a></li> <li><a href="namespaces.html"><span>Namespaces</span></a></li> <li><a href="annotated.html"><span>Classes</span></a></li> <li class="current"><a href="files.html"><span>Files</span></a></li> </ul> </div> <div class="tabs"> <ul> <li><a href="files.html"><span>File List</span></a></li> </ul> </div> <h1>sq3.cpp</h1><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <span class="preprocessor">#if 0</span> <a name="l00002"></a>00002 <span class="preprocessor"></span><span class="preprocessor"># ifndef COUT</span> <a name="l00003"></a>00003 <span class="preprocessor"></span><span class="preprocessor"># include <iostream></span> <a name="l00004"></a>00004 <span class="preprocessor"># define COUT std::cerr << "SQ3:"<<__FILE__ << ":" << std::dec<<__LINE__ << ": "</span> <a name="l00005"></a>00005 <span class="preprocessor"></span><span class="preprocessor"># endif</span> <a name="l00006"></a>00006 <span class="preprocessor"></span><span class="preprocessor">#endif</span> <a name="l00007"></a>00007 <span class="preprocessor"></span> <a name="l00008"></a>00008 <span class="preprocessor">#include "sq3.hpp"</span> <a name="l00009"></a>00009 <span class="preprocessor">#include <vector></span> <a name="l00010"></a>00010 <span class="preprocessor">#include <sstream></span> <a name="l00011"></a>00011 <span class="preprocessor">#include <cstring></span> <a name="l00012"></a>00012 <a name="l00013"></a>00013 <span class="preprocessor">#if SQ3_USE_WCHAR</span> <a name="l00014"></a>00014 <span class="preprocessor"></span><span class="preprocessor">#include <cwchar></span> <a name="l00015"></a>00015 <span class="preprocessor">#endif</span> <a name="l00016"></a>00016 <span class="preprocessor"></span> <a name="l00017"></a>00017 <span class="keyword">namespace </span>sq3 { <a name="l00018"></a>00018 <a name="l00019"></a><a class="code" href="structsq3_1_1statement__reset__finalizer.html#a971093f32adc41f731a01407f281b85f">00019</a> <span class="keywordtype">void</span> <a class="code" href="structsq3_1_1statement__reset__finalizer.html#a971093f32adc41f731a01407f281b85f" title="Calls t-&gt;reset() and assigns t to 0.">statement_reset_finalizer::operator()</a>( ::<a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">sq3::statement</a> * & st ) <a name="l00020"></a>00020 { <a name="l00021"></a>00021 <span class="keywordflow">if</span>( st ) <a name="l00022"></a>00022 { <a name="l00023"></a>00023 st-><a class="code" href="classsq3_1_1statement.html#ae0270423dc9bf151b5a57bfd42da2efb" title="Calls sqlite3_reset() on the underlying statement handle and returns the result.">reset</a>(); <a name="l00024"></a>00024 st = 0; <a name="l00025"></a>00025 } <a name="l00026"></a>00026 } <a name="l00027"></a>00027 <a name="l00028"></a><a class="code" href="structsq3_1_1sqlite3__stmt__reset__finalizer.html#a65ff29a33d7b8c1166f09b3226d6a25e">00028</a> <span class="keywordtype">void</span> <a class="code" href="structsq3_1_1sqlite3__stmt__reset__finalizer.html#a65ff29a33d7b8c1166f09b3226d6a25e" title="Calls sqlite3_reset(t) and assigns t to 0.">sqlite3_stmt_reset_finalizer::operator()</a>( sqlite3_stmt * & st ) <a name="l00029"></a>00029 { <a name="l00030"></a>00030 <span class="keywordflow">if</span>( st ) <a name="l00031"></a>00031 { <a name="l00032"></a>00032 sqlite3_reset( st ); <a name="l00033"></a>00033 st = 0; <a name="l00034"></a>00034 } <a name="l00035"></a>00035 } <a name="l00036"></a>00036 <a name="l00037"></a><a class="code" href="structsq3_1_1sqlite3__stmt__finalizer.html#a394e4ae2be74ff6cba9dbe8b2ec6016b">00037</a> <span class="keywordtype">void</span> <a class="code" href="structsq3_1_1sqlite3__stmt__finalizer.html#a394e4ae2be74ff6cba9dbe8b2ec6016b" title="Calls sqlite3_finalize(t) and assigns t to 0.">sqlite3_stmt_finalizer::operator()</a>( sqlite3_stmt * & st ) <a name="l00038"></a>00038 { <a name="l00039"></a>00039 <span class="keywordflow">if</span>( st ) <a name="l00040"></a>00040 { <a name="l00041"></a>00041 sqlite3_finalize( st ); <a name="l00042"></a>00042 st = 0; <a name="l00043"></a>00043 } <a name="l00044"></a>00044 } <a name="l00045"></a>00045 <a name="l00046"></a><a class="code" href="structsq3_1_1sqlite3__finalizer.html#a4fab246707b5af35712b24c4a22fa0f5">00046</a> <span class="keywordtype">void</span> <a class="code" href="structsq3_1_1sqlite3__finalizer.html#a4fab246707b5af35712b24c4a22fa0f5" title="Calls sqlite3_close(t) and assigns t to 0.">sqlite3_finalizer::operator()</a>( sqlite3 * & s ) <a name="l00047"></a>00047 { <a name="l00048"></a>00048 <span class="keywordflow">if</span>( s ) <a name="l00049"></a>00049 { <a name="l00050"></a>00050 sqlite3_close( s ); <a name="l00051"></a>00051 s = 0; <a name="l00052"></a>00052 } <a name="l00053"></a>00053 } <a name="l00054"></a>00054 <a name="l00055"></a>00055 <a name="l00056"></a><a class="code" href="namespacesq3.html#a080ee04ba6c41a38c4d3efbb1ccb741d">00056</a> <span class="keywordtype">bool</span> <a class="code" href="namespacesq3.html#a080ee04ba6c41a38c4d3efbb1ccb741d" title="rc_is_okay() is an easy way to check if rc is one of SQLITE_OK, SQLITE_ROW, or SQLITE_DONE...">rc_is_okay</a>( <span class="keywordtype">int</span> rc ) <a name="l00057"></a>00057 { <a name="l00058"></a>00058 <span class="keywordflow">return</span> ((SQLITE_DONE==rc) || (SQLITE_OK==rc) || (SQLITE_ROW==rc)); <a name="l00059"></a>00059 } <a name="l00060"></a>00060 <a name="l00061"></a>00061 <a name="l00062"></a><a class="code" href="classsq3_1_1statement.html#a5926de0822117564de1efc0bf9dbfe15">00062</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a5926de0822117564de1efc0bf9dbfe15" title="(Re-)prepares an SQL statement.">statement::prepare</a>( std::string <span class="keyword">const</span> & sql ) <a name="l00063"></a>00063 { <a name="l00064"></a>00064 <span class="keywordflow">return</span> this-><a class="code" href="classsq3_1_1statement.html#a5926de0822117564de1efc0bf9dbfe15" title="(Re-)prepares an SQL statement.">prepare</a>( sql.c_str(), <span class="keyword">static_cast<</span><span class="keywordtype">int</span><span class="keyword">></span>(sql.size()) ); <a name="l00065"></a>00065 } <a name="l00066"></a>00066 <a name="l00067"></a><a class="code" href="classsq3_1_1statement.html#a50cedb3f8864bf3b2ebdb18e5dad9513">00067</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a5926de0822117564de1efc0bf9dbfe15" title="(Re-)prepares an SQL statement.">statement::prepare</a>( <span class="keywordtype">char</span> <span class="keyword">const</span> * sql, <span class="keywordtype">int</span> len ) <a name="l00068"></a>00068 { <a name="l00069"></a>00069 <span class="comment">// FIXME: make this function clean up any existing sqlite3_stmt.</span> <a name="l00070"></a>00070 <span class="keyword">const</span> <span class="keywordtype">char</span> *tail=NULL; <a name="l00071"></a>00071 <span class="keywordflow">if</span>( 0 > len ) len = <span class="keyword">static_cast<</span><span class="keywordtype">int</span><span class="keyword">></span>(strlen(sql)); <a name="l00072"></a>00072 sqlite3_stmt * st = 0; <a name="l00073"></a>00073 <a name="l00074"></a>00074 <span class="keywordtype">int</span> rc = <a name="l00075"></a>00075 <span class="preprocessor">#if (SQLITE_VERSION_NUMBER >= 3003009)</span> <a name="l00076"></a>00076 <span class="preprocessor"></span> sqlite3_prepare_v2 <a name="l00077"></a>00077 <span class="preprocessor">#else</span> <a name="l00078"></a>00078 <span class="preprocessor"></span> sqlite3_prepare <a name="l00079"></a>00079 <span class="preprocessor">#endif</span> <a name="l00080"></a>00080 <span class="preprocessor"></span> (this->m_db.<a class="code" href="classsq3_1_1database.html#a674d66007f7cf0fe2f68233593526ecb" title="The low-level handle to the sqlite db.">handle</a>(), sql, len, &st, &tail); <a name="l00081"></a>00081 <a name="l00082"></a>00082 <span class="keywordflow">if</span>( SQLITE_OK == rc ) <a name="l00083"></a>00083 { <a name="l00084"></a>00084 this->m_argc = sqlite3_column_count(st); <a name="l00085"></a>00085 this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a854cd432ee8661e16707da4fb8bdc4b4" title="Gives ownership of p to this object (or a collection of like-types rcptr objects)...">take</a>( st ); <a name="l00086"></a>00086 } <a name="l00087"></a>00087 <span class="keywordflow">else</span> <a name="l00088"></a>00088 { <a name="l00089"></a>00089 this-><a class="code" href="classsq3_1_1statement.html#ab5c77d11b7f3c7cc5bd73cf8a8a1842e" title="Finizalizes the underlying prepared statement, freeing its resources.">finalize</a>(); <a name="l00090"></a>00090 } <a name="l00091"></a>00091 <span class="keywordflow">return</span> rc; <a name="l00092"></a>00092 } <a name="l00093"></a>00093 <a name="l00094"></a>00094 <span class="preprocessor">#if SQ3_USE_WCHAR</span> <a name="l00095"></a>00095 <span class="preprocessor"></span> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a5926de0822117564de1efc0bf9dbfe15" title="(Re-)prepares an SQL statement.">statement::prepare</a>( sqlite3_wstring_t <span class="keyword">const</span> sql, <span class="keywordtype">int</span> byteCount ) <a name="l00096"></a>00096 { <a name="l00097"></a>00097 <span class="keywordtype">void</span> <span class="keyword">const</span> * tail = NULL; <a name="l00098"></a>00098 <span class="keywordflow">if</span>( 0 > byteCount ) byteCount = ????; <a name="l00099"></a>00099 sqlite3_stmt * st = 0; <a name="l00100"></a>00100 <span class="keywordtype">int</span> rc = <a name="l00101"></a>00101 <span class="preprocessor">#if SQLITE_VERSION_NUMBER >= 3003009</span> <a name="l00102"></a>00102 <span class="preprocessor"></span> sqlite3_prepare16_v2 <a name="l00103"></a>00103 <span class="preprocessor">#else</span> <a name="l00104"></a>00104 <span class="preprocessor"></span> sqlite3_prepare16 <a name="l00105"></a>00105 <span class="preprocessor">#endif</span> <a name="l00106"></a>00106 <span class="preprocessor"></span> (this->m_db.<a class="code" href="classsq3_1_1database.html#a674d66007f7cf0fe2f68233593526ecb" title="The low-level handle to the sqlite db.">handle</a>(), sql, byteCount, &st, &tail); <a name="l00107"></a>00107 <span class="keywordflow">if</span>( SQLITE_OK == rc ) <a name="l00108"></a>00108 { <a name="l00109"></a>00109 this->m_argc = sqlite3_column_count(st); <a name="l00110"></a>00110 this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a854cd432ee8661e16707da4fb8bdc4b4" title="Gives ownership of p to this object (or a collection of like-types rcptr objects)...">take</a>(st); <a name="l00111"></a>00111 } <a name="l00112"></a>00112 <span class="keywordflow">else</span> <a name="l00113"></a>00113 { <a name="l00114"></a>00114 this-><a class="code" href="classsq3_1_1statement.html#ab5c77d11b7f3c7cc5bd73cf8a8a1842e" title="Finizalizes the underlying prepared statement, freeing its resources.">finalize</a>(); <a name="l00115"></a>00115 } <a name="l00116"></a>00116 <span class="keywordflow">return</span> rc; <a name="l00117"></a>00117 <a name="l00118"></a>00118 } <a name="l00119"></a>00119 <span class="preprocessor">#endif // SQ3_USE_WCHAR</span> <a name="l00120"></a>00120 <span class="preprocessor"></span> <a name="l00121"></a>00121 <a name="l00122"></a><a class="code" href="classsq3_1_1statement.html#ab5c77d11b7f3c7cc5bd73cf8a8a1842e">00122</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#ab5c77d11b7f3c7cc5bd73cf8a8a1842e" title="Finizalizes the underlying prepared statement, freeing its resources.">statement::finalize</a>() <a name="l00123"></a>00123 { <a name="l00124"></a>00124 <span class="keywordtype">int</span> rc = SQLITE_ERROR; <a name="l00125"></a>00125 <span class="keywordflow">if</span>( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() ) <a name="l00126"></a>00126 { <a name="l00127"></a>00127 rc = SQLITE_OK; <span class="comment">// we'll fudge a bit here.</span> <a name="l00128"></a>00128 <span class="comment">//sqlite3_finalize(this->m_stmt.get());</span> <a name="l00129"></a>00129 this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a854cd432ee8661e16707da4fb8bdc4b4" title="Gives ownership of p to this object (or a collection of like-types rcptr objects)...">take</a>(0); <span class="comment">// give up ownership.</span> <a name="l00130"></a>00130 } <a name="l00131"></a>00131 <span class="keywordflow">return</span> rc; <a name="l00132"></a>00132 } <a name="l00133"></a>00133 <a name="l00134"></a>00134 <a name="l00135"></a><a class="code" href="classsq3_1_1statement.html#ad0d64808c79092f3973663cf64285a90">00135</a> <a class="code" href="classsq3_1_1statement.html#ad0d64808c79092f3973663cf64285a90" title="Initializes a prepared statement without a query.">statement::statement</a>( <a class="code" href="classsq3_1_1database.html" title="Encapsulates a connection to an sqlite database.">database</a> & db ) <a name="l00136"></a>00136 : m_db(db), m_stmt(0), m_argc(0) <a name="l00137"></a>00137 { <a name="l00138"></a>00138 } <a name="l00139"></a>00139 <a name="l00140"></a><a class="code" href="classsq3_1_1statement.html#a7fd9941793b8368f0345419cd8b955c2">00140</a> <a class="code" href="classsq3_1_1statement.html#ad0d64808c79092f3973663cf64285a90" title="Initializes a prepared statement without a query.">statement::statement</a>( <a class="code" href="classsq3_1_1database.html" title="Encapsulates a connection to an sqlite database.">database</a> & db, std::string <span class="keyword">const</span> & sql ) <a name="l00141"></a>00141 : m_db(db), m_stmt(0), m_argc(0) <a name="l00142"></a>00142 { <a name="l00143"></a>00143 this-><a class="code" href="classsq3_1_1statement.html#a5926de0822117564de1efc0bf9dbfe15" title="(Re-)prepares an SQL statement.">prepare</a>( sql ); <a name="l00144"></a>00144 } <a name="l00145"></a><a class="code" href="classsq3_1_1statement.html#a11b1fafe86bbc3a28beee6e2be894e2f">00145</a> <a class="code" href="classsq3_1_1statement.html#ad0d64808c79092f3973663cf64285a90" title="Initializes a prepared statement without a query.">statement::statement</a>( <a class="code" href="classsq3_1_1database.html" title="Encapsulates a connection to an sqlite database.">database</a> & db, <span class="keywordtype">char</span> <span class="keyword">const</span> * sql, <span class="keywordtype">int</span> byteCount ) <a name="l00146"></a>00146 : m_db(db), m_stmt(0), m_argc(0) <a name="l00147"></a>00147 { <a name="l00148"></a>00148 this-><a class="code" href="classsq3_1_1statement.html#a5926de0822117564de1efc0bf9dbfe15" title="(Re-)prepares an SQL statement.">prepare</a>( sql, byteCount ); <a name="l00149"></a>00149 } <a name="l00150"></a>00150 <a name="l00151"></a>00151 <span class="preprocessor">#if SQ3_USE_WCHAR</span> <a name="l00152"></a>00152 <span class="preprocessor"></span> <a class="code" href="classsq3_1_1statement.html#ad0d64808c79092f3973663cf64285a90" title="Initializes a prepared statement without a query.">statement::statement</a>( <a class="code" href="classsq3_1_1database.html" title="Encapsulates a connection to an sqlite database.">database</a> & db, std::wstring <span class="keyword">const</span> & sql ) <a name="l00153"></a>00153 : m_db(db), m_stmt(0), m_argc(0) <a name="l00154"></a>00154 { <a name="l00155"></a>00155 this-><a class="code" href="classsq3_1_1statement.html#a5926de0822117564de1efc0bf9dbfe15" title="(Re-)prepares an SQL statement.">prepare</a>( sql ); <a name="l00156"></a>00156 } <a name="l00157"></a>00157 <a class="code" href="classsq3_1_1statement.html#ad0d64808c79092f3973663cf64285a90" title="Initializes a prepared statement without a query.">statement::statement</a>( database & db, <span class="keywordtype">wchar_t</span> <span class="keyword">const</span> * sql, <span class="keywordtype">int</span> byteCount ) <a name="l00158"></a>00158 : m_db(db), m_stmt(0), m_argc(0) <a name="l00159"></a>00159 { <a name="l00160"></a>00160 this-><a class="code" href="classsq3_1_1statement.html#a5926de0822117564de1efc0bf9dbfe15" title="(Re-)prepares an SQL statement.">prepare</a>( sql, byteCount ); <a name="l00161"></a>00161 } <a name="l00162"></a>00162 <span class="preprocessor">#endif // SQ3_USE_WCHAR</span> <a name="l00163"></a>00163 <span class="preprocessor"></span> <a name="l00164"></a>00164 <a name="l00165"></a><a class="code" href="classsq3_1_1statement.html#abce97e649b635a8cd8b6bebee657f3be">00165</a> <span class="keywordtype">bool</span> <a class="code" href="classsq3_1_1statement.html#abce97e649b635a8cd8b6bebee657f3be" title="Use after construction to ensure that a statement was compiled.">statement::is_prepared</a>()<span class="keyword"> const</span> <a name="l00166"></a>00166 <span class="keyword"> </span>{ <a name="l00167"></a>00167 <span class="keywordflow">return</span> 0 != this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(); <a name="l00168"></a>00168 } <a name="l00169"></a><a class="code" href="classsq3_1_1statement.html#a4707efaac820b250b2bb3bf38c008c32">00169</a> <a class="code" href="classsq3_1_1statement.html#a4707efaac820b250b2bb3bf38c008c32" title="Calls this-&gt;finalize().">statement::~statement</a>() <a name="l00170"></a>00170 { <a name="l00171"></a>00171 this-><a class="code" href="classsq3_1_1statement.html#ab5c77d11b7f3c7cc5bd73cf8a8a1842e" title="Finizalizes the underlying prepared statement, freeing its resources.">finalize</a>(); <a name="l00172"></a>00172 } <a name="l00173"></a><a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52">00173</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">int</span> index ) <a name="l00174"></a>00174 { <a name="l00175"></a>00175 <span class="keywordflow">return</span> sqlite3_bind_null( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index); <a name="l00176"></a>00176 } <a name="l00177"></a><a class="code" href="classsq3_1_1statement.html#a393836a9d0484176c9fe1e85a7c177f4">00177</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">int</span> index, <span class="keywordtype">int</span> data ) <a name="l00178"></a>00178 { <a name="l00179"></a>00179 <span class="keywordflow">return</span> sqlite3_bind_int( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index, data ); <a name="l00180"></a>00180 } <a name="l00181"></a><a class="code" href="classsq3_1_1statement.html#a9ceacfc6a97c9b20fcd8b8c3f0ae95d3">00181</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">int</span> index, <a class="code" href="namespacesq3.html#a9183a4a7baecd3726182653fc57a47ba" title="The type used for signed 64-bit integer operations.">int64_t</a> data ) <a name="l00182"></a>00182 { <a name="l00183"></a>00183 <span class="keywordflow">return</span> sqlite3_bind_int64( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index, data ); <a name="l00184"></a>00184 } <a name="l00185"></a><a class="code" href="classsq3_1_1statement.html#afb5ba8682629171588affc98807abdd7">00185</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">int</span> index, <span class="keywordtype">double</span> data ) <a name="l00186"></a>00186 { <a name="l00187"></a>00187 <span class="keywordflow">return</span> sqlite3_bind_double( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index, data ); <a name="l00188"></a>00188 } <a name="l00189"></a><a class="code" href="classsq3_1_1statement.html#a8b026f0984937f6de984194ed68b4242">00189</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">int</span> index, <span class="keywordtype">char</span> <span class="keyword">const</span> * data, <span class="keywordtype">int</span> len ) <a name="l00190"></a>00190 { <a name="l00191"></a>00191 <span class="keywordflow">if</span>( 0 > len ) len = <span class="keyword">static_cast<</span><span class="keywordtype">int</span><span class="keyword">></span>(strlen(data)); <a name="l00192"></a>00192 <span class="keywordflow">return</span> sqlite3_bind_text( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index, data, len, SQLITE_TRANSIENT ); <a name="l00193"></a>00193 } <a name="l00194"></a><a class="code" href="classsq3_1_1statement.html#a7782498cf5b643a66ba91ee684be6781">00194</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">int</span> index, <span class="keywordtype">void</span> <span class="keyword">const</span> * data, <span class="keywordtype">int</span> len ) <a name="l00195"></a>00195 { <a name="l00196"></a>00196 <span class="keywordflow">return</span> sqlite3_bind_blob( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index, data, len, SQLITE_TRANSIENT ); <a name="l00197"></a>00197 } <a name="l00198"></a>00198 <span class="comment">//int statement::bind( int index, wchar_t const * data, int len );</span> <a name="l00199"></a><a class="code" href="classsq3_1_1statement.html#a7bf38b2103ae8d124f513c0fe02a8153">00199</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">int</span> index, std::string <span class="keyword">const</span> & data ) <a name="l00200"></a>00200 { <a name="l00201"></a>00201 <span class="keywordflow">return</span> this-><a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">bind</a>( index, data.c_str(), <span class="keyword">static_cast<</span><span class="keywordtype">int</span><span class="keyword">></span>(data.size() ) ); <a name="l00202"></a>00202 } <a name="l00203"></a>00203 <span class="comment">//int statement::bind( int index, std::wstring const & data );</span> <a name="l00204"></a>00204 <a name="l00205"></a><a class="code" href="classsq3_1_1statement.html#af1ee9ed53aac4f4753d9b08e191a7d02">00205</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">char</span> <span class="keyword">const</span> * index ) <a name="l00206"></a>00206 { <a name="l00207"></a>00207 <span class="keywordflow">return</span> sqlite3_bind_null( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), <a name="l00208"></a>00208 sqlite3_bind_parameter_index( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index ) ); <a name="l00209"></a>00209 } <a name="l00210"></a><a class="code" href="classsq3_1_1statement.html#ae892d88378e0b22730ebc435a04f26b2">00210</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">char</span> <span class="keyword">const</span> * index, <span class="keywordtype">int</span> data ) <a name="l00211"></a>00211 { <a name="l00212"></a>00212 <span class="keywordflow">return</span> sqlite3_bind_int( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), <a name="l00213"></a>00213 sqlite3_bind_parameter_index( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index ), data ); <a name="l00214"></a>00214 } <a name="l00215"></a><a class="code" href="classsq3_1_1statement.html#a3c6f2955fdd0a13163d424d2a5e447cf">00215</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">char</span> <span class="keyword">const</span> * index, <a class="code" href="namespacesq3.html#a9183a4a7baecd3726182653fc57a47ba" title="The type used for signed 64-bit integer operations.">int64_t</a> data ) <a name="l00216"></a>00216 { <a name="l00217"></a>00217 <span class="keywordflow">return</span> sqlite3_bind_int64( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), <a name="l00218"></a>00218 sqlite3_bind_parameter_index( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index ), data ); <a name="l00219"></a>00219 } <a name="l00220"></a><a class="code" href="classsq3_1_1statement.html#ae1c7913f12c951ceff8c2da14fefd2e2">00220</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">char</span> <span class="keyword">const</span> * index, <span class="keywordtype">double</span> data ) <a name="l00221"></a>00221 { <a name="l00222"></a>00222 <span class="keywordflow">return</span> sqlite3_bind_double( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), <a name="l00223"></a>00223 sqlite3_bind_parameter_index( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index ), data ); <a name="l00224"></a>00224 } <a name="l00225"></a><a class="code" href="classsq3_1_1statement.html#a4469772af9f40c9dfd1e2a0a282cf8dc">00225</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">char</span> <span class="keyword">const</span> * index, <span class="keywordtype">char</span> <span class="keyword">const</span> * data, <span class="keywordtype">int</span> len ) <a name="l00226"></a>00226 { <a name="l00227"></a>00227 <span class="keywordflow">if</span>( 0 > len ) len = <span class="keyword">static_cast<</span><span class="keywordtype">int</span><span class="keyword">></span>(strlen(data) ); <a name="l00228"></a>00228 <span class="keywordflow">return</span> sqlite3_bind_text( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), <a name="l00229"></a>00229 sqlite3_bind_parameter_index( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index ) , data, len, SQLITE_TRANSIENT ); <a name="l00230"></a>00230 } <a name="l00231"></a><a class="code" href="classsq3_1_1statement.html#ab46d6efd8ed10679f2421675a48272c4">00231</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">char</span> <span class="keyword">const</span> * index, <span class="keywordtype">void</span> <span class="keyword">const</span> * data, <span class="keywordtype">int</span> len ) <a name="l00232"></a>00232 { <a name="l00233"></a>00233 <span class="keywordflow">return</span> sqlite3_bind_blob( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), <a name="l00234"></a>00234 sqlite3_bind_parameter_index( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index ) , data, len, SQLITE_TRANSIENT ); <a name="l00235"></a>00235 } <a name="l00236"></a>00236 <a name="l00237"></a><a class="code" href="classsq3_1_1statement.html#a1bd1ac61ecc85dd675282eb3bc75803c">00237</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">statement::bind</a>( <span class="keywordtype">char</span> <span class="keyword">const</span> * index, std::string <span class="keyword">const</span> & data ) <a name="l00238"></a>00238 { <a name="l00239"></a>00239 <span class="keywordflow">return</span> this-><a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">bind</a>( index, data.c_str(), <span class="keyword">static_cast<</span><span class="keywordtype">int</span><span class="keyword">></span>(data.size() ) ); <a name="l00240"></a>00240 } <a name="l00241"></a>00241 <a name="l00242"></a>00242 <a name="l00243"></a>00243 <a name="l00244"></a>00244 <a name="l00245"></a>00245 <a name="l00246"></a><a class="code" href="classsq3_1_1statement.html#a0fddc7388f7713d15d4bfe8451ca5971">00246</a> <a class="code" href="classsq3_1_1cursor.html" title="This type is for stepping through a db query result.">cursor</a> <a class="code" href="classsq3_1_1statement.html#a0fddc7388f7713d15d4bfe8451ca5971" title="Returns a cursor object ready to step over the result set from this object.">statement::get_cursor</a>() <a name="l00247"></a>00247 { <a name="l00248"></a>00248 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1cursor.html" title="This type is for stepping through a db query result.">cursor</a>(*<span class="keyword">this</span>); <a name="l00249"></a>00249 } <a name="l00250"></a><a class="code" href="classsq3_1_1statement.html#ab3bc7d1e366f0743720dd67d6d953ed0">00250</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#ab3bc7d1e366f0743720dd67d6d953ed0" title="Assumes this object&#39;s SQL statement is a single statement.">statement::execute</a>() <a name="l00251"></a>00251 { <a name="l00252"></a>00252 <span class="keywordflow">return</span> this-><a class="code" href="classsq3_1_1statement.html#a0fddc7388f7713d15d4bfe8451ca5971" title="Returns a cursor object ready to step over the result set from this object.">get_cursor</a>().<a class="code" href="classsq3_1_1cursor.html#a7253c675929242bbbef16ec6e3ba6ad0" title="Uses sqlite3_step() to step through this object&#39;s data set by one step.">step</a>(); <a name="l00253"></a>00253 } <a name="l00254"></a>00254 <a name="l00255"></a>00255 <span class="preprocessor">#define STATEMENT_EXECUTE_1ARG_IMPL \</span> <a name="l00256"></a>00256 <span class="preprocessor"> cursor rd( this->get_cursor() ); \</span> <a name="l00257"></a>00257 <span class="preprocessor"> int rc = rd.step(); \</span> <a name="l00258"></a>00258 <span class="preprocessor"> if( SQLITE_ROW == rc ) \</span> <a name="l00259"></a>00259 <span class="preprocessor"> { \</span> <a name="l00260"></a>00260 <span class="preprocessor"> rc = rd.get(0,tgt); \</span> <a name="l00261"></a>00261 <span class="preprocessor"> } \</span> <a name="l00262"></a>00262 <span class="preprocessor"> return rc;</span> <a name="l00263"></a>00263 <span class="preprocessor"></span> <a name="l00264"></a><a class="code" href="classsq3_1_1statement.html#a67b872e0ab75bde523aece808bcd57eb">00264</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#ab3bc7d1e366f0743720dd67d6d953ed0" title="Assumes this object&#39;s SQL statement is a single statement.">statement::execute</a>( <span class="keywordtype">int</span> & tgt ) <a name="l00265"></a>00265 { <a name="l00266"></a>00266 STATEMENT_EXECUTE_1ARG_IMPL; <a name="l00267"></a>00267 } <a name="l00268"></a><a class="code" href="classsq3_1_1statement.html#a967e1feaee78f38361f177b985d1f2ef">00268</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#ab3bc7d1e366f0743720dd67d6d953ed0" title="Assumes this object&#39;s SQL statement is a single statement.">statement::execute</a>( <a class="code" href="namespacesq3.html#a9183a4a7baecd3726182653fc57a47ba" title="The type used for signed 64-bit integer operations.">int64_t</a> & tgt ) <a name="l00269"></a>00269 { <a name="l00270"></a>00270 STATEMENT_EXECUTE_1ARG_IMPL; <a name="l00271"></a>00271 } <a name="l00272"></a><a class="code" href="classsq3_1_1statement.html#a162341e986a24c95cd18108b251e69b5">00272</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#ab3bc7d1e366f0743720dd67d6d953ed0" title="Assumes this object&#39;s SQL statement is a single statement.">statement::execute</a>( <span class="keywordtype">double</span> & tgt ) <a name="l00273"></a>00273 { <a name="l00274"></a>00274 STATEMENT_EXECUTE_1ARG_IMPL; <a name="l00275"></a>00275 } <a name="l00276"></a><a class="code" href="classsq3_1_1statement.html#abe03e9e5d525427e0f11bdc8ce2f1405">00276</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#ab3bc7d1e366f0743720dd67d6d953ed0" title="Assumes this object&#39;s SQL statement is a single statement.">statement::execute</a>( std::string & tgt ) <a name="l00277"></a>00277 { <a name="l00278"></a>00278 STATEMENT_EXECUTE_1ARG_IMPL; <a name="l00279"></a>00279 } <a name="l00280"></a>00280 <span class="preprocessor">#undef STATEMENT_EXECUTE_1ARG_IMPL</span> <a name="l00281"></a>00281 <span class="preprocessor"></span> <a name="l00282"></a><a class="code" href="classsq3_1_1statement.html#a99c38435a4902ba2a4672141d9217acd">00282</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#ab3bc7d1e366f0743720dd67d6d953ed0" title="Assumes this object&#39;s SQL statement is a single statement.">statement::execute</a>( <a class="code" href="namespacesq3.html#a033f4f2b2688f80675078447b55f831f" title="The published result codes from the sqlite3 API.">sqlite3_text_char_t</a> <span class="keyword">const</span> ** tgt, <span class="keywordtype">int</span> & len ) <a name="l00283"></a>00283 { <a name="l00284"></a>00284 <a class="code" href="classsq3_1_1cursor.html" title="This type is for stepping through a db query result.">cursor</a> rd( this-><a class="code" href="classsq3_1_1statement.html#a0fddc7388f7713d15d4bfe8451ca5971" title="Returns a cursor object ready to step over the result set from this object.">get_cursor</a>() ); <a name="l00285"></a>00285 <span class="keywordtype">int</span> rc = rd.<a class="code" href="classsq3_1_1cursor.html#a7253c675929242bbbef16ec6e3ba6ad0" title="Uses sqlite3_step() to step through this object&#39;s data set by one step.">step</a>(); <a name="l00286"></a>00286 <span class="keywordflow">if</span>( SQLITE_ROW == rc ) <a name="l00287"></a>00287 { <a name="l00288"></a>00288 rc = rd.<a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">get</a>(0,tgt,len); <a name="l00289"></a>00289 } <a name="l00290"></a>00290 <span class="keywordflow">return</span> rc; <a name="l00291"></a>00291 } <a name="l00292"></a><a class="code" href="classsq3_1_1statement.html#ae380ac44b617b5524478a7e61344af61">00292</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#ab3bc7d1e366f0743720dd67d6d953ed0" title="Assumes this object&#39;s SQL statement is a single statement.">statement::execute</a>( <span class="keywordtype">void</span> <span class="keyword">const</span> ** tgt, <span class="keywordtype">int</span> & len ) <a name="l00293"></a>00293 { <a name="l00294"></a>00294 <a class="code" href="classsq3_1_1cursor.html" title="This type is for stepping through a db query result.">cursor</a> rd( this-><a class="code" href="classsq3_1_1statement.html#a0fddc7388f7713d15d4bfe8451ca5971" title="Returns a cursor object ready to step over the result set from this object.">get_cursor</a>() ); <a name="l00295"></a>00295 <span class="keywordtype">int</span> rc = rd.<a class="code" href="classsq3_1_1cursor.html#a7253c675929242bbbef16ec6e3ba6ad0" title="Uses sqlite3_step() to step through this object&#39;s data set by one step.">step</a>(); <a name="l00296"></a>00296 <span class="keywordflow">if</span>( SQLITE_ROW == rc ) <a name="l00297"></a>00297 { <a name="l00298"></a>00298 rc = rd.<a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">get</a>(0,tgt,len); <a name="l00299"></a>00299 } <a name="l00300"></a>00300 <span class="keywordflow">return</span> rc; <a name="l00301"></a>00301 } <a name="l00302"></a>00302 <a name="l00303"></a>00303 <a name="l00304"></a><a class="code" href="classsq3_1_1statement.html#ae0270423dc9bf151b5a57bfd42da2efb">00304</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#ae0270423dc9bf151b5a57bfd42da2efb" title="Calls sqlite3_reset() on the underlying statement handle and returns the result.">statement::reset</a>() <a name="l00305"></a>00305 { <a name="l00306"></a>00306 <span class="keywordflow">return</span> this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() <a name="l00307"></a>00307 ? sqlite3_reset( this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() ) <a name="l00308"></a>00308 : SQLITE_ERROR; <a name="l00309"></a>00309 } <a name="l00310"></a>00310 <a name="l00311"></a><a class="code" href="classsq3_1_1statement.html#a2f917c5d299bc269db65dbf66137f140">00311</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a2f917c5d299bc269db65dbf66137f140" title="Returns the column count of this prepared statement, or -1 on error.">statement::colcount</a>() <a name="l00312"></a>00312 { <a name="l00313"></a>00313 <span class="keywordflow">return</span> this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() <a name="l00314"></a>00314 ? this->m_argc <a name="l00315"></a>00315 : -1; <a name="l00316"></a>00316 } <a name="l00317"></a>00317 <a name="l00318"></a><a class="code" href="classsq3_1_1statement.html#a9afbafab262574f41b71dd1fa7988713">00318</a> <span class="keywordtype">char</span> <span class="keyword">const</span> * <a class="code" href="classsq3_1_1statement.html#a9afbafab262574f41b71dd1fa7988713" title="On success, it returns the null-terminated column name of the given column.">statement::colname</a>( <span class="keywordtype">int</span> index ) <a name="l00319"></a>00319 { <a name="l00320"></a>00320 <span class="keywordtype">int</span> count = this-><a class="code" href="classsq3_1_1statement.html#a2f917c5d299bc269db65dbf66137f140" title="Returns the column count of this prepared statement, or -1 on error.">colcount</a>(); <a name="l00321"></a>00321 <span class="keywordflow">if</span>( -1 == count ) <span class="keywordflow">return</span> 0; <a name="l00322"></a>00322 <span class="keywordflow">if</span>( (index < 0) || (index >= count) ) <span class="keywordflow">return</span> 0; <a name="l00323"></a>00323 <span class="keywordflow">return</span> sqlite3_column_name(this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index); <a name="l00324"></a>00324 } <a name="l00325"></a>00325 <a name="l00326"></a><a class="code" href="classsq3_1_1statement.html#a937a9b52c5df0b31ff6f6c63644b45f4">00326</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1statement.html#a9afbafab262574f41b71dd1fa7988713" title="On success, it returns the null-terminated column name of the given column.">statement::colname</a>( <span class="keywordtype">int</span> index, <span class="keywordtype">char</span> <span class="keyword">const</span> ** cn ) <a name="l00327"></a>00327 { <a name="l00328"></a>00328 <span class="keywordtype">char</span> <span class="keyword">const</span> * c = this-><a class="code" href="classsq3_1_1statement.html#a9afbafab262574f41b71dd1fa7988713" title="On success, it returns the null-terminated column name of the given column.">colname</a>( index ); <a name="l00329"></a>00329 <span class="keywordflow">if</span>( c ) *cn = c; <a name="l00330"></a>00330 <span class="keywordflow">return</span> c ? SQLITE_OK : SQLITE_ERROR; <a name="l00331"></a>00331 } <a name="l00332"></a>00332 <a name="l00333"></a>00333 <a name="l00334"></a><a class="code" href="classsq3_1_1cursor.html#a9101adc9b33c4bcc4b9c30ae3306aa62">00334</a> <a class="code" href="classsq3_1_1cursor.html#a9101adc9b33c4bcc4b9c30ae3306aa62" title="Creates an empty cursor, whose only valid use is to assign it from another cursor...">cursor::cursor</a>() : m_stmt(0),m_cn(0) <a name="l00335"></a>00335 { <a name="l00336"></a>00336 } <a name="l00337"></a><a class="code" href="classsq3_1_1cursor.html#a3f910f6e7de50957796c0851d18a3443">00337</a> <a class="code" href="classsq3_1_1cursor.html#a9101adc9b33c4bcc4b9c30ae3306aa62" title="Creates an empty cursor, whose only valid use is to assign it from another cursor...">cursor::cursor</a>( <a class="code" href="classsq3_1_1cursor.html" title="This type is for stepping through a db query result.">cursor</a> <span class="keyword">const</span> & cp ) : m_stmt(cp.m_stmt),m_cn(0) <a name="l00338"></a>00338 { <a name="l00339"></a>00339 this->copy(cp); <a name="l00340"></a>00340 } <a name="l00341"></a>00341 <a name="l00342"></a><a class="code" href="classsq3_1_1cursor.html#a59ce053e50daf1c2175d3be32c0ad4dd">00342</a> <a class="code" href="classsq3_1_1cursor.html#a9101adc9b33c4bcc4b9c30ae3306aa62" title="Creates an empty cursor, whose only valid use is to assign it from another cursor...">cursor::cursor</a>( <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a> & st ) : m_stmt(&st),m_cn(0) <a name="l00343"></a>00343 { <a name="l00344"></a>00344 this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a854cd432ee8661e16707da4fb8bdc4b4" title="Gives ownership of p to this object (or a collection of like-types rcptr objects)...">take</a>(&st); <a name="l00345"></a>00345 } <a name="l00346"></a>00346 <a name="l00347"></a><a class="code" href="classsq3_1_1cursor.html#ad219d06e0b9c31b7a62bfa5cb21879ef">00347</a> <a class="code" href="classsq3_1_1cursor.html" title="This type is for stepping through a db query result.">cursor</a> & <a class="code" href="classsq3_1_1cursor.html#ad219d06e0b9c31b7a62bfa5cb21879ef" title="See the copy ctor.">cursor::operator=</a>( <a class="code" href="classsq3_1_1cursor.html" title="This type is for stepping through a db query result.">cursor</a> <span class="keyword">const</span> & cp ) <a name="l00348"></a>00348 { <a name="l00349"></a>00349 <span class="keywordflow">if</span>( &cp == <span class="keyword">this</span> ) <span class="keywordflow">return</span> *<span class="keyword">this</span>; <a name="l00350"></a>00350 this->copy(cp); <a name="l00351"></a>00351 <span class="keywordflow">return</span> *<span class="keyword">this</span>; <a name="l00352"></a>00352 } <a name="l00353"></a>00353 <a name="l00354"></a>00354 <span class="keywordtype">void</span> cursor::copy( <a class="code" href="classsq3_1_1cursor.html" title="This type is for stepping through a db query result.">cursor</a> <span class="keyword">const</span> & rhs ) <a name="l00355"></a>00355 { <a name="l00356"></a>00356 <span class="keywordflow">if</span>( &rhs == <span class="keyword">this</span> ) <span class="keywordflow">return</span>; <a name="l00357"></a>00357 this-><a class="code" href="classsq3_1_1cursor.html#a6b41bb7f1aebca20d69da0822fffbc57" title="&quot;Disconnects&quot; this object from the underlying result set, making this object...">close</a>(); <a name="l00358"></a>00358 this->m_stmt = rhs.m_stmt; <a name="l00359"></a>00359 <span class="keywordflow">if</span>( rhs.m_cn ) <a name="l00360"></a>00360 { <a name="l00361"></a>00361 this->m_cn = <span class="keyword">new</span> NameToIndexMap(*rhs.m_cn); <a name="l00362"></a>00362 } <a name="l00363"></a>00363 } <a name="l00364"></a>00364 <a name="l00365"></a><a class="code" href="classsq3_1_1cursor.html#a90597816ef97b8b500740c896808e5a4">00365</a> <a class="code" href="classsq3_1_1cursor.html#a90597816ef97b8b500740c896808e5a4" title="A curious side-effect which one needs to be aware of but very rarely is an issue:...">cursor::~cursor</a>() <a name="l00366"></a>00366 { <a name="l00367"></a>00367 this-><a class="code" href="classsq3_1_1cursor.html#a6b41bb7f1aebca20d69da0822fffbc57" title="&quot;Disconnects&quot; this object from the underlying result set, making this object...">close</a>(); <a name="l00368"></a>00368 } <a name="l00369"></a>00369 <a name="l00370"></a><a class="code" href="classsq3_1_1cursor.html#a7253c675929242bbbef16ec6e3ba6ad0">00370</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a7253c675929242bbbef16ec6e3ba6ad0" title="Uses sqlite3_step() to step through this object&#39;s data set by one step.">cursor::step</a>() <a name="l00371"></a>00371 { <a name="l00372"></a>00372 <span class="keywordflow">return</span> this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() <a name="l00373"></a>00373 ? sqlite3_step(this->m_stmt->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>()) <a name="l00374"></a>00374 : SQLITE_ERROR; <a name="l00375"></a>00375 } <a name="l00376"></a>00376 <a name="l00377"></a><a class="code" href="classsq3_1_1cursor.html#a44cfae0c25e1be91325c00a415541aa7">00377</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a44cfae0c25e1be91325c00a415541aa7" title="This is functionally the same as calling reset on the underlying prepared statement...">cursor::reset</a>() <a name="l00378"></a>00378 { <a name="l00379"></a>00379 <span class="keyword">delete</span> this->m_cn; <a name="l00380"></a>00380 this->m_cn = 0; <a name="l00381"></a>00381 <span class="keywordflow">return</span> this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() <a name="l00382"></a>00382 ? this->m_stmt->reset() <a name="l00383"></a>00383 : SQLITE_ERROR; <a name="l00384"></a>00384 } <a name="l00385"></a><a class="code" href="classsq3_1_1cursor.html#a6b41bb7f1aebca20d69da0822fffbc57">00385</a> <span class="keywordtype">void</span> <a class="code" href="classsq3_1_1cursor.html#a6b41bb7f1aebca20d69da0822fffbc57" title="&quot;Disconnects&quot; this object from the underlying result set, making this object...">cursor::close</a>() <a name="l00386"></a>00386 { <a name="l00387"></a>00387 this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a854cd432ee8661e16707da4fb8bdc4b4" title="Gives ownership of p to this object (or a collection of like-types rcptr objects)...">take</a>(0); <a name="l00388"></a>00388 <span class="keywordflow">if</span>( this->m_cn ) <a name="l00389"></a>00389 { <a name="l00390"></a>00390 <span class="keyword">delete</span> this->m_cn; <a name="l00391"></a>00391 this->m_cn = 0; <a name="l00392"></a>00392 } <a name="l00393"></a>00393 } <a name="l00394"></a>00394 <a name="l00395"></a><a class="code" href="classsq3_1_1cursor.html#ab43f9599d49c13195e78e49943d6157f">00395</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#ab43f9599d49c13195e78e49943d6157f" title="Returns the column count of the underlying prepared statement.">cursor::colcount</a>() <a name="l00396"></a>00396 { <a name="l00397"></a>00397 <span class="keywordflow">return</span> this->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() <a name="l00398"></a>00398 ? this->m_stmt->colcount() <a name="l00399"></a>00399 : -1; <a name="l00400"></a>00400 } <a name="l00401"></a>00401 <a name="l00402"></a>00402 <span class="preprocessor">#define CURSOR_CHECK_INDEX \</span> <a name="l00403"></a>00403 <span class="preprocessor"> if( ! this->m_stmt.get() ) return SQLITE_ERROR; \</span> <a name="l00404"></a>00404 <span class="preprocessor"> if( (index)>(this->m_stmt->m_argc-1)) return SQLITE_ERROR;</span> <a name="l00405"></a>00405 <span class="preprocessor"></span> <a name="l00406"></a><a class="code" href="classsq3_1_1cursor.html#a067706590778ef5147676499a7cfb808">00406</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a067706590778ef5147676499a7cfb808" title="If column index (0-based) is in bounds then this function check if the value of the...">cursor::isnull</a>( <span class="keywordtype">int</span> index, <span class="keywordtype">bool</span> & tgt ) <a name="l00407"></a>00407 { <a name="l00408"></a>00408 CURSOR_CHECK_INDEX; <a name="l00409"></a>00409 tgt = sqlite3_column_type( this->m_stmt->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index) == SQLITE_NULL; <a name="l00410"></a>00410 <span class="keywordflow">return</span> SQLITE_OK; <a name="l00411"></a>00411 } <a name="l00412"></a>00412 <a name="l00413"></a><a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12">00413</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">cursor::get</a>( <span class="keywordtype">int</span> index, <span class="keywordtype">int</span> & tgt ) <a name="l00414"></a>00414 { <a name="l00415"></a>00415 CURSOR_CHECK_INDEX; <a name="l00416"></a>00416 tgt = sqlite3_column_int( this->m_stmt->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index ); <a name="l00417"></a>00417 <span class="keywordflow">return</span> SQLITE_OK; <a name="l00418"></a>00418 } <a name="l00419"></a><a class="code" href="classsq3_1_1cursor.html#a31bba02827e9f39b9664f0e8f3031df6">00419</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">cursor::get</a>( <span class="keywordtype">int</span> index, <a class="code" href="namespacesq3.html#a9183a4a7baecd3726182653fc57a47ba" title="The type used for signed 64-bit integer operations.">int64_t</a> & tgt ) <a name="l00420"></a>00420 { <a name="l00421"></a>00421 CURSOR_CHECK_INDEX; <a name="l00422"></a>00422 tgt = sqlite3_column_int64( this->m_stmt->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index ); <a name="l00423"></a>00423 <span class="keywordflow">return</span> SQLITE_OK; <a name="l00424"></a>00424 } <a name="l00425"></a><a class="code" href="classsq3_1_1cursor.html#afc7513a109c892141b0e8d0ad94591a4">00425</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">cursor::get</a>( <span class="keywordtype">int</span> index, <span class="keywordtype">double</span> & tgt ) <a name="l00426"></a>00426 { <a name="l00427"></a>00427 CURSOR_CHECK_INDEX; <a name="l00428"></a>00428 tgt = sqlite3_column_double( this->m_stmt->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index ); <a name="l00429"></a>00429 <span class="keywordflow">return</span> SQLITE_OK; <a name="l00430"></a>00430 } <a name="l00431"></a><a class="code" href="classsq3_1_1cursor.html#a9f9541c0b41507349530cb62655565ed">00431</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">cursor::get</a>( <span class="keywordtype">int</span> index, std::string & tgt ) <a name="l00432"></a>00432 { <a name="l00433"></a>00433 CURSOR_CHECK_INDEX; <a name="l00434"></a>00434 <span class="keywordtype">char</span> <span class="keyword">const</span> * x = (<span class="keyword">const</span> <span class="keywordtype">char</span>*)sqlite3_column_text(this->m_stmt->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index); <a name="l00435"></a>00435 <span class="keywordtype">int</span> sz = sqlite3_column_bytes(this->m_stmt->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index); <a name="l00436"></a>00436 <span class="keywordflow">if</span>( 0 < sz ) <a name="l00437"></a>00437 { <a name="l00438"></a>00438 tgt = std::string( x, x+sz ); <a name="l00439"></a>00439 } <a name="l00440"></a>00440 <span class="keywordflow">else</span> <a name="l00441"></a>00441 { <a name="l00442"></a>00442 tgt = std::string(); <a name="l00443"></a>00443 } <a name="l00444"></a>00444 <span class="keywordflow">return</span> SQLITE_OK; <a name="l00445"></a>00445 } <a name="l00446"></a><a class="code" href="classsq3_1_1cursor.html#ab2760867c96cc67ee1da084d4837314e">00446</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">cursor::get</a>( <span class="keywordtype">int</span> index, <a class="code" href="namespacesq3.html#a033f4f2b2688f80675078447b55f831f" title="The published result codes from the sqlite3 API.">sqlite3_text_char_t</a> <span class="keyword">const</span> ** tgt, <span class="keywordtype">int</span> & sz ) <a name="l00447"></a>00447 { <a name="l00448"></a>00448 CURSOR_CHECK_INDEX; <a name="l00449"></a>00449 sz = sqlite3_column_bytes(this->m_stmt->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index); <a name="l00450"></a>00450 <span class="keywordflow">if</span>( 0 < sz ) <a name="l00451"></a>00451 { <a name="l00452"></a>00452 *tgt = sqlite3_column_text( this->m_stmt->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index); <a name="l00453"></a>00453 } <a name="l00454"></a>00454 <span class="keywordflow">else</span> <a name="l00455"></a>00455 { <a name="l00456"></a>00456 tgt = 0; <a name="l00457"></a>00457 } <a name="l00458"></a>00458 <span class="keywordflow">return</span> SQLITE_OK; <a name="l00459"></a>00459 } <a name="l00460"></a><a class="code" href="classsq3_1_1cursor.html#a439b6e0d6d76b0b1e4483d7e5feb1cdf">00460</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">cursor::get</a>( <span class="keywordtype">int</span> index, <span class="keywordtype">void</span> <span class="keyword">const</span> ** tgt, <span class="keywordtype">int</span> & sz ) <a name="l00461"></a>00461 { <a name="l00462"></a>00462 CURSOR_CHECK_INDEX; <a name="l00463"></a>00463 sz = sqlite3_column_bytes(this->m_stmt->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index); <a name="l00464"></a>00464 <span class="keywordflow">if</span>( 0 < sz ) <a name="l00465"></a>00465 { <a name="l00466"></a>00466 *tgt = sqlite3_column_blob(this->m_stmt->m_stmt.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), index); <a name="l00467"></a>00467 } <a name="l00468"></a>00468 <span class="keywordflow">return</span> SQLITE_OK; <a name="l00469"></a>00469 } <a name="l00470"></a>00470 <a name="l00471"></a>00471 <span class="comment"></span> <a name="l00472"></a>00472 <span class="comment"> /**</span> <a name="l00473"></a>00473 <span class="comment"> CURSOR_GET_STRING_IMPL2 is the implementation for the get(string,xxx) family of funcs</span> <a name="l00474"></a>00474 <span class="comment"> which take 2 arguments.</span> <a name="l00475"></a>00475 <span class="comment"> */</span> <a name="l00476"></a>00476 <span class="preprocessor">#define CURSOR_GET_STRING_IMPL2(vaR,targetNamE) \</span> <a name="l00477"></a>00477 <span class="preprocessor"> if( ! this->m_stmt.get() ) return SQLITE_ERROR; \</span> <a name="l00478"></a>00478 <span class="preprocessor"> if( 0 == this->index_colnames() ) return SQLITE_ERROR; \</span> <a name="l00479"></a>00479 <span class="preprocessor"> NameToIndexMap::const_iterator n2iit = this->m_cn->find( vaR ); \</span> <a name="l00480"></a>00480 <span class="preprocessor"> return ( this->m_cn->end() == n2iit ) ? SQLITE_ERROR : this->get( (*n2iit).second, targetNamE );</span> <a name="l00481"></a>00481 <span class="preprocessor"></span><span class="comment"></span> <a name="l00482"></a>00482 <span class="comment"> /**</span> <a name="l00483"></a>00483 <span class="comment"> CURSOR_GET_STRING_IMPL3 is the implementation for the get(string,xxx) family of funcs</span> <a name="l00484"></a>00484 <span class="comment"> which take 3 arguments. It is *almost* identicle to CURSOR_GET_STRING_IMPL2.</span> <a name="l00485"></a>00485 <span class="comment"> */</span> <a name="l00486"></a>00486 <span class="preprocessor">#define CURSOR_GET_STRING_IMPL3(vaR,targetNamE,sizeNamE) \</span> <a name="l00487"></a>00487 <span class="preprocessor"> if( ! this->m_stmt.get() ) return SQLITE_ERROR; \</span> <a name="l00488"></a>00488 <span class="preprocessor"> if( 0 == this->index_colnames() ) return SQLITE_ERROR; \</span> <a name="l00489"></a>00489 <span class="preprocessor"> NameToIndexMap::const_iterator n2iit = this->m_cn->find( vaR ); \</span> <a name="l00490"></a>00490 <span class="preprocessor"> return ( this->m_cn->end() == n2iit ) ? SQLITE_ERROR : this->get( (*n2iit).second, targetNamE, sizeNamE );</span> <a name="l00491"></a>00491 <span class="preprocessor"></span> <a name="l00492"></a>00492 <a name="l00493"></a><a class="code" href="classsq3_1_1cursor.html#a6a5d687fa67b52bc84d6fec7dcf50bd7">00493</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">cursor::get</a>( std::string <span class="keyword">const</span> & key, <span class="keywordtype">int</span> & tgt ) <a name="l00494"></a>00494 { <a name="l00495"></a>00495 CURSOR_GET_STRING_IMPL2(key,tgt); <a name="l00496"></a>00496 } <a name="l00497"></a><a class="code" href="classsq3_1_1cursor.html#aa0636f597a7bef8790fe852f7bcb78dc">00497</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">cursor::get</a>( std::string <span class="keyword">const</span> & key, <a class="code" href="namespacesq3.html#a9183a4a7baecd3726182653fc57a47ba" title="The type used for signed 64-bit integer operations.">int64_t</a> & tgt ) <a name="l00498"></a>00498 { <a name="l00499"></a>00499 CURSOR_GET_STRING_IMPL2(key,tgt); <a name="l00500"></a>00500 } <a name="l00501"></a><a class="code" href="classsq3_1_1cursor.html#a5c82f90758d3f3acc85b02ec5eec9ead">00501</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">cursor::get</a>( std::string <span class="keyword">const</span> & key, <span class="keywordtype">double</span> & tgt ) <a name="l00502"></a>00502 { <a name="l00503"></a>00503 CURSOR_GET_STRING_IMPL2(key,tgt); <a name="l00504"></a>00504 } <a name="l00505"></a><a class="code" href="classsq3_1_1cursor.html#a724207438afc61226a0a5610c0dfe996">00505</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">cursor::get</a>( std::string <span class="keyword">const</span> & key, std::string & tgt ) <a name="l00506"></a>00506 { <a name="l00507"></a>00507 CURSOR_GET_STRING_IMPL2(key,tgt); <a name="l00508"></a>00508 } <a name="l00509"></a><a class="code" href="classsq3_1_1cursor.html#a1425807dafd458673dddcf590ca40291">00509</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">cursor::get</a>( std::string <span class="keyword">const</span> & key, <a class="code" href="namespacesq3.html#a033f4f2b2688f80675078447b55f831f" title="The published result codes from the sqlite3 API.">sqlite3_text_char_t</a> <span class="keyword">const</span> ** tgt, <span class="keywordtype">int</span> & sz ) <a name="l00510"></a>00510 { <a name="l00511"></a>00511 CURSOR_GET_STRING_IMPL3(key,tgt,sz); <a name="l00512"></a>00512 } <a name="l00513"></a><a class="code" href="classsq3_1_1cursor.html#aad46132b270e2aa85f39d130ed9e40e8">00513</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#a8c99e59f1e5e7f680534fbd6a62fed12" title="If column index (0-based) is in bounds then this function assigns tgt to the value...">cursor::get</a>( std::string <span class="keyword">const</span> & key, <span class="keywordtype">void</span> <span class="keyword">const</span> ** tgt, <span class="keywordtype">int</span> & sz ) <a name="l00514"></a>00514 { <a name="l00515"></a>00515 CURSOR_GET_STRING_IMPL3(key,tgt,sz); <a name="l00516"></a>00516 } <a name="l00517"></a>00517 <a name="l00518"></a>00518 <a name="l00519"></a><a class="code" href="classsq3_1_1cursor.html#afb920de1da87ee657a29fa7165ba4859">00519</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#afb920de1da87ee657a29fa7165ba4859" title="Sets str to the column name as the given index (0-based).">cursor::colname</a>( <span class="keywordtype">int</span> index, std::string & tgt ) <a name="l00520"></a>00520 { <a name="l00521"></a>00521 <span class="keywordtype">char</span> <span class="keyword">const</span> * cn = 0; <a name="l00522"></a>00522 <span class="keywordtype">int</span> rc = this-><a class="code" href="classsq3_1_1cursor.html#afb920de1da87ee657a29fa7165ba4859" title="Sets str to the column name as the given index (0-based).">colname</a>( index, &cn ); <a name="l00523"></a>00523 <span class="keywordflow">if</span>( SQLITE_OK == rc ) <a name="l00524"></a>00524 { <a name="l00525"></a>00525 tgt = cn ? cn : <span class="stringliteral">""</span>; <a name="l00526"></a>00526 } <a name="l00527"></a>00527 <span class="keywordflow">return</span> rc; <a name="l00528"></a>00528 } <a name="l00529"></a>00529 <a name="l00530"></a><a class="code" href="classsq3_1_1cursor.html#a5a102b705938ffc5d0902a78cb1bc649">00530</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1cursor.html#afb920de1da87ee657a29fa7165ba4859" title="Sets str to the column name as the given index (0-based).">cursor::colname</a>( <span class="keywordtype">int</span> index, <span class="keywordtype">char</span> <span class="keyword">const</span> ** cn ) <a name="l00531"></a>00531 { <a name="l00532"></a>00532 <span class="keywordflow">return</span> this->m_stmt->colname( index, cn ); <a name="l00533"></a>00533 } <a name="l00534"></a>00534 <a name="l00535"></a>00535 <a name="l00536"></a>00536 <span class="preprocessor">#undef CURSOR_CHECK_INDEX</span> <a name="l00537"></a>00537 <span class="preprocessor"></span><span class="preprocessor">#undef CURSOR_GET_STRING_IMPL2</span> <a name="l00538"></a>00538 <span class="preprocessor"></span><span class="preprocessor">#undef CURSOR_GET_STRING_IMPL3</span> <a name="l00539"></a>00539 <span class="preprocessor"></span> <a name="l00540"></a><a class="code" href="classsq3_1_1database.html#a674d66007f7cf0fe2f68233593526ecb">00540</a> sqlite3 * <a class="code" href="classsq3_1_1database.html#a674d66007f7cf0fe2f68233593526ecb" title="The low-level handle to the sqlite db.">database::handle</a>()<span class="keyword"> const</span> <a name="l00541"></a>00541 <span class="keyword"> </span>{ <a name="l00542"></a>00542 <span class="keywordflow">return</span> this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(); <a name="l00543"></a>00543 } <a name="l00544"></a><a class="code" href="classsq3_1_1database.html#a031f52c894718d806d3d09696901dcca">00544</a> <a class="code" href="classsq3_1_1database.html#a031f52c894718d806d3d09696901dcca" title="Creates an unopened database.">database::database</a>() : m_dbh(0), m_name() <a name="l00545"></a>00545 { <a name="l00546"></a>00546 } <a name="l00547"></a>00547 <a name="l00548"></a>00548 <a name="l00549"></a><a class="code" href="classsq3_1_1database.html#a5dca436b8be0c07023e8347bb5137a80">00549</a> <a class="code" href="classsq3_1_1database.html#a031f52c894718d806d3d09696901dcca" title="Creates an unopened database.">database::database</a>( std::string <span class="keyword">const</span> & dbname ) <a name="l00550"></a>00550 : m_dbh(0), m_name(dbname) <a name="l00551"></a>00551 { <a name="l00552"></a>00552 this-><a class="code" href="classsq3_1_1database.html#ab7b7609d8dfc4b773c72f80839c38572" title="Creates/opens the given db file.">open</a>( dbname ); <a name="l00553"></a>00553 } <a name="l00554"></a>00554 <a name="l00555"></a><a class="code" href="classsq3_1_1database.html#a23fa7ca868f48e4de39c0f0f55cd2c9c">00555</a> <a class="code" href="classsq3_1_1database.html#a23fa7ca868f48e4de39c0f0f55cd2c9c" title="Closes this db.">database::~database</a>() <a name="l00556"></a>00556 { <a name="l00557"></a>00557 this-><a class="code" href="classsq3_1_1database.html#afae8e3a403d29e3ffeec86ccc0570743" title="&quot;Closes&quot; this db.">close</a>(); <a name="l00558"></a>00558 } <a name="l00559"></a>00559 <a name="l00560"></a>00560 <a name="l00561"></a>00561 <a name="l00562"></a>00562 <a name="l00563"></a><a class="code" href="classsq3_1_1database.html#af3b6b07c453a2ce5eaf9072e9cbe1f84">00563</a> <span class="keywordtype">bool</span> <a class="code" href="classsq3_1_1database.html#af3b6b07c453a2ce5eaf9072e9cbe1f84" title="Returns true if this db is opened.">database::is_open</a>()<span class="keyword"> const</span> <a name="l00564"></a>00564 <span class="keyword"> </span>{ <a name="l00565"></a>00565 <span class="keywordflow">return</span> 0 != this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(); <a name="l00566"></a>00566 } <a name="l00567"></a><a class="code" href="classsq3_1_1database.html#a70b7775e8ec6b930cd1df88c1d691d6a">00567</a> std::string <a class="code" href="classsq3_1_1database.html#a70b7775e8ec6b930cd1df88c1d691d6a" title="Returns the name of the db file.">database::name</a>()<span class="keyword"> const</span> <a name="l00568"></a>00568 <span class="keyword"> </span>{ <a name="l00569"></a>00569 <span class="keywordflow">return</span> this->m_name; <a name="l00570"></a>00570 } <a name="l00571"></a>00571 <a name="l00572"></a><a class="code" href="classsq3_1_1database.html#a96e7f35f86397c1f82325ec902d66600">00572</a> sqlite3 * <a class="code" href="classsq3_1_1database.html#a96e7f35f86397c1f82325ec902d66600" title="Transfers ownership of this-&gt;handle() to the caller.">database::take_handle</a>() <a name="l00573"></a>00573 { <a name="l00574"></a>00574 <span class="keywordflow">return</span> this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a854cd432ee8661e16707da4fb8bdc4b4" title="Gives ownership of p to this object (or a collection of like-types rcptr objects)...">take</a>(); <a name="l00575"></a>00575 } <a name="l00576"></a>00576 <a name="l00577"></a><a class="code" href="classsq3_1_1database.html#acf216ebb32313e51215468aec2ef0952">00577</a> <span class="keywordtype">void</span> <a class="code" href="classsq3_1_1database.html#a96e7f35f86397c1f82325ec902d66600" title="Transfers ownership of this-&gt;handle() to the caller.">database::take_handle</a>( sqlite3 * dbh, std::string <span class="keyword">const</span> & name ) <a name="l00578"></a>00578 { <a name="l00579"></a>00579 <span class="keywordflow">if</span>( this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() == dbh ) <span class="keywordflow">return</span>; <a name="l00580"></a>00580 this-><a class="code" href="classsq3_1_1database.html#afae8e3a403d29e3ffeec86ccc0570743" title="&quot;Closes&quot; this db.">close</a>(); <a name="l00581"></a>00581 this->m_name = name; <a name="l00582"></a>00582 this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a854cd432ee8661e16707da4fb8bdc4b4" title="Gives ownership of p to this object (or a collection of like-types rcptr objects)...">take</a>( dbh ); <a name="l00583"></a>00583 } <a name="l00584"></a>00584 <a name="l00585"></a><a class="code" href="classsq3_1_1database.html#ad108bff8ea5c80026f5ab45d19ec313c">00585</a> std::string <a class="code" href="classsq3_1_1database.html#ad108bff8ea5c80026f5ab45d19ec313c" title="Returns the last error message from sqlite, or an empty string if this object is...">database::errormsg</a>()<span class="keyword"> const</span> <a name="l00586"></a>00586 <span class="keyword"> </span>{ <a name="l00587"></a>00587 <span class="keywordtype">char</span> <span class="keyword">const</span> * m = this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() ? sqlite3_errmsg( this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() ) : 0; <a name="l00588"></a>00588 <span class="keywordflow">return</span> m ? m : <span class="stringliteral">""</span>; <a name="l00589"></a>00589 } <a name="l00590"></a>00590 <a name="l00591"></a><a class="code" href="classsq3_1_1database.html#ab7b7609d8dfc4b773c72f80839c38572">00591</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#ab7b7609d8dfc4b773c72f80839c38572" title="Creates/opens the given db file.">database::open</a>( <span class="keywordtype">char</span> <span class="keyword">const</span> * dbn, <span class="keywordtype">long</span> flags ) <a name="l00592"></a>00592 { <a name="l00593"></a>00593 <span class="keywordflow">if</span>( ! dbn ) <span class="keywordflow">return</span> SQLITE_ERROR; <a name="l00594"></a>00594 <span class="keywordtype">int</span> rc = 0; <a name="l00595"></a>00595 <span class="keywordflow">if</span>( this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() ) <a name="l00596"></a>00596 { <a name="l00597"></a>00597 rc = this-><a class="code" href="classsq3_1_1database.html#afae8e3a403d29e3ffeec86ccc0570743" title="&quot;Closes&quot; this db.">close</a>(); <a name="l00598"></a>00598 <span class="keywordflow">if</span>( 0 != rc ) <span class="keywordflow">return</span> rc; <a name="l00599"></a>00599 } <a name="l00600"></a>00600 this->m_name = dbn; <a name="l00601"></a>00601 sqlite3 * sq = 0; <a name="l00602"></a>00602 <span class="preprocessor">#if (SQLITE_VERSION_NUMBER >= 3005001)</span> <a name="l00603"></a>00603 <span class="preprocessor"></span> <span class="keywordflow">if</span>( ! flags ) <a name="l00604"></a>00604 { <a name="l00605"></a>00605 rc = sqlite3_open(dbn, &sq); <a name="l00606"></a>00606 } <a name="l00607"></a>00607 <span class="keywordflow">else</span> <a name="l00608"></a>00608 { <a name="l00609"></a>00609 rc = sqlite3_open_v2( dbn, &sq, flags, NULL ); <a name="l00610"></a>00610 } <a name="l00611"></a>00611 <span class="preprocessor">#else</span> <a name="l00612"></a>00612 <span class="preprocessor"></span> { <span class="keywordtype">int</span> bogus; bogus = flags; } <span class="comment">// avoid "unused variable: flags" warning from gcc</span> <a name="l00613"></a>00613 rc = sqlite3_open(dbn, &sq); <a name="l00614"></a>00614 <span class="preprocessor">#endif // sqlite3 >= 3.5.1</span> <a name="l00615"></a>00615 <span class="preprocessor"></span> <span class="keywordflow">if</span>( SQLITE_OK == rc ) <a name="l00616"></a>00616 { <a name="l00617"></a>00617 this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a854cd432ee8661e16707da4fb8bdc4b4" title="Gives ownership of p to this object (or a collection of like-types rcptr objects)...">take</a>( sq ); <a name="l00618"></a>00618 rc = this-><a class="code" href="classsq3_1_1database.html#af18c9185b4c73af3c453f54cba13015f" title="This function is called when open() succeeds.">on_open</a>(); <a name="l00619"></a>00619 } <a name="l00620"></a>00620 <span class="keywordflow">if</span>( SQLITE_OK != rc ) <a name="l00621"></a>00621 { <a name="l00622"></a>00622 this-><a class="code" href="classsq3_1_1database.html#afae8e3a403d29e3ffeec86ccc0570743" title="&quot;Closes&quot; this db.">close</a>(); <span class="comment">// ingore any close() failure in this case</span> <a name="l00623"></a>00623 } <a name="l00624"></a>00624 <span class="keywordflow">return</span> rc; <a name="l00625"></a>00625 } <a name="l00626"></a>00626 <a name="l00627"></a><a class="code" href="classsq3_1_1database.html#a20a1de94fdab6a3e5a604a8776f39e5b">00627</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#ab7b7609d8dfc4b773c72f80839c38572" title="Creates/opens the given db file.">database::open</a>( std::string <span class="keyword">const</span> & dbn, <span class="keywordtype">long</span> flags ) <a name="l00628"></a>00628 { <a name="l00629"></a>00629 <span class="keywordflow">return</span> this-><a class="code" href="classsq3_1_1database.html#ab7b7609d8dfc4b773c72f80839c38572" title="Creates/opens the given db file.">open</a>( dbn.c_str(), flags ); <a name="l00630"></a>00630 } <a name="l00631"></a>00631 <a name="l00632"></a><a class="code" href="classsq3_1_1database.html#af18c9185b4c73af3c453f54cba13015f">00632</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#af18c9185b4c73af3c453f54cba13015f" title="This function is called when open() succeeds.">database::on_open</a>() <a name="l00633"></a>00633 { <a name="l00634"></a>00634 <span class="keywordflow">return</span> SQLITE_OK; <a name="l00635"></a>00635 } <a name="l00636"></a>00636 <a name="l00637"></a>00637 <span class="preprocessor">#if SQ3_USE_WCHAR</span> <a name="l00638"></a>00638 <span class="preprocessor"></span> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#ab7b7609d8dfc4b773c72f80839c38572" title="Creates/opens the given db file.">database::open</a>( sqlite3_wstring_t dbn ) <a name="l00639"></a>00639 { <a name="l00640"></a>00640 <span class="comment">//std::wcerr << L"database::open(wchar_t " << dbn << L")\n";</span> <a name="l00641"></a>00641 this-><a class="code" href="classsq3_1_1database.html#afae8e3a403d29e3ffeec86ccc0570743" title="&quot;Closes&quot; this db.">close</a>(); <a name="l00642"></a>00642 <span class="keywordtype">int</span> rc = sqlite3_open16(dbn, &this->m_db); <a name="l00643"></a>00643 sqlite3 * sq = 0; <a name="l00644"></a>00644 sqlite3_open(dbn, &sq); <a name="l00645"></a>00645 <span class="keywordflow">if</span>( SQLITE_OK == rc ) <a name="l00646"></a>00646 { <a name="l00647"></a>00647 this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a854cd432ee8661e16707da4fb8bdc4b4" title="Gives ownership of p to this object (or a collection of like-types rcptr objects)...">take</a>( sq ); <a name="l00648"></a>00648 rc = this-><a class="code" href="classsq3_1_1database.html#af18c9185b4c73af3c453f54cba13015f" title="This function is called when open() succeeds.">on_open</a>(); <a name="l00649"></a>00649 } <a name="l00650"></a>00650 <span class="keywordflow">if</span>( SQLITE_OK != rc ) <a name="l00651"></a>00651 { <a name="l00652"></a>00652 this-><a class="code" href="classsq3_1_1database.html#afae8e3a403d29e3ffeec86ccc0570743" title="&quot;Closes&quot; this db.">close</a>(); <a name="l00653"></a>00653 } <a name="l00654"></a>00654 <span class="keywordflow">return</span> rc; <a name="l00655"></a>00655 } <a name="l00656"></a>00656 <a name="l00657"></a>00657 <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#ab7b7609d8dfc4b773c72f80839c38572" title="Creates/opens the given db file.">database::open</a>( std::wstring <span class="keyword">const</span> & dbn ) <a name="l00658"></a>00658 { <a name="l00659"></a>00659 <span class="keywordflow">return</span> this-><a class="code" href="classsq3_1_1database.html#ab7b7609d8dfc4b773c72f80839c38572" title="Creates/opens the given db file.">open</a>( dbn.c_str() ); <a name="l00660"></a>00660 } <a name="l00661"></a>00661 <span class="preprocessor">#endif // SQ3_USE_WCHAR</span> <a name="l00662"></a>00662 <span class="preprocessor"></span> <a name="l00663"></a><a class="code" href="classsq3_1_1database.html#afae8e3a403d29e3ffeec86ccc0570743">00663</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#afae8e3a403d29e3ffeec86ccc0570743" title="&quot;Closes&quot; this db.">database::close</a>( <span class="keywordtype">bool</span> force ) <a name="l00664"></a>00664 { <a name="l00665"></a>00665 <span class="keywordflow">if</span>(0 == this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>()) <span class="keywordflow">return</span> SQLITE_ERROR; <a name="l00666"></a>00666 <span class="keywordflow">if</span>( force ) <a name="l00667"></a>00667 { <span class="comment">// do immediately close:</span> <a name="l00668"></a>00668 <span class="keywordflow">return</span> sqlite3_close( this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a854cd432ee8661e16707da4fb8bdc4b4" title="Gives ownership of p to this object (or a collection of like-types rcptr objects)...">take</a>() <span class="comment">/* transfer ownership to sqlite3 */</span> ); <a name="l00669"></a>00669 } <a name="l00670"></a>00670 <span class="keywordflow">else</span> <a name="l00671"></a>00671 { <span class="comment">// --reference_count and queue up the close:</span> <a name="l00672"></a>00672 this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a854cd432ee8661e16707da4fb8bdc4b4" title="Gives ownership of p to this object (or a collection of like-types rcptr objects)...">take</a>(0); <span class="comment">// drop existing handle.</span> <a name="l00673"></a>00673 <span class="keywordflow">return</span> SQLITE_OK; <a name="l00674"></a>00674 } <a name="l00675"></a>00675 } <a name="l00676"></a>00676 <a name="l00677"></a><a class="code" href="classsq3_1_1database.html#aefe363278ea935699a1c9f3d0b0c6e90">00677</a> <a class="code" href="namespacesq3.html#a9183a4a7baecd3726182653fc57a47ba" title="The type used for signed 64-bit integer operations.">int64_t</a> <a class="code" href="classsq3_1_1database.html#aefe363278ea935699a1c9f3d0b0c6e90" title="Returns the rowid of the most recently inserted row on this db.">database::insertid</a>() <a name="l00678"></a>00678 { <a name="l00679"></a>00679 <span class="keywordflow">return</span> this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() <a name="l00680"></a>00680 ? sqlite3_last_insert_rowid(this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>()) <a name="l00681"></a>00681 : -1; <a name="l00682"></a>00682 } <a name="l00683"></a>00683 <a name="l00684"></a><a class="code" href="classsq3_1_1database.html#a722715171d91b3713e07485fc89f5fda">00684</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a722715171d91b3713e07485fc89f5fda" title="Returns the number of database rows that were changed (or inserted or deleted) by...">database::changes</a>() <a name="l00685"></a>00685 { <a name="l00686"></a>00686 <span class="keywordflow">return</span> this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() <a name="l00687"></a>00687 ? sqlite3_changes(this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>()) <a name="l00688"></a>00688 : -1; <a name="l00689"></a>00689 } <a name="l00690"></a>00690 <a name="l00691"></a><a class="code" href="classsq3_1_1database.html#a0baa615d200aad7e121f8e11aad12d33">00691</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a0baa615d200aad7e121f8e11aad12d33" title="See sqlite3_busy_timeout().">database::setbusytimeout</a>( <span class="keywordtype">int</span> ms ) <a name="l00692"></a>00692 { <a name="l00693"></a>00693 <span class="keywordflow">return</span> this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>() <a name="l00694"></a>00694 ? sqlite3_busy_timeout(this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), ms) <a name="l00695"></a>00695 : SQLITE_ERROR; <a name="l00696"></a>00696 } <a name="l00697"></a>00697 <a name="l00698"></a><a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130">00698</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(<span class="keyword">const</span> std::string &sql) <a name="l00699"></a>00699 { <a name="l00700"></a>00700 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql ).execute(); <a name="l00701"></a>00701 } <a name="l00702"></a>00702 <a name="l00703"></a><a class="code" href="classsq3_1_1database.html#a8ff3ede6345e3e242eec5a3225dc5121">00703</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(<span class="keywordtype">char</span> <span class="keyword">const</span> * sql ) <a name="l00704"></a>00704 { <a name="l00705"></a>00705 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql, -1 ).execute(); <a name="l00706"></a>00706 } <a name="l00707"></a>00707 <a name="l00708"></a><a class="code" href="classsq3_1_1database.html#acdced556dd72d05d866977de348a7bf7">00708</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(<span class="keywordtype">char</span> <span class="keyword">const</span> * sql, <span class="keywordtype">int</span> & tgt) <a name="l00709"></a>00709 { <a name="l00710"></a>00710 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql ).execute( tgt ); <a name="l00711"></a>00711 } <a name="l00712"></a>00712 <a name="l00713"></a><a class="code" href="classsq3_1_1database.html#a702ae3d77fc416e3a99cce89db2725d5">00713</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(std::string <span class="keyword">const</span> & sql, <span class="keywordtype">int</span> & tgt) <a name="l00714"></a>00714 { <a name="l00715"></a>00715 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql ).execute( tgt ); <a name="l00716"></a>00716 } <a name="l00717"></a>00717 <a name="l00718"></a><a class="code" href="classsq3_1_1database.html#ac8e93cadab160c9e8a6cb08237245633">00718</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(<span class="keywordtype">char</span> <span class="keyword">const</span> * sql, <a class="code" href="namespacesq3.html#a9183a4a7baecd3726182653fc57a47ba" title="The type used for signed 64-bit integer operations.">int64_t</a> & tgt) <a name="l00719"></a>00719 { <a name="l00720"></a>00720 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql, -1 ).execute( tgt ); <a name="l00721"></a>00721 } <a name="l00722"></a>00722 <a name="l00723"></a><a class="code" href="classsq3_1_1database.html#a5369be6be1be26df849152fcf8130ad6">00723</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(std::string <span class="keyword">const</span> & sql, <a class="code" href="namespacesq3.html#a9183a4a7baecd3726182653fc57a47ba" title="The type used for signed 64-bit integer operations.">int64_t</a> & tgt) <a name="l00724"></a>00724 { <a name="l00725"></a>00725 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql ).execute( tgt ); <a name="l00726"></a>00726 } <a name="l00727"></a>00727 <a name="l00728"></a><a class="code" href="classsq3_1_1database.html#aaf56e701d812206e50321c10d5be9ef0">00728</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(<span class="keywordtype">char</span> <span class="keyword">const</span> * sql, <span class="keywordtype">double</span> & tgt) <a name="l00729"></a>00729 { <a name="l00730"></a>00730 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql, -1 ).execute( tgt ); <a name="l00731"></a>00731 } <a name="l00732"></a>00732 <a name="l00733"></a><a class="code" href="classsq3_1_1database.html#a3d01669b93c2189536b3dc00f1b1d95d">00733</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(std::string <span class="keyword">const</span> & sql, <span class="keywordtype">double</span> & tgt) <a name="l00734"></a>00734 { <a name="l00735"></a>00735 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql ).execute( tgt ); <a name="l00736"></a>00736 } <a name="l00737"></a>00737 <a name="l00738"></a><a class="code" href="classsq3_1_1database.html#a9ca1419e1bddff40a34bf28695cdc240">00738</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(<span class="keywordtype">char</span> <span class="keyword">const</span> * sql, std::string & tgt) <a name="l00739"></a>00739 { <a name="l00740"></a>00740 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql ).execute( tgt ); <a name="l00741"></a>00741 } <a name="l00742"></a>00742 <a name="l00743"></a><a class="code" href="classsq3_1_1database.html#aab4aac54b8c566ab303114c7275794cb">00743</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(std::string <span class="keyword">const</span> & sql, std::string & tgt) <a name="l00744"></a>00744 { <a name="l00745"></a>00745 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql ).execute( tgt ); <a name="l00746"></a>00746 } <a name="l00747"></a>00747 <a name="l00748"></a><a class="code" href="classsq3_1_1database.html#a72a0b07aaf834385214287ea9fd8c2e0">00748</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(<span class="keywordtype">char</span> <span class="keyword">const</span> * sql, <a class="code" href="namespacesq3.html#a033f4f2b2688f80675078447b55f831f" title="The published result codes from the sqlite3 API.">sqlite3_text_char_t</a> <span class="keyword">const</span> ** tgt, <span class="keywordtype">int</span> & len ) <a name="l00749"></a>00749 { <a name="l00750"></a>00750 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql ).execute( tgt, len ); <a name="l00751"></a>00751 } <a name="l00752"></a>00752 <a name="l00753"></a><a class="code" href="classsq3_1_1database.html#ab9c770b9d4bd6122ed4fa7e235469e58">00753</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(std::string <span class="keyword">const</span> & sql, <a class="code" href="namespacesq3.html#a033f4f2b2688f80675078447b55f831f" title="The published result codes from the sqlite3 API.">sqlite3_text_char_t</a> <span class="keyword">const</span> ** tgt, <span class="keywordtype">int</span> & len ) <a name="l00754"></a>00754 { <a name="l00755"></a>00755 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql ).execute( tgt, len ); <a name="l00756"></a>00756 } <a name="l00757"></a>00757 <a name="l00758"></a>00758 <span class="comment">// int database::execute(char const * sql, std::wstring & tgt);</span> <a name="l00759"></a>00759 <span class="comment">// int database::execute(std::string const & sql, std::wstring & tgt);</span> <a name="l00760"></a><a class="code" href="classsq3_1_1database.html#aea24bc15b9a2357746d2c170108e8bf6">00760</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(<span class="keywordtype">char</span> <span class="keyword">const</span> * sql, <span class="keywordtype">void</span> <span class="keyword">const</span> ** tgt, <span class="keywordtype">int</span> & len ) <a name="l00761"></a>00761 { <a name="l00762"></a>00762 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql ).execute( tgt, len ); <a name="l00763"></a>00763 } <a name="l00764"></a><a class="code" href="classsq3_1_1database.html#a2e569222ff4b565f14f94ae228731d06">00764</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>(std::string <span class="keyword">const</span> & sql, <span class="keywordtype">void</span> <span class="keyword">const</span> ** tgt, <span class="keywordtype">int</span> & len ) <a name="l00765"></a>00765 { <a name="l00766"></a>00766 <span class="keywordflow">return</span> <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a>( *<span class="keyword">this</span>, sql ).execute( tgt, len ); <a name="l00767"></a>00767 } <a name="l00768"></a>00768 <a name="l00769"></a><a class="code" href="classsq3_1_1database.html#a8f35d75e829113926eb015e011b51ad0">00769</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>( std::string <span class="keyword">const</span> & sql, sqlite3_callback callback, <span class="keywordtype">void</span> * data, std::string & errmsg ) <a name="l00770"></a>00770 { <a name="l00771"></a>00771 <span class="keywordflow">return</span> this-><a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">execute</a>( sql.c_str(), callback, data, errmsg ); <a name="l00772"></a>00772 } <a name="l00773"></a>00773 <a name="l00774"></a><a class="code" href="classsq3_1_1database.html#a64d2c72d998ccdf01fc90a97001ba078">00774</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>( <span class="keywordtype">char</span> <span class="keyword">const</span> * sql, sqlite3_callback callback, <span class="keywordtype">void</span> * data, std::string & errmsg ) <a name="l00775"></a>00775 { <a name="l00776"></a>00776 <span class="keywordtype">char</span> * cerrmsg = 0; <a name="l00777"></a>00777 <span class="keywordtype">int</span> ret = 0; <a name="l00778"></a>00778 <span class="keywordflow">try</span> <a name="l00779"></a>00779 { <a name="l00780"></a>00780 <span class="comment">// allow callback to safely throw.</span> <a name="l00781"></a>00781 ret = sqlite3_exec( this->m_dbh.<a class="code" href="classrefcount_1_1rcptr.html#a5b11a128adf4ce03c0c8be942cc8d672" title="Returns this object&#39;s underlying pointer, which may be 0.">get</a>(), sql, callback, data, &cerrmsg ); <a name="l00782"></a>00782 } <a name="l00783"></a>00783 <span class="keywordflow">catch</span>( ... ) <a name="l00784"></a>00784 { <a name="l00785"></a>00785 <span class="keywordflow">if</span>( cerrmsg ) <a name="l00786"></a>00786 { <a name="l00787"></a>00787 errmsg = cerrmsg; <a name="l00788"></a>00788 sqlite3_free( cerrmsg ); <a name="l00789"></a>00789 } <a name="l00790"></a>00790 <span class="keywordflow">throw</span>; <a name="l00791"></a>00791 } <a name="l00792"></a>00792 <span class="keywordflow">if</span>( cerrmsg ) <a name="l00793"></a>00793 { <a name="l00794"></a>00794 errmsg = cerrmsg; <a name="l00795"></a>00795 sqlite3_free( cerrmsg ); <a name="l00796"></a>00796 } <a name="l00797"></a>00797 <span class="keywordflow">return</span> ret; <a name="l00798"></a>00798 } <a name="l00799"></a>00799 <a name="l00800"></a><a class="code" href="classsq3_1_1database.html#a615e275daeda196a48f3f21cef19b6ff">00800</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>( std::string <span class="keyword">const</span> & sql, sqlite3_callback callback, <span class="keywordtype">void</span> * data ) <a name="l00801"></a>00801 { <a name="l00802"></a>00802 std::string ignored; <a name="l00803"></a>00803 <span class="keywordflow">return</span> this-><a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">execute</a>( sql, callback, data, ignored ); <a name="l00804"></a>00804 } <a name="l00805"></a>00805 <a name="l00806"></a><a class="code" href="classsq3_1_1database.html#a6a323641fd3d95787dddb1933c15be5a">00806</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">database::execute</a>( <span class="keywordtype">char</span> <span class="keyword">const</span> * sql, sqlite3_callback callback, <span class="keywordtype">void</span> * data ) <a name="l00807"></a>00807 { <a name="l00808"></a>00808 std::string s( sql ? sql : <span class="stringliteral">""</span> ); <a name="l00809"></a>00809 std::string ignored; <a name="l00810"></a>00810 <span class="keywordflow">return</span> this-><a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">execute</a>( s, callback, data, ignored ); <a name="l00811"></a>00811 } <a name="l00812"></a>00812 <a name="l00813"></a>00813 <a name="l00814"></a><a class="code" href="classsq3_1_1database.html#ac9fda7f2a5e13df8a1e7cce2ecb13279">00814</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#ac9fda7f2a5e13df8a1e7cce2ecb13279" title="This is a convenience wrapper for execute( &quot;pragma ...&quot; ).">database::pragma</a>( <span class="keywordtype">char</span> <span class="keyword">const</span> * code ) <a name="l00815"></a>00815 { <a name="l00816"></a>00816 std::ostringstream os; <a name="l00817"></a>00817 os << <span class="stringliteral">"pragma "</span> << code; <a name="l00818"></a>00818 std::string sql( os.str() ); <a name="l00819"></a>00819 <span class="keywordflow">return</span> this-><a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">execute</a>( sql.c_str() ); <a name="l00820"></a>00820 } <a name="l00821"></a>00821 <a name="l00822"></a><a class="code" href="classsq3_1_1database.html#a1cd1358658597f872f849691dafc12ed">00822</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#a1cd1358658597f872f849691dafc12ed" title="Convenience wrapper around execute(&quot;vacuum&quot;).">database::vacuum</a>() <a name="l00823"></a>00823 { <a name="l00824"></a>00824 <span class="keywordflow">return</span> this-><a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">execute</a>( <span class="stringliteral">"vacuum"</span> ); <a name="l00825"></a>00825 } <a name="l00826"></a>00826 <a name="l00827"></a><a class="code" href="classsq3_1_1database.html#abd2da1a48439fe0bcb4d2f1f1985c9c6">00827</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1database.html#abd2da1a48439fe0bcb4d2f1f1985c9c6" title="Looks through sqlite_master for a list of views, triggers, and tables, and drops...">database::clear</a>() <a name="l00828"></a>00828 { <a name="l00829"></a>00829 <span class="keywordflow">if</span>( ! this-><a class="code" href="classsq3_1_1database.html#af3b6b07c453a2ce5eaf9072e9cbe1f84" title="Returns true if this db is opened.">is_open</a>() ) <a name="l00830"></a>00830 { <a name="l00831"></a>00831 <span class="keywordflow">return</span> SQLITE_ERROR; <a name="l00832"></a>00832 } <a name="l00833"></a>00833 <span class="keywordtype">char</span> <span class="keyword">const</span> * parts[] = { <span class="stringliteral">"view"</span>, <span class="stringliteral">"trigger"</span>, <span class="stringliteral">"table"</span>, 0 }; <a name="l00834"></a>00834 std::string <a class="code" href="classsq3_1_1database.html#a70b7775e8ec6b930cd1df88c1d691d6a" title="Returns the name of the db file.">name</a>; <a name="l00835"></a>00835 <span class="keyword">typedef</span> std::vector<std::string> CmdList; <a name="l00836"></a>00836 CmdList list; <a name="l00837"></a>00837 <span class="keywordtype">int</span> rc = SQLITE_OK; <a name="l00838"></a>00838 <span class="keywordflow">for</span>( <span class="keywordtype">int</span> i = 0; i < 3; ++i ) <a name="l00839"></a>00839 { <a name="l00840"></a>00840 <a class="code" href="classsq3_1_1statement.html" title="This class represents a prepared database statement.">statement</a> master(*<span class="keyword">this</span>,<span class="stringliteral">"select name from sqlite_master where type=? and name not like 'sqlite_%'"</span>); <a name="l00841"></a>00841 rc = master.<a class="code" href="classsq3_1_1statement.html#a46f848c8167a24d86e79f8c76ab26e52" title="Binds NULL to the given placeholder index (1-based, not 0-based!).">bind</a>( 1, parts[i] ); <a name="l00842"></a>00842 <span class="keywordflow">if</span>( ! <a class="code" href="namespacesq3.html#a080ee04ba6c41a38c4d3efbb1ccb741d" title="rc_is_okay() is an easy way to check if rc is one of SQLITE_OK, SQLITE_ROW, or SQLITE_DONE...">rc_is_okay</a>(rc) ) <span class="keywordflow">return</span> rc; <a name="l00843"></a>00843 <a class="code" href="classsq3_1_1cursor.html" title="This type is for stepping through a db query result.">cursor</a> cur(master.<a class="code" href="classsq3_1_1statement.html#a0fddc7388f7713d15d4bfe8451ca5971" title="Returns a cursor object ready to step over the result set from this object.">get_cursor</a>()); <a name="l00844"></a>00844 <span class="keywordflow">while</span>( SQLITE_ROW == cur.step() ) <a name="l00845"></a>00845 { <a name="l00846"></a>00846 name = <span class="stringliteral">""</span>; <a name="l00847"></a>00847 rc = cur.get(0, name); <a name="l00848"></a>00848 <span class="keywordflow">if</span>( ! <a class="code" href="namespacesq3.html#a080ee04ba6c41a38c4d3efbb1ccb741d" title="rc_is_okay() is an easy way to check if rc is one of SQLITE_OK, SQLITE_ROW, or SQLITE_DONE...">rc_is_okay</a>(rc) ) <span class="keywordflow">return</span> rc; <a name="l00849"></a>00849 list.push_back( std::string(<span class="stringliteral">"drop "</span>) + parts[i] + <span class="stringliteral">"'"</span> + name + <span class="stringliteral">"'"</span> ); <a name="l00850"></a>00850 } <a name="l00851"></a>00851 } <a name="l00852"></a>00852 CmdList::const_iterator it = list.begin(); <a name="l00853"></a>00853 CmdList::const_iterator et = list.end(); <a name="l00854"></a>00854 <span class="keywordflow">for</span>( ; et != it; ++it ) <a name="l00855"></a>00855 { <a name="l00856"></a>00856 std::string cmd = *it; <a name="l00857"></a>00857 rc = this-><a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">execute</a>( cmd ); <a name="l00858"></a>00858 } <a name="l00859"></a>00859 <span class="keywordflow">return</span> rc; <a name="l00860"></a>00860 } <a name="l00861"></a>00861 <a name="l00862"></a>00862 <a name="l00863"></a>00863 <a name="l00864"></a>00864 <a name="l00865"></a>00865 <a name="l00866"></a>00866 <a name="l00867"></a>00867 <a name="l00868"></a>00868 <a name="l00869"></a>00869 <a name="l00870"></a><a class="code" href="classsq3_1_1transaction.html#a1a461bcb8b02d1cf3bb4d6cc4598d369">00870</a> transaction::transaction( <a class="code" href="classsq3_1_1database.html" title="Encapsulates a connection to an sqlite database.">database</a> & db, <span class="keywordtype">bool</span> start ) <a name="l00871"></a>00871 : m_db(db), m_intrans(false) <a name="l00872"></a>00872 { <a name="l00873"></a>00873 <span class="keywordflow">if</span>( start ) this-><a class="code" href="classsq3_1_1transaction.html#a7c2086d6e48f39b27f006a2c1cb5fae0" title="Starts the transaction.">begin</a>(); <a name="l00874"></a>00874 } <a name="l00875"></a>00875 <a name="l00876"></a><a class="code" href="classsq3_1_1transaction.html#aba444c389b8f7758edac498d194b1aeb">00876</a> <a class="code" href="classsq3_1_1transaction.html#aba444c389b8f7758edac498d194b1aeb" title="Calls this-&gt;rollback().">transaction::~transaction</a>() <a name="l00877"></a>00877 { <a name="l00878"></a>00878 this-><a class="code" href="classsq3_1_1transaction.html#aef819599c00a3a780ea565671155747d" title="Initiates a rollback and returns the result of executing a rollback command.">rollback</a>(); <a name="l00879"></a>00879 } <a name="l00880"></a>00880 <a name="l00881"></a><a class="code" href="classsq3_1_1transaction.html#a7c2086d6e48f39b27f006a2c1cb5fae0">00881</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1transaction.html#a7c2086d6e48f39b27f006a2c1cb5fae0" title="Starts the transaction.">transaction::begin</a>() <a name="l00882"></a>00882 { <a name="l00883"></a>00883 <span class="keywordflow">if</span>( this->m_intrans ) <a name="l00884"></a>00884 { <a name="l00885"></a>00885 <span class="keywordflow">return</span> SQLITE_ERROR; <a name="l00886"></a>00886 } <a name="l00887"></a>00887 <span class="keywordtype">int</span> rc = this->m_db.<a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">execute</a>(<span class="stringliteral">"begin"</span>); <a name="l00888"></a>00888 this->m_intrans = (SQLITE_DONE == rc) || (SQLITE_OK == rc); <a name="l00889"></a>00889 <span class="keywordflow">return</span> rc; <a name="l00890"></a>00890 } <a name="l00891"></a>00891 <a name="l00892"></a><a class="code" href="classsq3_1_1transaction.html#a7508951fb31172fc90e5d5170a640332">00892</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1transaction.html#a7508951fb31172fc90e5d5170a640332" title="Commits the active transaction.">transaction::commit</a>() <a name="l00893"></a>00893 { <a name="l00894"></a>00894 <span class="keywordflow">if</span>( ! this->m_intrans ) <a name="l00895"></a>00895 { <a name="l00896"></a>00896 <span class="keywordflow">return</span> SQLITE_ERROR; <a name="l00897"></a>00897 } <a name="l00898"></a>00898 <span class="keywordtype">int</span> rc = this->m_db.<a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">execute</a>(<span class="stringliteral">"commit"</span>); <a name="l00899"></a>00899 <span class="keywordflow">if</span>( SQLITE_BUSY != rc ) <a name="l00900"></a>00900 { <a name="l00901"></a>00901 <span class="comment">// According to the sqlite3 docs, if a COMMIT fails with BUSY</span> <a name="l00902"></a>00902 <span class="comment">// then the transaction is still open.</span> <a name="l00903"></a>00903 this->m_intrans = <span class="keyword">false</span>; <a name="l00904"></a>00904 } <a name="l00905"></a>00905 <span class="keywordflow">return</span> rc; <a name="l00906"></a>00906 } <a name="l00907"></a><a class="code" href="classsq3_1_1transaction.html#aef819599c00a3a780ea565671155747d">00907</a> <span class="keywordtype">int</span> <a class="code" href="classsq3_1_1transaction.html#aef819599c00a3a780ea565671155747d" title="Initiates a rollback and returns the result of executing a rollback command.">transaction::rollback</a>() <a name="l00908"></a>00908 { <a name="l00909"></a>00909 <span class="keywordflow">if</span>( ! this->m_intrans ) <a name="l00910"></a>00910 { <a name="l00911"></a>00911 <span class="keywordflow">return</span> SQLITE_ERROR; <a name="l00912"></a>00912 } <a name="l00913"></a>00913 this->m_intrans = <span class="keyword">false</span>; <a name="l00914"></a>00914 <span class="keywordflow">return</span> this->m_db.<a class="code" href="classsq3_1_1database.html#a65d5e801060b1dad34d539b191305130" title="Functionally identical to execute(char const *).">execute</a>(<span class="stringliteral">"rollback"</span>); <a name="l00915"></a>00915 } <a name="l00916"></a>00916 <a name="l00917"></a>00917 <span class="keywordtype">int</span> cursor::index_colnames() <a name="l00918"></a>00918 { <a name="l00919"></a>00919 <span class="keywordflow">if</span>( ! this->m_cn ) <a name="l00920"></a>00920 { <a name="l00921"></a>00921 this->m_cn = <span class="keyword">new</span> NameToIndexMap; <a name="l00922"></a>00922 } <a name="l00923"></a>00923 <span class="keywordflow">else</span> <a name="l00924"></a>00924 <span class="keywordflow">if</span>( ! this->m_cn->empty() ) <a name="l00925"></a>00925 { <a name="l00926"></a>00926 <span class="comment">// We're using a cached result</span> <a name="l00927"></a>00927 <span class="keywordflow">return</span> -1; <a name="l00928"></a>00928 } <a name="l00929"></a>00929 <span class="keywordtype">char</span> <span class="keyword">const</span> * cname; <a name="l00930"></a>00930 <span class="keywordtype">int</span> cc = this-><a class="code" href="classsq3_1_1cursor.html#ab43f9599d49c13195e78e49943d6157f" title="Returns the column count of the underlying prepared statement.">colcount</a>(); <a name="l00931"></a>00931 <span class="keywordtype">int</span> pos = 0; <a name="l00932"></a>00932 <span class="keywordflow">for</span>( <span class="keywordtype">int</span> i = 0; i < cc; ++i, ++pos ) <a name="l00933"></a>00933 { <a name="l00934"></a>00934 cname = 0; <a name="l00935"></a>00935 <span class="keywordflow">if</span>( SQLITE_OK != this-><a class="code" href="classsq3_1_1cursor.html#afb920de1da87ee657a29fa7165ba4859" title="Sets str to the column name as the given index (0-based).">colname</a>( i, &cname ) ) <a name="l00936"></a>00936 <span class="comment">//if( ! (cname = this->m_stmt->colname( i ) ) )</span> <a name="l00937"></a>00937 { <a name="l00938"></a>00938 <span class="keywordflow">break</span>; <a name="l00939"></a>00939 } <a name="l00940"></a>00940 (*this->m_cn)[std::string(cname ? cname : <span class="stringliteral">""</span>)] = i; <a name="l00941"></a>00941 } <a name="l00942"></a>00942 <span class="keywordflow">return</span> pos; <a name="l00943"></a>00943 } <a name="l00944"></a>00944 <a name="l00945"></a>00945 <a name="l00946"></a>00946 } <span class="comment">// namespace</span> </pre></div></div> <hr class="footer"/><address style="text-align: right;"><small>Generated by <a href="http://www.doxygen.org/index.html"> <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.2-20100208 </small></address> </body> </html>