chengxr
/
QFD2


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114
							<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.14"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>EasyQtSql: EasyQtSql/EasyQtSql_Util.h Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtreedata.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
  $(document).ready(initResizable);
/* @license-end */</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectalign" style="padding-left: 0.5em;">
   <div id="projectname">EasyQtSql
   </div>
   <div id="projectbrief">Easy SQL data access helper for QtSql</div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.14 -->
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
var searchBox = new SearchBox("searchBox", "search",false,'Search');
/* @license-end */
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(function() {
  initMenu('',true,false,'search.php','Search');
  $(document).ready(function() { init_search(); });
});
/* @license-end */</script>
<div id="main-nav"></div>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
      <div id="nav-sync" class="sync"></div>
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
/* @license magnet:?xt=urn:btih:cf05388f2679ee054f2beb29a391d25f4e673ac3&amp;dn=gpl-2.0.txt GPL-v2 */
$(document).ready(function(){initNavTree('_easy_qt_sql___util_8h_source.htm','');});
/* @license-end */
</script>
<div id="doc-content">
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div class="header">
  <div class="headertitle">
<div class="title">EasyQtSql_Util.h</div>  </div>
</div><!--header-->
<div class="contents">
<a href="_easy_qt_sql___util_8h.htm">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno">    1</span>&#160;<span class="preprocessor">#ifndef EASYQTSQL_UTIL_H</span></div><div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="preprocessor">#define EASYQTSQL_UTIL_H</span></div><div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160;</div><div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="comment">/*</span></div><div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160;<span class="comment"> * The MIT License (MIT)</span></div><div class="line"><a name="l00006"></a><span class="lineno">    6</span>&#160;<span class="comment"> * Copyright 2018 Alexey Kramin</span></div><div class="line"><a name="l00007"></a><span class="lineno">    7</span>&#160;<span class="comment"> *</span></div><div class="line"><a name="l00008"></a><span class="lineno">    8</span>&#160;<span class="comment"> * Permission is hereby granted, free of charge, to any person obtaining</span></div><div class="line"><a name="l00009"></a><span class="lineno">    9</span>&#160;<span class="comment"> * a copy of this software and associated documentation files (the</span></div><div class="line"><a name="l00010"></a><span class="lineno">   10</span>&#160;<span class="comment"> * &quot;Software&quot;), to deal in the Software without restriction, including</span></div><div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;<span class="comment"> * without limitation the rights to use, copy, modify, merge, publish,</span></div><div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160;<span class="comment"> * distribute, sublicense, and/or sell copies of the Software, and to</span></div><div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160;<span class="comment"> * permit persons to whom the Software is furnished to do so, subject to</span></div><div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;<span class="comment"> * the following conditions:</span></div><div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;<span class="comment"> *</span></div><div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;<span class="comment"> * The above copyright notice and this permission notice shall be</span></div><div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;<span class="comment"> * included in all copies or substantial portions of the Software.</span></div><div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;<span class="comment"> *</span></div><div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;<span class="comment"> * THE SOFTWARE IS PROVIDED &quot;AS IS&quot;, WITHOUT WARRANTY OF ANY KIND,</span></div><div class="line"><a name="l00020"></a><span class="lineno">   20</span>&#160;<span class="comment"> * EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF</span></div><div class="line"><a name="l00021"></a><span class="lineno">   21</span>&#160;<span class="comment"> * MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND</span></div><div class="line"><a name="l00022"></a><span class="lineno">   22</span>&#160;<span class="comment"> * NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE</span></div><div class="line"><a name="l00023"></a><span class="lineno">   23</span>&#160;<span class="comment"> * LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION</span></div><div class="line"><a name="l00024"></a><span class="lineno">   24</span>&#160;<span class="comment"> * OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION</span></div><div class="line"><a name="l00025"></a><span class="lineno">   25</span>&#160;<span class="comment"> * WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.</span></div><div class="line"><a name="l00026"></a><span class="lineno">   26</span>&#160;<span class="comment"> *</span></div><div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;<span class="comment">*/</span></div><div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160;</div><div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;<span class="preprocessor">#ifndef EASY_QT_SQL_MAIN</span></div><div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160;</div><div class="line"><a name="l00031"></a><span class="lineno">   31</span>&#160;<span class="preprocessor">#include &quot;<a class="code" href="_easy_qt_sql___query_result_8h.htm">EasyQtSql_QueryResult.h</a>&quot;</span></div><div class="line"><a name="l00032"></a><span class="lineno">   32</span>&#160;</div><div class="line"><a name="l00033"></a><span class="lineno">   33</span>&#160;<span class="preprocessor">#endif</span></div><div class="line"><a name="l00034"></a><span class="lineno">   34</span>&#160;</div><div class="line"><a name="l00054"></a><span class="lineno"><a class="line" href="class_util.htm">   54</a></span>&#160;<span class="keyword">class </span><a class="code" href="class_util.htm">Util</a></div><div class="line"><a name="l00055"></a><span class="lineno">   55</span>&#160;{</div><div class="line"><a name="l00056"></a><span class="lineno">   56</span>&#160;<span class="keyword">public</span>:</div><div class="line"><a name="l00057"></a><span class="lineno">   57</span>&#160;</div><div class="line"><a name="l00063"></a><span class="lineno">   63</span>&#160;   <span class="keyword">template</span>&lt;<span class="keyword">typename</span> Func&gt;</div><div class="line"><a name="l00064"></a><span class="lineno"><a class="line" href="class_util.htm#ab212a05ceda1f1060b772f6908253af2">   64</a></span>&#160;   <span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="class_util.htm#ab212a05ceda1f1060b772f6908253af2">each</a>(<a class="code" href="class_query_result.htm">QueryResult</a> &amp;res, Func&amp;&amp; f)</div><div class="line"><a name="l00065"></a><span class="lineno">   65</span>&#160;   {</div><div class="line"><a name="l00066"></a><span class="lineno">   66</span>&#160;      <span class="keywordtype">int</span> rowCount = 0;</div><div class="line"><a name="l00067"></a><span class="lineno">   67</span>&#160;</div><div class="line"><a name="l00068"></a><span class="lineno">   68</span>&#160;      <span class="keywordflow">if</span> (res.<a class="code" href="class_query_result.htm#a46b374177ab23d8f9d7dc9366eb57655">isActive</a>())</div><div class="line"><a name="l00069"></a><span class="lineno">   69</span>&#160;      {</div><div class="line"><a name="l00070"></a><span class="lineno">   70</span>&#160;         <span class="keywordflow">while</span> (res.<a class="code" href="class_query_result.htm#a1c756382c20c126979b28715d529c054">next</a>())</div><div class="line"><a name="l00071"></a><span class="lineno">   71</span>&#160;         {</div><div class="line"><a name="l00072"></a><span class="lineno">   72</span>&#160;            f(res);</div><div class="line"><a name="l00073"></a><span class="lineno">   73</span>&#160;            ++rowCount;</div><div class="line"><a name="l00074"></a><span class="lineno">   74</span>&#160;         }</div><div class="line"><a name="l00075"></a><span class="lineno">   75</span>&#160;      }</div><div class="line"><a name="l00076"></a><span class="lineno">   76</span>&#160;</div><div class="line"><a name="l00077"></a><span class="lineno">   77</span>&#160;      <span class="keywordflow">return</span> rowCount;</div><div class="line"><a name="l00078"></a><span class="lineno">   78</span>&#160;   }</div><div class="line"><a name="l00079"></a><span class="lineno">   79</span>&#160;</div><div class="line"><a name="l00087"></a><span class="lineno">   87</span>&#160;   <span class="keyword">template</span>&lt;<span class="keyword">typename</span> Func&gt;</div><div class="line"><a name="l00088"></a><span class="lineno"><a class="line" href="class_util.htm#af0d70a7ab17cd3f445cfeda22e367185">   88</a></span>&#160;   <span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="class_util.htm#af0d70a7ab17cd3f445cfeda22e367185">range</a>(<a class="code" href="class_query_result.htm">QueryResult</a> &amp;res, <span class="keywordtype">int</span> start, <span class="keywordtype">int</span> count, Func&amp;&amp; f)</div><div class="line"><a name="l00089"></a><span class="lineno">   89</span>&#160;   {</div><div class="line"><a name="l00090"></a><span class="lineno">   90</span>&#160;      Q_ASSERT(start &gt;= 0);</div><div class="line"><a name="l00091"></a><span class="lineno">   91</span>&#160;      Q_ASSERT(count &gt;= 0);</div><div class="line"><a name="l00092"></a><span class="lineno">   92</span>&#160;</div><div class="line"><a name="l00093"></a><span class="lineno">   93</span>&#160;      <span class="keywordtype">int</span> rowCount = 0;</div><div class="line"><a name="l00094"></a><span class="lineno">   94</span>&#160;</div><div class="line"><a name="l00095"></a><span class="lineno">   95</span>&#160;      <span class="keywordflow">if</span> (res.<a class="code" href="class_query_result.htm#a46b374177ab23d8f9d7dc9366eb57655">isActive</a>())</div><div class="line"><a name="l00096"></a><span class="lineno">   96</span>&#160;      {</div><div class="line"><a name="l00097"></a><span class="lineno">   97</span>&#160;         <span class="comment">//skip items</span></div><div class="line"><a name="l00098"></a><span class="lineno">   98</span>&#160;         <span class="keywordflow">for</span> (<span class="keywordtype">int</span> i = 0; i &lt; start; ++i)</div><div class="line"><a name="l00099"></a><span class="lineno">   99</span>&#160;         {</div><div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;            <span class="keywordflow">if</span> (!res.<a class="code" href="class_query_result.htm#a1c756382c20c126979b28715d529c054">next</a>())</div><div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160;               <span class="keywordflow">return</span> rowCount;</div><div class="line"><a name="l00102"></a><span class="lineno">  102</span>&#160;         }</div><div class="line"><a name="l00103"></a><span class="lineno">  103</span>&#160;</div><div class="line"><a name="l00104"></a><span class="lineno">  104</span>&#160;         <span class="keywordflow">for</span> (<span class="keywordtype">int</span> i = 0; i &lt; count &amp;&amp; res.<a class="code" href="class_query_result.htm#a1c756382c20c126979b28715d529c054">next</a>(); ++i)</div><div class="line"><a name="l00105"></a><span class="lineno">  105</span>&#160;         {</div><div class="line"><a name="l00106"></a><span class="lineno">  106</span>&#160;            f(res);</div><div class="line"><a name="l00107"></a><span class="lineno">  107</span>&#160;            rowCount++;</div><div class="line"><a name="l00108"></a><span class="lineno">  108</span>&#160;         }</div><div class="line"><a name="l00109"></a><span class="lineno">  109</span>&#160;      }</div><div class="line"><a name="l00110"></a><span class="lineno">  110</span>&#160;</div><div class="line"><a name="l00111"></a><span class="lineno">  111</span>&#160;      <span class="keywordflow">return</span> rowCount;</div><div class="line"><a name="l00112"></a><span class="lineno">  112</span>&#160;   }</div><div class="line"><a name="l00113"></a><span class="lineno">  113</span>&#160;</div><div class="line"><a name="l00121"></a><span class="lineno">  121</span>&#160;   <span class="keyword">template</span>&lt;<span class="keyword">typename</span> Func&gt;</div><div class="line"><a name="l00122"></a><span class="lineno"><a class="line" href="class_util.htm#a8b0d3aaa507f4f4add129795a2cd6247">  122</a></span>&#160;   <span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="class_util.htm#a8b0d3aaa507f4f4add129795a2cd6247">top</a>(<a class="code" href="class_query_result.htm">QueryResult</a> &amp;res, <span class="keywordtype">int</span> topCount, Func&amp;&amp; f)</div><div class="line"><a name="l00123"></a><span class="lineno">  123</span>&#160;   {</div><div class="line"><a name="l00124"></a><span class="lineno">  124</span>&#160;      <span class="keywordflow">return</span> <a class="code" href="class_util.htm#af0d70a7ab17cd3f445cfeda22e367185">range</a>(res, 0, topCount, f);</div><div class="line"><a name="l00125"></a><span class="lineno">  125</span>&#160;   }</div><div class="line"><a name="l00126"></a><span class="lineno">  126</span>&#160;   </div><div class="line"><a name="l00132"></a><span class="lineno">  132</span>&#160;   <span class="keyword">template</span>&lt;<span class="keyword">typename</span> Func&gt;</div><div class="line"><a name="l00133"></a><span class="lineno"><a class="line" href="class_util.htm#a08e77f4051011d51e9d79339a839580a">  133</a></span>&#160;   <span class="keyword">static</span> <span class="keywordtype">int</span> <a class="code" href="class_util.htm#a08e77f4051011d51e9d79339a839580a">first</a>(<a class="code" href="class_query_result.htm">QueryResult</a> &amp;res, Func&amp;&amp; f)</div><div class="line"><a name="l00134"></a><span class="lineno">  134</span>&#160;   {</div><div class="line"><a name="l00135"></a><span class="lineno">  135</span>&#160;      <span class="keywordflow">return</span> <a class="code" href="class_util.htm#a8b0d3aaa507f4f4add129795a2cd6247">top</a>(res, 1, f);</div><div class="line"><a name="l00136"></a><span class="lineno">  136</span>&#160;   }</div><div class="line"><a name="l00137"></a><span class="lineno">  137</span>&#160;</div><div class="line"><a name="l00138"></a><span class="lineno">  138</span>&#160;<span class="keyword">private</span>:</div><div class="line"><a name="l00139"></a><span class="lineno">  139</span>&#160;   <a class="code" href="class_util.htm">Util</a>(){}</div><div class="line"><a name="l00140"></a><span class="lineno">  140</span>&#160;};</div><div class="line"><a name="l00141"></a><span class="lineno">  141</span>&#160;</div><div class="line"><a name="l00142"></a><span class="lineno">  142</span>&#160;<span class="preprocessor">#endif // EASYQTSQL_UTIL_H</span></div><div class="ttc" id="class_util_htm_af0d70a7ab17cd3f445cfeda22e367185"><div class="ttname"><a href="class_util.htm#af0d70a7ab17cd3f445cfeda22e367185">Util::range</a></div><div class="ttdeci">static int range(QueryResult &amp;res, int start, int count, Func &amp;&amp;f)</div><div class="ttdoc">Applies function (lambda) f to count rows starting from start index. </div><div class="ttdef"><b>Definition:</b> EasyQtSql_Util.h:88</div></div>
<div class="ttc" id="class_util_htm_a8b0d3aaa507f4f4add129795a2cd6247"><div class="ttname"><a href="class_util.htm#a8b0d3aaa507f4f4add129795a2cd6247">Util::top</a></div><div class="ttdeci">static int top(QueryResult &amp;res, int topCount, Func &amp;&amp;f)</div><div class="ttdoc">Applies function (lambda) f to topCount rows from res. </div><div class="ttdef"><b>Definition:</b> EasyQtSql_Util.h:122</div></div>
<div class="ttc" id="class_util_htm"><div class="ttname"><a href="class_util.htm">Util</a></div><div class="ttdoc">Utility functions. </div><div class="ttdef"><b>Definition:</b> EasyQtSql_Util.h:54</div></div>
<div class="ttc" id="class_query_result_htm_a46b374177ab23d8f9d7dc9366eb57655"><div class="ttname"><a href="class_query_result.htm#a46b374177ab23d8f9d7dc9366eb57655">QueryResult::isActive</a></div><div class="ttdeci">bool isActive() const</div><div class="ttdoc">Returns true if the query is active. An active QSqlQuery is one that has been exec()&amp;#39;d successfully b...</div><div class="ttdef"><b>Definition:</b> EasyQtSql_QueryResult.h:151</div></div>
<div class="ttc" id="class_query_result_htm"><div class="ttname"><a href="class_query_result.htm">QueryResult</a></div><div class="ttdoc">QSqlQuery wrapper with handy data fetch methods. </div><div class="ttdef"><b>Definition:</b> EasyQtSql_QueryResult.h:39</div></div>
<div class="ttc" id="class_util_htm_a08e77f4051011d51e9d79339a839580a"><div class="ttname"><a href="class_util.htm#a08e77f4051011d51e9d79339a839580a">Util::first</a></div><div class="ttdeci">static int first(QueryResult &amp;res, Func &amp;&amp;f)</div><div class="ttdoc">Applies function (lambda) f to first result row. </div><div class="ttdef"><b>Definition:</b> EasyQtSql_Util.h:133</div></div>
<div class="ttc" id="class_query_result_htm_a1c756382c20c126979b28715d529c054"><div class="ttname"><a href="class_query_result.htm#a1c756382c20c126979b28715d529c054">QueryResult::next</a></div><div class="ttdeci">bool next()</div><div class="ttdoc">Retrieves the next record in the result, if available, and positions the query on the retrieved recor...</div><div class="ttdef"><b>Definition:</b> EasyQtSql_QueryResult.h:60</div></div>
<div class="ttc" id="_easy_qt_sql___query_result_8h_htm"><div class="ttname"><a href="_easy_qt_sql___query_result_8h.htm">EasyQtSql_QueryResult.h</a></div></div>
<div class="ttc" id="class_util_htm_ab212a05ceda1f1060b772f6908253af2"><div class="ttname"><a href="class_util.htm#ab212a05ceda1f1060b772f6908253af2">Util::each</a></div><div class="ttdeci">static int each(QueryResult &amp;res, Func &amp;&amp;f)</div><div class="ttdoc">Applies function (lambda) f to each row in res. </div><div class="ttdef"><b>Definition:</b> EasyQtSql_Util.h:64</div></div>
</div><!-- fragment --></div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  <ul>
    <li class="navelem"><a class="el" href="dir_ccd1b38e141953c502dde9cd8646e4d8.htm">EasyQtSql</a></li><li class="navelem"><a class="el" href="_easy_qt_sql___util_8h.htm">EasyQtSql_Util.h</a></li>
    <li class="footer">Generated by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.14 </li>
  </ul>
</div>
</body>
</html>