class_util.htm 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350
  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: Util 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_util.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-static-methods">Static Public Member Functions</a> &#124;
  89. <a href="class_util-members.htm">List of all members</a> </div>
  90. <div class="headertitle">
  91. <div class="title">Util Class Reference</div> </div>
  92. </div><!--header-->
  93. <div class="contents">
  94. <p>Utility functions.
  95. <a href="class_util.htm#details">More...</a></p>
  96. <p><code>#include &lt;<a class="el" href="_easy_qt_sql___util_8h_source.htm">EasyQtSql_Util.h</a>&gt;</code></p>
  97. <table class="memberdecls">
  98. <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-static-methods"></a>
  99. Static Public Member Functions</h2></td></tr>
  100. <tr class="memitem:ab212a05ceda1f1060b772f6908253af2"><td class="memTemplParams" colspan="2">template&lt;typename Func &gt; </td></tr>
  101. <tr class="memitem:ab212a05ceda1f1060b772f6908253af2"><td class="memTemplItemLeft" align="right" valign="top">static int&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_util.htm#ab212a05ceda1f1060b772f6908253af2">each</a> (<a class="el" href="class_query_result.htm">QueryResult</a> &amp;res, Func &amp;&amp;f)</td></tr>
  102. <tr class="memdesc:ab212a05ceda1f1060b772f6908253af2"><td class="mdescLeft">&#160;</td><td class="mdescRight">Applies function (lambda) f to each row in res. <a href="#ab212a05ceda1f1060b772f6908253af2">More...</a><br /></td></tr>
  103. <tr class="separator:ab212a05ceda1f1060b772f6908253af2"><td class="memSeparator" colspan="2">&#160;</td></tr>
  104. <tr class="memitem:af0d70a7ab17cd3f445cfeda22e367185"><td class="memTemplParams" colspan="2">template&lt;typename Func &gt; </td></tr>
  105. <tr class="memitem:af0d70a7ab17cd3f445cfeda22e367185"><td class="memTemplItemLeft" align="right" valign="top">static int&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_util.htm#af0d70a7ab17cd3f445cfeda22e367185">range</a> (<a class="el" href="class_query_result.htm">QueryResult</a> &amp;res, int start, int count, Func &amp;&amp;f)</td></tr>
  106. <tr class="memdesc:af0d70a7ab17cd3f445cfeda22e367185"><td class="mdescLeft">&#160;</td><td class="mdescRight">Applies function (lambda) f to count rows starting from start index. <a href="#af0d70a7ab17cd3f445cfeda22e367185">More...</a><br /></td></tr>
  107. <tr class="separator:af0d70a7ab17cd3f445cfeda22e367185"><td class="memSeparator" colspan="2">&#160;</td></tr>
  108. <tr class="memitem:a8b0d3aaa507f4f4add129795a2cd6247"><td class="memTemplParams" colspan="2">template&lt;typename Func &gt; </td></tr>
  109. <tr class="memitem:a8b0d3aaa507f4f4add129795a2cd6247"><td class="memTemplItemLeft" align="right" valign="top">static int&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_util.htm#a8b0d3aaa507f4f4add129795a2cd6247">top</a> (<a class="el" href="class_query_result.htm">QueryResult</a> &amp;res, int topCount, Func &amp;&amp;f)</td></tr>
  110. <tr class="memdesc:a8b0d3aaa507f4f4add129795a2cd6247"><td class="mdescLeft">&#160;</td><td class="mdescRight">Applies function (lambda) f to topCount rows from res. <a href="#a8b0d3aaa507f4f4add129795a2cd6247">More...</a><br /></td></tr>
  111. <tr class="separator:a8b0d3aaa507f4f4add129795a2cd6247"><td class="memSeparator" colspan="2">&#160;</td></tr>
  112. <tr class="memitem:a08e77f4051011d51e9d79339a839580a"><td class="memTemplParams" colspan="2">template&lt;typename Func &gt; </td></tr>
  113. <tr class="memitem:a08e77f4051011d51e9d79339a839580a"><td class="memTemplItemLeft" align="right" valign="top">static int&#160;</td><td class="memTemplItemRight" valign="bottom"><a class="el" href="class_util.htm#a08e77f4051011d51e9d79339a839580a">first</a> (<a class="el" href="class_query_result.htm">QueryResult</a> &amp;res, Func &amp;&amp;f)</td></tr>
  114. <tr class="memdesc:a08e77f4051011d51e9d79339a839580a"><td class="mdescLeft">&#160;</td><td class="mdescRight">Applies function (lambda) f to first result row. <a href="#a08e77f4051011d51e9d79339a839580a">More...</a><br /></td></tr>
  115. <tr class="separator:a08e77f4051011d51e9d79339a839580a"><td class="memSeparator" colspan="2">&#160;</td></tr>
  116. </table>
  117. <a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
  118. <div class="textblock"><p>Utility functions. </p>
  119. <div class="fragment"><div class="line">t.<a class="code" href="class_database.htm#ad2283c7025501aafc33530d19beb02b4">first</a>(<span class="stringliteral">&quot;SELECT 1&quot;</span>, [](<span class="keyword">const</span> <a class="code" href="class_query_result.htm">QueryResult</a> &amp;row){</div><div class="line"> qDebug() &lt;&lt; row.<a class="code" href="class_query_result.htm#a5e3b49cb821efecac406606d9e3adb13">scalar</a>&lt;<span class="keywordtype">bool</span>&gt;();</div><div class="line">});</div><div class="line"></div><div class="line">t.<a class="code" href="class_database.htm#a7a13f4fc603fb829f123894d9abd6ea7">each</a>(<span class="stringliteral">&quot;SELECT * FROM table1&quot;</span>, [](<span class="keyword">const</span> <a class="code" href="class_query_result.htm">QueryResult</a> &amp;row){</div><div class="line"> qDebug() &lt;&lt; row.<a class="code" href="class_query_result.htm#a023bd84f7010368d616d7dbb1b399a06">toMap</a>();</div><div class="line">});</div><div class="line"></div><div class="line"><a class="code" href="class_prepared_query.htm">PreparedQuery</a> query = t.<a class="code" href="class_database.htm#a03e2c9113452bb52bb7018ef2366bce1">prepare</a>(<span class="stringliteral">&quot;SELECT a, b, c, d FROM table1 WHERE a = ? AND b = ?&quot;</span>);</div><div class="line"></div><div class="line"><a class="code" href="class_util.htm#ab212a05ceda1f1060b772f6908253af2">Util::each</a>(query.<a class="code" href="class_prepared_query.htm#a1013aea1638d6d04868ce39130bc1b67">exec</a>(1, 2), [](<span class="keyword">const</span> <a class="code" href="class_query_result.htm">QueryResult</a> &amp;row){</div><div class="line"> qDebug() &lt;&lt; row.<a class="code" href="class_query_result.htm#a023bd84f7010368d616d7dbb1b399a06">toMap</a>();</div><div class="line">});</div></div><!-- fragment --> </div><h2 class="groupheader">Member Function Documentation</h2>
  120. <a id="ab212a05ceda1f1060b772f6908253af2"></a>
  121. <h2 class="memtitle"><span class="permalink"><a href="#ab212a05ceda1f1060b772f6908253af2">&#9670;&nbsp;</a></span>each()</h2>
  122. <div class="memitem">
  123. <div class="memproto">
  124. <div class="memtemplate">
  125. template&lt;typename Func &gt; </div>
  126. <table class="mlabels">
  127. <tr>
  128. <td class="mlabels-left">
  129. <table class="memname">
  130. <tr>
  131. <td class="memname">static int Util::each </td>
  132. <td>(</td>
  133. <td class="paramtype"><a class="el" href="class_query_result.htm">QueryResult</a> &amp;&#160;</td>
  134. <td class="paramname"><em>res</em>, </td>
  135. </tr>
  136. <tr>
  137. <td class="paramkey"></td>
  138. <td></td>
  139. <td class="paramtype">Func &amp;&amp;&#160;</td>
  140. <td class="paramname"><em>f</em>&#160;</td>
  141. </tr>
  142. <tr>
  143. <td></td>
  144. <td>)</td>
  145. <td></td><td></td>
  146. </tr>
  147. </table>
  148. </td>
  149. <td class="mlabels-right">
  150. <span class="mlabels"><span class="mlabel">inline</span><span class="mlabel">static</span></span> </td>
  151. </tr>
  152. </table>
  153. </div><div class="memdoc">
  154. <p>Applies function (lambda) f to each row in res. </p>
  155. <dl class="params"><dt>Parameters</dt><dd>
  156. <table class="params">
  157. <tr><td class="paramname">res</td><td><a class="el" href="class_query_result.htm" title="QSqlQuery wrapper with handy data fetch methods. ">QueryResult</a> </td></tr>
  158. <tr><td class="paramname">f</td><td>Function </td></tr>
  159. </table>
  160. </dd>
  161. </dl>
  162. </div>
  163. </div>
  164. <a id="a08e77f4051011d51e9d79339a839580a"></a>
  165. <h2 class="memtitle"><span class="permalink"><a href="#a08e77f4051011d51e9d79339a839580a">&#9670;&nbsp;</a></span>first()</h2>
  166. <div class="memitem">
  167. <div class="memproto">
  168. <div class="memtemplate">
  169. template&lt;typename Func &gt; </div>
  170. <table class="mlabels">
  171. <tr>
  172. <td class="mlabels-left">
  173. <table class="memname">
  174. <tr>
  175. <td class="memname">static int Util::first </td>
  176. <td>(</td>
  177. <td class="paramtype"><a class="el" href="class_query_result.htm">QueryResult</a> &amp;&#160;</td>
  178. <td class="paramname"><em>res</em>, </td>
  179. </tr>
  180. <tr>
  181. <td class="paramkey"></td>
  182. <td></td>
  183. <td class="paramtype">Func &amp;&amp;&#160;</td>
  184. <td class="paramname"><em>f</em>&#160;</td>
  185. </tr>
  186. <tr>
  187. <td></td>
  188. <td>)</td>
  189. <td></td><td></td>
  190. </tr>
  191. </table>
  192. </td>
  193. <td class="mlabels-right">
  194. <span class="mlabels"><span class="mlabel">inline</span><span class="mlabel">static</span></span> </td>
  195. </tr>
  196. </table>
  197. </div><div class="memdoc">
  198. <p>Applies function (lambda) f to first result row. </p>
  199. <dl class="params"><dt>Parameters</dt><dd>
  200. <table class="params">
  201. <tr><td class="paramname">res</td><td><a class="el" href="class_query_result.htm" title="QSqlQuery wrapper with handy data fetch methods. ">QueryResult</a> <br />
  202. </td></tr>
  203. <tr><td class="paramname">f</td><td>Function </td></tr>
  204. </table>
  205. </dd>
  206. </dl>
  207. </div>
  208. </div>
  209. <a id="af0d70a7ab17cd3f445cfeda22e367185"></a>
  210. <h2 class="memtitle"><span class="permalink"><a href="#af0d70a7ab17cd3f445cfeda22e367185">&#9670;&nbsp;</a></span>range()</h2>
  211. <div class="memitem">
  212. <div class="memproto">
  213. <div class="memtemplate">
  214. template&lt;typename Func &gt; </div>
  215. <table class="mlabels">
  216. <tr>
  217. <td class="mlabels-left">
  218. <table class="memname">
  219. <tr>
  220. <td class="memname">static int Util::range </td>
  221. <td>(</td>
  222. <td class="paramtype"><a class="el" href="class_query_result.htm">QueryResult</a> &amp;&#160;</td>
  223. <td class="paramname"><em>res</em>, </td>
  224. </tr>
  225. <tr>
  226. <td class="paramkey"></td>
  227. <td></td>
  228. <td class="paramtype">int&#160;</td>
  229. <td class="paramname"><em>start</em>, </td>
  230. </tr>
  231. <tr>
  232. <td class="paramkey"></td>
  233. <td></td>
  234. <td class="paramtype">int&#160;</td>
  235. <td class="paramname"><em>count</em>, </td>
  236. </tr>
  237. <tr>
  238. <td class="paramkey"></td>
  239. <td></td>
  240. <td class="paramtype">Func &amp;&amp;&#160;</td>
  241. <td class="paramname"><em>f</em>&#160;</td>
  242. </tr>
  243. <tr>
  244. <td></td>
  245. <td>)</td>
  246. <td></td><td></td>
  247. </tr>
  248. </table>
  249. </td>
  250. <td class="mlabels-right">
  251. <span class="mlabels"><span class="mlabel">inline</span><span class="mlabel">static</span></span> </td>
  252. </tr>
  253. </table>
  254. </div><div class="memdoc">
  255. <p>Applies function (lambda) f to count rows starting from start index. </p>
  256. <dl class="params"><dt>Parameters</dt><dd>
  257. <table class="params">
  258. <tr><td class="paramname">res</td><td><a class="el" href="class_query_result.htm" title="QSqlQuery wrapper with handy data fetch methods. ">QueryResult</a> </td></tr>
  259. <tr><td class="paramname">start</td><td>Index of start row </td></tr>
  260. <tr><td class="paramname">count</td><td>Rows count </td></tr>
  261. <tr><td class="paramname">f</td><td>Function </td></tr>
  262. </table>
  263. </dd>
  264. </dl>
  265. </div>
  266. </div>
  267. <a id="a8b0d3aaa507f4f4add129795a2cd6247"></a>
  268. <h2 class="memtitle"><span class="permalink"><a href="#a8b0d3aaa507f4f4add129795a2cd6247">&#9670;&nbsp;</a></span>top()</h2>
  269. <div class="memitem">
  270. <div class="memproto">
  271. <div class="memtemplate">
  272. template&lt;typename Func &gt; </div>
  273. <table class="mlabels">
  274. <tr>
  275. <td class="mlabels-left">
  276. <table class="memname">
  277. <tr>
  278. <td class="memname">static int Util::top </td>
  279. <td>(</td>
  280. <td class="paramtype"><a class="el" href="class_query_result.htm">QueryResult</a> &amp;&#160;</td>
  281. <td class="paramname"><em>res</em>, </td>
  282. </tr>
  283. <tr>
  284. <td class="paramkey"></td>
  285. <td></td>
  286. <td class="paramtype">int&#160;</td>
  287. <td class="paramname"><em>topCount</em>, </td>
  288. </tr>
  289. <tr>
  290. <td class="paramkey"></td>
  291. <td></td>
  292. <td class="paramtype">Func &amp;&amp;&#160;</td>
  293. <td class="paramname"><em>f</em>&#160;</td>
  294. </tr>
  295. <tr>
  296. <td></td>
  297. <td>)</td>
  298. <td></td><td></td>
  299. </tr>
  300. </table>
  301. </td>
  302. <td class="mlabels-right">
  303. <span class="mlabels"><span class="mlabel">inline</span><span class="mlabel">static</span></span> </td>
  304. </tr>
  305. </table>
  306. </div><div class="memdoc">
  307. <p>Applies function (lambda) f to topCount rows from res. </p>
  308. <dl class="params"><dt>Parameters</dt><dd>
  309. <table class="params">
  310. <tr><td class="paramname">res</td><td><a class="el" href="class_query_result.htm" title="QSqlQuery wrapper with handy data fetch methods. ">QueryResult</a> </td></tr>
  311. <tr><td class="paramname">topCount</td><td>Count of rows </td></tr>
  312. <tr><td class="paramname">count</td><td>Rows count </td></tr>
  313. <tr><td class="paramname">f</td><td>Function </td></tr>
  314. </table>
  315. </dd>
  316. </dl>
  317. </div>
  318. </div>
  319. <hr/>The documentation for this class was generated from the following file:<ul>
  320. <li>EasyQtSql/<a class="el" href="_easy_qt_sql___util_8h_source.htm">EasyQtSql_Util.h</a></li>
  321. </ul>
  322. </div><!-- contents -->
  323. </div><!-- doc-content -->
  324. <!-- start footer part -->
  325. <div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  326. <ul>
  327. <li class="navelem"><a class="el" href="class_util.htm">Util</a></li>
  328. <li class="footer">Generated by
  329. <a href="http://www.doxygen.org/index.html">
  330. <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.14 </li>
  331. </ul>
  332. </div>
  333. </body>
  334. </html>