class_easy_qt_sql_1_1_database.htm 43 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
  5. <meta http-equiv="X-UA-Compatible" content="IE=9"/>
  6. <meta name="generator" content="Doxygen 1.8.14"/>
  7. <meta name="viewport" content="width=device-width, initial-scale=1"/>
  8. <title>EasyQtSql: EasyQtSql::Database Class Reference</title>
  9. <link href="tabs.css" rel="stylesheet" type="text/css"/>
  10. <script type="text/javascript" src="jquery.js"></script>
  11. <script type="text/javascript" src="dynsections.js"></script>
  12. <link href="navtree.css" rel="stylesheet" type="text/css"/>
  13. <script type="text/javascript" src="resize.js"></script>
  14. <script type="text/javascript" src="navtreedata.js"></script>
  15. <script type="text/javascript" src="navtree.js"></script>
  16. <script type="text/javascript">
  17. /* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
  18. $(document).ready(initResizable);
  19. /* @license-end */</script>
  20. <link href="search/search.css" rel="stylesheet" type="text/css"/>
  21. <script type="text/javascript" src="search/searchdata.js"></script>
  22. <script type="text/javascript" src="search/search.js"></script>
  23. <link href="doxygen.css" rel="stylesheet" type="text/css" />
  24. </head>
  25. <body>
  26. <div id="top"><!-- do not remove this div, it is closed by doxygen! -->
  27. <div id="titlearea">
  28. <table cellspacing="0" cellpadding="0">
  29. <tbody>
  30. <tr style="height: 56px;">
  31. <td id="projectalign" style="padding-left: 0.5em;">
  32. <div id="projectname">EasyQtSql
  33. </div>
  34. <div id="projectbrief">Easy SQL data access helper for QtSql</div>
  35. </td>
  36. </tr>
  37. </tbody>
  38. </table>
  39. </div>
  40. <!-- end header part -->
  41. <!-- Generated by Doxygen 1.8.14 -->
  42. <script type="text/javascript">
  43. /* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
  44. var searchBox = new SearchBox("searchBox", "search",false,'Search');
  45. /* @license-end */
  46. </script>
  47. <script type="text/javascript" src="menudata.js"></script>
  48. <script type="text/javascript" src="menu.js"></script>
  49. <script type="text/javascript">
  50. /* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
  51. $(function() {
  52. initMenu('',true,false,'search.php','Search');
  53. $(document).ready(function() { init_search(); });
  54. });
  55. /* @license-end */</script>
  56. <div id="main-nav"></div>
  57. </div><!-- top -->
  58. <div id="side-nav" class="ui-resizable side-nav-resizable">
  59. <div id="nav-tree">
  60. <div id="nav-tree-contents">
  61. <div id="nav-sync" class="sync"></div>
  62. </div>
  63. </div>
  64. <div id="splitbar" style="-moz-user-select:none;"
  65. class="ui-resizable-handle">
  66. </div>
  67. </div>
  68. <script type="text/javascript">
  69. /* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
  70. $(document).ready(function(){initNavTree('class_easy_qt_sql_1_1_database.htm','');});
  71. /* @license-end */
  72. </script>
  73. <div id="doc-content">
  74. <!-- window showing the filter options -->
  75. <div id="MSearchSelectWindow"
  76. onmouseover="return searchBox.OnSearchSelectShow()"
  77. onmouseout="return searchBox.OnSearchSelectHide()"
  78. onkeydown="return searchBox.OnSearchSelectKey(event)">
  79. </div>
  80. <!-- iframe showing the search results (closed by default) -->
  81. <div id="MSearchResultsWindow">
  82. <iframe src="javascript:void(0)" frameborder="0"
  83. name="MSearchResults" id="MSearchResults">
  84. </iframe>
  85. </div>
  86. <div class="header">
  87. <div class="summary">
  88. <a href="#pub-methods">Public Member Functions</a> &#124;
  89. <a href="#pro-attribs">Protected Attributes</a> &#124;
  90. <a href="class_easy_qt_sql_1_1_database-members.htm">List of all members</a> </div>
  91. <div class="headertitle">
  92. <div class="title">EasyQtSql::Database Class Reference</div> </div>
  93. </div><!--header-->
  94. <div class="contents">
  95. <p>QSqlDatabase wrapper.
  96. <a href="class_easy_qt_sql_1_1_database.htm#details">More...</a></p>
  97. <p><code>#include &lt;<a class="el" href="_easy_qt_sql_8h_source.htm">EasyQtSql.h</a>&gt;</code></p>
  98. <div class="dynheader">
  99. Inheritance diagram for EasyQtSql::Database:</div>
  100. <div class="dyncontent">
  101. <div class="center">
  102. <img src="class_easy_qt_sql_1_1_database.png" usemap="#EasyQtSql::Database_map" alt=""/>
  103. <map id="EasyQtSql::Database_map" name="EasyQtSql::Database_map">
  104. <area href="class_easy_qt_sql_1_1_transaction.htm" title="QSqlDatabase transaction wrapper. " alt="EasyQtSql::Transaction" shape="rect" coords="0,56,142,80"/>
  105. </map>
  106. </div></div>
  107. <table class="memberdecls">
  108. <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-methods"></a>
  109. Public Member Functions</h2></td></tr>
  110. <tr class="memitem:a456e50298d0dd2bb89ddbadee7bf2da5"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#a456e50298d0dd2bb89ddbadee7bf2da5">Database</a> (const QSqlDatabase &amp;db=QSqlDatabase())</td></tr>
  111. <tr class="separator:a456e50298d0dd2bb89ddbadee7bf2da5"><td class="memSeparator" colspan="2">&#160;</td></tr>
  112. <tr class="memitem:a4ba16ffeda09410df95720f2f7e9d872"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#a4ba16ffeda09410df95720f2f7e9d872">Database</a> (<a class="el" href="class_easy_qt_sql_1_1_database.htm">Database</a> &amp;&amp;other)</td></tr>
  113. <tr class="separator:a4ba16ffeda09410df95720f2f7e9d872"><td class="memSeparator" colspan="2">&#160;</td></tr>
  114. <tr class="memitem:a00ada326c3f4b3b01be26c552ad665dc"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_easy_qt_sql_1_1_database.htm">Database</a> &amp;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#a00ada326c3f4b3b01be26c552ad665dc">operator=</a> (<a class="el" href="class_easy_qt_sql_1_1_database.htm">Database</a> &amp;&amp;other)</td></tr>
  115. <tr class="separator:a00ada326c3f4b3b01be26c552ad665dc"><td class="memSeparator" colspan="2">&#160;</td></tr>
  116. <tr class="memitem:a55fa6c1582cdd3dd6981f53e61dce6b4"><td class="memItemLeft" align="right" valign="top">QSqlError&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#a55fa6c1582cdd3dd6981f53e61dce6b4">lastError</a> () const</td></tr>
  117. <tr class="memdesc:a55fa6c1582cdd3dd6981f53e61dce6b4"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns information about the last error that occurred on the underlying database. <a href="#a55fa6c1582cdd3dd6981f53e61dce6b4">More...</a><br /></td></tr>
  118. <tr class="separator:a55fa6c1582cdd3dd6981f53e61dce6b4"><td class="memSeparator" colspan="2">&#160;</td></tr>
  119. <tr class="memitem:abd563e304bb79860237c218b8bc10acd"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_easy_qt_sql_1_1_non_query_result.htm">NonQueryResult</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#abd563e304bb79860237c218b8bc10acd">execNonQuery</a> (const QString &amp;sql) const</td></tr>
  120. <tr class="memdesc:abd563e304bb79860237c218b8bc10acd"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes non-query SQL statement (DELETE, INSERT, UPDATE, CREATE, ALTER, etc.) <a href="#abd563e304bb79860237c218b8bc10acd">More...</a><br /></td></tr>
  121. <tr class="separator:abd563e304bb79860237c218b8bc10acd"><td class="memSeparator" colspan="2">&#160;</td></tr>
  122. <tr class="memitem:a5ae51f8e281cc1b41d7d48b7ca659b33"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_easy_qt_sql_1_1_query_result.htm">QueryResult</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#a5ae51f8e281cc1b41d7d48b7ca659b33">execQuery</a> (const QString &amp;sql) const</td></tr>
  123. <tr class="memdesc:a5ae51f8e281cc1b41d7d48b7ca659b33"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes SELECT query. <a href="#a5ae51f8e281cc1b41d7d48b7ca659b33">More...</a><br /></td></tr>
  124. <tr class="separator:a5ae51f8e281cc1b41d7d48b7ca659b33"><td class="memSeparator" colspan="2">&#160;</td></tr>
  125. <tr class="memitem:a8fc62bc8b97ae861420068e2d1dcff8a"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_easy_qt_sql_1_1_insert_query.htm">InsertQuery</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#a8fc62bc8b97ae861420068e2d1dcff8a">insertInto</a> (const QString &amp;table) const</td></tr>
  126. <tr class="memdesc:a8fc62bc8b97ae861420068e2d1dcff8a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates INSERT query wrapper. <a href="#a8fc62bc8b97ae861420068e2d1dcff8a">More...</a><br /></td></tr>
  127. <tr class="separator:a8fc62bc8b97ae861420068e2d1dcff8a"><td class="memSeparator" colspan="2">&#160;</td></tr>
  128. <tr class="memitem:a0da534e09d06f26d517c2acd41446a80"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_easy_qt_sql_1_1_delete_query.htm">DeleteQuery</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#a0da534e09d06f26d517c2acd41446a80">deleteFrom</a> (const QString &amp;table) const</td></tr>
  129. <tr class="memdesc:a0da534e09d06f26d517c2acd41446a80"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates DELETE query wrapper. <a href="#a0da534e09d06f26d517c2acd41446a80">More...</a><br /></td></tr>
  130. <tr class="separator:a0da534e09d06f26d517c2acd41446a80"><td class="memSeparator" colspan="2">&#160;</td></tr>
  131. <tr class="memitem:ad99ec8b68e916201dce33cda5018be67"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_easy_qt_sql_1_1_update_query.htm">UpdateQuery</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#ad99ec8b68e916201dce33cda5018be67">update</a> (const QString &amp;table) const</td></tr>
  132. <tr class="memdesc:ad99ec8b68e916201dce33cda5018be67"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates UPDATE query wrapper. <a href="#ad99ec8b68e916201dce33cda5018be67">More...</a><br /></td></tr>
  133. <tr class="separator:ad99ec8b68e916201dce33cda5018be67"><td class="memSeparator" colspan="2">&#160;</td></tr>
  134. <tr class="memitem:af87d995c4cf5eaf4870befe2f973487d"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_easy_qt_sql_1_1_prepared_query.htm">PreparedQuery</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#af87d995c4cf5eaf4870befe2f973487d">prepare</a> (const QString &amp;sql, bool forwardOnly=true) const</td></tr>
  135. <tr class="memdesc:af87d995c4cf5eaf4870befe2f973487d"><td class="mdescLeft">&#160;</td><td class="mdescRight">Prepares SQL statement. <a href="#af87d995c4cf5eaf4870befe2f973487d">More...</a><br /></td></tr>
  136. <tr class="separator:af87d995c4cf5eaf4870befe2f973487d"><td class="memSeparator" colspan="2">&#160;</td></tr>
  137. <tr class="memitem:ad4a237ca6acca4068b005d843e1551bb"><td class="memItemLeft" align="right" valign="top">QSqlDatabase &amp;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#ad4a237ca6acca4068b005d843e1551bb">qSqlDatabase</a> ()</td></tr>
  138. <tr class="memdesc:ad4a237ca6acca4068b005d843e1551bb"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns a reference to the wrapped QSqlDatabase object. <a href="#ad4a237ca6acca4068b005d843e1551bb">More...</a><br /></td></tr>
  139. <tr class="separator:ad4a237ca6acca4068b005d843e1551bb"><td class="memSeparator" colspan="2">&#160;</td></tr>
  140. <tr class="memitem:aa14b9309738dd427f7060a88ae193beb"><td class="memTemplParams" colspan="2">template&lt;typename Func &gt; </td></tr>
  141. <tr class="memitem:aa14b9309738dd427f7060a88ae193beb"><td class="memTemplItemLeft" align="right" valign="top">int&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#aa14b9309738dd427f7060a88ae193beb">each</a> (const QString &amp;query, Func &amp;&amp;f) const</td></tr>
  142. <tr class="memdesc:aa14b9309738dd427f7060a88ae193beb"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes <em>query</em> and applies function <em>f</em> to each result row. <a href="#aa14b9309738dd427f7060a88ae193beb">More...</a><br /></td></tr>
  143. <tr class="separator:aa14b9309738dd427f7060a88ae193beb"><td class="memSeparator" colspan="2">&#160;</td></tr>
  144. <tr class="memitem:a7165d67d4fdfa07b3d9700d5ed5c6a63"><td class="memTemplParams" colspan="2">template&lt;typename Func &gt; </td></tr>
  145. <tr class="memitem:a7165d67d4fdfa07b3d9700d5ed5c6a63"><td class="memTemplItemLeft" align="right" valign="top">int&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#a7165d67d4fdfa07b3d9700d5ed5c6a63">first</a> (const QString &amp;query, Func &amp;&amp;f) const</td></tr>
  146. <tr class="memdesc:a7165d67d4fdfa07b3d9700d5ed5c6a63"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes <em>query</em> and applies function <em>f</em> to the first result row. <a href="#a7165d67d4fdfa07b3d9700d5ed5c6a63">More...</a><br /></td></tr>
  147. <tr class="separator:a7165d67d4fdfa07b3d9700d5ed5c6a63"><td class="memSeparator" colspan="2">&#160;</td></tr>
  148. <tr class="memitem:a1832537434940c8334fe0ca012bee8dd"><td class="memTemplParams" colspan="2">template&lt;typename Func &gt; </td></tr>
  149. <tr class="memitem:a1832537434940c8334fe0ca012bee8dd"><td class="memTemplItemLeft" align="right" valign="top">int&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#a1832537434940c8334fe0ca012bee8dd">range</a> (const QString &amp;query, int start, int count, Func &amp;&amp;f) const</td></tr>
  150. <tr class="memdesc:a1832537434940c8334fe0ca012bee8dd"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes <em>query</em> and applies function <em>f</em> to <em>count</em> result rows starting from index <em>start</em>. <a href="#a1832537434940c8334fe0ca012bee8dd">More...</a><br /></td></tr>
  151. <tr class="separator:a1832537434940c8334fe0ca012bee8dd"><td class="memSeparator" colspan="2">&#160;</td></tr>
  152. <tr class="memitem:a2f66f508f3cc25d0512d841f938adfb4"><td class="memTemplParams" colspan="2">template&lt;typename Func &gt; </td></tr>
  153. <tr class="memitem:a2f66f508f3cc25d0512d841f938adfb4"><td class="memTemplItemLeft" align="right" valign="top">int&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#a2f66f508f3cc25d0512d841f938adfb4">top</a> (const QString &amp;query, int topCount, Func &amp;&amp;f) const</td></tr>
  154. <tr class="memdesc:a2f66f508f3cc25d0512d841f938adfb4"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes <em>query</em> and applies function <em>f</em> to <em>topCount</em> result rows. <a href="#a2f66f508f3cc25d0512d841f938adfb4">More...</a><br /></td></tr>
  155. <tr class="separator:a2f66f508f3cc25d0512d841f938adfb4"><td class="memSeparator" colspan="2">&#160;</td></tr>
  156. <tr class="memitem:abada64f2593dd9524199f570d9387296"><td class="memTemplParams" colspan="2">template&lt;typename T &gt; </td></tr>
  157. <tr class="memitem:abada64f2593dd9524199f570d9387296"><td class="memTemplItemLeft" align="right" valign="top">T&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#abada64f2593dd9524199f570d9387296">scalar</a> (const QString &amp;query) const</td></tr>
  158. <tr class="memdesc:abada64f2593dd9524199f570d9387296"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes <em>query</em> and returns scalar value converted to T. <a href="#abada64f2593dd9524199f570d9387296">More...</a><br /></td></tr>
  159. <tr class="separator:abada64f2593dd9524199f570d9387296"><td class="memSeparator" colspan="2">&#160;</td></tr>
  160. <tr class="memitem:aa06ecb239cde85058a7ed828e06906b7"><td class="memItemLeft" align="right" valign="top">QVariant&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#aa06ecb239cde85058a7ed828e06906b7">scalar</a> (const QString &amp;query) const</td></tr>
  161. <tr class="memdesc:aa06ecb239cde85058a7ed828e06906b7"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes <em>query</em> and returns scalar value. <a href="#aa06ecb239cde85058a7ed828e06906b7">More...</a><br /></td></tr>
  162. <tr class="separator:aa06ecb239cde85058a7ed828e06906b7"><td class="memSeparator" colspan="2">&#160;</td></tr>
  163. </table><table class="memberdecls">
  164. <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pro-attribs"></a>
  165. Protected Attributes</h2></td></tr>
  166. <tr class="memitem:af1da52105a07c38f77aad58df9792181"><td class="memItemLeft" align="right" valign="top">QSqlDatabase&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_easy_qt_sql_1_1_database.htm#af1da52105a07c38f77aad58df9792181">m_db</a></td></tr>
  167. <tr class="separator:af1da52105a07c38f77aad58df9792181"><td class="memSeparator" colspan="2">&#160;</td></tr>
  168. </table>
  169. <a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
  170. <div class="textblock"><p>QSqlDatabase wrapper. </p>
  171. <div class="fragment"><div class="line"><span class="keywordtype">void</span> test()</div><div class="line">{</div><div class="line"> QSqlDatabase db = QSqlDatabase::addDatabase(<span class="stringliteral">&quot;QSQLITE&quot;</span>);</div><div class="line"> db.setDatabaseName(<span class="stringliteral">&quot;:memory:&quot;</span>);</div><div class="line"></div><div class="line"> <span class="keywordflow">try</span></div><div class="line"> {</div><div class="line"> <a class="code" href="class_database.htm">Database</a> sdb(db);</div><div class="line"></div><div class="line"> sdb.execNonQuery(<span class="stringliteral">&quot;CREATE TABLE table (a int, b int, c int, d text)&quot;</span>);</div><div class="line"> }</div><div class="line"> <span class="keywordflow">catch</span> (<span class="keyword">const</span> <a class="code" href="class_d_b_exception.htm">DBException</a> &amp;e)</div><div class="line"> {</div><div class="line"> <span class="comment">//you can handle all the errors at one point</span></div><div class="line"></div><div class="line"> qDebug() &lt;&lt; e.<a class="code" href="class_d_b_exception.htm#adf142ded3fb236826a5a6ba4a606e584">lastError</a> &lt;&lt; e.<a class="code" href="class_d_b_exception.htm#a3ec8b4b593abee155554472ae0b58f12">lastQuery</a>;</div><div class="line"> }</div><div class="line">}</div></div><!-- fragment --> </div><h2 class="groupheader">Constructor &amp; Destructor Documentation</h2>
  172. <a id="a456e50298d0dd2bb89ddbadee7bf2da5"></a>
  173. <h2 class="memtitle"><span class="permalink"><a href="#a456e50298d0dd2bb89ddbadee7bf2da5">&#9670;&nbsp;</a></span>Database() <span class="overload">[1/2]</span></h2>
  174. <div class="memitem">
  175. <div class="memproto">
  176. <table class="mlabels">
  177. <tr>
  178. <td class="mlabels-left">
  179. <table class="memname">
  180. <tr>
  181. <td class="memname">EasyQtSql::Database::Database </td>
  182. <td>(</td>
  183. <td class="paramtype">const QSqlDatabase &amp;&#160;</td>
  184. <td class="paramname"><em>db</em> = <code>QSqlDatabase()</code></td><td>)</td>
  185. <td></td>
  186. </tr>
  187. </table>
  188. </td>
  189. <td class="mlabels-right">
  190. <span class="mlabels"><span class="mlabel">inline</span><span class="mlabel">explicit</span></span> </td>
  191. </tr>
  192. </table>
  193. </div><div class="memdoc">
  194. <dl class="params"><dt>Parameters</dt><dd>
  195. <table class="params">
  196. <tr><td class="paramname">db</td><td>QSqlDatabase to use</td></tr>
  197. </table>
  198. </dd>
  199. </dl>
  200. <p>Creates an <a class="el" href="class_easy_qt_sql_1_1_database.htm" title="QSqlDatabase wrapper. ">Database</a> object, tries to open <em>db</em> connection if not opened.</p>
  201. <dl class="exception"><dt>Exceptions</dt><dd>
  202. <table class="exception">
  203. <tr><td class="paramname"><a class="el" href="class_easy_qt_sql_1_1_d_b_exception.htm" title="Exception class for SQL errors handling. ">DBException</a></td><td></td></tr>
  204. </table>
  205. </dd>
  206. </dl>
  207. </div>
  208. </div>
  209. <a id="a4ba16ffeda09410df95720f2f7e9d872"></a>
  210. <h2 class="memtitle"><span class="permalink"><a href="#a4ba16ffeda09410df95720f2f7e9d872">&#9670;&nbsp;</a></span>Database() <span class="overload">[2/2]</span></h2>
  211. <div class="memitem">
  212. <div class="memproto">
  213. <table class="mlabels">
  214. <tr>
  215. <td class="mlabels-left">
  216. <table class="memname">
  217. <tr>
  218. <td class="memname">EasyQtSql::Database::Database </td>
  219. <td>(</td>
  220. <td class="paramtype"><a class="el" href="class_easy_qt_sql_1_1_database.htm">Database</a> &amp;&amp;&#160;</td>
  221. <td class="paramname"><em>other</em></td><td>)</td>
  222. <td></td>
  223. </tr>
  224. </table>
  225. </td>
  226. <td class="mlabels-right">
  227. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  228. </tr>
  229. </table>
  230. </div><div class="memdoc">
  231. </div>
  232. </div>
  233. <h2 class="groupheader">Member Function Documentation</h2>
  234. <a id="a0da534e09d06f26d517c2acd41446a80"></a>
  235. <h2 class="memtitle"><span class="permalink"><a href="#a0da534e09d06f26d517c2acd41446a80">&#9670;&nbsp;</a></span>deleteFrom()</h2>
  236. <div class="memitem">
  237. <div class="memproto">
  238. <table class="mlabels">
  239. <tr>
  240. <td class="mlabels-left">
  241. <table class="memname">
  242. <tr>
  243. <td class="memname"><a class="el" href="class_easy_qt_sql_1_1_delete_query.htm">DeleteQuery</a> EasyQtSql::Database::deleteFrom </td>
  244. <td>(</td>
  245. <td class="paramtype">const QString &amp;&#160;</td>
  246. <td class="paramname"><em>table</em></td><td>)</td>
  247. <td> const</td>
  248. </tr>
  249. </table>
  250. </td>
  251. <td class="mlabels-right">
  252. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  253. </tr>
  254. </table>
  255. </div><div class="memdoc">
  256. <p>Creates DELETE query wrapper. </p>
  257. <dl class="params"><dt>Parameters</dt><dd>
  258. <table class="params">
  259. <tr><td class="paramname">table</td><td>Table to delete from </td></tr>
  260. </table>
  261. </dd>
  262. </dl>
  263. </div>
  264. </div>
  265. <a id="aa14b9309738dd427f7060a88ae193beb"></a>
  266. <h2 class="memtitle"><span class="permalink"><a href="#aa14b9309738dd427f7060a88ae193beb">&#9670;&nbsp;</a></span>each()</h2>
  267. <div class="memitem">
  268. <div class="memproto">
  269. <div class="memtemplate">
  270. template&lt;typename Func &gt; </div>
  271. <table class="mlabels">
  272. <tr>
  273. <td class="mlabels-left">
  274. <table class="memname">
  275. <tr>
  276. <td class="memname">int EasyQtSql::Database::each </td>
  277. <td>(</td>
  278. <td class="paramtype">const QString &amp;&#160;</td>
  279. <td class="paramname"><em>query</em>, </td>
  280. </tr>
  281. <tr>
  282. <td class="paramkey"></td>
  283. <td></td>
  284. <td class="paramtype">Func &amp;&amp;&#160;</td>
  285. <td class="paramname"><em>f</em>&#160;</td>
  286. </tr>
  287. <tr>
  288. <td></td>
  289. <td>)</td>
  290. <td></td><td> const</td>
  291. </tr>
  292. </table>
  293. </td>
  294. <td class="mlabels-right">
  295. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  296. </tr>
  297. </table>
  298. </div><div class="memdoc">
  299. <p>Executes <em>query</em> and applies function <em>f</em> to each result row. </p>
  300. <dl class="params"><dt>Parameters</dt><dd>
  301. <table class="params">
  302. <tr><td class="paramname">query</td><td>SQL query string (SELECT statement) </td></tr>
  303. <tr><td class="paramname">f</td><td>Function (lambda) to apply to </td></tr>
  304. </table>
  305. </dd>
  306. </dl>
  307. <dl class="section return"><dt>Returns</dt><dd>num rows handled with function <em>f</em></dd></dl>
  308. <div class="fragment"><div class="line"><a class="code" href="class_database.htm">Database</a> db;</div><div class="line">db.<a class="code" href="class_database.htm#a7a13f4fc603fb829f123894d9abd6ea7">each</a>(<span class="stringliteral">&quot;SELECT * FROM table&quot;</span>, [](<span class="keyword">const</span> <a class="code" href="class_query_result.htm">QueryResult</a> &amp;res)</div><div class="line">{</div><div class="line"> qDebug() &lt;&lt; res.<a class="code" href="class_query_result.htm#a023bd84f7010368d616d7dbb1b399a06">toMap</a>();</div><div class="line">});</div></div><!-- fragment -->
  309. </div>
  310. </div>
  311. <a id="abd563e304bb79860237c218b8bc10acd"></a>
  312. <h2 class="memtitle"><span class="permalink"><a href="#abd563e304bb79860237c218b8bc10acd">&#9670;&nbsp;</a></span>execNonQuery()</h2>
  313. <div class="memitem">
  314. <div class="memproto">
  315. <table class="mlabels">
  316. <tr>
  317. <td class="mlabels-left">
  318. <table class="memname">
  319. <tr>
  320. <td class="memname"><a class="el" href="class_easy_qt_sql_1_1_non_query_result.htm">NonQueryResult</a> EasyQtSql::Database::execNonQuery </td>
  321. <td>(</td>
  322. <td class="paramtype">const QString &amp;&#160;</td>
  323. <td class="paramname"><em>sql</em></td><td>)</td>
  324. <td> const</td>
  325. </tr>
  326. </table>
  327. </td>
  328. <td class="mlabels-right">
  329. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  330. </tr>
  331. </table>
  332. </div><div class="memdoc">
  333. <p>Executes non-query SQL statement (DELETE, INSERT, UPDATE, CREATE, ALTER, etc.) </p>
  334. <dl class="params"><dt>Parameters</dt><dd>
  335. <table class="params">
  336. <tr><td class="paramname">query</td><td>SQL statement string </td></tr>
  337. </table>
  338. </dd>
  339. </dl>
  340. <dl class="exception"><dt>Exceptions</dt><dd>
  341. <table class="exception">
  342. <tr><td class="paramname"><a class="el" href="class_easy_qt_sql_1_1_d_b_exception.htm" title="Exception class for SQL errors handling. ">DBException</a></td><td></td></tr>
  343. </table>
  344. </dd>
  345. </dl>
  346. </div>
  347. </div>
  348. <a id="a5ae51f8e281cc1b41d7d48b7ca659b33"></a>
  349. <h2 class="memtitle"><span class="permalink"><a href="#a5ae51f8e281cc1b41d7d48b7ca659b33">&#9670;&nbsp;</a></span>execQuery()</h2>
  350. <div class="memitem">
  351. <div class="memproto">
  352. <table class="mlabels">
  353. <tr>
  354. <td class="mlabels-left">
  355. <table class="memname">
  356. <tr>
  357. <td class="memname"><a class="el" href="class_easy_qt_sql_1_1_query_result.htm">QueryResult</a> EasyQtSql::Database::execQuery </td>
  358. <td>(</td>
  359. <td class="paramtype">const QString &amp;&#160;</td>
  360. <td class="paramname"><em>sql</em></td><td>)</td>
  361. <td> const</td>
  362. </tr>
  363. </table>
  364. </td>
  365. <td class="mlabels-right">
  366. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  367. </tr>
  368. </table>
  369. </div><div class="memdoc">
  370. <p>Executes SELECT query. </p>
  371. <dl class="params"><dt>Parameters</dt><dd>
  372. <table class="params">
  373. <tr><td class="paramname">query</td><td>SQL statement string </td></tr>
  374. </table>
  375. </dd>
  376. </dl>
  377. <dl class="exception"><dt>Exceptions</dt><dd>
  378. <table class="exception">
  379. <tr><td class="paramname"><a class="el" href="class_easy_qt_sql_1_1_d_b_exception.htm" title="Exception class for SQL errors handling. ">DBException</a></td><td></td></tr>
  380. </table>
  381. </dd>
  382. </dl>
  383. </div>
  384. </div>
  385. <a id="a7165d67d4fdfa07b3d9700d5ed5c6a63"></a>
  386. <h2 class="memtitle"><span class="permalink"><a href="#a7165d67d4fdfa07b3d9700d5ed5c6a63">&#9670;&nbsp;</a></span>first()</h2>
  387. <div class="memitem">
  388. <div class="memproto">
  389. <div class="memtemplate">
  390. template&lt;typename Func &gt; </div>
  391. <table class="mlabels">
  392. <tr>
  393. <td class="mlabels-left">
  394. <table class="memname">
  395. <tr>
  396. <td class="memname">int EasyQtSql::Database::first </td>
  397. <td>(</td>
  398. <td class="paramtype">const QString &amp;&#160;</td>
  399. <td class="paramname"><em>query</em>, </td>
  400. </tr>
  401. <tr>
  402. <td class="paramkey"></td>
  403. <td></td>
  404. <td class="paramtype">Func &amp;&amp;&#160;</td>
  405. <td class="paramname"><em>f</em>&#160;</td>
  406. </tr>
  407. <tr>
  408. <td></td>
  409. <td>)</td>
  410. <td></td><td> const</td>
  411. </tr>
  412. </table>
  413. </td>
  414. <td class="mlabels-right">
  415. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  416. </tr>
  417. </table>
  418. </div><div class="memdoc">
  419. <p>Executes <em>query</em> and applies function <em>f</em> to the first result row. </p>
  420. <dl class="params"><dt>Parameters</dt><dd>
  421. <table class="params">
  422. <tr><td class="paramname">query</td><td>SQL query string (SELECT statement) </td></tr>
  423. <tr><td class="paramname">f</td><td>Function (lambda) to apply to </td></tr>
  424. </table>
  425. </dd>
  426. </dl>
  427. <dl class="section return"><dt>Returns</dt><dd>num rows handled with function <em>f</em></dd></dl>
  428. <div class="fragment"><div class="line"><a class="code" href="class_database.htm">Database</a> db;</div><div class="line">db.<a class="code" href="class_database.htm#ad2283c7025501aafc33530d19beb02b4">first</a>(<span class="stringliteral">&quot;SELECT * FROM table&quot;</span>, [](<span class="keyword">const</span> <a class="code" href="class_query_result.htm">QueryResult</a> &amp;res)</div><div class="line">{</div><div class="line"> qDebug() &lt;&lt; res.<a class="code" href="class_query_result.htm#a023bd84f7010368d616d7dbb1b399a06">toMap</a>();</div><div class="line">});</div></div><!-- fragment -->
  429. </div>
  430. </div>
  431. <a id="a8fc62bc8b97ae861420068e2d1dcff8a"></a>
  432. <h2 class="memtitle"><span class="permalink"><a href="#a8fc62bc8b97ae861420068e2d1dcff8a">&#9670;&nbsp;</a></span>insertInto()</h2>
  433. <div class="memitem">
  434. <div class="memproto">
  435. <table class="mlabels">
  436. <tr>
  437. <td class="mlabels-left">
  438. <table class="memname">
  439. <tr>
  440. <td class="memname"><a class="el" href="class_easy_qt_sql_1_1_insert_query.htm">InsertQuery</a> EasyQtSql::Database::insertInto </td>
  441. <td>(</td>
  442. <td class="paramtype">const QString &amp;&#160;</td>
  443. <td class="paramname"><em>table</em></td><td>)</td>
  444. <td> const</td>
  445. </tr>
  446. </table>
  447. </td>
  448. <td class="mlabels-right">
  449. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  450. </tr>
  451. </table>
  452. </div><div class="memdoc">
  453. <p>Creates INSERT query wrapper. </p>
  454. <dl class="params"><dt>Parameters</dt><dd>
  455. <table class="params">
  456. <tr><td class="paramname">table</td><td>Table to insert into with list of columns </td></tr>
  457. </table>
  458. </dd>
  459. </dl>
  460. </div>
  461. </div>
  462. <a id="a55fa6c1582cdd3dd6981f53e61dce6b4"></a>
  463. <h2 class="memtitle"><span class="permalink"><a href="#a55fa6c1582cdd3dd6981f53e61dce6b4">&#9670;&nbsp;</a></span>lastError()</h2>
  464. <div class="memitem">
  465. <div class="memproto">
  466. <table class="mlabels">
  467. <tr>
  468. <td class="mlabels-left">
  469. <table class="memname">
  470. <tr>
  471. <td class="memname">QSqlError EasyQtSql::Database::lastError </td>
  472. <td>(</td>
  473. <td class="paramname"></td><td>)</td>
  474. <td> const</td>
  475. </tr>
  476. </table>
  477. </td>
  478. <td class="mlabels-right">
  479. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  480. </tr>
  481. </table>
  482. </div><div class="memdoc">
  483. <p>Returns information about the last error that occurred on the underlying database. </p>
  484. </div>
  485. </div>
  486. <a id="a00ada326c3f4b3b01be26c552ad665dc"></a>
  487. <h2 class="memtitle"><span class="permalink"><a href="#a00ada326c3f4b3b01be26c552ad665dc">&#9670;&nbsp;</a></span>operator=()</h2>
  488. <div class="memitem">
  489. <div class="memproto">
  490. <table class="mlabels">
  491. <tr>
  492. <td class="mlabels-left">
  493. <table class="memname">
  494. <tr>
  495. <td class="memname"><a class="el" href="class_easy_qt_sql_1_1_database.htm">Database</a>&amp; EasyQtSql::Database::operator= </td>
  496. <td>(</td>
  497. <td class="paramtype"><a class="el" href="class_easy_qt_sql_1_1_database.htm">Database</a> &amp;&amp;&#160;</td>
  498. <td class="paramname"><em>other</em></td><td>)</td>
  499. <td></td>
  500. </tr>
  501. </table>
  502. </td>
  503. <td class="mlabels-right">
  504. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  505. </tr>
  506. </table>
  507. </div><div class="memdoc">
  508. </div>
  509. </div>
  510. <a id="af87d995c4cf5eaf4870befe2f973487d"></a>
  511. <h2 class="memtitle"><span class="permalink"><a href="#af87d995c4cf5eaf4870befe2f973487d">&#9670;&nbsp;</a></span>prepare()</h2>
  512. <div class="memitem">
  513. <div class="memproto">
  514. <table class="mlabels">
  515. <tr>
  516. <td class="mlabels-left">
  517. <table class="memname">
  518. <tr>
  519. <td class="memname"><a class="el" href="class_easy_qt_sql_1_1_prepared_query.htm">PreparedQuery</a> EasyQtSql::Database::prepare </td>
  520. <td>(</td>
  521. <td class="paramtype">const QString &amp;&#160;</td>
  522. <td class="paramname"><em>sql</em>, </td>
  523. </tr>
  524. <tr>
  525. <td class="paramkey"></td>
  526. <td></td>
  527. <td class="paramtype">bool&#160;</td>
  528. <td class="paramname"><em>forwardOnly</em> = <code>true</code>&#160;</td>
  529. </tr>
  530. <tr>
  531. <td></td>
  532. <td>)</td>
  533. <td></td><td> const</td>
  534. </tr>
  535. </table>
  536. </td>
  537. <td class="mlabels-right">
  538. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  539. </tr>
  540. </table>
  541. </div><div class="memdoc">
  542. <p>Prepares SQL statement. </p>
  543. <dl class="params"><dt>Parameters</dt><dd>
  544. <table class="params">
  545. <tr><td class="paramname">sql</td><td>SQL statement string </td></tr>
  546. <tr><td class="paramname">forwardOnly</td><td>Configure underlying QSqlQuery as forwardOnly </td></tr>
  547. </table>
  548. </dd>
  549. </dl>
  550. </div>
  551. </div>
  552. <a id="ad4a237ca6acca4068b005d843e1551bb"></a>
  553. <h2 class="memtitle"><span class="permalink"><a href="#ad4a237ca6acca4068b005d843e1551bb">&#9670;&nbsp;</a></span>qSqlDatabase()</h2>
  554. <div class="memitem">
  555. <div class="memproto">
  556. <table class="mlabels">
  557. <tr>
  558. <td class="mlabels-left">
  559. <table class="memname">
  560. <tr>
  561. <td class="memname">QSqlDatabase&amp; EasyQtSql::Database::qSqlDatabase </td>
  562. <td>(</td>
  563. <td class="paramname"></td><td>)</td>
  564. <td></td>
  565. </tr>
  566. </table>
  567. </td>
  568. <td class="mlabels-right">
  569. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  570. </tr>
  571. </table>
  572. </div><div class="memdoc">
  573. <p>Returns a reference to the wrapped QSqlDatabase object. </p>
  574. </div>
  575. </div>
  576. <a id="a1832537434940c8334fe0ca012bee8dd"></a>
  577. <h2 class="memtitle"><span class="permalink"><a href="#a1832537434940c8334fe0ca012bee8dd">&#9670;&nbsp;</a></span>range()</h2>
  578. <div class="memitem">
  579. <div class="memproto">
  580. <div class="memtemplate">
  581. template&lt;typename Func &gt; </div>
  582. <table class="mlabels">
  583. <tr>
  584. <td class="mlabels-left">
  585. <table class="memname">
  586. <tr>
  587. <td class="memname">int EasyQtSql::Database::range </td>
  588. <td>(</td>
  589. <td class="paramtype">const QString &amp;&#160;</td>
  590. <td class="paramname"><em>query</em>, </td>
  591. </tr>
  592. <tr>
  593. <td class="paramkey"></td>
  594. <td></td>
  595. <td class="paramtype">int&#160;</td>
  596. <td class="paramname"><em>start</em>, </td>
  597. </tr>
  598. <tr>
  599. <td class="paramkey"></td>
  600. <td></td>
  601. <td class="paramtype">int&#160;</td>
  602. <td class="paramname"><em>count</em>, </td>
  603. </tr>
  604. <tr>
  605. <td class="paramkey"></td>
  606. <td></td>
  607. <td class="paramtype">Func &amp;&amp;&#160;</td>
  608. <td class="paramname"><em>f</em>&#160;</td>
  609. </tr>
  610. <tr>
  611. <td></td>
  612. <td>)</td>
  613. <td></td><td> const</td>
  614. </tr>
  615. </table>
  616. </td>
  617. <td class="mlabels-right">
  618. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  619. </tr>
  620. </table>
  621. </div><div class="memdoc">
  622. <p>Executes <em>query</em> and applies function <em>f</em> to <em>count</em> result rows starting from index <em>start</em>. </p>
  623. <dl class="params"><dt>Parameters</dt><dd>
  624. <table class="params">
  625. <tr><td class="paramname">query</td><td>SQL query string (SELECT statement) </td></tr>
  626. <tr><td class="paramname">start</td><td>Start index </td></tr>
  627. <tr><td class="paramname">count</td><td>Row count to handle </td></tr>
  628. <tr><td class="paramname">f</td><td>Function (lambda) to apply to </td></tr>
  629. </table>
  630. </dd>
  631. </dl>
  632. <dl class="section return"><dt>Returns</dt><dd>num rows handled with function <em>f</em></dd></dl>
  633. <div class="fragment"><div class="line"><a class="code" href="class_database.htm">Database</a> db;</div><div class="line">db.<a class="code" href="class_database.htm#a3b1fb50c3263775351fc981fda798207">range</a>(<span class="stringliteral">&quot;SELECT * FROM table&quot;</span>, 3, 10, [](<span class="keyword">const</span> <a class="code" href="class_query_result.htm">QueryResult</a> &amp;res)</div><div class="line">{</div><div class="line"> qDebug() &lt;&lt; res.<a class="code" href="class_query_result.htm#a023bd84f7010368d616d7dbb1b399a06">toMap</a>();</div><div class="line">});</div></div><!-- fragment -->
  634. </div>
  635. </div>
  636. <a id="abada64f2593dd9524199f570d9387296"></a>
  637. <h2 class="memtitle"><span class="permalink"><a href="#abada64f2593dd9524199f570d9387296">&#9670;&nbsp;</a></span>scalar() <span class="overload">[1/2]</span></h2>
  638. <div class="memitem">
  639. <div class="memproto">
  640. <div class="memtemplate">
  641. template&lt;typename T &gt; </div>
  642. <table class="mlabels">
  643. <tr>
  644. <td class="mlabels-left">
  645. <table class="memname">
  646. <tr>
  647. <td class="memname">T EasyQtSql::Database::scalar </td>
  648. <td>(</td>
  649. <td class="paramtype">const QString &amp;&#160;</td>
  650. <td class="paramname"><em>query</em></td><td>)</td>
  651. <td> const</td>
  652. </tr>
  653. </table>
  654. </td>
  655. <td class="mlabels-right">
  656. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  657. </tr>
  658. </table>
  659. </div><div class="memdoc">
  660. <p>Executes <em>query</em> and returns scalar value converted to T. </p>
  661. <dl class="params"><dt>Parameters</dt><dd>
  662. <table class="params">
  663. <tr><td class="paramname">query</td><td>SQL query string (SELECT statement) </td></tr>
  664. </table>
  665. </dd>
  666. </dl>
  667. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_easy_qt_sql_1_1_query_result.htm#a46595f825d0fd0a5c765bc6d301fccb9" title="Returns scalar value converted to type T (the value of the first column of the current row) ...">QueryResult::scalar</a> </dd></dl>
  668. </div>
  669. </div>
  670. <a id="aa06ecb239cde85058a7ed828e06906b7"></a>
  671. <h2 class="memtitle"><span class="permalink"><a href="#aa06ecb239cde85058a7ed828e06906b7">&#9670;&nbsp;</a></span>scalar() <span class="overload">[2/2]</span></h2>
  672. <div class="memitem">
  673. <div class="memproto">
  674. <table class="mlabels">
  675. <tr>
  676. <td class="mlabels-left">
  677. <table class="memname">
  678. <tr>
  679. <td class="memname">QVariant EasyQtSql::Database::scalar </td>
  680. <td>(</td>
  681. <td class="paramtype">const QString &amp;&#160;</td>
  682. <td class="paramname"><em>query</em></td><td>)</td>
  683. <td> const</td>
  684. </tr>
  685. </table>
  686. </td>
  687. <td class="mlabels-right">
  688. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  689. </tr>
  690. </table>
  691. </div><div class="memdoc">
  692. <p>Executes <em>query</em> and returns scalar value. </p>
  693. <dl class="params"><dt>Parameters</dt><dd>
  694. <table class="params">
  695. <tr><td class="paramname">query</td><td>SQL query string (SELECT statement) </td></tr>
  696. </table>
  697. </dd>
  698. </dl>
  699. <dl class="section see"><dt>See also</dt><dd><a class="el" href="class_easy_qt_sql_1_1_query_result.htm#a46595f825d0fd0a5c765bc6d301fccb9" title="Returns scalar value converted to type T (the value of the first column of the current row) ...">QueryResult::scalar</a> </dd></dl>
  700. </div>
  701. </div>
  702. <a id="a2f66f508f3cc25d0512d841f938adfb4"></a>
  703. <h2 class="memtitle"><span class="permalink"><a href="#a2f66f508f3cc25d0512d841f938adfb4">&#9670;&nbsp;</a></span>top()</h2>
  704. <div class="memitem">
  705. <div class="memproto">
  706. <div class="memtemplate">
  707. template&lt;typename Func &gt; </div>
  708. <table class="mlabels">
  709. <tr>
  710. <td class="mlabels-left">
  711. <table class="memname">
  712. <tr>
  713. <td class="memname">int EasyQtSql::Database::top </td>
  714. <td>(</td>
  715. <td class="paramtype">const QString &amp;&#160;</td>
  716. <td class="paramname"><em>query</em>, </td>
  717. </tr>
  718. <tr>
  719. <td class="paramkey"></td>
  720. <td></td>
  721. <td class="paramtype">int&#160;</td>
  722. <td class="paramname"><em>topCount</em>, </td>
  723. </tr>
  724. <tr>
  725. <td class="paramkey"></td>
  726. <td></td>
  727. <td class="paramtype">Func &amp;&amp;&#160;</td>
  728. <td class="paramname"><em>f</em>&#160;</td>
  729. </tr>
  730. <tr>
  731. <td></td>
  732. <td>)</td>
  733. <td></td><td> const</td>
  734. </tr>
  735. </table>
  736. </td>
  737. <td class="mlabels-right">
  738. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  739. </tr>
  740. </table>
  741. </div><div class="memdoc">
  742. <p>Executes <em>query</em> and applies function <em>f</em> to <em>topCount</em> result rows. </p>
  743. <dl class="params"><dt>Parameters</dt><dd>
  744. <table class="params">
  745. <tr><td class="paramname">query</td><td>SQL query string (SELECT statement) </td></tr>
  746. <tr><td class="paramname">topCount</td><td>Row count to handle </td></tr>
  747. <tr><td class="paramname">f</td><td>Function (lambda) to apply to </td></tr>
  748. </table>
  749. </dd>
  750. </dl>
  751. <dl class="section return"><dt>Returns</dt><dd>num rows handled with function <em>f</em></dd></dl>
  752. <div class="fragment"><div class="line"><a class="code" href="class_database.htm">Database</a> db;</div><div class="line">db.<a class="code" href="class_database.htm#a91583d42e701fb399563facc3c3c58c0">top</a>(<span class="stringliteral">&quot;SELECT * FROM table&quot;</span>, 10, [](<span class="keyword">const</span> <a class="code" href="class_query_result.htm">QueryResult</a> &amp;res)</div><div class="line">{</div><div class="line"> qDebug() &lt;&lt; res.<a class="code" href="class_query_result.htm#a023bd84f7010368d616d7dbb1b399a06">toMap</a>();</div><div class="line">});</div></div><!-- fragment -->
  753. </div>
  754. </div>
  755. <a id="ad99ec8b68e916201dce33cda5018be67"></a>
  756. <h2 class="memtitle"><span class="permalink"><a href="#ad99ec8b68e916201dce33cda5018be67">&#9670;&nbsp;</a></span>update()</h2>
  757. <div class="memitem">
  758. <div class="memproto">
  759. <table class="mlabels">
  760. <tr>
  761. <td class="mlabels-left">
  762. <table class="memname">
  763. <tr>
  764. <td class="memname"><a class="el" href="class_easy_qt_sql_1_1_update_query.htm">UpdateQuery</a> EasyQtSql::Database::update </td>
  765. <td>(</td>
  766. <td class="paramtype">const QString &amp;&#160;</td>
  767. <td class="paramname"><em>table</em></td><td>)</td>
  768. <td> const</td>
  769. </tr>
  770. </table>
  771. </td>
  772. <td class="mlabels-right">
  773. <span class="mlabels"><span class="mlabel">inline</span></span> </td>
  774. </tr>
  775. </table>
  776. </div><div class="memdoc">
  777. <p>Creates UPDATE query wrapper. </p>
  778. <dl class="params"><dt>Parameters</dt><dd>
  779. <table class="params">
  780. <tr><td class="paramname">table</td><td>Table to update </td></tr>
  781. </table>
  782. </dd>
  783. </dl>
  784. </div>
  785. </div>
  786. <h2 class="groupheader">Member Data Documentation</h2>
  787. <a id="af1da52105a07c38f77aad58df9792181"></a>
  788. <h2 class="memtitle"><span class="permalink"><a href="#af1da52105a07c38f77aad58df9792181">&#9670;&nbsp;</a></span>m_db</h2>
  789. <div class="memitem">
  790. <div class="memproto">
  791. <table class="mlabels">
  792. <tr>
  793. <td class="mlabels-left">
  794. <table class="memname">
  795. <tr>
  796. <td class="memname">QSqlDatabase EasyQtSql::Database::m_db</td>
  797. </tr>
  798. </table>
  799. </td>
  800. <td class="mlabels-right">
  801. <span class="mlabels"><span class="mlabel">protected</span></span> </td>
  802. </tr>
  803. </table>
  804. </div><div class="memdoc">
  805. </div>
  806. </div>
  807. <hr/>The documentation for this class was generated from the following file:<ul>
  808. <li>EasyQtSql/<a class="el" href="_easy_qt_sql_8h_source.htm">EasyQtSql.h</a></li>
  809. </ul>
  810. </div><!-- contents -->
  811. </div><!-- doc-content -->
  812. <!-- start footer part -->
  813. <div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  814. <ul>
  815. <li class="navelem"><a class="el" href="namespace_easy_qt_sql.htm">EasyQtSql</a></li><li class="navelem"><a class="el" href="class_easy_qt_sql_1_1_database.htm">Database</a></li>
  816. <li class="footer">Generated by
  817. <a href="http://www.doxygen.org/index.html">
  818. <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.14 </li>
  819. </ul>
  820. </div>
  821. </body>
  822. </html>